C Home + Comments Catch up Editing Share > h fanshawecca-my.sharepoint.com Online Tools | Fanshawe College MGMT5063 Organizational Change & Deve... ACCT5012 Group Project Student F23.xlsx is depreciation in a cash budget - Google S... WP for Ethan Brown: ACCT5012 - Management... ACCT5012 Group Project Student F23 Search for tools, help, and more (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Automate Help HB Calibri (Body) 12 A A BI U ab D ab Custom - .00 0 .00 0 NTT B9 fx A B C E F G H J K M N P Q R S 1 2 3 Max. Poin Group Points 4 5 6 7 Beginning cash balance 8 Add: Receipts 9 Collections from Customers 10 Total receipts: 11 Total available cash: 12 Less: Disbursements 13 Direct Materials 14 Direct Labour 15 Manufacturing Overhead 16 Selling and Administrative expenses 17 Purchase of a Machine 18 Income Tax expense 19 Dividends CASH BUDGET for the year ending 31st December 2023 1 15560 2 3 4 $ Year 15,560.00 HB 2 2 2 2 $ 219,280 $ 236,720 $ 269,120 $ 281,520 $ 1,006,640 2 $1,824,793.60 $1,988,080.64 $2,262,865.92 $2,360,960.00 $8,436,700.16 2 31469 137495 20 Total disbursements: 21 Excess (deficiency) of available cash over cash disbursements 22 Financing 23 Add: Borrowings 24 Less: Repayments (including interest) 25 Ending cash balance 26 27 Notes: 0 32048 142045 33022 33370 129910 2 152040 156275 587855 2 0 250000 250000 500000 2 60000 2 2 2 2 2 2 2 32 EB > T U V W X Y Z AA = Cost of Ending Finished Invento Cost of Goods Sold Selling & Admin. budget Income Statement CVP Income Statement Cash Budget Worksheets Balance Sheet + Workbook Statistics Give Feedback to Microsoft | 75% +