Calculating Implied Growth Rates
Once you understand the concept of reverse DCF, the practical question becomes: How do I actually calculate what growth rate is baked into a stock's price? This article walks through the mechanics, the spreadsheet setup, the common pitfalls, and the interpretation framework.
Quick definition: Implied growth rate is the average annual growth in free cash flow (or revenue, or earnings) that a DCF model requires to match a stock's current market price, assuming all other inputs are held constant.
Key takeaways
- Implied growth rates require a full DCF model; you can't calculate them with a simple formula.
- The calculation works by iterating (trial and error) through growth assumptions until the DCF output matches the market price.
- Different growth assumptions (FCF growth vs. revenue growth, near-term vs. long-term) produce different implied rates; clarity on what you're solving for is essential.
- Implied growth rates are most meaningful when compared to historical growth, peer growth, or your own forward projections.
- Terminal value dominates the DCF, so implied growth in the explicit forecast period is often less sensitive than implied terminal growth assumptions.
- Spreadsheet goal-seek or iterative solvers make the calculation practical; hand calculation is impractical.
The DCF framework you'll use
To calculate implied growth, you need a working DCF model. Here's the skeleton:
Year 1 FCF = Base Year FCF × (1 + growth rate)^1
Year 2 FCF = Base Year FCF × (1 + growth rate)^2
...
Year 5 FCF = Base Year FCF × (1 + growth rate)^5
Terminal Value = Year 5 FCF × (1 + terminal growth) / (WACC - terminal growth)
PV of Year 1–5 FCF = Sum of [FCF / (1 + WACC)^year]
PV of Terminal Value = Terminal Value / (1 + WACC)^5
Enterprise Value = PV of Years 1–5 + PV of Terminal Value
Equity Value = Enterprise Value − Net Debt
Stock Price = Equity Value / Shares Outstanding
When you calculate implied growth, you're solving for the growth rate that makes the final "Stock Price" equal to the current market price.
Building the spreadsheet
Here's a practical setup:
Step 1: Gather baseline data.
- Current stock price (market price today).
- Most recent annual FCF (or estimate it from operating cash flow minus capex).
- Number of shares outstanding.
- Net debt (total debt minus cash).
- WACC (your estimate of the company's cost of capital).
- Terminal growth rate assumption (typically 2–3% for mature companies).
Step 2: Set up the DCF table.
A B
1 Year Forecast Year
2 FCF Growth [variable to solve]
3 WACC [fixed, your estimate]
4 Terminal G [fixed, your estimate]
5
6 Year 1 FCF Base FCF × (1 + B2)^1
7 Year 2 FCF Base FCF × (1 + B2)^2
8 Year 3 FCF Base FCF × (1 + B2)^3
9 Year 4 FCF Base FCF × (1 + B2)^4
10 Year 5 FCF Base FCF × (1 + B2)^5
11
12 PV of Year 1 FCF Year 1 FCF / (1 + WACC)^1
13 PV of Year 2 FCF Year 2 FCF / (1 + WACC)^2
14 ...
15 PV of Year 5 FCF Year 5 FCF / (1 + WACC)^5
16
17 Sum of PV (Years 1–5) Sum of B12:B16
18
19 Terminal Value Year 5 FCF × (1 + Terminal G) / (WACC − Terminal G)
20 PV of Terminal Terminal Value / (1 + WACC)^5
21
22 Enterprise Value Sum of PV (Years 1–5) + PV of Terminal
23 Less: Net Debt [input, negative = cash position]
24 Equity Value Enterprise Value − Net Debt
25
26 Shares Outstanding [input]
27 Implied Stock Price Equity Value / Shares Outstanding
28
29 Market Price [input, today's price]
30 Difference Implied Stock Price − Market Price
Step 3: Use goal-seek (or similar solver) to find the growth rate that makes the Difference (row 30) equal to zero.
In Excel, this is: Data > What-If Analysis > Goal Seek. Set target cell to row 30, target value to 0, variable cell to B2 (FCF Growth Rate).
The solver will iterate through values until Implied Stock Price matches Market Price. The value it lands on in B2 is your implied growth rate.
A worked example: SaaS Company
Let's say you're analyzing a cloud software company trading at $50 per share.
Inputs:
- Market price: $50
- Shares outstanding: 100 million
- Recent annual FCF: $200 million
- Net debt: −$100 million (i.e., $100M cash position)
- WACC: 8%
- Terminal growth: 3%
- Forecast period: 5 years
Initial DCF setup (with a guess of 20% growth):
Year 1 FCF: $200M × 1.20 = $240M
Year 2 FCF: $200M × 1.20^2 = $288M
Year 3 FCF: $200M × 1.20^3 = $346M
Year 4 FCF: $200M × 1.20^4 = $415M
Year 5 FCF: $200M × 1.20^5 = $498M
PV of Year 1–5:
$240M / 1.08^1 = $222M
$288M / 1.08^2 = $247M
$346M / 1.08^3 = $275M
$415M / 1.08^4 = $305M
$498M / 1.08^5 = $339M
Sum = $1,388M
Terminal Value:
$498M × 1.03 / (0.08 − 0.03) = $498M × 1.03 / 0.05 = $10,245M
PV of Terminal:
$10,245M / 1.08^5 = $6,977M
Enterprise Value: $1,388M + $6,977M = $8,365M
Equity Value: $8,365M − (−$100M) = $8,465M
Implied Stock Price: $8,465M / 100M shares = $84.65
Difference: $84.65 − $50 = $34.65 (too high)
Your initial 20% growth guess is too aggressive. The model produces a valuation of $84.65, but the market price is $50. You need lower growth.
Using goal-seek: You set the solver to adjust the growth rate (currently 20%) so that the Difference reaches zero. After iteration, let's say the solver converges on 12%.
Implied growth rate: 12% annually over 5 years.
This tells you that for the stock to trade at $50, given your assumptions about WACC (8%) and terminal growth (3%), the market is pricing in an average annual FCF growth of 12%.
Now the question becomes: Is 12% realistic? If the company has historically grown at 18% and your forward analysis suggests 15%, then 12% is conservative—the stock may be undervalued. If the company has slowed to 8% growth and your analysis suggests further deceleration, then 12% is optimistic—the stock may be overvalued.
Variations: Solving for different growth rates
The example above solves for growth over the explicit forecast period (Years 1–5). But you might instead solve for different unknowns:
Variation A: Different growth rates for different periods
Many analysts use a two-stage model:
- High growth (Years 1–3): explicit, high growth rate
- Transition (Years 4–5): declining growth toward terminal
- Terminal (Year 6+): perpetual stable growth
You can solve for the high-growth rate while keeping transition and terminal rates fixed. Or solve for the transition rate. The choice depends on which period's growth is most uncertain.
Variation B: Revenue growth instead of FCF growth
Some analysts solve for implied revenue growth, then map that to implied margins. The math is identical; you're just using revenue in the numerator instead of FCF. Be careful: revenue and FCF growth often diverge, especially if margins are changing.
Variation C: Solving for WACC instead
Instead of holding WACC constant and solving for growth, you can flip it: hold growth constant and solve for implied WACC. This is covered in depth in Article 07, but the process is mechanically identical—goal-seek finds the WACC that makes the Implied Price match the Market Price.
Sensitivity and the terminal value problem
Here's a critical insight: Most of the value in a DCF comes from the terminal period. In the example above, the PV of the terminal value was $6,977M out of a total enterprise value of $8,365M—83% of the valuation.
This has a profound implication: Small changes in terminal assumptions create huge swings in implied growth.
Example: In the SaaS company above, you solved for 12% growth. But what if you change the terminal growth assumption from 3% to 2%?
With 2% terminal growth, the terminal value becomes:
$498M × 1.02 / (0.08 − 0.02) = $498M × 1.02 / 0.06 = $8,470M
versus the previous:
$498M × 1.03 / (0.08 − 0.03) = $10,245M
The terminal value is now lower. To hit the same $50 market price, you'd need lower growth in the explicit forecast period—maybe 10% instead of 12%.
Conversely, if you assume 4% terminal growth, terminal value rises, and you'd need even higher explicit-period growth to justify the $50 price.
This is why reverse DCF requires transparency about terminal assumptions. The implied growth number is only meaningful in the context of the terminal assumptions you've made.
How to interpret implied growth rates
Once you have an implied growth rate, use it as a diagnostic, not a prediction.
Step 1: Compare to history. What has the company actually grown at historically? If the implied rate is similar, the market is pricing in trend continuation. If much higher, the market is pricing in acceleration. If lower, deceleration.
Step 2: Compare to forward guidance. What does management project? If the implied rate exceeds guidance, the market is betting on upside surprise or management sandbagging. If it's below guidance, the market is skeptical.
Step 3: Compare to peers. What growth rates are comparable companies achieving? If your stock's implied growth is much higher than peers, ask why—Is there a competitive advantage? Or is the stock overvalued relative to peers?
Step 4: Stress-test against fundamentals. Can the company realistically achieve this growth? What market size is required? What share gains? What operating leverage? A 40% implied growth rate for a mature industrials company is obviously unrealistic. A 25% implied growth rate for a cloud company is plausible but not guaranteed.
Step 5: Assess risk/reward. If your analysis suggests the company is more likely to achieve 8% growth, but the market is pricing in 12%, there's downside risk if growth disappoints. Conversely, if you believe 18% is achievable, there's upside.
The role of margins
Growth in FCF is not the same as growth in revenue. A company can grow revenue at 10% but FCF at 5% if margins compress, or grow FCF at 15% on 8% revenue growth if margins expand.
When you solve for implied FCF growth, you're capturing net growth—the combined effect of revenue growth and margin changes. If the implied FCF growth is 12% but revenue growth is only 8%, the market is pricing in margin expansion. This is a testable assumption: Can the company realistically expand margins by 40–50% (the implied leverage) over five years?
Common mistakes in calculation
Mistake 1: Forgetting to update shares outstanding or using old net debt figures.
If a company has done a large acquisition or issued equity, share count changes. Use current shares outstanding. Similarly, net debt should be current, not historical.
Mistake 2: Using the wrong FCF definition.
Operating cash flow minus capex is a simplified FCF. Some analysts include working capital changes, taxes, or other adjustments. Be consistent and clear about what "FCF" means in your model.
Mistake 3: Letting the terminal assumption drift.
If you're solving for Year 1–5 growth, you're holding terminal growth constant. But if you haven't thought carefully about what terminal growth should be, you're anchoring the entire calculation to a weak assumption. Do the research: What's the long-run growth rate of the economy? What's the company's long-run competitive position? 2–3% is reasonable for mature companies; 1–2% for aging ones; 3–5% for companies with structural growth advantages.
Mistake 4: Using the stock price as a proxy for equity value.
Stock price is stock price. To get equity value, multiply by shares outstanding. And remember: when you're calculating implied growth, you're working backward from market price to enterprise value, not the reverse.
FAQ
Q: How do I choose between solving for growth vs. solving for WACC?
Ask: Which assumption am I least confident in? If you have a solid estimate of the company's cost of capital but growth is wildly uncertain, solve for growth. If cost of capital is opaque but growth is fairly clear, solve for WACC.
Q: Does implied growth change every day?
Yes. Stock prices change minute by minute. If you run implied growth calculations on Monday and Thursday at different prices, you'll get different numbers. This is actually useful: you can track how the market's growth assumptions have shifted by comparing implied growth rates over time.
Q: What if the implied growth rate is negative?
This suggests the market is pricing in contraction. For a mature, stable business, this is rare. For a distressed company, it's common. Negative implied growth deserves investigation: Is the market wrong, or is the business genuinely deteriorating?
Q: Can I use implied growth to predict the stock's next move?
No. Implied growth tells you what's priced in today. If earnings come in below expectations, sentiment shifts, or the competitive environment changes, the implied growth rate will change, but reverse DCF won't predict that shift.
Q: Is there a "right" implied growth rate?
Not universally. The "right" rate depends on the company's fundamentals, competitive position, and market opportunity. Reverse DCF reveals what is priced in; you supply the judgment about what should be priced in.
Related concepts
- Understanding Free Cash Flow — The numerator you're growing in your DCF model.
- WACC: Weighted Average Cost of Capital — The discount rate you'll hold constant when solving for growth.
- Terminal Value and Perpetual Growth — The assumptions that dominate DCF sensitivity.
- Market Expectation Analysis — The next step: interpreting what your implied growth rate means.
Summary
Calculating implied growth rates is a mechanical exercise: build a DCF, hold WACC and terminal assumptions constant, and solve for the growth rate that matches the market price. The real skill lies not in the calculation but in interpreting the result. Compare implied growth to history, guidance, peers, and fundamentals. Assess whether the market's implicit bet on growth is realistic. Use this analysis to inform your investment decision.
The power of implied growth rates lies in making market assumptions visible and testable. Once you know what growth the market is pricing in, you can decide if that's a reasonable bet.