WACC Calculator
Calculate Weighted Average Cost of Capital instantly. The standard discount rate for DCF valuations and capital budgeting decisions.
WACC Formula:(E/V × Re) + (D/V × Rd × (1-Tc))
Now visualize it in PowerPoint
Create professional financial charts and DCF models with Deckary. Build consulting-grade waterfall charts and sensitivity analyses.
What is WACC?
WACC (Weighted Average Cost of Capital) is the average rate of return a company must earn on its existing assets to satisfy its creditors, owners, and other capital providers. It blends the cost of equity and cost of debt, weighted by their proportions in the capital structure.
WACC is essential for financial analysis because it:
- Serves as the discount rate in DCF (Discounted Cash Flow) valuations
- Helps evaluate whether projects exceed the minimum required return
- Enables comparison of investment opportunities across different risk levels
- Informs optimal capital structure decisions
Example WACC Calculation
Total Value (V) = $500M + $200M = $700M
Equity Weight = $500M / $700M = 71.43%
Debt Weight = $200M / $700M = 28.57%
After-tax Cost of Debt = 5% × (1 - 0.25) = 3.75%
WACC = (71.43% × 10%) + (28.57% × 3.75%)
WACC = 7.14% + 1.07% = 8.21%
This means the company must earn at least 8.21% on its investments to satisfy all capital providers.
When to Use WACC
WACC is fundamental to corporate finance, valuation, and investment analysis
DCF Valuation
Capital Budgeting
Hurdle Rate Setting
Capital Structure Optimization
WACC Benchmarks by Industry
| Industry | Typical WACC | Notes |
|---|---|---|
| Utilities | 5-7% | Stable cash flows, high leverage capacity |
| Consumer Staples | 6-8% | Defensive sector, moderate risk |
| Healthcare | 7-9% | Mix of stable and growth segments |
| Industrial | 8-10% | Cyclical exposure, capital intensive |
| Technology | 9-12% | Higher growth, higher equity costs |
| Biotech / Early-Stage | 12-18% | High risk, often all-equity financed |
Note: These are indicative ranges. Actual WACC depends on company-specific factors including beta, credit rating, and capital structure.
How to Calculate WACC in Excel
While this calculator provides instant results, financial models often require building WACC calculations in Excel. Here's how to structure it:
Step 1: Input Section
A1: Equity Value B1: 500,000,000
A2: Debt Value B2: 200,000,000
A3: Cost of Equity B3: 10%
A4: Cost of Debt B4: 5%
A5: Tax Rate B5: 25%
Step 2: Calculate Capital Weights
Total Capital: =B1+B2
Equity Weight: =B1/(B1+B2)
Debt Weight: =B2/(B1+B2)
Step 3: WACC Formula
=(B1/(B1+B2))*B3 + (B2/(B1+B2))*B4*(1-B5)
This formula directly calculates WACC by multiplying weights by their respective costs, with the tax shield applied to debt.
Pro Tip: Cost of Equity with CAPM
Calculate cost of equity using CAPM: =Risk_Free_Rate + Beta * (Market_Return - Risk_Free_Rate). Use 10-year Treasury for risk-free rate and company beta from financial data providers.
Ready to build better financial slides?
Calculate WACC here, then present your DCF analysis with professional charts in PowerPoint using Deckary.
14-day free trial. No credit card required.
Frequently Asked Questions
Everything you need to know about WACC calculations
Related Calculators
ROI Calculator
Return on Investment for business cases and project justification.
CAGR Calculator
Compound Annual Growth Rate for measuring growth over time.
NPV Calculator
Net Present Value for capital budgeting and investment analysis.
IRR Calculator
Internal Rate of Return to evaluate project attractiveness.
TAM SAM SOM Calculator
Total Addressable Market for strategy and due diligence.