now please

Task No. Question Details The owner of a company has prepared the following Cash Flow Forecast for the month from March to July 2020. In the table below: March April May June July SAR SAR SAR SAR SAR Sales 1000 20000 3000 (cash) 5000 4000 Sales 5000 6000 800 (credit) 7000 1000 Purchase 400 500 900 1000 600 s (credit) 4.1 Prepare the cash flow forecast for the company for the 3 months May to July. You are required to 1. At the end of April the cash balance is forecast to be 10000SAR. 2. Credit sales are paid 2 months after they are sold 3. Credit purchases are to be paid 1 month after they are bought 4. Rent of 4000 SAR is paid each month 5. Wages of 10000SAR are paid each month Produce this using a spreadsheet