cash flow

Task 4: Review the Cash Flow Statement Task No. Question Details The owner of Cup of Joe has prepared the following Cash Flow Forecast for the month from March to July 2018. In the table below: June SAR SAR SAR March April May puly SAR SAR Sales 10 000 2000 12000 11200 cash) 15 000 14 400 Sales 20 000 10800 18 000 14800 22 000 (credit Purchases 14000 14 000 16 400 (credit) 15 200 1800 4.1 Prepare the cash flow forecast for Cup of Joe for the 3 months May to July. You are required to 1. At the end of April the cash balance is forecast to be 20 00OSAR 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 2000 SAR is paid each month 5. Wages of 8 DOOSAR are paid each month Produce this using a spreadsheet. 4.3 Write a short email to the owner of the company on the changes that you have made and give your reasons. Students will be taking a screenshot on how to preview adjust and print the spreadsheet. 4.3