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$[[,$Reported,,Horizon period,Terminal,,$],[$S millions,$2018,2019,2020,2021,2022,$Period$],[$Sales$,$$$56,880,$$$57,734,$$$58,600,$$$59,480,$$$60,372,$$$60,976$