Reverse DCF in Excel: Decode Market-Implied Growth (2026)

July 3, 2026 · VeloraAI Team
Financial Modeling Data Analysis Excel

Every stock price is a bet on a specific growth rate — you just cannot see it. A traditional DCF asks "what is this company worth?" and produces a number you then argue about. A reverse DCF in Excel flips the question: "what growth rate does the market already believe?" Instead of debating whether 8% or 12% revenue growth is right, you solve for the exact rate baked into today's share price — and then decide if that expectation is reasonable, aggressive, or comically wrong. This guide shows you how to build a reverse discounted cash flow model in Excel from scratch, use Goal Seek to solve for the implied growth rate, and interpret the output like a value investor.

If you have ever looked at a stock and thought "this price only makes sense if growth accelerates," the reverse DCF turns that intuition into a number.

What Is a Reverse DCF?

A reverse DCF (reverse discounted cash flow) starts with a company's current market price and solves backward for the free cash flow growth rate that would justify that price. Instead of forecasting cash flows to derive a valuation, you fix the valuation to the market price and let the growth rate become the unknown — turning a subjective "fair value" debate into a testable prediction about future growth.

The traditional DCF process moves left-to-right: assumptions → cash flows → discounted value → implied share price. The reverse DCF moves right-to-left: market price → required discounted value → required cash flows → implied growth rate.

graph LR
    A[Growth Assumptions] --> B[Forecast FCF]
    B --> C[Discount to PV]
    C --> D[Enterprise Value]
    D --> E[Implied Share Price]
    F[Current Market Price] --> G[Required Enterprise Value]
    G --> H[Required FCF Stream]
    H --> I[Implied Growth Rate]
    style A fill:#dbeafe,stroke:#3b82f6
    style E fill:#dbeafe,stroke:#3b82f6
    style F fill:#fef3c7,stroke:#f59e0b
    style I fill:#fef3c7,stroke:#f59e0b

ℹ️ Note: A reverse DCF does not tell you if a stock is cheap or expensive. It tells you the assumption you would need to accept to justify the current price. Whether that assumption is realistic is your job to judge.

Why Use a Reverse DCF Instead of a Forward DCF?

Forward DCFs suffer from a well-known pathology: analysts start with a target price and then reverse-engineer the assumptions needed to get there, hiding bias behind precise-looking spreadsheets. The reverse DCF short-circuits this by removing your growth guess from the input side entirely.

The reverse DCF is particularly useful when:

  • You disagree with sell-side price targets and want to test which assumption is doing the heavy lifting
  • You are screening for mispriced stocks — a company with a 3% implied growth rate that is genuinely growing at 10% may be undervalued
  • You are pitching a short thesis — showing that a stock's price requires 25% growth for a decade is more persuasive than arguing over WACC decimal points
  • You are stress-testing consensus — comparing implied growth against management guidance, sell-side estimates, and industry growth rates

For a complete forward-DCF walkthrough (including WACC construction, terminal value methods, and equity bridge mechanics), see our DCF model in Excel guide. This post assumes you already understand those mechanics.

How Do You Build a Reverse DCF in Excel Step by Step?

Building a reverse DCF in Excel is a six-step process: pull the market data, set up the FCF forecast structure, calculate the discount rate, model terminal value, discount everything to present value, then use Goal Seek to solve for the growth rate that makes the model's implied enterprise value equal the observed market enterprise value.

Step 1: Pull Current Market Data

Start with the observed inputs — this is what makes it "reverse."

Input Source Excel Cell
Current share price Live quote B4
Diluted shares outstanding Latest 10-Q B5
Total debt Balance sheet B6
Cash and equivalents Balance sheet B7
Minority interest Balance sheet B8
Preferred equity Balance sheet B9

Then calculate the current enterprise value — this is the number your DCF has to match:

Market Cap        = B4 * B5
Enterprise Value  = Market Cap + B6 - B7 + B8 + B9

In Excel:

