Sensitivity Analysis of Firm’s WACC
FIN 620 – Sensitivity Analysis of Firm’s WACC
Assignment:
Using your assigned firm and one of its competitors, obtain the WACC for
each firm.
Perform sensitivity analysis of your assigned firm’s WACC based upon its
competitor (higher and lower WACC values). Identify your assumptions
used.
Using the modified WACC values from your sensitivity analysis, compute
the firm’s total corporate value using the cash flows provided by
valuepro.net.
Source of WACC: valuepro.net (you may use other references).
Output:
1. WACC for firm and one of its competitors.
2. Sensitivity Analysis using Excel for your assigned firm. Assumptions
used in your sensitivity analysis.
3. Firm’s cash flows and prior total corporate value.
4. Firm’s revised total corporate value using the modified WACC
values.