I need help with the Cash budget. this is what I have so far. If you could explain where you get the numbers from that would be great. like what formulas to do and so on.

Transcribed Image Text:

Waterway Corporation Cash Budget For the First Quarter of 20xx First Quarter January February March Quarter 8 Beginning cash balance $ 100,500 $ 800,000 $ 800,000 Cell Reference 9 Add: Receipts -0 Collections from customers $ 1,336,380 $ 1,350,900 $ 1,385,700 $ 4,072,980 1 Total available cash $ 1,436,880 $ 2,150,900 $ 2,185,700 $ 4,072,980 32 Less: Disbursements 33 Direct Materials 34 Direct Labor 35 Manufacturing Overhead 36 Selling and Administrative Expense ssss $ 205,304 $ 169,498 $ 172,815 $ 547,617 $ 180,720 $ 180,560 $ 187,040 $ 548,320 $ 97,860 $ 97,830 $ 99,045 $ 294,735 $ 274,700 $ 273,900 $ 279,500 $ 828,100 37 Equipment Purchase $ 500,000 $ 500,000 38 Dividends $ 12,500 $ 12,500 $ 12,500 $ 37,500 39 Total disbursements $ 771,084 $ 1,234,288 $ 750,900 $ 2,756,272 40 Excess (deficiency) of available cash over cash 41 disbursements $ 665,796 $ 916,612 $ 1,434,800 $ 1,316,708 42 Financing: 143 Add: Borrowings 144 Less: Repayments 145 Interest 146 Ending cash balance 147 Value Formula Cell Reference Formula Formula Formula Formula Formula Formula Formula $ 1,473,575.00 148 149 Waterway Corporation Cash Budget For the First Quarter of 20xx First Quarter January February March Quarter 8 Beginning cash balance $ 100,500 $ 800,000 $ 800,000 Cell Reference 9 Add: Receipts -0 Collections from customers $ 1,336,380 $ 1,350,900 $ 1,385,700 $ 4,072,980 1 Total available cash $ 1,436,880 $ 2,150,900 $ 2,185,700 $ 4,072,980 32 Less: Disbursements 33 Direct Materials 34 Direct Labor 35 Manufacturing Overhead 36 Selling and Administrative Expense ssss $ 205,304 $ 169,498 $ 172,815 $ 547,617 $ 180,720 $ 180,560 $ 187,040 $ 548,320 $ 97,860 $ 97,830 $ 99,045 $ 294,735 $ 274,700 $ 273,900 $ 279,500 $ 828,100 37 Equipment Purchase $ 500,000 $ 500,000 38 Dividends $ 12,500 $ 12,500 $ 12,500 $ 37,500 39 Total disbursements $ 771,084 $ 1,234,288 $ 750,900 $ 2,756,272 40 Excess (deficiency) of available cash over cash 41 disbursements $ 665,796 $ 916,612 $ 1,434,800 $ 1,316,708 42 Financing: 143 Add: Borrowings 144 Less: Repayments 145 Interest 146 Ending cash balance 147 Value Formula Cell Reference Formula Formula Formula Formula Formula Formula Formula $ 1,473,575.00 148 149