Please fill in the cash flow template from the data entry sheet, showing all the formulas used please :)

ASSIGNMENT 1 2001 CASH FLOW Ma'a Motors Cash Flow Forecast Quarter ending 31 December 2020 NOTE: Depending on how the cash flow is prepared, not all pink and blue cells may need entries October November December | Quarter Cash Flow from Operating Activities Inflow From rentals Total Cash Inflow Outflow Advertising Depot rent General Insurance Maintenance and Servicing Wages Total outflow Net Cash Inflow (outflow) from operations Beginning cash balance Ending cash balance ASSIGNMENT 1,2001 DATA ENTRY Months in a year Months in a quarter (budgetperiod) 30 Revenue Days for hire September Ocbber November December 31 30 31 85% Hireage level Cash collection - Month ofsale Month following sale Hire price per day Average daily revenue if all cars hired out 60% 40% 30 $800 OTHER PAYMENTS Depotrent Advertising General (Telephone, Supplies, Utilities, ISP etc)) Maintenance and servicing Wages Monthly $4,000 $500 $400 $3,000 $5,000 Annual $15,000 Insurance premium 12 months (paid 1 June 2020) BALANCE SHEET ITEMS Cash at Bank as at 1 October 2020 Accounts Payable Advertising 1 October 2020 $11.750 $525T NON-CURRENT ASSETS Cost Expected Life Years 5 61 Residual Value $ $100,000 $2,000 Motor Vehicles Office Furniture and Fittings $300,000 $20,000 Straight line method is used for all non-currentassets