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$[[,$Reported,Forecast Horizon Period,,,,Terminal$],[$$ millions,$2018,2019,2020-$ i i$,2021,2022,$Period$],[$Sales$,$$$76,056,$$$79,124,$$$83,780,$$$87,234,$$$92,296,$$$93,428$

Estimate the value of a share of Target common stock using the discounted cash flow $($DCF$)$ model as of February $2,2019.$