Question

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

Answer 1

First 208,000 4,761,000 4,969,000 Second 63,974 7,757,500 7,821,474 Third 67,651 5,564,000 5,631,651 Fourth 65,086 7,222,500 7,287,586 214,066 2,939,400 2,295,560 681,000 248,523 3,222,000 2,502,800 1,213,000 225,845 2,287,800 1,817,720 653,000 Beginning Cash Balance Add;Cash Collections Total Cash Available Less; Cash Disbursements Materials Direct Labor Manufacturing Overhead Selling and Admnstrative Equipment Purchase Dividend Interest Total Disbursements Excess (deficiency) Financing: Borrowing Repayment Total Financing Ending Cash Balance 248,334 3,565,800 2,754,920 1,129,000 285,000 (1900000*15%) 25,000 1,700 8,009,754 (722,168) 25,000 25,000 12,500 7,223,823 597,651 25,000 7,200 5,016,565 615,086 6,155,026 (1,186,026) 1,250,000 790,000 1,250,000 63,974 (530,000) (530,000) 67,651 (550,000) (550,000) 65,086 790,000 67,832