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.

Assumption

Terminal period growth rate $2\%$

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