Sensitivity Analysis $$ Data Tables

It is very common for analysts to sensitize key inputs to see a possible range of valuations.

Open the attached Excel file and go to the worksheet labeled: $9-$Data Table

Complete the data table and select the enterprise valuation given using a $4\%$ growth rate and a $7\mathrm{.}5\%$ WACC, the value using a $1\%$ growth rate and $9\mathrm{.}5\%$ WACC, respectively.