Type any stock ticker world-wide and we auto populate beta, capital structure, and the effective tax rate from current filings. Built by analysts who use it every day.
Implied discount rate - Annualized
Every WACC is wrong to two decimals. The point of a sensitivity table is to show the range of possibilities for a given company. The current cell highlighted in orange.
| β \ ERP → | 3.50% | 4.50% | 5.50% | 6.50% | 7.50% |
|---|---|---|---|---|---|
| β = 0.60 | 6.38% | 6.96% | 7.54% | 8.13% | 8.71% |
| β = 0.90 | 7.40% | 8.27% | 9.15% | 10.02% | 10.90% |
| β = 1.20 | 8.42% | 9.59% | 10.75% | 11.92% | 13.09% |
| β = 1.50 | 9.44% | 10.90% | 12.36% | 13.82% | 15.28% |
| β = 1.80 | 10.46% | 12.21% | 13.96% | 15.71% | 17.46% |
The whole equation is a weighted sum. Everything else is just figuring out the inputs.
Using current market data as of May 2026. Numbers rounded for readability. The calculator above will produce the unrounded version.
Ke = 4.35% + 1.20 × 5.50% Ke = 4.35% + 6.60%
Kd(1 - t) = 4.50% × 0.84
E = $3,400B · D = $96B · V = $3,496B We = 3,400 / 3,496 = 97.25% Wd = 96 / 3,496 = 2.75%
WACC = 0.9725 × 10.95% + 0.0275 × 3.78% WACC = 10.65% + 0.10%
If your computed WACC sits outside the typical range for the sector, treat that as a signal to recheck inputs rather than a discovery.
If your WACC feels off, it's almost always one of these.
Wisesheets pulls live WACC inputs (beta, debt, cap structure, tax rate) directly into Excel or Google Sheets with one formula. It is used by 60,000+ retail investors and analysts worldwide.
Get Free Trial