---### Financial Analysis Exercise: Evaluating a New Product Line#### Scenario:You are a manager at Permeable Fiber, which is considering adding a new product line. Your boss has indicated that consultants were paid $1.1 million to provide their estimates, which primarily focus on Net Income. Before investing $32 million in new equipment for this project, it is crucial to review the provided financial estimates and give your opinion.#### Financial Estimates (in millions of dollars):| | 1 | 2 ||---|---|---|| **Sales revenue** | 77.0 | 77.0 || **Cost of goods sold** | 42.0 | 42.0 || **Gross profit** | 35.0 | 35.0 || **Selling, general & admin. expenses** | 4.0 | 4.0 || **Depreciation** | 16.0 | 16.0 || **Net operating income** | 15.0 | 15.0 || **Income tax** | 4.1 | 4.1 || **Net Income** | 11.0 | 11.0 |#### Notes:- All calculations made by the consultants are correct.- The project demands $25 million in working capital upfront (Year 0), which will be fully recovered in the final year of the project (Year 2).---#### Task:Based on the given information, calculate the Free Cash Flow (FCF) for the relevant periods. Enter your calculated values in the boxes below:- **The first relevant period's FCF is:** [ ]- **The second relevant period's FCF is:** [ ]- **The third relevant period's FCF (if any) is:** [ ]---### Explanation of Financial Concepts:**Free Cash Flow (FCF):**Free Cash Flow represents the cash that a company generates after accounting for cash outflows to support operations and maintain its capital assets. It is a vital measurement as it shows how efficient a company is at generating cash.The formula to calculate FCF is:\[ \text{FCF} = \text{Net Operating Income} - \text{Taxes Paid} + \text{Depreciation} - \text{Change in Working Capital} \]When analyzing investments or projects, positive FCF indicates that the project is generating excess cash that can be

Relevant cash flows while evaluating a capital project are the cash flows, to be resulted due to the…

You are a manager at Permeable Fiber, which is considering adding a new product line. Your boss said to you "We already owe these consultants $1.1 million, and all they estimated is Net Income. Before we spend $32 million on new equipment for this project, look the report over and give me your opinion." Here are the report's estimates (in millions of dollars; note that the question is continued below, so you need to scroll down to see it all): 1 2 Sales revenue 77.0 77.0 - Cost of goods sold 42.0 42.0 Gross profit 35.0 35.0 -Selling, gen. & admin. exp. 4.0 4.0 -Depreciation 16.0 16.0 Net operating income 15.0 15.0 - Income tax 4.1 4.1 Net Income 11.0 11.0 Everything that the consultants have calculated is correct, as far as it goes. The project will require $25 million in working capital upfront (year 0), which will be fully recovered in the last year of the project (year 2). The first relevant period's FCF is: The second relevant period's FCF is: The third relevant period's FCF (if any) is:

