Module $7$ Homework

Estimating Share Value Using the DCF 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{m}\text{i}\text{l}\text{l}\text{i}\text{o}\text{n}\text{s}},\backslash$table$[[$Reported$],[2018]],$Forecast Horizon Period,$\backslash$table$[[$Terminal$],[$Period$]]],[2019,2020,2021,2022],[$Sales$,$$$57,512,$$$58,366,$$$59,232,$$$60,112,$$$61,004,$$$61,608$