The owners of a business are drawing up a cash flow forecast for January, February and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The owners of a business are drawing up a cash flow forecast for January, February and March. They estimate that in January, revenue will be £20,000. This is expected to rise by 25% each month up to and including March. This is due to the owners spending £4,000 on marketing in January. Other costs are as follows: £6,250 per month on wages • £1,050 loan repayments in February and March • Additional costs per month equal to 15% of monthly revenue The opening balance is £15,000. Using the information, complete the cash flow forecast below. January February Inflows Revenue Total Inflows Outflows Marketing Wages Loan Repayments Additional Costs Total Outflows Net Cash Flow Opening Balance Closing Balance March The owners of a business are drawing up a cash flow forecast for January, February and March. They estimate that in January, revenue will be £20,000. This is expected to rise by 25% each month up to and including March. This is due to the owners spending £4,000 on marketing in January. Other costs are as follows: £6,250 per month on wages • £1,050 loan repayments in February and March • Additional costs per month equal to 15% of monthly revenue The opening balance is £15,000. Using the information, complete the cash flow forecast below. January February Inflows Revenue Total Inflows Outflows Marketing Wages Loan Repayments Additional Costs Total Outflows Net Cash Flow Opening Balance Closing Balance March
Expert Answer:
Answer rating: 100% (QA)
To complete the cash flow forecast we will calculate the inflows and outflows for each month and upd... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Diana has recently followed a course in furniture making and has decided to set up her own workshop from which she will be producing wooden chairs. She starts renting a small workshop at an annual...
-
Currently, the unit selling price of a product is $220, the unit variable cost is $180, and the total fixed costs are $312,000. A proposal is being evaluated to increase the unit selling price to...
-
Du Pont Identity If Roten Rooters, Inc., has an equity multiplier of 1.35, total asset turn-over of 1.30, and a profit margin of 8.5 percent, what is its ROE?
-
In a Harris poll of 514 human resource professionals, 463 said that the appearance of a job applicant is most important for a good first impression. Use 1000 bootstrap samples to construct a 99%...
-
Briefly explain the manner in which (a) input and output controls and (b) processing controls may be tested when an EDP system is used for cash receipts transactions.
-
Gutierrez Company reported net income of $225,000 for 2017. Gutierrez also reported depreciation expense of $45,000 and a loss of $5,000 on the disposal of equipment. The comparative balance sheet...
-
Big sister and little brother have just finished filling a crate with rocks from their garden. The crate of rocks has a mass of 11.0 kg and now must be moved. Big sister pulls on a rope attached to...
-
Refer to Figure 7.16. Assume that the head loss in the pipe is given by h L = 0.02(L/D)(V 2 /2g), where V is the mean velocity in the pipe, D is the pipe diameter, and L is the pipe length. The...
-
Paul's Premium Pillows has the following events occur during the current year. a. Paul paid his employees $90,000 cash for work done in the current year. He also owes an additional $10,000 for work...
-
Is the current organization of the United States system of Justice suited to produce "fair" outcomes? If so, what components are crucial to ensuring impartiality, justice for all? If not, identify...
-
If they rent, the builder will require monthly rental payments of $1,100 and a security deposit equal to two months of rent. Since they want to be protected against the possible loss of their...
-
The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 12,000 $ 16,450 Beginning work in process inventory 14,500...
-
You have built some intelligent projections shown below: 1. What is the Revenue CAGR (compounded annual growth rate) over this projection period? 2. What is the EBITDA CAGR (compounded annual...
-
In an organizational setting, how can you utilize knowledge on diversity, justice and cultural competency to help create greater justice and equity?
-
ABC company acquired the natural resource for $ 4,000,000. The estimated recoverable units from the natural resource at that time of purchase were 400,000 units. Assumed. 40,000 units of the natural...
-
A 20-cm-square vertical plate is heated to a temperature of 30oC and submerged in glycerin at 10oC. Calculate the heat lost from both sides of the plate.
-
Eureka Membership Warehouse, Inc., is a rapidly growing chain of retail outlets offering brand-name merchandise at discount prices. A security analysts report issued by a national brokerage firm...
-
VisiCalc, the first computer spreadsheet program, was released to the public in 1979. A year later, introduction of the DIF format made spreadsheets much more popular because they could now be...
-
The Energy Department estimates that domestic demand for natural gas will grow by more than 40% between now and 2025. Distinguish between a demand function and a demand curve. What is the difference...
-
List some BOs for this term and explain their role.
-
Identify the EBT for the word Change and give reasons for this choice.
-
Create three more patterns for change. Use three different scenarios.
Study smarter with the SolutionInn App