Excel Activity: Free Cash Flow Valuation Model

Start with the partial model in the file Ch$08$ P$25$ Build a Model.xIsx. Selected data for the Derby Corporation are shown here. Use the data to answer the questions.

INPUTS $($In Millions$)$

$\backslash$table$[[$INPUIS $($In Millions$),$Year$],[$Current$,-$ Projected,$4],[,0,1,2,3],[$Free cash flow,,,$-$$$25\mathrm{.}0,$$$25\mathrm{.}0,$$$110\mathrm{.}0,$$$117\mathrm{.}7$