How to Calculate WACC: Step-by-Step Guide with AAPL & MSFT Examples
Want the WACC concept first? Start with the DCF WACC Concept Guide, then come back here to calculate it step by step.
What is WACC?
WACC stands for Weighted Average Cost of Capital. It's the blended rate a company pays to fund its operations through debt and equity. Think of it as the company's "blended interest rate." Every dollar of capital has a cost, and WACC is the average.
In DCF analysis, WACC plays a starring role: it's the discount rate. Every future cash flow gets discounted back to the present using WACC. If you get WACC wrong, the whole valuation is off.
Here's the core idea. When a company raises money, it comes from two places:
- Debt (loans, bonds): interest payments, tax-deductible
- Equity (stock): dividends and share price appreciation, not tax-deductible
Each source has a different cost. WACC blends them together into one number that represents the overall cost of capital.
This guide focuses on the step-by-step manual WACC calculation and capital structure analysis. For how WACC works as the DCF discount rate, try the interactive DCF WACC Guide (interactive lesson).
The WACC Formula
WACC = (E/V x Re) + (D/V x Rd x (1 - T))Let's walk through each part:
| Variable | Meaning | How to Get It |
|---|---|---|
| E | Market value of equity | Stock price x shares outstanding |
| D | Market value of debt | Total debt on the balance sheet (or bond prices) |
| V | Total enterprise value | E + D |
| Re | Cost of equity | CAPM model (we'll cover this next) |
| Rd | Cost of debt | Yield on existing debt or credit rating |
| T | Tax rate | Corporate tax rate (marginal, not effective) |
The weights (E/V and D/V) tell you how much of the company's capital comes from each source. A company that's 80% equity and 20% debt will have a WACC closer to the cost of equity. A company that's 50/50 will have a more balanced blend.
The (1 - T) piece is the tax shield. Interest payments are tax-deductible, so the after-tax cost of debt is lower than the stated interest rate. If a company pays 5% on debt and has a 21% tax rate, the after-tax cost is 5% x (1 - 0.21) = 3.95%.
How to Calculate Cost of Equity (CAPM)
The most common method for calculating Re is the Capital Asset Pricing Model (CAPM):
Re = Rf + Beta x (Rm - Rf)- Rf (Risk-Free Rate): The return on a risk-free investment. In practice, this is the 10-year US Treasury yield. As of mid-2026, that's around 4.3%.
- Beta (Investment Beta): A measure of how much a stock's price moves relative to the overall market. The S&P 500 has a beta of 1.0. A stock with beta of 1.5 is 50% more volatile than the market. You can find beta on any financial data platform.
- Rm - Rf (Equity Risk Premium / ERP): The extra return investors expect from stocks over risk-free bonds. Historically, this has been 5-6% in the US market.
Sources: U.S. Treasury — Daily Yield Curve for current 10-year Treasury yields · Damodaran — DCF Basics (NYU Stern) for the CAPM and WACC framework.
Apple (AAPL) example:
Let's calculate Apple's cost of equity as of mid-2026:
- Risk-free rate: 4.3% (10-year Treasury)
- Beta: 1.2 (Apple is slightly more volatile than the market)
- Equity risk premium: 5.5%
Re = 4.3% + 1.2 x 5.5%
Re = 4.3% + 6.6%
Re = 10.9%So Apple's cost of equity is about 10.9%. That means investors expect roughly an 11% annual return from holding Apple stock, given its risk profile.
Want to see this in action? Check out Apple's valuation on Modelvix with real WACC inputs.
How to Calculate Cost of Debt
Cost of debt is simpler than cost of equity. It's the effective interest rate the company pays on its borrowings.
Two ways to estimate it:
The tax shield matters:
Interest payments reduce taxable income. So the after-tax cost of debt is:
After-tax Rd = Pre-tax Rd x (1 - Tax Rate)Example: A company issues bonds at 5% yield. The corporate tax rate is 21%.
After-tax Rd = 5% x (1 - 0.21)
After-tax Rd = 5% x 0.79
After-tax Rd = 3.95%That 3.95% is much lower than the 5% stated rate, which is why debt financing is often cheaper than equity financing on an after-tax basis.
Putting It All Together — WACC Example
Let's calculate WACC for Microsoft (MSFT) using real-world numbers.
Step 1: Gather the data
| Input | Value | Source |
|---|---|---|
| Stock price | $480 | Current market price (e.g. Yahoo Finance) |
| Shares outstanding | 7.43B | Latest 10-K / 10-Q (SEC EDGAR) |
| Equity value (E) | $3.57 trillion | $480 x 7.43B |
| Total debt (D) | $65 billion | Latest balance sheet (SEC EDGAR) |
| Beta | 0.9 | Financial data provider (e.g. Finnhub, Bloomberg) |
| Risk-free rate | 4.3% | U.S. Treasury Daily Yield Curve |
| Equity risk premium | 5.5% | Damodaran NYU Stern framework (for ERP context) |
| Pre-tax cost of debt | 4.0% | MSFT bond yields (issuer-specific) |
| Tax rate | 21% | U.S. statutory corporate rate (IRC §11) |
Step 2: Calculate cost of equity (Re)
Re = 4.3% + 0.9 x 5.5%
Re = 4.3% + 4.95%
Re = 9.25%Step 3: Calculate after-tax cost of debt (Rd)
After-tax Rd = 4.0% x (1 - 0.21)
After-tax Rd = 4.0% x 0.79
After-tax Rd = 3.16%Step 4: Calculate the weights
Total value (V) = E + D = $3.57T + $0.065T = $3.635T
Weight of equity (E/V) = $3.57T / $3.635T = 98.2%
Weight of debt (D/V) = $0.065T / $3.635T = 1.8%Step 5: Calculate WACC
WACC = (98.2% x 9.25%) + (1.8% x 3.16%)
WACC = 9.08% + 0.06%
WACC = 9.14%Microsoft's WACC is roughly 9.1%. That's the discount rate you'd use to value MSFT in a DCF model. For most large US companies, WACC falls in the 8-10% range.
You can explore Microsoft's valuation on Modelvix and see how this WACC drives the intrinsic value.
How WACC Affects DCF Valuation
WACC is the discount rate in a DCF model: the higher it goes, the less future cash flows are worth today. In practice, moving WACC from 7% to 12% cuts the present value of the same cash flows by nearly 20% — and because terminal value makes up 70–80% of total value, even a 0.5% change can swing a valuation by 10–15%.
For the full sensitivity breakdown, including the $100 cash flow example and a WACC-vs-PV comparison table, see the DCF WACC Concept Guide.
Common WACC Mistakes
1. Using book value instead of market value for equity
Book equity is what the company originally raised plus retained earnings. Market equity is what the stock is worth today. These can be wildly different. For most companies, market value is the right choice because it reflects the current cost of raising equity.
2. Ignoring preferred stock or other financing sources
Some companies have preferred stock, convertible debt, or leases that count as financing. If you leave them out, the WACC calculation is incomplete. Include all sources of capital in the weights.
3. Using outdated beta or risk-free rate
Beta changes over time. A beta from 3 years ago might not reflect the company's current risk. Same for the risk-free rate. If rates have moved, use the current 10-year yield, not last year's number.
4. Not adjusting for country risk premium
For international companies, especially in emerging markets, you need to add a country risk premium to the cost of equity. Political instability, currency risk, and weaker legal protections all increase the required return.
5. Using the wrong tax rate (marginal vs effective)
Always use the marginal tax rate (the statutory rate for new income), not the effective tax rate (what the company actually paid). The effective rate can be distorted by one-time items, tax credits, and deferred taxes. The marginal rate reflects the true tax benefit of new debt.
We cover more on this in our Valuation Mistakes guide, which dives into WACC errors and other common pitfalls. For a broader DCF assumptions overview (growth rates, terminal value, reinvestment assumptions), see DCF Assumptions Guide.
WACC Limitations
WACC interacts closely with terminal value — see how it amplifies valuation sensitivity.
WACC is a powerful tool, but it has real limitations.
It assumes a stable capital structure. WACC is calculated using today's debt-to-equity ratio. If the company plans to change its capital structure (e.g., take on more debt or buy back shares), the current WACC might not reflect future costs.
It's not suitable for project-level valuation. If you're valuing a specific project within a company, using the company's overall WACC can be misleading. The project might have a different risk profile than the company as a whole. In that case, consider using the Adjusted Present Value (APV) method, which separates the value of the project from the value of the tax shield.
Industry-specific considerations matter. A utility company with stable cash flows and high debt might have a WACC of 5-6%. A biotech startup with no revenue and high risk might have a WACC of 15-20%. The range across industries is huge, and using a one-size-fits-all WACC is a recipe for bad valuations.
WACC Sensitivity at a Glance
WACC moves in one direction — higher WACC means lower present value — but the magnitude depends on your assumptions. Here's how small changes compound over time:
| WACC | $100/yr Perpetuity PV | Change vs 9.14% |
|---|---|---|
| 7% | $1,429 | +56% |
| 8% | $1,250 | +37% |
| 9.14% | $1,094 | (benchmark) |
| 10% | $1,000 | –9% |
| 12% | $833 | –24% |
Illustrative sensitivity — not investment advice. Moving from 7% to 12% cuts the perpetuity value by roughly 42% ($1,429 → $833). This directional impact holds regardless of the specific company or valuation model you use.
How to Calculate WACC in Excel
You can replicate these calculations in a spreadsheet without any special tools. Here's a minimal layout:
| Cell | Label | Formula / Input | Example (AAPL) |
|---|---|---|---|
| B2 | Re (Cost of Equity) | =B5+B6*(B7-B5) | 10.9% |
| B3 | Rd (Pre-tax Cost of Debt) | enter manually | 4.0% |
| B4 | Tax Rate | enter manually | 21% |
| B5 | Risk-Free Rate | enter manually | 4.3% |
| B6 | Beta | enter manually | 1.2 |
| B7 | Market Return (Rm) | Rf + ERP | 9.8% |
Key formulas:
- Cost of Equity (Re):
=RiskFreeRate + Beta (MarketReturn - RiskFreeRate)→ enters cell B2 via=B5+B6(B7-B5)= 10.9% - After-tax Cost of Debt:
=PreTaxRd (1 - TaxRate)→=B3(1-B4)= 3.16% - Equity Weight (E/V):
=MarketCap/(MarketCap+TotalDebt) - Debt Weight (D/V):
=1 - EquityWeight - WACC:
=EquityWeightRe + DebtWeightAfterTaxRd(whereAfterTaxRd = B3*(1-B4))
Enter your own Re, Rd, and tax rate values. This guide does not provide a downloadable spreadsheet file — build your own worksheet using the steps above. You can then plug the resulting WACC into Modelvix's simulator to run Monte Carlo scenarios.
FAQ
What is a good WACC for a company?
There's no universal "good" WACC. It depends on the industry and market conditions. For mature US companies, 8-10% is typical. Utilities might be 5-7%. High-growth tech companies might be 10-14%. The key is whether the company's return on invested capital (ROIC) exceeds its WACC. That's when value is being created.
Why do tech companies have higher WACC than utilities?
Tech companies have higher betas (more volatile stock prices), which leads to a higher cost of equity. They also tend to carry less debt, so the lower-cost debt component has less weight in the WACC calculation. Utilities have stable cash flows, low betas, and high debt levels, all of which push WACC down.
Can WACC be negative?
In theory, yes. If the risk-free rate is negative (as it has been in some European countries) and the company has very low risk, WACC could technically be negative. But in practice, a negative WACC means investors are paying the company to hold their money, which is extremely rare. For virtually all real-world DCF analysis, WACC is positive.
How often should WACC be recalculated?
At least once a quarter, or whenever there's a significant change in interest rates, the company's stock price, or its capital structure. Many analysts update WACC with every earnings report. The risk-free rate and beta can change quickly, and using stale numbers leads to inaccurate valuations.
What's the difference between WACC and cost of equity?
Cost of equity (Re) is the return shareholders expect. WACC is the blended return expected by all capital providers (both debt and equity holders). WACC is always lower than the cost of equity because debt is cheaper and provides a tax shield. For a company with no debt, WACC equals the cost of equity.
---
By the Modelvix Team
Ready to apply WACC in your own analysis? Try Modelvix's DCF simulation. Enter a ticker and see how WACC impacts intrinsic value. Start your analysis here.
Disclaimer: This content is for educational purposes only and does not constitute financial advice. Always conduct your own research before making investment decisions.