(**quick disclaimer: The free cash flows EACH year is suppose to be a different number each time cause my previous question answered on here had years 1-9 the same number throughout, but it was marked wrong. This my third time uploading the same question but with different numbers so please be 100% sure your're correct )
You are a manager at Northern Fibre, which is considering expanding its operations in synthetic fibre manufacturing. Your boss comes into your office, drops a consultant's report on yourdesk, and complains, "We owe these consultants $1.3 million for this report, and I am not sure their analysis makes sense. Before we spend the $26 million on new equipment needed for this project, look it over and give me your opinion." You open the report and find the following estimates (in millions of dollars):
All of the estimates in the report seem correct. You note that the consultants used straight-line depreciation for the new equipment that will be purchased today (year 0), which is what the accounting department recommended for financial reporting purposes. CRA allows a CCA rate of 45% on the equipment for tax purposes. The report concludes that because the project will increase earnings by $5.798 million per year for 10 years, the project is worth $57.98 million. You think back to your glory days in finance class and realize there is more work to be done!
First you note that the consultants have not factored in the fact that the project will require $11 million in working capital up front (year 0), which will be fully recovered in year 10. Next you see they have attributed $2.08 million of selling, general and administrative expenses to the project, but you know that $1.04 million of this amount is overhead that will be incurred even if the project is not accepted. Finally, you know that accounting earnings are not the right thing to focus on!
QUESTION:
a. Given the available information, what are the free cash flows in years 0 through 10 that should be used to evaluate the proposed project?
1. The free cash flow for year 0 is $___ million. (Round to three decimal places, and enter a decrease as a negativenumber.)
2. The free cash flow for year 1 is $___ million. (Round to three decimal places, and enter a decrease as a negativenumber.)
3. The free cash flow for year 2 is $___ million. (Round to three decimal places, and enter a decrease as a negativenumber.)
4. The free cash flow for year 3 is $___ million. (Round to three decimal places, and enter a decrease as a negativenumber.)
5. The free cash flow for year 4 is $___ million. (Round to three decimal places, and enter a decrease as a negativenumber.)
6. The free cash flow for year 5 is $___ million. (Round to three decimal places, and enter a decrease as a negativenumber.)
7. The free cash flow for year 6 is $___ million. (Round to three decimal places, and enter a decrease as a negativenumber.)
8. The free cash flow for year 7 is $___ million. (Round to three decimal places, and enter a decrease as a negativenumber.)
9. The free cash flow for year 8 is $___ million. (Round to three decimal places, and enter a decrease as a negativenumber.)
10. The free cash flow for year 9 is $___ million. (Round to three decimal places, and enter a decrease as a negativenumber.)
11. The free cash flow for year 10 is $___ million. (Round to three decimal places, and enter a decrease as a negativenumber.)
Note** In my answer also you will get all fund flow from 1 to 9 years same. If later on i realised that i was wrong i will update you.
Thanks
Solution
Year | Sales | Cost of Goods Sold | Addl General Sales & Administrative exp | Deprecaition | Net Profit for Tax | Tax Amount (35%) | Cash Flow from the Projects | Working Capital Investment | New Equipment Cost | Total Free Cash Flow from the projects |
0 | - | - | - | - | - | - | -11.000 | -26.000 | -37.000 | |
1 | 34.000 | 20.400 | 2.080 | 2.600 | 8.920 | 3.122 | 8.398 | - | - | 8.398 |
2 | 34.000 | 20.400 | 2.080 | 2.600 | 8.920 | 3.122 | 8.398 | - | - | 8.398 |
3 | 34.000 | 20.400 | 2.080 | 2.600 | 8.920 | 3.122 | 8.398 | - | - | 8.398 |
4 | 34.000 | 20.400 | 2.080 | 2.600 | 8.920 | 3.122 | 8.398 | - | - | 8.398 |
5 | 34.000 | 20.400 | 2.080 | 2.600 | 8.920 | 3.122 | 8.398 | - | - | 8.398 |
6 | 34.000 | 20.400 | 2.080 | 2.600 | 8.920 | 3.122 | 8.398 | - | - | 8.398 |
7 | 34.000 | 20.400 | 2.080 | 2.600 | 8.920 | 3.122 | 8.398 | - | - | 8.398 |
8 | 34.000 | 20.400 | 2.080 | 2.600 | 8.920 | 3.122 | 8.398 | - | - | 8.398 |
9 | 34.000 | 20.400 | 2.080 | 2.600 | 8.920 | 3.122 | 8.398 | - | - | 8.398 |
10 | 34.000 | 20.400 | 2.080 | 2.600 | 8.920 | 3.122 | 8.398 | 11.000 | - | 19.398 |
*Additional General, Sales and Administrative Expenses relevant for proposed project
= $ 2.080 - 1.040 = $1.040 million
**Income Tax Rate = 3.122 / 8.920 = 35%
(**quick disclaimer: The free cash flows EACH year is suppose to be a different number each...
(**quick disclaimer: The free cash flows EACH year is suppose to be a different number each time cause my previous question answered on here had years 1-9 the same number throughout, but it was marked wrong. SO IF YEARS 1-9 ARE THE SAME ITS INCORRECT! Also, attempted 12.259 for year 1 and its also incorrect. This my fourth time uploading the same question but with different numbers so please be 100% sure you're correct please and ill leave a thumbs...
You are a manager at Northern Fibre, which is considering expanding its operations in synthetic fibre manufacturing. Your boss comes into your office, drops a consultant's report on your desk, and complains, "We owe these consultants $1.9 million for this report, and I am not sure their analysis makes sense. Before we spend the $24 million on new equipment needed for this project, look it over and give me your opinion." You open the report and find the following estimates...
You are a manager at Percolated Fibre, which is considering expanding its operations in synthetic fibre manufacturing. Your boss comes into your office, drops a consultant's report on your desk, and complains, "We owe these consultants $ 1.7 million for this report, and I am not sure their analysis makes sense. Before we spend the $ 25.6 million on new equipment needed for this project, look it over and give me your opinion." You open the report and find the...
You are a manager at Percolated Fiber whith is considering expanding its operations in syntherc fber manufacturing. Your bess comes into your office, drops a consultans report on your desk, and complans, VWe owe these consutants $1. million for this report, and I amnct sure their analysis makes Befcre we Faminga Farecast (S millionj Salas ra - Co: of goods sold 34 000 20.400 20.400 20 400 20.400 -Saing, general ad admnstratr -Depreciation Nat aparating income Incomc tax 2400 2.400...
eBook Horizon Value of Free Cash Flows Current and projected free cash flows for Radell Global Operations are shown below. Actual 2018 $611.74 2019 $672.42 Projected 2020 $712.47 2021 $762.34 Free cash flow (millions of dollars) Growth is expected to be constant after 2020, and the weighted average cost of capital is 11.25%. What is the horizon (continuing) value at 2021 if growth from 2020 remains constant? Do not round intermediate calculations. Enter your answer in millions. For example, an...
You are a manager at Northern Fibre, which is considering expanding its operations in synthetic fibre manufacturing. Your boss comes into your office, drops a consultant's report on your desk, and complains, "We owe these consultants $1.3 million for this report, and I am not sure their analysis makes sense. Before we spend the $26 million on new equipment needed for this project, look it over and give me your opinion." You open the report and find the following estimates...
You are a manager at Percolated Fiber, which is considering expanding its operations in synthetic fiber manufacturing. Your boss comes into your office, drops a consultant's report on your desk, and complains, "We owe these consultants $1.4 million for this report, and I am not sure their analysis makes sense. Before we spend the $19.5 million on new equipment needed for this project, look it over and give me your opinion." You open the report and find the following estimates...
THE YEARS 1-9 ARE NOT SUPPOSE TO BE THE SAME IN EACH YEAR'S FINAL CASH FLOW BECAUSE ITS INCORRECT. FOR INSTANCE, YEARS 1-9 ARE NOT SUPPOSE TO BE 7.227 EACH YEAR. RATHER, ITS SUPPOSE TO BE A DIFFERENT NUMBER EACH YEAR. You are a manager at Northern Fibre, which is considering expanding its operations in synthetic fibre manufacturing. Your boss comes into your office, drops a consultant's report on yourdesk, and complains, "We owe these consultants $1.9 million for this...
The cash flows associated with an investment project are an immediate cost of $2300 and benefits of $1200 in one year, $800 in two years, and $2000 in three years. The cost of capital (WACC) is 10%. What is the project's NPV? Your Answer: Answer Hide hint for Question 6 NPV is the sum of the discounted cash flows. A firm is considering a potential investment project that would result in an immediate loss in free cash flow of $116...
2 RiverRocks, Inc., is considering a project with the following projected free cash flows: 2 Year 3 0 4 Cash Flow (in millions) $19.6 $10.4 $19.9 -$50.7 $14.9 The firm believes that, given the risk of this project, the WACC method is the appropriate approach to valuing the project. RiverRocks' WACC is 11.7%. Should it take on this project? Why or why not? The timeline for the project's cash flows is: (Select the best choice below.) OA. Cash Flows (millions)...