Question: cells D2%:H29. In cells C30:H35 create a data table that will calculate the enterprise value for various values of WACC (provided for you), terminal growth

cells D2%:H29. In cells C30:H35 create a data table that will calculate the enterprise value for various values of WACC (provided for you), terminal growth rate and terminal EBITDA multiple. The values for terminal growth rate and terminal EBITDA multiple will be displaved in cells D30:H30. Use a formula that will cause the growth rate to be displaved if cell C3 reads "Perpetuity" and the EBITDA multiple to be displayed otherwise. Use conditional formatting so that growth rates are displaved as percentages and multiples are not. Use the following values for terminal growth rates and terminal EBITDA multiples in columns D through H, respectively: Terminal growth rates; 4.0%, 4.5%, 5.0%, 5.5%, 4.0% Terminal EBITDA multiples: 8.0, 2.0, 10,0, 11.0, 12.0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
