Estimating Share Value Using the DCF Model Module Following are forecasts of Home Depot's sales, net...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Estimating Share Value Using the DCF Model Module Following are forecasts of Home Depot's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 3, 2019, which the company labels fiscal 2018. Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. Reported NOPAT NOA Terminal $ millions 2018 2019 2020 2021 2022 Period Sales $89,808 $96,095 $102,822 $110,019 $117,721 $120,075 10,021 10,763 11,516 12,322 13,185 13,448 21,203 22,686 24,273 25,972 27,791 28,346 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 2% Discount rate (WACC) 7.85% Common shares outstanding 1,105 million Net nonoperating obligations (NNO) $22,762 million a. Estimate the value of a share of Home Depot's common stock using the discounted cash flow (DCF) model as of February 3, 2019. ($ millions) Increase in NOA FCFF (NOPAT - Increase in NOA) Reported 2018 Forecast Horizon Terminal 2019 2020 2021 2022 Period $ 0 $ 0 $ 0 $ 0 $ 0 0 0 0 0 0 Present value of horizon FCFF 0 0 0 0 Cum. present value of horizon FCFF $ 0 Present value of terminal FCFF 0 Total firm value 0 NNO 0 Firm equity value $ 0 Shares outstanding (millions) 0 Stock price per share $ 0 b. Home Depot stock closed at $190.06 on March 28, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? Please answer all parts of the question. Estimating Share Value Using the DCF Model Module Following are forecasts of Home Depot's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 3, 2019, which the company labels fiscal 2018. Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. Reported NOPAT NOA Terminal $ millions 2018 2019 2020 2021 2022 Period Sales $89,808 $96,095 $102,822 $110,019 $117,721 $120,075 10,021 10,763 11,516 12,322 13,185 13,448 21,203 22,686 24,273 25,972 27,791 28,346 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 2% Discount rate (WACC) 7.85% Common shares outstanding 1,105 million Net nonoperating obligations (NNO) $22,762 million a. Estimate the value of a share of Home Depot's common stock using the discounted cash flow (DCF) model as of February 3, 2019. ($ millions) Increase in NOA FCFF (NOPAT - Increase in NOA) Reported 2018 Forecast Horizon Terminal 2019 2020 2021 2022 Period $ 0 $ 0 $ 0 $ 0 $ 0 0 0 0 0 0 Present value of horizon FCFF 0 0 0 0 Cum. present value of horizon FCFF $ 0 Present value of terminal FCFF 0 Total firm value 0 NNO 0 Firm equity value $ 0 Shares outstanding (millions) 0 Stock price per share $ 0 b. Home Depot stock closed at $190.06 on March 28, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? Please answer all parts of the question.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Given a circularly linked list L containing an even number of nodes, describe how to split L into two circularly linked lists of half the size.
-
Which of the following would be considered product costs under absorption costing? 1. Variable manufacturing overhead 2. Fixed manufacturing overhead 3. Selling and administrative expenses a. 1, 2,...
-
Use the data of Exercise 19 to calculate a 95% CI for the difference between true average stopping distance for cars equipped with system 1 and cars equipped with system 2. Does the interval suggest...
-
When should a board consider forming a governance, development, audit, membership, and compensation committee? Or should any of these be task forces?
-
Rusty Spears, CEO of Rusty's Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a...
-
Prepare an essay evaluating the impact of Steve Jobs, on the Apple's performance by addressing the following: Assess the role of the business leader in driving organisational performance. Critically...
-
rude People No training Computer not updated Wrong fee Too much coffee Outdated Procedures Bad cream Brew time too long No training Too much water Too many grounds Wrong size filter Dirty cups Coffee...
-
Write a program to print below pattern? 1 222 33333 4444444
-
What are some Strategy Formulation/Strategic Alternatives for Netflix? Explain what some strategic alternatives and formulation strategies for Netflix In-house content? Marketing Ad Content? o...
-
2. Given f(x)=sec x-cos-2(x) Determine all points on the function y = f(x) where the slope of the tangent is horizontal. [3 marks]
-
Being in attendance helps you strengthen your work history and failure to do so can affect an employee's productivity. Can you imagine how it could affect the office when your coworker does not come...
-
2. Solve for n: C3 = 4(P2).
-
Robin Ltd and John Ltd enter into a business undertaking. There is a contractual agreement between the two companies whereby they share control and must agree on all strategic financial and operating...
-
A spacecraft has left the earth and is moving toward Mars. An observer on the earth finds that, relative to measurements made when the spacecraft was at rest, its a. length is shorter b. KE is less...
-
For the simple linear regression model, show that the values for \(\widehat{\beta_{1}}\) and \(\widehat{\beta_{0}}\) that solve the equations (5.9) are: \[ \begin{gather*}...
-
The multiple linear regression model (5.6) can be viewed as a first-order approximation of the general model \[ \begin{equation*} Y=g(\boldsymbol{x})+\varepsilon \tag{5.42} \end{equation*} \] where...
-
Table 5. 6 shows data from an agricultural experiment where crop yield was measured for two levels of pesticide and three levels of fertilizer. There are three responses for each combination. (a)...
Study smarter with the SolutionInn App