How do I make a projected income statemtent?

Projected Income Statement Quarter ending 31 December 2020 Quarter Revenue Car Hire $58 650 Less Expenses Advertising $1 525 Depot rent $12 000 General expenses $1 200 Insurance premium 12 months (paid 1 June 2020) $0 Maintenance and servicing $9 000 Wages $15 000 Depreciation $14 333 Total expenses $53 058 Net Profit $5 592 Net Profit if Advertsing is $700 /month $8 601 Cash balance if Advertising is $700 /month $ 31 101Other 0 The business has a contract with Habib Garages to clean the cars and service them. The monthly fee for these services is $3,000. paid in the month incurred. 0 General costs (including telephone. stationary. ISP provider etc.) are estimated at $400 a month, paid in the month they are incurred. - Leilani hires Cheng Xu at $5,000 a month and this is paid on the twentieth of the month in which it is earned. (Ignore PAYE and any other deductions). - The depot is leased for a monthly fee of $4,000 and is payable on the rst of each month 0 The advertising is estimated at $500 a month and is payable by the 20th of the following month. . The annual insurance premium is $15,000 and was paid on 1 June 2020. o The balance of Cash at Bank on 1 October 20_2(1.1 $11,750 a The Balance of Accounts Payable on 1 October 2020 relating to Advertising was $525 Leilani Ma'a owns a car hire business mlled Ma'a Motors. Leilani comes to you asking for assistance in preparing budgets for the quarter 1 October to 31 December 2020. Following discussion you have noted down the following data. Revenue There are ten % and these are available for hire for each month for the given number of days: mm o The average hire price is $75 per day giving $750 daily revenue if all ten ears are hired out. o Although all the cars are available every day, on average they are only hired for 85% of the time. - Tourists pay when they collect the ear. but business travellers use the credit facility and pay on the 20'h of the month follow'ng their hire of the car. Based on earlier experience 40% of the hirers are business travellers and the rest (60%) are tourists. Non-Current Assets 0 It is business policy to use the straight line method of depreciation for all non-current assets. 0 The cars when bought two years ago had a cost price of $300,000 with an estimated useful life ofve years and a residual value of $100,000 0 The ofce equipment which cost $20,000 has an expected life of 6 years with $2,000 residual value