Estimating Share Value Using the DCF Model Following are forecasts of Home Depot's sales, net operating...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Estimating Share Value Using the DCF Model 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 millions Sales NOPAT NOA Terminal 2018 2019 2020 2021 2022 Period $108,203 $115,777 $123,882 $132,553 $141,832 $144,669 12,073 12,967 13,875 14,846 15,885 16,203 25,546 27,332 29,245 31,292 33,483 34,152 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) 2% 7.85% Common shares outstanding 1,105 million Net nonoperating obligations (NNO) $27,424 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) Present value of horizon FCFF Cum. present value of horizon FCFF $ Present value of terminal FCFF Total firm value NNO Firm equity value $ Shares outstanding (millions) $ Reported 2018 Forecast Horizon Terminal 2019 2020 2021 2022 Period $ $ $ $ $ Stock price per share 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? Estimating Share Value Using the DCF Model 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 millions Sales NOPAT NOA Terminal 2018 2019 2020 2021 2022 Period $108,203 $115,777 $123,882 $132,553 $141,832 $144,669 12,073 12,967 13,875 14,846 15,885 16,203 25,546 27,332 29,245 31,292 33,483 34,152 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) 2% 7.85% Common shares outstanding 1,105 million Net nonoperating obligations (NNO) $27,424 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) Present value of horizon FCFF Cum. present value of horizon FCFF $ Present value of terminal FCFF Total firm value NNO Firm equity value $ Shares outstanding (millions) $ Reported 2018 Forecast Horizon Terminal 2019 2020 2021 2022 Period $ $ $ $ $ Stock price per share 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?
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
When a buyer agrees to a contract in the supplier's currency, and purchase a forward exchange contract, which party bears the risk of currency fluctuation? a:buyer, b:supplier, c:supplier and buyer...
-
Kenley Corporation Comparative Balance Sheets June 30, 2013 and June 30 2014 Assets 2013 2014 Cash 12,500 69,900 Accounts Receivable 36,000 31,000 Inventory 51,400 46,400 Prepaid Expenses 2,600 3,200...
-
Governments assert that their safety standards for food imports are important to ensure that their citizens not be harmed by unsafe foods. Comment on how such a concern may be a nontariff barrier.
-
Computer security controls are an integral part of any modern organizations defense system. What are some processes, systems, and controls companies should have in place with regard to their IT...
-
In Problem assume that the annual interest rate on a credit card is 25.74% and interest is calculated by the average daily balance method. The unpaid balance at the start of a 28-day billing cycle...
-
Presented below are selected financial data from the The Coca-Cola Company 2015 annual report. Using the ratio definitions from Exhibit 4.6, calculate the following ratios: receivable turnover,...
-
World View is considering production of a lighted world globe that the company would price at a markup of 25 percent above full cost Management estimates that the variable cost of the globe will be...
-
Marathon Company makes and sells a single product. The current selling price is $ 1 8 per unit. Variable expenses are $ 1 2 per unit, and fixed expenses total $ 3 6 , 0 0 0 per month. ( Unless...
-
Rank what you perceive as the 5 most serious crime issues in the United States. Be specific and make sure to consider a wide-range of factors (population affected, location, costs to society, etc.)....
-
Use the following information: Equipment that cost $300,000 with a book value of $156,000 was sold for $180,000. Data from the comparative balance sheets are: 12/31/12 12/31/11 $2,160,000 $1,950,000...
-
Initial Post Remember that your Board consists of arts patrons without financial expertise or training. Based upon this module's required reading and the background information given, form an initial...
-
Atlas Foods produces the following three supplemental food products simultaneously through a refining process costing $93,000. The joint products, Alfa and Betters, have a final selling price of $4...
-
15. What are the proceeds of $1,000,000 deposited in a bank on July 10 for 1 month at 1.5%? Take care to apply "money market" rules and use the proper "day count." 16. What is the present value as of...
-
The risk free rate is 5 per cent. The expected return on the market is 10 per cent. If share XYZ has a beta of 1.1, what is the expected return based on the CAPM?( 1 mark ) If share NOM has an...
-
Over the past year, Ardmore Company reported sales of $5.1 million (70% credit sales) and cost of goods sold of $3.6 million. On average, inventory was sold in 65 days and receivables were collected...
-
Copy and complete the statement. 3800 m ? km =
-
The following T-accounts contain keyed entries representing five transactions involving the stockholders' equity of Meadow, Inc.: Required Using this information, give detailed descriptions,...
-
The financial statements for the Columbia Sportswear Company can be found in Appendix A at the end of this book. Required Answer the following questions: a. How many shares of common stock are...
-
Egghead, Inc., was a software chain that had over 100 stores across the U.S. Initially its founders and employees owned the company privately. The company eventually went public with an initial...
Study smarter with the SolutionInn App