Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 3 [30] Your friend James has started his own printing cafe in August 2021 and needs to present a cash flow forecast to the

image text in transcribed
image text in transcribed
Question 3 [30] Your friend James has started his own printing cafe in August 2021 and needs to present a cash flow forecast to the bank as part of his financing application to buy a new 3D printer. James has little knowledge of cash flow forecasts and asked you to assist him with the calculation. He gave you the following information that might be helpful: Total sales for August and September were R200 000 and R240 000, respectively. James expects the sales to increase by 20% in October, and November's sales are expected to be R60 000 more than the sales in October Cash sales are estimated to be 30% of the total sales. Debtors must pay their outstanding debt as follows: 40% in the month after the sales, 35% in the second month after the sales and the rest in the third month after the sales. Purchases are 60% of the total sales, of which 20% are paid in cash. James must pay his creditors 40% in the month after the purchase and the rest must be settled in the second month after the purchase Salerobe. The office building cene is RTO 000 per month and James expects to repair the office building in James had R6 000 cash in his bank account at the end of August 2021. Salaries and wages for August and September were R30 000 per month, but will increase by 8% from November at a cost of R50 000 Required: Calculate a cash flow forecast from September 2021 to November 2021 using the format given in Table 4.6 of the prescribed textbook to determine the closing cash balance at the end of November 2021 Table 4.6 The general format of the cash budget Jan Feb R Nov R R R Cash receipts Less: Cosh disbursements XXX XXG XXM (XXA) XXB (XXH) XXI (XXN) XXO Net cash flow Add: Beginning cash Ending cash Less: Minimum cash balance XXC XXD XXD XXXJ XXP XXJ XXQ Required total financing Excess cash balance (XXE) (XXK) XXL (XXR) XXS XXF Firms generally use a combination of eyton final sales forecast T pyti

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

International Financial Accounting And Reporting

Authors: Ciaran Connolly

2nd Edition

0903854724, 978-0903854726

More Books

Students also viewed these Accounting questions