Estimating Share Value Using the ROPI 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. $$

$\backslash$table$[[$Smillions$,\backslash$table$[[$Reported$],[2018]],\backslash$table$[[$Forecast Horizon Period$],[2019]],2020,2021,2022,\backslash$table$[[$Terminal$],[$Period$]]],[$Sales$,$$$170,756,$$$181,001,$$$191,861,$$$203,373,$$$215,576,$$