=B4*B5+B6-B7+B8+B9

This is your target EV — the number the reverse DCF will solve backward from.

Step 2: Set Up the Free Cash Flow Forecast

The reverse DCF's forecast structure is identical to a normal DCF — you just leave the growth rate as an unknown Excel will solve for later.

Structure your projection sheet with a 5- or 10-year explicit forecast window. Column D onward should hold Year 1 through Year N. Row layout:

  1. Revenue — starting from the last reported LTM figure
  2. Revenue growth % — the cell Goal Seek will solve for (e.g., $B$12)
  3. EBIT margin % — held constant or tapered based on your view
  4. Tax rate — statutory or effective
  5. D&A % of revenue
  6. CapEx % of revenue
  7. Change in NWC % of revenue change
  8. Unlevered Free Cash Flow (UFCF)

The UFCF formula in Year 1 (column D):

=D3*D5*(1-$B$14)+D3*D7-D3*D8-(D3-C3)*$B$15

Where D3 = Year 1 revenue, D5 = EBIT margin, $B$14 = tax rate, D7 = D&A %, D8 = CapEx %, $B$15 = NWC change %.

Year 1 revenue itself is driven by the growth cell:

=C3*(1+$B$12)

Where C3 is LTM revenue and $B$12 is the growth rate assumption Goal Seek will solve for.

💡 Pro Tip: Model EBIT margin as either constant or as a linear taper toward an industry-median terminal margin. Holding a 40% margin flat for 10 years usually inflates the DCF and makes the implied growth rate look artificially low.

Step 3: Calculate WACC

WACC is an input, not an unknown, in a reverse DCF. You are testing what growth rate is required — so pick a defensible WACC and hold it fixed. A quick WACC in Excel:

=B20*B21+B22*(1-B14)*B23

Where B20 = cost of equity (from CAPM), B21 = equity weight, B22 = pre-tax cost of debt, B14 = tax rate, B23 = debt weight.

For most large-cap US companies, WACC lands between 7% and 10%. If your WACC assumption is contentious, run the reverse DCF at multiple WACCs — you will get an implied growth rate curve rather than a single point estimate.

Step 4: Terminal Value

The reverse DCF's terminal value uses the same Gordon Growth formula as a forward DCF, but the terminal growth rate matters more here because it interacts directly with your explicit-period growth assumption.

Two common conventions:

  • Fix terminal growth at long-run GDP (2–3%) and let Goal Seek solve only for the explicit-period growth. This is the standard approach.
  • Fade explicit-period growth to terminal growth using a linear or logistic function, then solve for the starting growth rate. More realistic for growth companies.

Terminal value in Excel (Gordon Growth, end of Year N):

=N9*(1+$B$16)/($B$17-$B$16)

Where N9 = Year N UFCF, $B$16 = terminal growth rate (e.g., 2.5%), $B$17 = WACC.

⚠️ Warning: If terminal value ends up representing more than 80% of your reverse DCF's total value, the implied growth rate is being driven almost entirely by your terminal assumption — not by anything the explicit forecast is saying. In that case, extend the explicit forecast to 10 years or use a fade curve.

Step 5: Discount FCFs to Present Value

Use XNPV rather than NPV so Excel handles the exact dates correctly. If your cash flow row is D9:N9 and your date row is D2:N2, and your WACC lives in $B$17:

=XNPV($B$17,D9:N9,D2:N2)

Add the discounted terminal value:

=N10/(1+$B$17)^10

Where N10 holds the undiscounted terminal value and 10 is the years to the end of the forecast.

Total enterprise value from the reverse DCF:

=XNPV($B$17,D9:N9,D2:N2)+N10/(1+$B$17)^10

Call this cell B25 — the model-implied EV.

Step 6: Solve for Implied Growth With Goal Seek

