Answer:
Your Company
The cash that must be borrowed to cover all cash disbursements and to obtain the required November 30 cash balance is:
= $18,000.
Explanation:
a) Data and Calculations:
Selling price per unit = $32
Variable cost per unit = $20
Contribution margin per unit = $12 ($32 - $20)
Beginning cash balance on November 1 = $45,000
Cash disbursements = $1460,000
Depreciation expense = $35,000
Minimum required cash balance on November 30 = $75,000
Budgeted sales units for November = 46,000
Sales revenue (cash) = $1,472,000 (46,000 * $32)
Variable costs = 920,000 (46,000 * $20)
Contribution margin = $552,000 (46,000 * $12)
Cash Budget
For the month of November
Beginning cash balance $45,000
Total cash collections = 1,472,000
Cash available $1,517,000
Cash disbursements (1,460,000)
Cash balance $57,000
Cash to borrow 18,000 ($75,000 - $57,000)
Minimum cash balance $75,000
