Question
Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for AT&T for 2019 through 2022 a. Forecast the terminal period
Estimating Share Value Using the DCF Model
Following are forecasted sales, NOPAT, and NOA for AT&T for 2019 through 2022
a. Forecast the terminal period values assuming a 2% terminal period growth rate.
Round answers to the nearest dollar.
Reported | Forecast Horizon | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
$ millions | 2018 | 2019 | 2020 | 2021 | 2022 | Terminal Period | |||||||||||||||||||||||||||||
Sales | $170,756 | $181,001 | $191,861 | $203,373 | $215,576 | Answer
| |||||||||||||||||||||||||||||
NOPAT | 20,895 | 22,082 | 23,407 | 24,812 | 26,300 | Answer
| |||||||||||||||||||||||||||||
NOA | 369,039 | 390,931 | 414,387 | 439,251 | 465,607 | Answer
|
b. Estimate the value of a share of AT&T common stock using the discounted cash flow (DCF) model as of December 31, 2018; assume a discount rate (WACC) of 5.7%, common shares outstanding of 7,281.6 million, net nonoperating obligations (NNO) of $175,155 million, and noncontrolling interest (NCI) from the balance sheet of $9,795 million.
Rounding instructions:
-
Use rounded answers for subsequent computations.
- Round answers to the nearest whole number unless otherwise noted (do not round shares outstanding).
- Round discount factor to 5 decimal places and stock price per share to two decimal places.
- Use negative signs for your FCFF and Present value of horizon FCFF answers, when appropriate. Otherwise, do not use negative signs with your answers.
TXRH | Reported | Forecast Horizon | Terminal | |||
---|---|---|---|---|---|---|
$ thousands | 2018 | 2019 | 2020 | 2021 | 2022 | Period |
Increase in NOA | Answer
| Answer
| Answer
| Answer
| Answer
| |
FCFF (NOPAT - Increase in NOA) | Answer
| Answer
| Answer
| Answer
| Answer
| |
Discount factor [1 / (1 + rw)t ] | Answer
| Answer
| Answer
| Answer
| ||
Present value of horizon FCFF | Answer
| Answer
| Answer
| Answer
| ||
Cumulative PV of horizon FCFF | Answer
| |||||
Present value of terminal FCFF | Answer
| |||||
Total firm value | Answer
| |||||
NNO | Answer
| |||||
NCI | Answer
| |||||
Firm equity value | Answer
| |||||
Shares outstanding | Answer
| |||||
Stock price per share | Answer |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started