Wacc Excel Template. This analysis shows how changes in capital structure, cost of debt, cost of equity, and cost of preferred equity will affect a company's wacc. The template also includes other tabs for other elements of a financial model.
The wacc formula used by the calculator in the excel template is: This advanced wacc analysis template was built using apple inc.'s financial statements. The cost of equity, the cost of debt and the weighting factor.