Estimating Share Value Using the ROPI Model

Following are forecasts of sales, net operating profit after tax $($NOPAT$),$ and net operating assets $($NOA$)$ as of December $31,2018,$ for Humana.

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.

$\backslash$table$[[$$${?}^{\text{\$}},$Reported,Horizon period,$\backslash$table$[[$Terminal$],[$Period$]]],[2018,2019,2020,2021,2022],[$Sales$,$$$56,752,$$$57,606,$$$58,472,$$$59,352,$$$60,244,$$$60,848$