Question: Question 1 ( 4 3 marks in total ) Staples Digital is planning to open a new location soon that will be cash intensive and

Question 1(43 marks in total) Staples Digital is planning to open a new location soon that will be cash intensive and management wants to know the estimated cashflow in the six months to the planned opening date. Operations and administration have provided the following information: 1. Available cash at the end of December 2020 was \(13,000\).2. Sales in December 2020 was \(36,200\).3.\(70\%\) of sales are collected in cash immediately and the remaining \(30\%\) is collected one month after the month of sale. 4.\(60\%\) of purchases are paid in cash immediately and the remaining \(40\%\) is paid two months after the month of purchase. 5. November purchase was 18,600.6. Staples Digital pay salary of \(7500\) every month. 7. The monthly rent that Staples Digital pay is \(1800\).8. Monthly utilities bill amounts to \(190\).9. The depreciation charge for Staples Digital non-current assets is \(220\) monthly. 10. Staples Digital plan to take a loan in March 2021 with monthly interest of \(1450\) Sales and purchases have been forecasted to be the following: Required: a) Prepare a cash flow forecast from January 2021 to June 2021. All relevant workings must be shown (41 marks). b) Based on this cash flow forecast, comment on whether you consider this business to be sustainable, and explain why? (2 marks)
Question 1 ( 4 3 marks in total ) Staples Digital

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!