the financial model includes, as a minimum, the projected cash flow, profit and loss, and balance sheet figures for the first year of trading i.e. until 31 December 2022. The statements should show quarterly figures with annual totals, where appropriate.

A:18 B:1 C:20

in Excel and send me the screenshot, please

and this is the information

1. The first quarters sales are expected to be 3,000 doubling every quarter during the year. 2. The gross profit margin on sales is expected to be 40%. 3. Of each quarters sales, A% are cash sales. 4. Bad debts are on credit sales and are anticipated to be B% each quarter. 5. 50% of the credit sales are paid in the quarter in which the sale is made. The remaining debtors, after bad debts, are collected in the following quarter. 6. Sufficient stock is purchased to cover the next quarters sales e.g. the stock for the sales in the fourth quarter is purchased in the third quarter. In the first quarter assume the first two quarters purchases are made and assume the final quarters purchases are 30,000 (the sales for the first quarter of 2023 are unknown). 7. Purchases are paid for in the quarter bought (i.e. there are no trade creditors).

8. Gross staff salaries are 2,100 per quarter and paid in the quarter incurred. 9. Distribution costs are 10% of sales and are paid in the quarter of the sale. 10. Bank interest charged is 2% per quarter calculated on the balance at the end of the previous quarter. It is payable in the following quarter i.e. the quarter in which it is charged. No interest is receivable on credit (positive) balances. 11. The company buys machinery costing 10,000 in the first quarter. 12. A van costing 8,000 is purchased in the third quarter. 13. The company depreciation policy is to depreciate assets at C% per annum on a straight-line basis. 14. The company incurs a quarterly telephone bill of 525, which is usually paid in the quarter it is incurred. However, the fourth quarters bill is 600 and will not be paid until January 2023. 15. Ignore the effect of corporation tax, VAT, PAYE, and inflation. 16. Include any other expenses Emma has obviously omitted from the above information.