Homework Module $13$

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$[[\backslash$table$[[$$

Complete chart and sections after photo cut off. Total firm value, NNO, Firm equity Value, Shares outstanding $($millions$),$ Stock price per share