Start with the partial model in the file Ch08 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 Ch08 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 0 Projected 1 2 Free cash flow -$25.0 3 $25.0 $100.0 $107.0 4 Marketable securities $ 40 Notes payable $ 100 Long-term bonds $ 300 Preferred stock $ 50 WACC Number of shares of stock 12.00% 50 The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. 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. 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 FCF Present value of HV $ fill in the blank 3 million fill in the blank 4 million $ fill in the blank 5 million Value of operations c. Calculate the estimated Year-0 price per share of common equity. Round your answer to the nearest cent Start with the partial model in the file Ch08 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 0 Projected 1 2 Free cash flow -$25.0 3 $25.0 $100.0 $107.0 4 Marketable securities $ 40 Notes payable $ 100 Long-term bonds $ 300 Preferred stock $ 50 WACC Number of shares of stock 12.00% 50 The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. 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. 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 FCF Present value of HV $ fill in the blank 3 million fill in the blank 4 million $ fill in the blank 5 million Value of operations c. Calculate the estimated Year-0 price per share of common equity. Round your answer to the nearest cent
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Which of the following statements best describes the 'dilation' in rock mechanics? a. Movement of the rock along the shear direction during the direct shear tests b. Radial expansion of the intact...
-
Discuss some factors that must be considered in determining the maximum number of multiprogrammed processes for a particular system. You may assume a batch system with the same number of processes as...
-
Some of the highest tides in the world occur in the Bay of Fundy on the Atlantic Coast of Canada. At Hopewell Cape the water depth at low tide is about 2.0 m and at high tide it is about 12.0 m. The...
-
Which of the following has been a finding of prior research that has examined whether information systems audit staff should be recruited with an information technology background or an audit...
-
Define the term ubiquitous and explain whether this term can be used appropriately to describe bacteria and archaea.
-
ACCT 2301-003 Principles of Financial Accounting Fall 2022 Final exam-Quake Quantum Quays (QQQ) Project (35 points) Financial Accounting Spiceland 6th Edition QQQ was founded in 2021 Below is the...
-
Describe how you would organize and lead project meetings including the method you can use to reach consensus on meeting agendas, include citation to support how consensus will be reached?
-
Qualitative variables describe how much or how many of something there is. In Exercises 1114, determine whether the statement is true or false. If the statement is false, rewrite it as a true...
-
In a study, 200 patients with skin cancer are randomly divided into two groups. One group receives an experimental drug and the other group receives a placebo. Is this a randomized experiment or an...
-
A _______ sample is one in which the population is divided into groups and a random sample of groups is drawn. In Exercises 712, fill in each blank with the appropriate word or phrase.
-
An e-store that sells cell phone accessories reports that 98% of its customers are satisfied with the speed of delivery. In Exercises 916, specify the type of bias involved.
-
Variables that classify individuals into categories are called _____________. In Exercises 510, fill in each blank with the appropriate word or phrase.
-
Find the area bounded by y = f(x), the x-axis, between the given values (a) f(x) = 12x 4r3 between x = 2 and x = 4. (b) f(x) = 3 er between = 0 and x = 1. 4+x (c) f(x) = - x3 from x = 1 to x = 2....
-
A bar of a steel alloy that exhibits the stress-strain behavior shown in Figure 6.22 is subjected to a tensile load; the specimen is 375 mm (14.8 in.) long and has a square cross section 5.5 mm (0.22...
-
Explain and discuss how countries gain from international trade.
-
What is oligopoly?
-
What is mutual interdependence?
Study smarter with the SolutionInn App