Bundle: Financial Management: Theory And Practice, Loose-leaf Version, 15th + Mindtapv2.0 Finance, 1 Term (6 Months) Printed Access Card
15th Edition
ISBN: 9780357261736
Author: Eugene F. Brigham, Michael C. Ehrhardt
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 7, Problem 22SP
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-4free 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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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
Consider an investment where the cash flows are:
– $946.21 at time t = 0 (negative since this is your initial investment)
$377 at time t = 1 in years
$204 at time t = 2 in years
$499 at time t = 3 in years
(a) Use Excel's "Solver" to find the internal rate of return (IRR) of this investment. Take a screen shot showing
Solver open with your entries for the function clearly visible. Paste the screen shot into an application (like
Paint), and save it as a (.png) file. Upload your screenshot below.
(b) What is the value of IRR found by Solver?
Show your work (use of formula, etc.) in solving the problem.
Provide your answer/solution in the answer space provided below.
Answer the question:
Given the following historical returns, calculate the average return and the standard deviation:
Year
Return
1
14%
2
10%
3
15%
4
11%
Chapter 7 Solutions
Bundle: Financial Management: Theory And Practice, Loose-leaf Version, 15th + Mindtapv2.0 Finance, 1 Term (6 Months) Printed Access Card
Ch. 7 - Two investors are evaluating General Electric’s...Ch. 7 - A bond that pays interest forever and has no...Ch. 7 - Explain how to use the free cash flow valuation...Ch. 7 - EMC Corporations current free cash flow is 400,000...Ch. 7 - Thress Industries just paid a dividend of $1.50 a...Ch. 7 - Boehm Incorporated is expected to pay a 1.50 per...Ch. 7 - Woidtke Manufacturing’s stock currently sells for...Ch. 7 - A company currently pays a dividend of $2 per...Ch. 7 - Nick’s Enchiladas has preferred stock outstanding...Ch. 7 - Kendra Enterprises has never paid a dividend. Free...
Ch. 7 - Dozier Corporation is a fast-growing supplier of...Ch. 7 - Crisp Cookware’s common stock is expected to pay a...Ch. 7 - Prob. 10PCh. 7 - Prob. 12PCh. 7 - Simpkins Corporation does not pay any dividends...Ch. 7 - Several years ago, Rolen Riders issued preferred...Ch. 7 - You buy a share of The Ludwig Corporation stock...Ch. 7 - You are analyzing Jillians Jewelry (JJ) stock for...Ch. 7 - Prob. 20PCh. 7 - Start with the partial model in the file Ch07 P25...Ch. 7 - Prob. 23SPCh. 7 - Start with the partial model in the file Ch07 P27...Ch. 7 - Describe briefly the legal rights and privileges...Ch. 7 - Prob. 2MCCh. 7 - Use a pie chart to illustrate the sources that...Ch. 7 - Suppose the free cash flow at Time 1 is expected...Ch. 7 - Use BMs data and the free cash flow valuation...Ch. 7 - You have just learned that B&M has undertaken a...Ch. 7 - Prob. 7MCCh. 7 - Prob. 8MCCh. 7 - Prob. 9MCCh. 7 - What is the horizon value at Year 4? What is the...Ch. 7 - Prob. 11MCCh. 7 - Prob. 14MCCh. 7 - Prob. 15MCCh. 7 - Assume that Temp Force is a constant growth...Ch. 7 - Prob. 17MCCh. 7 - Prob. 18MCCh. 7 - Prob. 19MCCh. 7 - Prob. 20MCCh. 7 - Prob. 21MC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Financial Forecast : This section outlines the projected financial statements. The financial statements should include detailed notes/explanations and assumptions to substantiate your projections. You can use imaginary numbers, however, can you include a capital or a loan of $100,000 usd in the statments. Please provide the Key assumptions Provide the mentioned Financial statements in tabular form:Income statementBalance sheetCash flow statementBreak-even analysisarrow_forwardDetermine the rate of return for the cash flows shown in the diagram. Use trial and error (start with two trials with 5% and 10% interest rates) and then use interpolation (or more trials) to approximate the result. Roh?? S7000 1- ? Year 590 s90 s90 sz00 sz00 sz00 $3000arrow_forwardProfitability index. Given the discount rate and the future cash flow of each project listed in the following table, , use the PI to determine which projects the company should accept. ..... What is the Pl of project A? (Round to two decimal places.)arrow_forward
- The probability distribution of the returns of two assets, A and B, are shown in the table below. Calculate the covariance between the returns of asset A and asset B. State of Economy Probability of State Return of Asset A Return of Asset B Boom 0.20 40% 5% Normal 0.45 20% 10% Slow Down 0.25 0% 15% Recession 0.10 -20% 30% O-0.3750 -0.0114 0.3750 -50.2500 -2.525arrow_forwardThe possible rates of return of two assets, A and B, under different economic conditions are given below: Economic Situation Probability Return of Asset A Return of Asset B Recession 0.2 10% 6% Stable 0.5 14% 15% Growth 0.3 20% 11% An investor places 50% of his funds in Asset A and 50% in Asset B. [Note: you may use correlation between A and B as 0.2401] Required: (i)Calculate the risk and expected return for each asset. (ii)Calculate the risk and expected return of the investor’s 2-assets portfolio. (iii) What do you understand by total risk?arrow_forward3. Excel Question. Download the monthly NASDAQ prices (1985-2023) from Brightspace.What is the simple arithmetic average return over this period?What would have been your annualized HPR if you invested (reinvesting the proceeds)over this period? Disregard the question above because I cant attach the entire excel file but i will attach a screenshot. Please just tell me and explain to me which column do i use to find the arithmetic average return for this period and also how to calculate the annualized HPR over this period. I am just confused which column and which numbers to use.arrow_forward
- 3. Excel Question. Download the monthly NASDAQ prices (1985-2023) from Brightspace.What is the simple arithmetic average return over this period?What would have been your annualized HPR if you invested (reinvesting the proceeds)over this period? Disregard the question, I just put it there for your reference. But how do i compute the arithmetic average return for this? Please just tell me how to compute it. I am not asking you to solve it. And also tell me how to compute the annualized HPR using the dataarrow_forwardThe following table..shows the one-year return distribution of Startup, Inc. Calculate: a. The expected return. b. The standard deviation of the return. Data table (Click on the following icon in order to copy its contents into a spreadsheet.) 40% Probability Return - 80% 20% -65% 20% - 40% 10% -20% 10% 1,000%arrow_forwardThis graph shows the net present value of an investment with annual cash flows of -$1,000, $100, $300, $400, and $675 as a function of different costs of capital (interest %). Note that this cash flow returns increasing amounts after the initial investment. Drag left or right on the graph to move the cursors to see the net present value (NPV) for different costs of capital. The point where the curve crosses the X-axis determines the internal rate of return (IRR). (Note: due to limited pixel resolution, it is sometimes difficult to get to that precise point.)arrow_forward
- 6-1 YIELD CURVES Assume that yields on U.S. Treasury securities were as follows: Term Rate 6 months 4.69% 1 year 5.49 2 years 5.66 З years 5.71 4 years 5.89 5 years 6.05 10 years 6.12 20 years 6.64 30 years 6.76arrow_forwardrefer to below table ,Conduct a sensitivity analysis to determine the sensitivity of NPV to changes in the sales price, number of units sold, the variable costs per unit, fixed costs and the cost of capital. Set these variables’ values at 10% above and 10% below their base-case values. 2. Include a graph in your analysis with below table? 10% above Year Net Cash Flow (RM) Discount Rate (13.20%) Present Value (RM) 0 -1,217,800.00 1 -1217800 1 328,750.00 0.883392 290415.19 2 337,330.00 0.780382 263246.2 3 346,423.15 0.689383 238818.31 4 355,195.10 0.608996 216312.32 5 614,461.20 0.537982 330569.16 NPV 121561.19 10% below Year Net Cash Flow (RM) Discount Rate (10.80%) Present Value (RM) 0 -1,145,800.00 1 -1145800 1 184,000.00 0.902527 166064.98 2 185,395.00 0.814555 151014.45 3 189,459.85 0.735158 139282.93 4 193,936.89 0.6635 128677.14 5 448,143.25 0.598827 268360.17…arrow_forwardThe expected market return and risk for different assumptions about the state of the economy is shown below. State of Economy Probability of State Expected Market Return Fast growth 0.11 35% Slow growth 0.50 16% No growth 0.20 5% Recession 0.15 -22% Depression 0.04 -32% Compute the expected return and standard deviation. Note: Round your answers to 2 decimal places. Compute the expected return and risk for the following 2 scenarios: Note: Round your answers to 2 decimal places. Scenario 1: State of Economy Probability of State Expected Market Return Fast growth 0.09 38% Slow growth 0.33 16% No growth 0.36 2% Recession 0.19-18% Depression 0.03 -32% Scenario 2: State of Economy Probability of State Expected Market Return Fast growth 0.16 40% Slow growth 0.31 13% No growth 0.38 2% Recession 0.12-17% Depression 0.03 -33%arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Dividend disocunt model (DDM); Author: Edspira;https://www.youtube.com/watch?v=TlH3_iOHX3s;License: Standard YouTube License, CC-BY