Now the reverse DCF's magic step: force the model's implied EV to equal the observed market EV, and let Excel solve for the growth rate.

  1. Open Data > What-If Analysis > Goal Seek
  2. Set cell: B25 (model-implied EV)
  3. To value: the numeric target from the market EV formula — enter the number, not a cell reference
  4. By changing cell: $B$12 (the revenue growth % assumption)
  5. Click OK

Excel iterates until the model EV matches the market EV. The resulting value in $B$12 is the market-implied growth rate — the growth rate the market has silently priced in.

graph TD
    A[Market Cap + Debt - Cash] --> B[Target EV]
    C[Revenue Growth Assumption] --> D[Forecast UFCF]
    D --> E[Discount to PV]
    E --> F[Model EV]
    B --> G{Goal Seek}
    F --> G
    G --> H[Implied Growth Rate]
    style H fill:#dcfce7,stroke:#16a34a

Example: If a company's current EV is $180B and your fixed-inputs reverse DCF returns a model EV of $180B when revenue growth is set to 9.4%, then 9.4% is the growth rate the market has priced in. Anything above that is upside; anything below is downside.

Reverse DCF Worked Example: A $150 Stock

Assume a mature software company trading at $150 per share with 500M diluted shares, $2B of debt, $5B of cash, and no minority interest or preferred. LTM revenue is $10B, LTM EBIT margin is 25%, D&A is 5% of revenue, CapEx is 4% of revenue, NWC change is 2% of revenue change, tax rate is 21%, and WACC is 9%. Terminal growth is fixed at 2.5%.

Observed enterprise value:

Market Cap = 150 × 500M = $75B
EV         = $75B + $2B - $5B = $72B

Model setup: 10-year explicit period with revenue growth held constant across all forecast years (a simplifying assumption). EBIT margin held at 25%. Terminal value uses Gordon Growth at 2.5%.

Before Goal Seek: You put in an initial guess of 8% revenue growth. The model spits out an EV of $63B — below the market's $72B. That means the market believes growth is higher than 8%.

After Goal Seek: Set the model EV cell to 72,000 (in millions) by changing the growth rate cell. Excel converges around 10.8%.

Interpretation: The market is pricing in ~10.8% annual revenue growth for the next 10 years, with steady 25% EBIT margins throughout. If the company's actual 5-year historical growth is 14% and management guides 12% for next year, the stock looks reasonably valued or slightly cheap. If historical growth is 6% and consensus is calling for 7%, the stock is priced for a growth acceleration that has not shown up in the numbers — a potential short signal.

💡 Pro Tip: Always compare the implied growth rate against three benchmarks: (1) trailing 3–5 year historical growth, (2) management's forward guidance, and (3) industry growth rate. If the implied growth exceeds all three, you have a hard question to answer before buying.

Two-Stage Reverse DCF for High-Growth Companies

A single-stage reverse DCF (constant growth for 10 years) breaks down for hypergrowth companies. A 25% growth rate held for a decade produces revenue numbers that quickly become absurd — a $10B company grows to $93B.

The two-stage reverse DCF splits the forecast into an explicit high-growth phase (typically Years 1–5) and a fade phase (Years 6–10) that converges to the terminal growth rate.

Fade formula in Excel (linear taper), where $B$12 is the starting growth rate and $B$16 is the terminal growth rate:

=$B$12-((ROW()-6)/(10-5))*($B$12-$B$16)

Or use a smooth logistic fade:

=$B$16+($B$12-$B$16)*EXP(-0.4*(ROW()-1))

You then run Goal Seek on $B$12 (the Stage 1 growth rate) to match the model EV to the market EV.

Reverse DCF Variant Best For Trade-off
Single-stage constant growth Mature businesses (large-cap consumer, industrials) Overstates late-stage cash flows for growth companies
Two-stage linear fade Growth-to-mature transitions Fade shape can look arbitrary
Two-stage logistic fade Hypergrowth companies (SaaS, biotech) More complex to build and defend
Three-stage with terminal Extended growth stories (10+ yr moats) Adds a fifth judgment call on top of everything else

