Coronado, Inc. prepared the following cash budget for the fourth quarter. Fill in the missing amounts, assuming that Coronado desires to maintain a $15,000 minimum monthly cash balance and all equipment was purchased during December. Any required borrowings and repayments must be made in even increments of $1,000.
(Enter answers in necessary fields only. Leave other fields blank. Do not enter 0.)
Please help me fill in the blanks with work so I can follow along.
Extracted text: October November December Beginning cash balance $ $15,500 $ 16500 16850 Collections from sales 50,000 80000 103150 Total cash available 66,500 95,500 120,000 Less disbursements Materials purchases 10,000 14,000 Direct labor 5,000 5,000 8,000 Manufacturing 20,000 23,500 22,000 overhead Selling & administrative 27,500 25,000 expenses Equipment purchase Dividends 5,000 Total disbursements 66,000 Excess (deficiency) of cash 32,000 Minimum cash balance 15,000 15,000 15,000 Cash available -14,500 9,000 (needed) Financing: Borrowings Repayments Interest -150 Total financing -15,150 Ending cash balance $15,500 $16,850 $ %24
Extracted text: October November December Quarter $15,500 $ $16,500 16500 16850 50,000 80000 103150 233,150 66,500 95,500 120,000 249650 10,000 14,000 37,500 5,000 5,000 8,000 18,000 20,000 23,500 22,000 27,500 25,000 15,000 5,000 5,000 66,000 32,000 15,000 15,000 15,000 -14,500 9,000 15,000 -15,000 -150 -150 -15,150 -150 $15,500 $16,850 $ $ %24