You are a manager at Permeable Fiber, which is considering adding a new product line. Your boss said to you "We already owe these consultants $1.1 million, and all they estimated is Net Income. Before we spend $32 million on new equipment for this project, look the report over and give me your opinion." Here are the report's estimates (in millions of dollars; note that the question is continued below, so you need to scroll down to see it all): 1 2 Sales revenue 77.0 77.0 - Cost of goods sold 42.0 42.0 Gross profit 35.0 35.0 -Selling, gen. & admin. exp. 4.0 4.0 -Depreciation 16.0 16.0 Net operating income 15.0 15.0 - Income tax 4.1 4.1 Net Income 11.0 11.0 Everything that the consultants have calculated is correct, as far as it goes. The project will require $25 million in working capital upfront (year 0), which will be fully recovered in the last year of the project (year 2). The first relevant period's FCF is: The second relevant period's FCF is: The third relevant period's FCF (if any) is:

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Please show complete steps thanks and correctly. If you are using excel show cell referencing and explain also pls.
Business at your design engineering firm has been brisk. To keep up with the increasing workload, you are considering the purchase of a new state-of-the-art CAD/CAM system costing $550,000, which would provide 4,500 hours of productive time per year. Your firm puts a lot of effort into drawing new product designs. At present, this is all done by design engineers on an old CAD/CAM system installed five years ago. If you purchase the system, 40% of the productive time will be devoted to drawing (CAD) and the remainder to CAM. While drawing, the system is expected to out-produce the old CAD/CAM system by a factor of 2.1. You estimate that the additional annual out-of-pocket cost of maintaining the new CAD/CAM system will be $155,000, including any tax effects. The expected useful life of the system is eight years, after which the equipment will have no residual value. As an alternative, you could hire more design engineers. Each normally works 1,800 hours per year, and 50% of this time is…
Talbot Industries is considering launching a new product. The new manufacturing equipment will cost $18 million, and production and sales will require an initial $3 million investment in net operating working capital. The company's tax rate is 25 %. Enter your answers as a positive values. Enter your answers in millions. For example, an answer of $10,550,000 should be entered as 10.55. Round your answers to two decimal places. Please show all work and solutions. Show all work.
Doug Washington, the owner of Coyote Printing, is evaluating a printing company in Texas. Stan College, the company's CFO, has just finished his analysis of company. He has estimated that the printing company would be productive for eight years, during which the market would be completely diminished. Stan has taken an estimate of the balance statement and forecast to Hattie May, the company's financial officer. Hattie has been asked by Doug to perform an analysis of the printing company and present her recommendation on whether the company should open the take over the printing company. Hattie May has used the estimates provided by Stan to determine the revenues that could be expected from the printing company. She has also projected the expense of taking over the printing company and the annual operating expenses. If the company takes over the printing company, it will cost $700 million today, and it will have a cash outflow of $75 million nine years from today in costs associated…
Persimmon, Inc. is considering a 3 year project. Your boss said to you “We owe these consultants $1.2 million for this report. Before we spend $15 million on new equipment needed for this project, look it over and give me your opinion.” Here are the report’s estimates (in millions of dollars): [BE SURE TO SCROLL DOWN TO SEE THE ENTIRE QUESTION.] 1 2 3 Sales revenue 25.0 25.0 25.0 - Cost of…
How do I solve this accounting question?
ONLY NEED ANSWER OF PART (IV)
Wally loves your analysis. He has now asked you to evaluate potential new project investments. Both projects aim to make widgets. Widgets sell for $10 each. Project A will produce 4,500 units in the first year, 6,500 units in the second and third years and a whopping 44,000 units in the fourth year. Project A requires an investment of 3 machines each costing $25,000. Project B will produce 2,400 units in the first year, 2,200 units in the second year, 1,950 units in the third year and 1,460 units in the fourth year. Project B requires an initial investment of 1 machine worth $25,000. Wally has said that to make the analysis easier - you need not calculate depreciation on the machine, the tax shelter benefit or the residual value of the machine at the end of production. Wally just said I want you understand the cash flows from the information provided above. (a) Calculate the net present value for each of Project A and Project B, assuming a 15% cost of capital. (b) What is the IRR of…
Suppose you have been hired as a financial consultant to Defense Electronics, Incorporated (DEI), a large, publicly traded firm that is the market share leader in radar detection systems (RDSS). The company is looking at setting up a manufacturing plant overseas to produce a new line of RDSS. This will be a five-year project. The company bought some land three years ago for $7.2 million in anticipation of using it as a toxic dump site for waste chemicals, but it built a piping system to safely discard the chemicals instead. If the land were sold today, the net proceeds would be $7.66 million after taxes. In five years, the land will be worth $7.96 million after taxes. The company wants to build its new manufacturing plant on this land; the plant will cost $13.24 million to build. The following market data on DEI's securities are current: Debt: Common stock: Preferred stock: Market: 91,200 6.9 percent coupon bonds outstanding, 23 years to maturity, selling for 94.4 percent of par; the…
Background Hyde Park Technologies Pty Ltd (HPT), a medium-sized enterprise with a turnover of $100 million per year is considering the purchase of an ERP system. As they have an urgent need to update their accounting system, they plan on purchasing an ERP financial module as the first step and then over time, they plan on integrating this module as part of a larger ERP rollout through the company. Eileen Dover, the CEO of HPT recently issued a request for proposal (RFP) to a number of ERP vendors. To assist the vendors in the preparation of their responses, Eileen has provided the following information: . HPT was founded by Eileen's father (Hans Dover) in 1986. Even though Hans is now in his 70s, he still plays an important figurehead role in the company and will have influence in the choice of vendor. Eileen has emphasised that whilst the presentation materials be to a high professional standard, it is imperative that they clearly and simply articulate the "Hansefits" of the new…
The Chief Operations Officer (COO) of a manufacturing firm recommends one of the manufacturing sites to undergo a process improvement initiative. He claims that this project will enable the company to realize a net savings of at least $3.25 Mln. The Chief Financial Officer (CFO) of the company tasked you to conduct a financial analysis to verify the claims of the COO. After performing cost analysis, you estimated that the project will require an initial investment of $2 Mln today and $1 Mln in Year 1. Afterwards, the initiative will yield an annual cost savings of $850k from Year 2 to Year 10. You assume that these cost savings are realized at the end of each year. (a) Suppose that you use a discount rate of 5%. Will the resulting net savings support the claim of the COO? (b) Determine the Internal Rate of Return (IRR) of the process improvement initiative. (c) Show the NPV profile of the project.
The independent project estimates below have been developed by the engineering and finance managers at Golphanen Enterprises. The corporate MARR is 8% per year, and the capital investment limit set by the CFO is $4 million. As a new employee in the Engineering Department, you have been asked to recommend the economically best projects. Use (a) hand solution, and (b) spreadsheet solution to determine your recommendation. Project Cost, Life, NCF, Project $ Millions Years $ per Year 1 −1.5 8 360,000 2 −3.5 10 600,000 3 −1.8 5 520,000 4 −2.0 4 820,000

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS