Excel File Edit View Insert Format Tools Data Window Help > . C ... MAA103 Budgeting Assignment (2) ~ Q Search (Cmd + Ctri + U) Of Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share & Cut Calibri (Body) 11 AA 2 7 V de Wrap Text v General Auto-sum " Av [A Copy Fill Paste BIU Av EE Merge & Centre v $ ~ % 9 00 -20 Conditional Format Cell Insert Delete Format Sort & Format Styles Clear v Find & Sensitivity Add-ins Analyse Formatting as Table Filter Select Data B29 + x V fx C D G M N O CASH BUDGET Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Jul-25 Aug-25 Sep-25 Oct-25 Nov-25 Dec-25 TOTAL OPENING CASH BALANCE CASH INFLOWS: Collections From Customers Bank Loan 10 11 TOTAL CASH AVAILABLE: 12 13 CASH OUTFLOWS 14 Payments For Purchases 15 Insurance Expense 16 Bank Fees 17 Council Rates 18 Office Supplies Expense 19 Utility Expense 20 Marketing Expenses 21 Rent Expense 22 Salaries Expense - Sales Assistant 23 Salaries Expense - Technicians 24 Salaries Expense - Office Staff 25 Drawings By Owners 26 Capital Investment (initial setup) 27 Purchase of Equipment 28 Interest Expense 29 30 31 32 CLOSING CASH BALANCE 34 35 37 48 49 Group_Information FactSheet Cash_Budget IncomeStatement_Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Schedule of Cash Collection Schedule of Cash Payments + Ready TX Accessibility: Investigate + 100% 23 SEP 12 GExcel File Edit View Insert Format Tools Data Window Help ()) A Australian $ 4 Q 8 0 Thu 12 Sep 1:58:41 PM AutoSave O h A ? ? . C ... MAA103 Budgeting Assignment (2) ~ Q Search (Cmd + Ctri + U) Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share & Cut Calibri (Body) 11 AA 2 7 V ap Wrap Text v General Auto-sum " As [A Copy Paste Fill Format B U v MvAv Merge & Centre v $ ~ % " 00 -20 Conditional Format Cell Insert Delete Format Sort & Find & Sensitivity Add-ins Analyse Formatting as Table Styles Clear v Filter Select Data D55 4 X V fx BUDGETED INCOME STATEMENT Jan-25 Feb.25 Mar-25 Apr-25 May-25 Jun-25 Jul-25 Aug-25 Sep-25 Oct-25 Nov-25 Dec-25 TOTAL Sales Revenue Cost of Goods Sold Gross Profit other Income Service Revenue Operating Expenses Selling Expenses: Marketing Expenses Depreciation Expense - Shop Fittings Depreciation Expense - Repair Equipment Salaries Expense - Sales Assistant Salaries Expense - Technicians Utility Expense Council Rates Insurance Expense Depreciation Expense - Initial Setup General & Administrative Expenses: Insurance Expense Council Rates Office Supplies Expense Utility Expense Depreciation Expense - Office Equipment Salaries Expense - Office Staff Total Operating Expense Net Operating Profit on-Operating Income and Expenses Interest Expense Profit (Loss) before income tax 4 Group_Information FactSheet Cash_Budget IncomeStatement_Budget Sales Budget Cost of Sales Budget Purchases Budget Selling & Admin Expense Budget Schedule of Cash Collection Schedule of Ca Ready Ax Accessibility: Investigate UJ 70 23 SEP 12 G