Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 3 [30] Your friend James has started his own printing cafe in August 2021 and needs to present acash flow forecast to the bank
Question 3 [30] Your friend James has started his own printing cafe in August 2021 and needs to present acash 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 R200000 and R240000, 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. Salaries and wages for August and September were R30 000 per month, but will increase by 8% from October. The office building rent is R10 000 per month and James expects to repair the office building in November at a cost of R50 000. James had R6 000 cash in his bank account at the end of August 2021. 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. Baker Corporation Statement of Cash Flows ($000) TABLE 4.6 for the Year Ended December 31, 2015 Cash flow from operating activities Net profits after taxes $180 Depreciation 100 Decrease in accounts receivable 100 Decrease in inventories 300 Increase in accounts payable 200 Decrease in accruals 100" Cash provided by operating activities $780 Cash flow from investment activities Increase in gross fixed assets ($300) Changes in equity investments in other firms 0 Cash provided by investment activities ($300) Cash flow from financing activities Decrease in notes payable ($100) Increase in long-term debt 200 Changes in stockholders' equity 0 Dividends paid 80) Cash provided by financing activities $ 20 Net increase in cash and marketable securities $500 "As is customary, parentheses are used to denote a negative number, which in this case is a cash outflow. "Retained earnings are excluded here because their change is actually reflected in the combination of the Net profits after taxes" and "Dividends paid" entries
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started