KPI calculator

WACC Calculator

Enter your values to calculate WACC. Use the formula and examples below for Excel, Google Sheets, Power BI, and dashboards.

Affiliate resources

Ideas for You

Useful learning resources related to this page. As an Amazon Associate, this site may earn from qualifying purchases at no extra cost to you.

WACC books Books that help you understand WACC and related business metrics more deeply. Explore resources → WACC audiobooks Audiobook searches for learning WACC while commuting, walking, or working. Explore resources → Financial modeling Excel resources Excel-focused resources for building KPI trackers and dashboard workflows. Explore resources → Business valuation resources Practical resources for turning WACC into reports, dashboards, and business decisions. Explore resources →

Calculate WACC

Equity Value Debt Value Cost of Equity Cost of Debt Tax Rate

Result—

Formula

(E/V × Re) + (D/V × Rd × (1 - Tax Rate))

Excel formula

=IFERROR((B2/(B2+C2))*D2+(C2/(B2+C2))*E2*(1-F2),0)

Power BI DAX measure

WACC =
VAR EquityValue = [Equity Value]
VAR DebtValue = [Debt Value]
VAR TotalCapital = EquityValue + DebtValue
RETURN
    DIVIDE(EquityValue, TotalCapital) * [Cost of Equity]
    + DIVIDE(DebtValue, TotalCapital) * [Cost of Debt] * (1 - [Tax Rate])

Read the complete WACC formula guide →