DCF Calculator: How to Calculate Intrinsic Value with Discounted Cash Flow
April 7, 2026 · Stock Valuation · 10 min read
What Is a DCF Model — And Why Wall Street Uses It
The Discounted Cash Flow (DCF) model is the foundation of institutional valuations. It's how investment banks, private equity firms, and hedge funds estimate what a business is worth. It's not fancy or mysterious. It's a formula.
And the formula is simple: A stock is worth the sum of all the cash it will generate in the future — converted to today's dollars.
The DCF calculator is just the tool that runs that formula without errors.
Why Most Retail Investors Don't Use DCF
Two reasons:
The math is tedious. By hand, it takes 20-30 minutes per stock. Spreadsheets are better, but still require setup, error-checking, and assumption tweaking.
It's easy to get wrong. Small errors in discount rate, terminal growth rate, or revenue projections can swing the valuation by 30-50%. Most investors either botch the inputs or don't understand their sensitivity.
A DCF calculator automates the mechanics and surfaces which assumptions matter most. It lets you focus on the business, not the spreadsheet.
The DCF Formula: Breaking It Down
A DCF has five components:
1. Project Free Cash Flow (FCF)
Free cash flow = operating cash flow minus capital expenditures. It's the cash a business generates after it pays for growth.
Project FCF forward 5–10 years based on:
- Historical FCF margin (FCF as % of revenue)
- Revenue growth expectations
- Capital intensity (how much the business needs to reinvest)
For Apple in 2026: $120 billion annual FCF. If you expect 8% growth over 5 years, project each year forward.
2. Estimate the Terminal Value
You can't project cash flows forever. After year 5 or 10, assume the company grows at a stable, long-term rate (typically 2–3%, roughly GDP growth). Calculate the value of all cash flows after that terminal year using a perpetuity formula.
Terminal Value = Final Year FCF — (1 + Terminal Growth Rate) / (Discount Rate - Terminal Growth Rate)
This terminal value often represents 60–80% of the total DCF output. Small changes in terminal assumptions swing the entire valuation.
3. Choose a Discount Rate
The discount rate (also called WACC, the Weighted Average Cost of Capital) is the return you could earn elsewhere at similar risk. For public equities, it's typically 8–12%.
If the risk-free rate (Treasury yield) is 4% and the market risk premium is 5%, and the company's beta is 1.2, then: Discount Rate = 4% + (1.2 × 5%) = 10%
Use this to discount all future cash flows back to present value.
4. Discount All Cash Flows to Present Value
For each year, calculate: Present Value = Projected FCF / (1 + Discount Rate)^Year
Sum all present values. That's the Enterprise Value.
5. Convert to Per-Share Value
Enterprise Value = sum of discounted FCF + terminal value Equity Value = Enterprise Value - Net Debt (debt minus cash) Value Per Share = Equity Value / Shares Outstanding
Real Example: Using a DCF Calculator on Microsoft (MSFT)
Let's walk through a real DCF calculation using MSFT as of April 2026.
Inputs:
- Current stock price: $450
- Shares outstanding: 2.39 billion
- Current debt: $60 billion
- Current cash: $80 billion
- Net debt: -$20 billion (net cash position)
- Latest annual FCF: $72 billion
- FCF margin (FCF/revenue): 32%
- Historical revenue growth: 15% annually
Projections:
| Year | Growth Rate | Projected FCF |
|---|---|---|
| 2026 | 13% | $81.5B |
| 2027 | 12% | $91.3B |
| 2028 | 11% | $101.3B |
| 2029 | 10% | $111.4B |
| 2030 | 9% | $121.4B |
Terminal Value:
Year 2030 FCF: $121.4B Terminal Growth: 3% Discount Rate: 9%
Terminal Value = $121.4B — 1.03 / (0.09 - 0.03) = $2,082B
Discount Rate: 9% (based on MSFT's beta, capital structure, and market conditions)
Present Value Calculations:
| Year | FCF | Discount Factor | Present Value |
|---|---|---|---|
| 2026 | $81.5B | 0.917 | $74.8B |
| 2027 | $91.3B | 0.842 | $76.9B |
| 2028 | $101.3B | $0.772 | $78.2B |
| 2029 | $111.4B | 0.708 | $78.9B |
| 2030 | $121.4B | 0.650 | $78.9B |
| Terminal | $2,082B | 0.650 | $1,353B |
Total Enterprise Value: $74.8 + $76.9 + $78.2 + $78.9 + $78.9 + $1,353 = $1,741B
Equity Value: $1,741B + $20B net cash = $1,761B
Value Per Share: $1,761B / 2.39B shares = $737 per share
Current price is $450. The DCF-derived fair value is $737. That suggests MSFT is trading at a 39% discount to calculated intrinsic value.
(This is a simplified example for illustration. Real DCFs include multiple scenarios—base case, bull case, bear case—and MSFT's actual fair value requires sector, competitive, and macro analysis beyond this sketch.)
Why This Matters (And Why Most Investors Miss It)
The DCF reveals what a business is worth as a going concern—not what it's worth based on current earnings, not what comparable companies trade at, but what it's actually worth given what it will produce.
For growth companies that are reinvesting heavily (and thus have low current earnings), the DCF often shows a fair value significantly above what the P/E ratio suggests. For mature, cash-generative businesses, the DCF can reveal that the market is already pricing in all future value and there's no margin of safety.
A single DCF can be wrong—inputs are estimates, not facts. But a DCF calculator that runs multiple scenarios (base, bull, bear) and shows you the range of outcomes gives you real insight into valuation risk.
The Limitations of DCF (And When to Use Other Methods)
Terminal value risk. The terminal value dominates the output. A 1% difference in terminal growth assumption can shift the fair value by 20%+. For companies with truly uncertain long-term futures, the DCF is more speculation than analysis.
Garbage in, garbage out. If your revenue growth projections are wishful, or your discount rate doesn't reflect true risk, the output is worthless. This is why Equity Rank blends 19 valuation methods instead of relying on DCF alone. When DCF, P/E multiples, EV/EBITDA, Price-to-Book, and others all point to similar fair value, that consensus is trustworthy.
Macro sensitivity. If interest rates rise, the discount rate rises, and all DCF valuations compress. If recession risk increases, terminal growth assumptions tighten. The DCF is a snapshot given today's assumptions, not a prophecy.
How to Use a DCF Calculator Effectively
1. Start with historical data. Don't guess. Pull the last 5 years of revenue, operating cash flow, and capex. Calculate historical FCF margins and growth rates. Use these as anchors for projections.
2. Build three scenarios. Base case (management guidance + your assessment), bull case (upside surprise), bear case (structural challenges). Run the DCF for each.
3. Stress-test the discount rate. Calculate fair value at 8%, 10%, and 12% discount rates. See how sensitive the output is. If a 2% change in discount rate swings the fair value by 40%, the valuation is fragile.
4. Compare to other methods. Don't stop at DCF. Run P/E-based valuation, EV/EBITDA, dividend discount models. Do they point to similar fair value? Or is DCF an outlier? If it's an outlier, dig into why.
5. Update quarterly. As actual results come in, adjust your assumptions. If the company beats revenue guidance, raise your projections. If capex rises unexpectedly, recalculate FCF margins. The DCF is a living model, not a one-time calculation.
DCF Calculator vs. Manual Spreadsheet
Manual spreadsheet: You build it once, you control every assumption, and you learn exactly how the model works. Takes 2–3 hours to build well.
DCF calculator (like Equity Rank's): Plug in historical data and assumptions, get results instantly, stress-test easily, compare against consensus fair values, and integrate with margin of safety and analyst trend analysis. Takes 2–3 minutes per stock.
For serious investors, the calculator is worth it—you spend the time understanding the business and tweaking assumptions, not wrestling with spreadsheets.
Key Takeaways
- A DCF calculates intrinsic value by summing all future cash flows, discounted to present value.
- Five components matter most: FCF projections, terminal growth rate, discount rate, terminal value, and per-share conversion.
- Small input changes swing the output dramatically. Terminal growth, discount rate, and revenue projections are the big three. Stress-test them.
- The DCF is only one lens. Blend it with P/E, EV/EBITDA, dividend discount, and other methods. Consensus across methods is trustworthy; outliers warrant investigation.
- Use a calculator, not a manual spreadsheet, if you're evaluating more than a few stocks. It saves time and reduces math errors.
- Update quarterly as new financial data becomes available. The DCF is a snapshot, not a permanent valuation.
Calculate Fair Value Instantly with Equity Rank
Equity Rank runs DCF models alongside seven other valuation methods on 500+ stocks daily. Input your own growth and margin assumptions, or use the platform defaults, and get a consensus fair value in seconds. Then compare to the current price to calculate margin of safety—the valuation edge every investor should know.
Start your free 7-day trial and run DCF calculations on any stock ?
DCF models are based on projections, not guarantees. Fair value estimates involve assumptions about future growth, profitability, and discount rates. Actual results may differ materially. Directional accuracy figures are based on simulation, not live trading results. Equity Rank is not a registered investment adviser. This is educational content, not investment advice or a recommendation to take any action. Consult a qualified financial adviser before making investment decisions.