Estimating Share Value Using the DCF Model

Following are forecasts of Illinois Tool Works Inc. sales, net operating profit after tax $($NOPAT$),$ a

Note: Complete the entire question in Excel and format each answer to two decimal places. Th

$\backslash$table$[[$Reported$,$Forecast Horizon Period,Terminal$],[\backslash$table$[[$millions$]],2018,2019,2020,2021,2022,$Period$],[$Sales$,$$$7,384,$$$7,827,$$$8,297,$$$8,795,$$$9,322,$$$9,509$