Estimating Share Value Using the DCF Model

Following are forecasted sales, NOPAT, and NOA for AT&T for

$2019$

$$through

$2022$

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.

a

$.$

$$Forecast the terminal period values assuming the following terminal period growth rate.

b

$.$

$$Estimate the value of a share of AT&T common stock using the discounted calsh flow

$($

DCF

$)$

$$model as of December

$31$

$,$

$2018$

$$using the following assumptions and the information above