X C Home ACCT5012 Group Project Student F23 ho FOL Email Fanshawe College fanshawecca-my.sharepoint.com My files OneDrive Search for tools, help, and more (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Automate Help Zoom 70 100% New Window Freeze Panes Headings Gridlines Formula Bar Sheet View Default H7 fx A E F G H K L M N 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 B CASH BUDGET for the year ending 31st December 2023 1 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: 28 Minimum cash balance: $10,000 =ad Budget Workbook Statistics 2 3 4 Year 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 32 Exit Keep New Options 0 S ACCT5012 Group Project Student F23.xlsx Begins with Q Search Done EB HB PF Comments Catch up Editing Share Immersive Reader P Q R S T U V W X Y Z AA AB 15 Cost of Ending Finished Invento Cost of Goods Sold Selling & Admin. budget Income Statement CVP Income Statement Cash Budget Worksheets Balar + > AC AD Give Feedback to Microsoft | 75% +