Start with the partial model in the file Cho8 P25 Build a Model.xlsx. Selected data for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Start with the partial model in the file Cho8 P25 Build a Model.xlsx. Selected data for the Derby Corporation are shown here. Use the data to answer the questions. INPUTS (In Millions) Year Current Projected 3 4 Free cash flow -$20.0 $20.0 $80.0 $85.6 Marketable securities 40 $ 100 $ 300 Notes payable Long-term bonds Preferred stock 50 WACC 11.00% Number of shares of stock 20 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. Enter your answer in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answer to two decimal places. million 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. Enter your answers in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answers to two decimal places. Present value of Hv million million Present value of FCF Value of operations %24 million c. Calculate the estimated Year-0 price per share of common equity. Round your answer to the nearest cent. %24 %24 Start with the partial model in the file Cho8 P25 Build a Model.xlsx. Selected data for the Derby Corporation are shown here. Use the data to answer the questions. INPUTS (In Millions) Year Current Projected 3 4 Free cash flow -$20.0 $20.0 $80.0 $85.6 Marketable securities 40 $ 100 $ 300 Notes payable Long-term bonds Preferred stock 50 WACC 11.00% Number of shares of stock 20 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. Enter your answer in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answer to two decimal places. million 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. Enter your answers in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answers to two decimal places. Present value of Hv million million Present value of FCF Value of operations %24 million c. Calculate the estimated Year-0 price per share of common equity. Round your answer to the nearest cent. %24 %24
Expert Answer:
Answer rating: 100% (QA)
Estimated horizon value a growing perpetuity 856107011007 a 228980 million Growth rate i... View the full answer
Related Book For
Intermediate Financial Management
ISBN: 978-1285850030
12th edition
Authors: Eugene F. Brigham, Phillip R. Daves
Posted Date:
Students also viewed these accounting questions
-
Start with the partial model in the file Ch21 P08 Build a Model.xlsx on the textbook's Web site. Kasperov Corporation has an unlevered cost of equity of 12% and is taxed at a 40% rate. The 4-year...
-
Start with the partial model in the file Ch12 P11 Build a Model.xlsx on the textbook's Web site, which contains Henley Corporation's most recent financial statements. Use the following ratios and...
-
Start with the partial model in the file Ch3 P07 Build a Model.xls from the textbook's Web site. Following is information for the required returns and standard deviations of returns for A, B, and C:...
-
A 0.1 cm thick flat copper plate, 2.5 m x 2.5 m square is to be cooled in a vertical position. The initial temperature of the plate is 90?C with the ambient fluid at 30?C. The fluid medium is either...
-
Conduct a two-sample ttest (Section 9.2) of the null hypothesis that the two treatment means are equal for each dot plot. Use = .05 and two-tailed tests. In the course of the test, compare each of...
-
Stroud Sporting Gear Inc. has a net profit margin of 9%, a total asset turnover of 2.4, total assets of $225 million, and total equity of $120 million. What is the company's return on equity?
-
Identify the four components of a use case and how they affect each other.
-
Lets say your boss develops an EFE Matrix that includes 62 factors. How would you suggest reducing the number of factors to 20?
-
Image transcription text timing, and colour represents brake thermal efficiency (landscape format, in colour) b) Analyse the heat loss (%) and ignition delay (deg) and plot them as a function of...
-
Myles Etter and Crystal Santori are partners who share in the income equally and have capital balances of $210,000 and $62,500, respectively. Etter, with the consent of Santori, sells one-third of...
-
Check the boxes of the points where the graph has an absolute maximum A. a B. b C. c D. d E. e F. r G. s H. t Check the boxes of the points where the graph has an absolute minimum A. a B. b C. c D. d...
-
Perform research on financial service institutions in your geographic area. Describe in detail the financial services that each provides, comparing interest rates, fees, and investment options. Which...
-
Identify some impacts on the financial services industry caused by changes in general economic conditions. (Identify the economic and political climate relating to the financial services industry).
-
Hugh has the choice between investing in a City of Heflin bond at 3.45 percent or investing in a Surething Incorporated bond at 4.75 percent. Assuming that both bonds have the same nontax...
-
How do theories of socialization, such as symbolic interactionism and social learning theory, help us understand the mechanisms through which individuals acquire and internalize social norms, roles,...
-
S Last month when Holiday Creations, Incorporated, sold 37,000 units, total sales were $148,000, total variable expenses were $111,000, and fixed expenses were $36,500. Required: 1. What is the...
-
When a manufacturing company buys a machine that will last them many years, the cost of that machine does not constitute a cost to the company in the year when it was purchased. Rather, the machine...
-
I frequently use NY Times and CNN and am aware of Fox News but I never use it. I visit these sites, NY Times and CNN, a few times a week whenever I have to research something or see something on...
-
At today's spot exchange rates 1 U.S. dollar can be exchanged for 9 Mexican pesos or for 111.23 Japanese yen. You have pesos that you would like to exchange for yen. What is the cross rate between...
-
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $3,250,000 (all on credit), and its net profit margin was...
-
Chapman Inc.'s Mexican subsidiary, V. Gomez Corporation, is expected to pay to Chapman 50 pesos in dividends in 1 year after all foreign and U.S. taxes have been subtracted. The exchange rate in 1...
-
The isotope cesium-137, which has a half-life of 30 years, is a product of nuclear power plants. How long will it take for this isotope to decay to about one-half its original amount? (a) 0 yr (b) 15...
-
Which of the three raysalpha, beta, or gammahas the greatest penetrating power?
-
Which type of radiationalpha, beta, or gammaresults in the greatest change in mass number? The greatest change in atomic number?
Study smarter with the SolutionInn App