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.

$$998,532$;$$781,622$

$$965,119$;$$903,617$

$$697,644$;$$1,503,484$

$$1,503,484$;$$697,644$