A reverse DCF takes a stock's current price as a given and works backward through the discounted cash flow formula to find the growth rate or discount rate that justifies it. Instead of guessing at assumptions and producing a fair value, you flip the model around and extract the market's implied expectations, then you judge whether those expectations are realistic. The rest of this guide walks through the mechanics, a numeric example, and the Excel steps to build one yourself.
TL;DR:
- Market-implied growth rates for a company can typically range between 11% and 12% annually over an eight-year forecast, given a $50 billion market cap and $1.5 billion cash flow.
- Implied growth rates far exceeding the company's historical performance or industry averages may signal overestimation or unrealistic market expectations.
- Using the reverse DCF requires careful selection of cash flow type, discount rate, growth horizon, and terminal value method; errors here can distort the implied assumptions.
- Terminal value often dominates valuation output, meaning small changes to terminal growth assumptions can significantly alter the implied growth rate.
- Comparing the implied market expectations from a reverse DCF with your own reasoned assumptions helps identify over- or underpriced stocks before building forward-looking models.
Table of Contents
- What reverse DCF is: the math and intuition
- Step-by-step build: inputs, assumptions, and solving approach
- Numeric worked example: reverse to implied growth
- How to implement reverse DCF in Excel and using calculators
- Common mistakes, sensitivity checks, and red flags
- When to use reverse DCF vs forward DCF
- Author and Oracle Investments resources
- What a reverse DCF is actually good for
- FAQ
- Sources
What reverse DCF is: the math and intuition
A standard DCF forecasts cash flows, discounts them at a chosen rate, and sums them into a present value you compare against the stock's price. A reverse DCF rearranges that same identity: price becomes the known input, and growth or the discount rate becomes the unknown you solve for. The math does not change, only which variable sits on which side of the equation, a point the Stern DCF chapter lays out clearly when it frames valuation as a function of consistent inputs.
Two solves are common in practice:
- Solve for implied growth, holding the discount rate fixed, to see what cash flow trajectory the price demands.
- Solve for implied discount rate, holding growth fixed, to see what required return the market seems to be pricing.
The choice of cash flow matters just as much as the choice of unknown. Free cash flow to equity (FCFE) pairs with a cost of equity, while free cash flow to the firm (FCFF) pairs with a weighted average cost of capital. Whichever combination you use, the output tells you what the market believes about a company's future, not what you believe.
Step-by-step build: inputs, assumptions, and solving approach
Before you solve anything, four inputs need to be locked in: the cash flow base, the discount rate, the growth horizon, and the terminal value method. Get these wrong and the implied growth rate you extract will be meaningless.
Start with cash flow choice. If you are valuing equity directly, use FCFE and discount it at the cost of equity. If you are valuing the whole firm and then bridging to equity, use FCFF and discount it at WACC. The Stern lecture packet on DCF valuation is explicit that mixing these two creates biased results, so pick one path and stay consistent through every formula. A primer on calculating FCFE and FCFF from financial statements is useful if you are not already comfortable pulling these numbers.
Next, set the discount rate. For cost of equity, build it from a risk-free rate, a beta, and an equity risk premium (CAPM), or reference an industry WACC if you want a faster shortcut. A separate walkthrough on calculating a required rate of return covers both the CAPM build and simpler practical alternatives.
Then define the growth horizon: how many years of explicit high growth you model before the company settles into a terminal growth rate, typically capped near the long-run economic growth rate. Terminal value is usually calculated with the growing perpetuity formula.
With inputs framed, here is the solving sequence:
- Populate cash flow, discount rate, and terminal growth assumptions in separate, clearly labeled cells.
- Build the explicit forecast period formulas, linking each year's cash flow to the growth assumption cell.
- Calculate terminal value and discount it back alongside the explicit period cash flows.
- Sum the present values and set that cell equal to the current market price or market cap.
- Solve algebraically for constant growth, or use iteration (Excel Goal Seek) for staged, multi-year forecasts.
Pro Tip: Keep every assumption in its own input cell rather than buried inside a formula, so Goal Seek has a single, clean variable to adjust.
Numeric worked example: reverse to implied growth
Say a company has a market capitalization of $50 billion and trailing free cash flow of $1.5 billion.
- Market capitalization: $50 billion (illustrative)
- Trailing free cash flow: $1.5 billion (illustrative)
- Discount rate: 9%, terminal growth: 2.5% (illustrative)
Using an 8-year explicit forecast, you set up each year's cash flow as the prior year's value multiplied by (1 plus the growth rate), discount each year back at 9%, calculate a terminal value in year 8 using the growing perpetuity formula, discount that back too, and sum everything. Set that sum equal to $50 billion and use Excel's Goal Seek to change the growth rate cell until the model matches the market cap.
The output might land near 11% to 12% annual free cash flow growth for eight years, a figure you then judge against the company's own historical growth and its industry peers, not against an abstract benchmark. Investopedia's own reverse-DCF walkthrough shows the same mechanic solving for an implied growth rate in a simplified hypothetical, landing near 50% annual free cash flow growth given its specific inputs, a reminder that the result depends entirely on the starting assumptions you feed in. If the implied number sits far above anything the company has achieved historically, that is the signal worth investigating.
How to implement reverse DCF in Excel and using calculators
Excel handles reverse DCF cleanly once the formulas are linked correctly. The core functions you need are NPV or XNPV for discounting irregular cash flow timing, a growing perpetuity formula for terminal value, and simple multiplication links so each forecast year pulls from a single growth assumption cell.
A clean layout helps more than clever formulas:
- Put every assumption (discount rate, growth rate, terminal growth) in a labeled input block at the top.
- Build forecast years in rows below, each formula referencing the input cells rather than hardcoded numbers.
- Sum discounted cash flows plus discounted terminal value into one total valuation cell.
To solve in reverse, open Goal Seek under the Data tab, set the total valuation cell as the target, set it equal to the market price or market cap, and choose the growth rate cell as the variable to change. For models with more than one unknown, Solver under the Data tab handles multi-variable optimization. A practical DCF guide walks through the full template structure if you want a reference layout before building your own.
Pro Tip: Lock your discount rate and terminal growth cells with Excel's cell protection before running Goal Seek, so you never accidentally solve for the wrong variable.
Common mistakes, sensitivity checks, and red flags
The most frequent error is discounting FCFE at WACC or FCFF at cost of equity. This mismatch systematically biases the implied growth rate, usually pushing it higher or lower than the market actually expects, a problem the Stern lecture notes flag directly as a common source of valuation error.
Terminal value also tends to dominate the total, often representing the majority of a DCF's present value, which means a half-point shift in terminal growth can swing your implied growth output dramatically. Terminal value assumptions carry outsized influence on valuation outcomes, a risk the Stern chapter on DCF valuation treats as a core modeling hazard rather than a minor detail.
Build a sensitivity grid before trusting any single output:
- Vary growth rate across a low, central, and high scenario.
- Vary discount rate across the same three tiers.
- Vary forecast horizon length to see how sensitive the result is to timing.
Red flags include implied growth rates far above the company's historical ceiling, implied discount rates below the risk-free rate, or a terminal value that accounts for nearly all of the total valuation. A quick valuation metrics checklist can help you spot these inconsistencies fast.
When to use reverse DCF vs forward DCF
Reverse DCF and forward DCF answer different questions. Reverse DCF tells you what the market currently believes, which makes it a diagnostic and a sanity check. Forward DCF lets you build your own assumptions and arrive at a target price you are willing to act on.
A practical workflow runs both in sequence:
- Start with reverse DCF to see what growth or discount rate the current price implies.
- Compare that implied figure against the company's own history and its peers.
- Build a forward DCF using the growth and discount assumptions you actually find credible.
- Use the gap between the two models as your margin of safety or your red flag.
Reverse DCF has limits too: it depends on clean cash flow data, and it works best for companies with a long enough operating history to judge plausibility against.
Author and Oracle Investments resources
This guide was written by Matt, drawing on the same valuation inputs covered in Oracle Investments' primers on free cash flow and intrinsic value calculation. Some stock scoring tools assess fundamentals like profitability and valuation, which can help you sanity check implied growth assumptions quickly. None of this constitutes personalized investment advice.
What a reverse DCF is actually good for
Most of the attention around reverse DCF goes to the worked example, the single growth number you extract and compare to history. That number matters less than the habit it builds. The real value is in forcing yourself to state, explicitly, what a stock's price requires to be true, rather than nodding along to a narrative about a company's prospects.
Where conventional advice falls short is treating reverse DCF as a verdict rather than a question. The number only means something next to the company's own history, its margins, and its competitive position, context a spreadsheet cannot supply on its own.
If you take one thing from this guide, let it be sequencing: run the reverse solve first, write down whether the implied assumption seems earned, and only then build your own forward model. Skipping straight to a forward DCF without checking what the market already assumes is how investors end up anchored to their own narrative instead of testing it against the price in front of them.
— Matt
This article is general information, not a substitute for advice from a qualified financial advisor. Consult a qualified financial professional about your own circumstances before acting on anything here.
FAQ
What is the reverse DCF model?
A reverse DCF model starts with a stock's current price and works backward through the discounted cash flow formula to find the growth rate or discount rate the price implies. Analysts then compare that implied assumption against the company's history and industry norms to judge whether the market's expectations are realistic.
How can I use the reverse DCF model in Excel?
Build your discounted cash flow model as usual, with cash flow, discount rate, and terminal growth in separate labeled cells, then set the total present value equal to the market price. From there, use Excel's Goal Seek tool under the Data tab to change the growth rate (or discount rate) cell until the model output matches that price.
What are the two methods for DCF?
The two common cash flow approaches are FCFE, discounted at the cost of equity, and FCFF, discounted at the weighted average cost of capital. Mixing the two, such as discounting FCFE at WACC, biases the resulting valuation and is one of the most frequent setup errors in both forward and reverse DCF models.
Is DCF basically NPV?
DCF and NPV share the same discounting math: both bring future cash flows back to a present value using a chosen discount rate. The difference is framing, DCF is typically used to value an asset like a stock or business, while NPV is more commonly applied to compare or accept individual investment projects.
Sources
For the underlying theory on discount rates, terminal value, and cash flow consistency, the Stern DCF valuation chapter and Stern lecture packet are the deeper academic references. For a practical, numbers-first walkthrough of the reverse solve itself, see Investopedia's reverse DCF example. Readers bridging equity value to enterprise value can also consult MarketCapLens on market cap versus enterprise value.
- Evaluate stock price with reverse-engineering DCF
- Valuation: principles and practice — Discounted Cash Flow Valuation (chapter 12 excerpt)