Reported $ Forecast Horizon Period Terminal millions 2018 2019 2020 2021 2022 Period Sales $100,629 $107,673 $115,210 $123,274 $131,904 $134,542 NOPAT 11,228 12,059 12,904 13,807 14,773 15,069 NOA 23,758 25,419 27,198 29,102 31,139 31,761 Answer the following requirements assuming a discount rate (WACC) of 7.85%, a terminal period growth rate of 2%, common shares outstanding of 1,105 million, net nonoperating obligations (NNO) of $25,504 million. Required 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. Note: Do not round until your final answer; round your final answer to two decimal places. Stock price per share: $ b. Home Depot stock closed at $176.76 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?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
Reported
$
Forecast Horizon Period
Terminal
millions 2018
2019
2020 2021
2022 Period
Sales $100,629 $107,673 $115,210 $123,274 $131,904 $134,542
NOPAT
11,228 12,059 12,904 13,807 14,773 15,069
NOA
23,758 25,419 27,198 29,102 31,139 31,761
Answer the following requirements assuming a discount rate (WACC) of 7.85%, a terminal period growth rate of 2%, common shares outstanding of 1,105 million, net nonoperating
obligations (NNO) of $25,504 million.
Required
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.
Note: Do not round until your final answer; round your final answer to two decimal places.
Stock price per share: $
b. Home Depot stock closed at $176.76 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?
Transcribed Image Text:Reported $ Forecast Horizon Period Terminal millions 2018 2019 2020 2021 2022 Period Sales $100,629 $107,673 $115,210 $123,274 $131,904 $134,542 NOPAT 11,228 12,059 12,904 13,807 14,773 15,069 NOA 23,758 25,419 27,198 29,102 31,139 31,761 Answer the following requirements assuming a discount rate (WACC) of 7.85%, a terminal period growth rate of 2%, common shares outstanding of 1,105 million, net nonoperating obligations (NNO) of $25,504 million. Required 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. Note: Do not round until your final answer; round your final answer to two decimal places. Stock price per share: $ b. Home Depot stock closed at $176.76 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 Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education