WACC Calculator
Calculate the Weighted Average Cost of Capital (WACC) for your company
Capital Structure
Component | Calculation | Result |
---|
About WACC
WACC (Weighted Average Cost of Capital) represents a firm's average after-tax cost of capital from all sources.
Formula: WACC = (E÷V × Re) + (D÷V × Rd × (1−Tc))
Where:
E = Market value of equity
D = Market value of debt
V = E + D (Total capital)
Using WACC
Used as a discount rate in discounted cash flow analysis
Helps evaluate investment opportunities
Used to determine economic value added (EVA)
Important for capital budgeting decisions
The WACC represents the minimum return that a company must earn on its existing asset base to satisfy its creditors, owners, and other providers of capital.
Note: A lower WACC indicates that a company can take on projects with lower returns and still create value for shareholders. Companies typically compare the WACC to the IRR (Internal Rate of Return) of potential projects.
What is WACC?
The Weighted Average Cost of Capital (WACC) is the average rate a company pays to finance its operations, weighted by the proportion of each capital source (debt and equity). It represents the minimum return a company must earn to satisfy its investors and creditors.
WACC is used in:
Investment decisions (e.g., evaluating projects)
Company valuation (DCF analysis)
Mergers & Acquisitions (M&A)
Capital structure optimization
WACC Formula
The WACC formula combines the cost of equity and the after-tax cost of debt, weighted by their proportions in the capital structure:
Variables:
Variable | Description |
---|---|
Market value of equity | |
Market value of debt | |
Total firm value | |
Cost of equity (estimated via CAPM or DDM) | |
Cost of debt (yield to maturity on bonds/interest rate) | |
Corporate tax rate |
How to Calculate WACC (Step-by-Step)
Step 1: Determine the Market Value of Equity ()
Public Companies:
Private Companies: Use comparable company analysis or book value adjustments.
Step 2: Determine the Market Value of Debt ()
Public Companies: Use the market value of bonds.
Private Companies: Use book value or estimate based on similar firms.
Short-term Debt: Include if part of the capital structure.
Step 3: Calculate the Cost of Equity ()
Method 1: Capital Asset Pricing Model (CAPM)
= Risk-free rate (e.g., 10-year Treasury bond)
= Beta (stock's volatility vs. market)
= Market risk premium
Method 2: Dividend Discount Model (DDM)
= Expected dividend next year
= Current stock price
= Dividend growth rate
Step 4: Calculate the Cost of Debt ()
Public Companies: Use yield to maturity (YTM) on bonds.
Private Companies: Use average interest rate on loans.
After-Tax Cost of Debt:
Step 5: Compute WACC
Plug all values into the WACC formula.
Example WACC Calculation
Given:
Equity (): $500M
Debt (): $300M
Total Value (): $800M
Cost of Equity (): 10% (from CAPM)
Cost of Debt (): 5%
Tax Rate (): 30%
Calculation:
WACC Calculator (Excel/Google Sheets)
Here’s a simple template:
Input | Value | Formula |
---|---|---|
Market Value of Equity () | 500,000,000 | - |
Market Value of Debt () | 300,000,000 | - |
Total Firm Value () | =SUM(B2:B3) | |
Cost of Equity () | 10% | (From CAPM/DDM) |
Cost of Debt () | 5% | (YTM/Interest Rate) |
Tax Rate () | 30% | - |
WACC | = (B2/B4)*B5 + (B3/B4)*(B6*(1-B7)) | 7.56% |
Why is WACC Important?
Investment Decisions:
If a project's return > WACC, it adds value.
If return < WACC, it destroys value.
Valuation: Used in Discounted Cash Flow (DCF) analysis.
Optimal Capital Structure: Helps balance debt vs. equity to minimize cost.
Limitations of WACC
Assumes constant capital structure (debt/equity mix).
Beta (β) can be volatile and hard to estimate for private firms.
Tax rates may change, affecting after-tax cost of debt.