For a full SaaS-specific approach with cohort-based revenue modeling, see the SaaS startup financial model guide — the reverse DCF sits on top of that forecast structure rather than replacing it.

How Do You Interpret the Implied Growth Rate?

The implied growth rate is a claim about the future that the market is making right now. Your job is to decide whether the market's claim is supported by the evidence.

Use this decision framework:

graph TD
    A[Run Reverse DCF] --> B[Implied Growth Rate]
    B --> C{Compare to<br/>historical + guidance}
    C -->|Implied &gt;&gt; historical| D[Priced for<br/>acceleration]
    C -->|Implied ≈ historical| E[Priced for<br/>continuation]
    C -->|Implied &lt;&lt; historical| F[Priced for<br/>deceleration]
    D --> G[Is acceleration<br/>supported by<br/>concrete catalysts?]
    E --> H[Base case:<br/>fairly valued]
    F --> I[Is deceleration<br/>justified by<br/>maturity or risk?]
    G -->|No| J[Overvalued]
    G -->|Yes| K[Reasonable]
    I -->|No| L[Undervalued]
    I -->|Yes| M[Reasonable]

Three interpretive questions to ask every time:

  1. Is the implied growth rate higher than the industry growth rate? If yes, the market believes this company will gain share. Verify with unit economics, product cycle, and competitive positioning.
  2. Does the implied EBIT margin assumption hold? A reverse DCF that solves for growth while holding margins flat may be missing an operating leverage story — good or bad.
  3. What does the sensitivity table look like? A ±100bp change in WACC often moves the implied growth rate by 200–300bps. Run the reverse DCF at three WACCs to see the range.

For a systematic way to build these sensitivity outputs, see our guide on sensitivity analysis in Excel — the two-way data table approach works identically for reverse DCF outputs.

Common Reverse DCF Mistakes (and How to Fix Them)

1. Solving for Growth When Margin Is the Real Story

If a company's margins are expanding or compressing, holding EBIT margin flat forces Goal Seek to over- or under-attribute value to growth. Fix: Model a margin trajectory (either based on guidance or a peer benchmark) and let growth do only the residual work.

2. Ignoring Stock-Based Compensation

SBC is a real economic cost. If you treat it as non-cash and add it back, your reverse DCF will show a lower implied growth rate — but you have effectively pretended dilution does not exist. Fix: Subtract SBC from UFCF or reduce shares outstanding growth in the equity bridge. See our stock-based compensation guide for the mechanics.

3. Using a Single Cash Flow for the Terminal Year

Gordon Growth uses FCF_(N+1), not FCF_N. If you feed Year N cash flow into the terminal formula without growing it one year forward, you understate terminal value by (1 + g). Fix: Multiply Year N UFCF by (1 + terminal growth) before applying the perpetuity formula.

4. Not Locking WACC Assumptions

Running Goal Seek while WACC or the equity weight changes creates a circular reference that Excel silently resolves in unpredictable ways. Fix: Enter WACC as a hard-coded input for the reverse DCF, not as a formula that depends on the model output.

5. Comparing Implied Revenue Growth to Implied EPS Growth

These are not the same. A company with high SBC dilution and no operating leverage can have flat EPS growth despite 15% revenue growth. Fix: Be explicit about whether you are solving for revenue growth, UFCF growth, or EPS growth, and compare each to the appropriate benchmark.

6. Anchoring on Round Numbers

Goal Seek can converge at values like 9.9741%. Reporting that as "the market is pricing in 9.97% growth" is fake precision. Fix: Round to the nearest 25 or 50 basis points and describe the answer as a range ("roughly 10%").

⚠️ Warning: Goal Seek is a numerical solver — it will converge on the first value that satisfies the constraint, not necessarily the right value. Always sanity-check the result by manually entering the solved growth rate back into your model and confirming the EV matches.

Reverse DCF vs Forward DCF: When to Use Which

