FRA Exercise $5$

Estimating Share Value Using the DCF Model

Following are forecasts of Target Corporation's sales, net operating profit after tax $($NOPAT$),$ and net operating assets $($NOA$)$ as of February $2,2019,$ which we label fiscal year $2018.$

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$[[$$ millions,Reported,Forecast Horizon Period,$\backslash$table$[[$Terminal$],[$Period$]]],[2019,2020,2021,2022],[$Sales$,$$$75,906,$$$79,124,$$$83,630,$$$87,234,$$$92,146,$$$93,428$