Dcf Discount Rate by the Numbers: A Data Analysis for Investors
The DCF discount rate is the single most consequential input in any discounted cash flow model. Change it by two percentage points and your intrinsic value estimate shifts by 30-40%. Get it wrong in one direction and a business trading at fair value looks cheap. Get it wrong in the other direction and a genuinely undervalued company looks expensive. This post runs the data on how the DCF discount rate is built, where analysts go wrong, and what current market conditions imply for the rates you should be using right now.
The discount rate represents your required rate of return: the minimum return that justifies owning this asset rather than holding a low-risk instrument.
Key Takeaways
- The DCF discount rate is typically WACC (weighted average cost of capital), blending cost of equity and after-tax cost of debt weighted by capital structure.
- With the 10-year Treasury near 4.45% in early 2026, the standard cost of equity for a beta-1.0 stock runs 9.5-10.0% using CAPM with a 5% equity risk premium.
- A 1% increase in the discount rate reduces the present value of a 10-year cash flow stream by 6-8%, depending on the growth profile.
- High-ROIC businesses like Apple (ROIC 45.1%) can tolerate higher discount rates because their capital efficiency limits reinvestment drag on per-share value.
- Using the same discount rate for a stable consumer staples company and a speculative growth stock is the most common DCF error among retail investors.
- The 10-year Treasury yield is the floor for any discount rate in a U.S.-listed equity DCF model.
What the DCF Discount Rate Actually Represents
The discount rate converts future cash flows into present value. If you require a 10% annual return, a dollar received one year from now is worth $1 / 1.10 = $0.91 today. A dollar received 10 years from now is worth $1 / (1.10)^10 = $0.39 today. The higher your required return, the less you should pay for cash flows that sit far in the future.
A discount rate of 8% applied to a 10-year DCF produces an intrinsic value roughly 28% higher than the same model run at 10%. That gap is the difference between a buy decision and a pass. It matters more than most investors recognize.
The rate simultaneously encodes three things: the time value of money (the risk-free rate component), compensation for systematic market risk (equity risk premium times beta), and any company-specific adjustment for size, capital structure, or operating uncertainty.
What Is CAGR Growth Rate and Why It Feeds the Discount Rate Decision
CAGR (compound annual growth rate) describes how quickly a business has grown over a defined period. It connects to the discount rate because a high-growth company justifies a higher terminal growth assumption in your DCF, which shifts how much intrinsic value sits in the terminal value versus the explicit forecast years.
A company with free cash flow growing at 15% CAGR over five years might project 10-12% near-term growth tapering to 3% by year 10. In that scenario, roughly 65-70% of DCF intrinsic value sits in the terminal value. That concentration means the discount rate dominates the output more than the near-term projections.
A company growing at 5% CAGR has more intrinsic value in the explicit cash flows and less in the terminal value, so the discount rate matters at the margin but drives less of the headline result.
What Is the 10 Year Treasury Rate and Its Role
The 10-year Treasury rate is the baseline for every cost of equity calculation in the U.S. It represents the risk-free rate: the return available on a U.S. government obligation with no credit risk and a 10-year duration that roughly matches typical DCF forecast horizons.
As of early 2026, the 10-year Treasury yields approximately 4.45%. That figure has direct consequences for equity valuations. In 2021, when the 10-year sat below 1.5%, a DCF using a 7% discount rate was defensible. At 4.5%, a 7% rate implies an equity risk premium of 2.5%, which history suggests is insufficient compensation for equity risk.
| 10-Year Treasury Rate | Cost of Equity (beta 1.0, ERP 5%) | Notes |
|---|---|---|
| 1.5% (2021 low) | 6.5% | Justified ultra-high valuations in growth stocks |
| 3.0% (2023) | 8.0% | Transitional period as rates normalized |
| 4.5% (2026) | 9.5% | Current baseline for standard DCF work |
| 5.5% (historical peak region) | 10.5% | Would compress equity multiples further |
The equity risk premium (ERP) of 5% in the table reflects the historical average estimate by Aswath Damodaran at NYU. Some practitioners use 4.5%, others 5.5%. That spread alone produces a 15-20% swing in intrinsic value on a 10-year model.
Is DCF Fundamental Analysis
Yes. DCF is the most direct form of fundamental analysis. Fundamental analysis means valuing a business based on its actual financial characteristics, not chart patterns or price momentum. DCF derives value from the company's own cash-generating ability and requires no comparison to peer multiples.
Every other valuation shortcut (P/E, EV/EBITDA, P/FCF) is a compressed DCF with implicit assumptions about growth and discount rates baked in. When you use a P/E multiple, you are making an implicit statement about the discount rate and growth rate embedded in that multiple, whether you know it or not. DCF makes those assumptions explicit, which is why it produces better decisions when done carefully.
How to Build the Discount Rate: WACC Step by Step
WACC is the standard discount rate for enterprise-value DCF models. Here is the construction:
Step 1: Cost of equity using CAPM
Cost of Equity = Risk-Free Rate + (Beta x Equity Risk Premium)
Using April 2026 data: Risk-free rate of 4.45%, equity risk premium of 5.0%. For Apple (AAPL) with a beta near 1.2: Cost of Equity = 4.45% + (1.2 x 5.0%) = 10.45%.
Step 2: After-tax cost of debt
Use the company's weighted average interest rate on outstanding debt. Apply the tax shield: After-Tax Cost of Debt = Pre-Tax Rate x (1 - Effective Tax Rate). Microsoft's average debt cost runs near 3.8%, giving an after-tax cost of roughly 2.9% at a 24% effective tax rate.
Step 3: WACC formula
WACC = (Equity / Total Capital) x Cost of Equity + (Debt / Total Capital) x After-Tax Cost of Debt
For a company that is 90% equity-financed with a 10.5% cost of equity and minimal debt, WACC approximates 10.5%. For a company with 50% debt at 4% after-tax and 50% equity at 10%, WACC = (0.50 x 10%) + (0.50 x 4%) = 7%.
Sensitivity of Intrinsic Value to the Discount Rate
This table shows the direct impact of discount rate changes on intrinsic value. The model uses $5 billion in current FCFF, 8% near-term growth, and a 3% terminal growth rate.
| Discount Rate | Intrinsic Value per Share | Change vs. 9% Base |
|---|---|---|
| 7.0% | $182 | +42% |
| 8.0% | $148 | +16% |
| 9.0% | $128 | base |
| 10.0% | $111 | -13% |
| 11.0% | $98 | -23% |
| 12.0% | $87 | -32% |
A 2-point swing in the discount rate changes intrinsic value by 30-42%. This concentration of model sensitivity in a single input is why the margin of safety is not optional. You are working with an estimated rate, not a known one. The margin of safety protects against being wrong.
How to Calculate Dividend Growth Rate Using Excel
When applying a dividend discount model (a simplified DCF variant), the dividend growth rate is the key growth input alongside the discount rate. To calculate historical dividend growth rate in Excel:
- Enter the starting dividend (e.g., $1.40) in cell B1.
- Enter the ending dividend (e.g., $1.94) in cell B2.
- Enter the number of years (e.g., 10) in cell B3.
- In cell B4, type: =(B2/B1)^(1/B3)-1
- Format B4 as a percentage.
For Coca-Cola (KO), the dividend grew from approximately $1.40 per share in 2016 to $1.94 in 2026, a 10-year CAGR of roughly 3.3%. At a current yield of 3.0%, a dividend discount model using a discount rate of 8% and a 3.3% growth rate implies an intrinsic value of: D1 / (r - g) = $2.00 / (0.08 - 0.033) = approximately $42.55. If KO trades above that, the implied return at that price falls below 8%.
How to Calculate Dividend Growth Rate Using the Sustainable Growth Rate
The dividend growth rate can also be estimated from fundamentals rather than history using the sustainable growth rate formula:
Sustainable Growth Rate = ROE x Retention Ratio
Where retention ratio = 1 - payout ratio.
For Johnson & Johnson (JNJ): ROE near 22%, payout ratio near 50%, sustainable growth rate = 22% x 0.50 = 11%. That ceiling is above JNJ's actual dividend growth of 5-6% per year, which makes sense for a mature company with a rising payout ratio. The sustainable growth rate sets the upper bound. Actual dividend growth depends on how the company balances reinvestment versus distribution.
The dividend growth rate feeds directly into the Gordon Growth Model, which is itself a simplified DCF with dividends as the cash flows. The discount rate must exceed g by a meaningful margin for the model to produce a sensible result.
Discount Rate by Company Type
Different businesses carry different risk profiles and require different DCF discount rates. Using a uniform rate across all companies is a structural error.
| Company Profile | Appropriate Discount Rate | Rationale |
|---|---|---|
| Blue-chip dividend grower (JNJ, KO) | 7.5-9.0% | Stable FCF, investment-grade debt, low beta |
| Large-cap tech (AAPL, MSFT) | 9.0-10.5% | Higher growth priced in, cyclical exposure |
| Mid-cap growth | 11-13% | Less predictable cash flows, higher beta |
| Small-cap or pre-profit | 14-18%+ | Execution risk, limited operating history |
Apple's ROIC of 45.1% means each dollar it reinvests generates returns far above even a 10.5% cost of equity. That spread between return on capital and cost of capital is what allows a P/E of 28.3 to be fair value rather than speculation.
Further reading: Investopedia · CFA Institute
Why wacc Matters
This section anchors the discussion on wacc. The detailed treatment, formula, and worked examples appear in the body of this article above. The points below summarize the most important takeaways for value investors who want to apply wacc in real portfolio decisions. ValueMarkers exposes the underlying data on every covered ticker via the screener and stock profile pages, so the concepts in this article translate directly into actionable filters.
Key inputs for wacc
See the main discussion of wacc in the sections above for the full treatment, including the inputs, the calculation methodology, the typical sector benchmarks, and the most common pitfalls to avoid. The ValueMarkers screener lets value investors filter the full universe of 100,000+ stocks across 73 exchanges using wacc alongside the rest of the 120-indicator composite, with sector percentiles and historical trends shown on every stock profile.
Sector benchmarks for wacc
See the main discussion of wacc in the sections above for the full treatment, including the inputs, the calculation methodology, the typical sector benchmarks, and the most common pitfalls to avoid. The ValueMarkers screener lets value investors filter the full universe of 100,000+ stocks across 73 exchanges using wacc alongside the rest of the 120-indicator composite, with sector percentiles and historical trends shown on every stock profile.
Related ValueMarkers Resources
- Enterprise Value to Free Cash Flow (EV/FCF) — Enterprise Value to Free Cash Flow captures how cheaply a stock trades relative to its fundamentals
- Margin of Safety — Margin of Safety expresses how cheaply a stock trades relative to its fundamentals
- Enterprise Value to Revenue (EV/Revenue) — Enterprise Value to Revenue is the metric used to how cheaply a stock trades relative to its fundamentals
- Discounted Cash Flow — related ValueMarkers analysis
- Dcf Model — related ValueMarkers analysis
- Fcf — related ValueMarkers analysis
Frequently Asked Questions
canara bank stock rate
Canara Bank is an Indian public sector bank listed on the NSE and BSE. Its DCF discount rate would reflect Indian sovereign risk, using the Indian 10-year government bond as the risk-free rate (near 7% in early 2026) plus an equity risk premium appropriate for Indian banking sector risk. A typical DCF discount rate for Canara Bank would run 12-14%, materially higher than U.S. blue chips like Apple, because it reflects added country risk, sector risk from state ownership, and lower liquidity than U.S.-listed equities.
what is cagr growth rate
CAGR stands for compound annual growth rate. It measures the rate at which a value would need to grow each year to go from a starting figure to an ending figure over a given period. The formula is: CAGR = (Ending Value / Beginning Value)^(1/Years) - 1. If a company grew free cash flow from $2 billion to $4 billion over 7 years, the CAGR is ($4B / $2B)^(1/7) - 1 = 10.4% per year. This historical CAGR is the starting point for your DCF growth assumptions.
is dcf fundamental analysis
Yes. DCF is the most direct form of fundamental analysis, valuing a business by estimating its future free cash flows and discounting them at a required rate of return. Unlike relative valuation, DCF does not depend on other companies being correctly priced. It derives value from the company's own cash-generating ability, making it the foundation of independent intrinsic value analysis. Every other multiple is a shorthand version of DCF with implicit assumptions baked in.
what is the 10 year treasury rate
The 10-year Treasury rate is the yield on U.S. government bonds maturing in 10 years. It is the standard risk-free rate used in cost of equity calculations and DCF models. As of early 2026, it sits near 4.45%. It functions as the floor for any discount rate: no investor should accept a lower return from a risky equity investment than they can earn low-risk on a U.S. government bond.
how to calculate dividend growth rate using excel
To calculate dividend growth rate in Excel, put the starting dividend in one cell and the ending dividend in another, then use the formula =(Ending/Starting)^(1/Years)-1 and format as a percentage. For a 5-year calculation where dividends grew from $1.00 to $1.47, the formula returns 8.0% CAGR. This rate then feeds into a dividend discount model as the growth input, paired with your required discount rate. The discount rate must always exceed the growth rate for the model to produce a finite positive value.
how to calculate dividend growth rate g
The dividend growth rate (g) for the Gordon Growth Model is calculated as either the historical dividend CAGR over 5-10 years, or as the sustainable growth rate (ROE x Retention Ratio). For stable companies, the historical CAGR is more reliable. For companies changing their payout policy, the sustainable growth rate provides a forward-looking estimate from fundamentals. The critical constraint is that g must always remain below the discount rate r; otherwise the Gordon Growth Model produces a mathematically invalid (negative or infinite) result.
Run your own discount rate analysis using the ValueMarkers DCF calculator, which computes WACC from beta, the current Treasury rate, and your debt cost inputs, then applies it across a full sensitivity matrix.
Written by Javier Sanz, Founder of ValueMarkers. Last updated April 2026.
Ready to find your next value investment?
ValueMarkers tracks 120+ fundamental indicators across 100,000+ stocks on 73 global exchanges. Run the methodology above in seconds with our stock screener, or see today's top-ranked names on the leaderboard.
Related tools: DCF Calculator · Methodology · Compare ValueMarkers
Disclaimer: This content is for informational and educational purposes only and does not constitute investment advice, a recommendation, or an offer to buy or sell any security. Past performance does not guarantee future results. Consult a licensed financial advisor before making investment decisions.