Situation Use Forward DCF Use Reverse DCF
First-time valuation of a company Yes No
Testing whether consensus is realistic No Yes
Pitching a short thesis Both Yes (headline)
Screening for mispricings No Yes
Setting a price target Yes No
Auditing another analyst's model Yes Yes
Investor presentations to non-technical audiences No Yes (easier narrative)

The two methods are complements, not substitutes. Use a forward DCF to establish your view of intrinsic value, then a reverse DCF to translate the current price into the market's view. The difference between the two — measured in growth rate rather than dollars — is where alpha lives.

Automating the Reverse DCF Workflow

The mechanical parts of a reverse DCF — pulling market data, running Goal Seek, formatting the sensitivity output — are repetitive across every company you screen. Tools like VeloraAI can pull the latest market cap, debt, and cash data directly into your workbook, run the Goal Seek loop across a watchlist of tickers, and format the output as a comparable table showing implied growth for every company you track. This turns a 45-minute per-company exercise into a 3-minute screen.

The judgment part — deciding whether an 11% implied growth rate is reasonable for a specific business — is still yours. AI accelerates the mechanics; it does not replace the analyst's read on whether the market's implicit forecast makes sense.

Frequently Asked Questions

What is a reverse DCF used for?

A reverse DCF is used to figure out what growth rate the market has implicitly priced into a stock. Instead of estimating fair value from scratch, you take the current share price as given and solve for the assumption — usually revenue or free cash flow growth — that would justify that price. It is especially useful for testing whether consensus growth expectations are realistic.

How do I run Goal Seek for a reverse DCF in Excel?

Open Data > What-If Analysis > Goal Seek, set the "Set cell" to your model-implied enterprise value cell, set "To value" to the observed market enterprise value (as a number, not a reference), and set "By changing cell" to your revenue or FCF growth assumption. Click OK, and Excel iterates until the two EVs match, leaving the implied growth rate in your growth cell.

What discount rate should I use in a reverse DCF?

Use the same WACC you would use in a forward DCF — typically 7–10% for large-cap US companies. The key rule in a reverse DCF is that WACC must be a fixed input, not a formula that depends on the model output, because Goal Seek assumes a one-variable problem. If WACC is contested, run the reverse DCF at multiple WACCs to build a range.

Is a reverse DCF better than a normal DCF?

Neither is objectively better — they answer different questions. A forward DCF produces your estimate of fair value; a reverse DCF produces the market's implicit forecast. Sophisticated investors run both: the forward DCF for their own view, the reverse DCF to understand what consensus believes. Compare the two to identify where you disagree with the market.

Can I do a reverse DCF without Goal Seek?

Yes, using the single-stage Gordon Growth shortcut: Implied Growth ≈ WACC − (Next-Year FCF ÷ Enterprise Value). This gives a quick estimate but assumes constant growth forever and ignores the explicit-forecast period. For any real investment decision, the Goal Seek approach on a multi-year forecast is meaningfully more accurate.

How accurate is a reverse DCF?

A reverse DCF is only as accurate as its inputs — WACC, terminal growth, margin assumptions, and forecast horizon. It is not a "correct answer machine." Its value is not the precise implied growth rate, but the framework it creates for comparing market expectations against fundamentals. Two analysts running reverse DCFs on the same stock with the same WACC should get similar answers within 100–200 basis points.

Putting It All Together

The reverse DCF flips valuation from a subjective forecasting exercise into a testable statement about market expectations. You stop arguing about what a stock "should" be worth and start asking what the current price actually requires the future to look like. That is a fundamentally more honest way to think about equity risk — and it is a skill that separates analysts who move markets from those who describe them.

Build one in Excel for the next stock you are evaluating: pull market data, forecast UFCF with a variable growth rate, discount at your WACC, and let Goal Seek solve for the growth rate that matches today's price. Then compare the answer against historical growth, guidance, and industry benchmarks. If the numbers do not line up, you have found a mispricing — or a market signal you should take seriously. Either way, you have moved past subjective valuation into a repeatable process, and that is where consistent investment returns are made.