Description This Weighted Average Cost of Capital WACC model by Bolortseren is an Excel template. WACC EV x Re DV x Rd x 1 T. The WACC formula is EV x Re DV x Rd x 1-T.
D V Percentage of financing debt.
Tc Corporate tax rate. The first part of the calculation which requires its own calculator altogether is the cost of equity. How to Calculate WACC in Excel Here is a tutorial to lead you through calculating WACC weighted average cost of capital using Intrinios Excel add-in. The add-in can be installed on Mac OS X or Microsoft Windows.