uation of companies can be done by forecasting a series of cash flows and then estimating a horizon value. Your firm projects net cash flow in years 1 through 5 as follows: Year 1 Year 2 Year 3 Year 4 Year 5 100 Million $ 120 Million $ 135 Million $ 140 Million $ 147 Million $ Assume that the company is expecting a growth rate of 6% starting year 5 and a discount rate of 12%; compute the PV of the company? Show the details of all your calculations.

uation of companies can be done by forecasting a series of cash flows and then estimating a horizon value. Your firm projects net cash flow in years 1 through 5 as follows: Year 1 Year 2 Year 3 Year 4 Year 5 100 Million $ 120 Million $ 135 Million $ 140 Million $ 147 Million $ Assume that the company is expecting a growth rate of 6% starting year 5 and a discount rate of 12%; compute the PV of the company? Show the details of all your calculations.

Financial And Managerial Accounting

15th Edition

ISBN:9781337902663

Author:WARREN, Carl S.

Publisher:WARREN, Carl S.

Chapter26: Capital Investment Analysis

Section: Chapter Questions

Problem 4CMA

See similar textbooks

Similar questions

You will apply the concepts of company valuation that you have just learned to determine whether company XYZ is overvalued. We are currently at the end of the year "t". You performed a thorough financial analysis of XYZ and forecast the following Free Cash Flows (FCF): Year t+1: 352 million USDYear t+2: 385 million USDYear t+3: 407 million USDFrom year t+3 onward, you expect the FCFs to grow at a constant yearly rate of 4%. Through your analysis, you also determined that the appropriate Weighted Average Cost of Capital (WACC) for XYZ was 11%. Finally, you know that XYZ has 1000 million USD in debt and 100 million shares outstanding.
a firm wants to start a project. a team of financial analysts estimated the following cash flows. Years Cash Flow 0 -$100000 1 55000 2 43000 3 45000 suppose that the discount rate (interest rate) is 12%, the NPV will be?
Start with the partial model in the file Ch07 P25 Build a Model.xlsx on the textbook’s Web site. Selected data for the Derby Corporation are shown here. Use the data to answer the following questions.a. Calculate the estimated horizon value (i.e., the value of operations at the end of the forecast period immediately after the Year-4 free cash flow). Assume growth becomes constant after Year 3.b. Calculate the present value of the horizon value, the present value of the free cash flows, and the estimated Year-0 value of operations. c. Calculate the estimated Year-0 price per share of common equity. INPUTS (In Millions) YearCurrent Projected0 1 2 3 4Free cash flow −$20.0 $20.0 $80.0 $84.0Marketable securities $40Notes payable $100Long-term bonds $300Preferred stock $50WACC 9.00%Number of shares of stock 40
a firm wants to start a project. A team of financial analysts estimated the following cash flows; Year Cash flow 0 -$100000 1 $55000 2 $43000 3 $45000 1. Suppose the discount rate (interest rate) is 12%, what is the NPV? 2. Suppose that the discount rate (interest rate) is 12%, according to the calculation of NPV we should? 3. the payback period is? 4. Based on the payback period calculations and if the cut off point is 2 years, the project should? 5. Suppose that the discount rate (interest rate) is 12%, the profitability index (PI) is? 6. suppose that the discount rate (interest rate) is 12% based on the PI calculation, the project should?
Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth ofzero using MARR = 14.5%. The study period needs to be exactly 8 years and each year shouldhave at least one unique cash flow that is different from the cash flows over the other years. Youranswer should contain a table showing the cash flows for each year and a graphical representationof the cash flows (cash-flow diagram)
Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 14.5%. The study period needs to be exactly 8 years and each year should have at least one unique cash flow that is different from the cash flows over the other years. Your answer should contain a table showing the cash flows for each year and a graphical representation of the cash flows (cash-flow diagram).
Asap Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 5.5%. The study period needs to be exactly 8 years and each year should have at least one unique cash-flow that is different from the cash-flows over the other years. Your answer should contain a table showing the cash-flows for each year and a graphical representation of the cash-flows (cash-flow diagram).
You are a consultant to a firm evaluating an expansion of its current business. The cash-flow forecasts (in millions of dollars) for the project are as follows: Years Cash Flow -10 1-5 +4 On the basis of the behavior of the firm's stock, you believe that the beta of the firm is 1.2. Assume that the project has the same risk as the firm overall. Given that the rate of return available on risk-free investments is 4% and that the expected rate of return on the market portfolio is 15%, would you accept or reject the project? Аcсept Reject
The HUT is evaluating a 5 year investment projected to yield the following relevant cash flows over its 5 year life: Given that the firm employs a 12% discount rate, what is the value of each of the three criteria: NPV? Profitability Index? Payback Period? V
* Problem 1 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 12%. The study period needs to be exactly 9 years and each year should have at least one unique cash-flow that is different from the cash-ftows over the other years. Your answer should containa table showing the cash-flows for each year and a graphical representation of the cash-flows (cash-flow diagram).
Find the profitability index (PI) for the following series of future cash flows, assuming the company’s cost of capital is 13.85 percent. The initial outlay is $328,041. Year 1: $196,585 Year 2: $165,370 Year 3: $148,695 Year 4: $188,689 Year 5: $128,457
2. Assume that today is December 31, 2021 and you need to determine the firm value of CoolTech, Inc. You have decided to apply the free cash flow valuation model to the firm's financial data that you've developed from a variety of data sources. The key values you have compiled are summarized in the following table: Free Cash Flow Year FCF Other Data Growth rate of FCF, beyond 2025 to infinity = 3% Weighted average cost of capital = 8% 700,000 800,000 950,000 980,000 2022 %3D 2023 %3D 2024 2025 What is the value of the entire CoolTech's entire company? + Factac F%