Exercise 5-27 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.) October November December Quarter $15,540 Beginning cash balance Collections from sales Total cash available Less disbursements $16,230 56,840 242,010 73,070 97,690 124,290 Materials purchases Direct labor Manufacturing overhead Selling & administrative expenses Equipment purchase Dividends 9,670 6,380 23,180 29,110 13,570 8,070 22,190 34,670 5,020 19,970 29,110 19,470 15,080 5,260 5,260 65,530 Total disbursements Excess (deficiency) of cash Minimum cash balance Cash available (needed) Financing: 29,350 15,000 15,000 15,000 7,460 13,520 Borrowings Repayments Interest 8,000 -8,000 80 80 80 8,080 $21,270 Total financing Ending cash balance $15,540 Click if you would like to Show Work for this question: Open Show Work