cash flow 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: April SAR March May June July SAR SAR SAR SAR Sales 400 8001 900 400 200 (cash) Sales 500 500 400 400 100 (credit) Purchases 4001 600 800 500 300 (credit) 4.11 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