Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

cash flow
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Exploring Strategic Change

Authors: Julia Balogun, Veronica Hope Hailey, Stafanie Gustafsson

4th Edition

0273778919, 9780273778912

More Books

Students also viewed these Accounting questions

Question

2. Use the working-backward strategy to plan a party.

Answered: 1 week ago

Question

Describe ERP and how it can create efficiency within a business

Answered: 1 week ago