Given the following information, fill in the cash budget

First Fourth $ $ $ Second Third 208,000 4,761,000 $ 7,757,500 $ 4,969,000 5,564,000 $ 7,222,500 $ $ 214,066 $ 2,939,400 $ 2,295,560 $ 681,000 $ 248,523 $ 225,845 3,222,000.00 $ 2,287,800.00 2,502,800 $ 1,817,720 1,213,000 $ 653,000 $ $ $ $ 248,334 3,565,800.00 2,754,920 1,129,000 $ 8. Cash Budget Beginning cash balance Add: Cash collections Total cash available Less: Cash disbursements Materials Direct Labor Manufacturing overhead Selling and administrative Equipment purchase Dividend Interest Total disbursements Excess (deficiency) Financing: Borrowing Repayment Total financing Ending cash balance On June 30, 2019 the Large Gnome Division plans to buy new machinery and equipment for $1,900,000. The new machinery and equipment will be acquired at the very end of the year, so it will not be used in production and sales during the coming year and it will not be depreciated until the following year. The Large Gnome Division expects to pay 15% down and finance the remaining 85% of the equipment cost with a loan. No interest payable will accrue on the equipment loan until after June 30, 2019. The Division must maintain a minimum cash balance of $60.000. If after accounting for cash receipts and disbursements (including dividends) in the cash budget, the budgeted cash available cash falls below $60,000 in any quarter, the Division will need to borrow cash. They have arranged a line of credit with Liberty Bank. allowing it to borrow in $10,000 increments. Assume borrowing will take place at the beginning of any quarter in which the available cash would otherwise be below $60,000 so that at no time during the quarter will the cash balance fall below $60,000 (after payment of interest). If there is extra cash at the end of the quarter and there is borrowing outstanding, the division should pay down principal (also in increments of $10,000). Liberty Bank charges the Division interest at the rate of 1.0% per quarter, which must be paid at the end of each quarter. As a fully owned subsidiary, the Large Gnome Division does not pay income taxes. All income taxes are charged to Kimmel Gnomes, the parent company. Large Gnome Division will pay dividends of $25,000 Kimmel Gnomes each quarter to its corporate parent, Kimmel Gnomes. The dividends must be paid, even if the Large Gnome Division has to borrow on its line of credit to make the payment The budgeted balance sheet for the Large Gnome Division on June 30, 2018 (which is the same as the budgeted balance sheet at the beginning of business July 1, 2018) is presented below. Kimmel Gnomes owns 100% of the Capital Stock of the Large Gnome Division. LARGE GNOME DIVISION - KIMMEL GNOMES BUDGETED BALANCE SHEET JUNE 30, 2018 ASSETS LIABILITIES & EQUITY Accounts Cash $208,000 Payable $96,000 Accounts Receivable 1,230,000 Notes Payable Raw Material Inventory 63,000 Capital Stock 4,000,000 Retained Plant and Equipment 14,500,000 Earnings 11,905,000 TOTAL ASSETS $16.001,000 TIL LIAB. & SE $16.001.000