Stock Valuation DCF Tool
Estimate intrinsic value per share using a discounted cash flow model. Project cash flows, apply a discount rate, and see a full valuation breakdown.
DCF valuation formulas
A discounted cash flow model estimates intrinsic value by projecting future cash flows and discounting them back to the present. This tool uses a simple single‑stage growth model for the explicit period and a Gordon growth model for terminal value.
1. Projected cash flow for year t
CFₜ = CF₀ × (1 + g)ᵗ
Where:
CF₀ = Starting cash flow
g = Annual growth rate
t = Year index (1, 2, …, N)
This formula grows the starting cash flow at a constant rate g for each year in the explicit forecast horizon.
2. Present value of each cash flow
PV(CFₜ) = CFₜ ÷ (1 + r)ᵗ
Where:
r = Discount rate (required rate of return)
Each future cash flow is discounted back to today using the required rate of return. Higher discount rates reduce present value.
3. Terminal value (Gordon growth)
TV = CF_N × (1 + gₜ) ÷ (r − gₜ)
Where:
CF_N = Cash flow in final forecast year
gₜ = Terminal growth rate
r = Discount rate
Terminal value represents the value of cash flows beyond the explicit forecast period, assuming a constant terminal growth rate.
4. Equity value and value per share
Equity value (PV) = Σ PV(CFₜ) + PV(TV) − Net debt
Intrinsic value per share = Equity value ÷ Shares outstanding
Net debt adjusts enterprise value to equity value. Dividing by shares outstanding yields intrinsic value per share.
These formulas provide a clean, intuitive DCF framework. In practice, investors may use multi‑stage growth, changing margins, and scenario analysis, but this structure is a solid starting point for understanding valuation.
How to think about DCF‑based stock valuation
Discounted cash flow analysis is one of the most conceptually rigorous ways to value a business. Instead of focusing on multiples or recent price action, DCF asks a simple question: how much cash can this business generate over time, and what is that stream of cash worth today given the risk?
Choosing the right cash flow
The first decision is which cash flow to model. Many investors use free cash flow to equity (after interest and principal payments) or free cash flow to the firm (before financing decisions). For educational purposes, you can treat “cash flow” as owner earnings—cash that could be distributed to shareholders without harming the business.
Consistency matters more than perfection. If you start with a conservative estimate of current free cash flow and apply realistic growth assumptions, you will get a useful sense of how sensitive value is to your inputs.
Growth, discount rate, and terminal assumptions
DCF is extremely sensitive to growth and discount rates. A small change in growth can dramatically change the terminal value, and a small change in discount rate can significantly alter present value. That’s why many investors prefer to err on the side of caution: lower growth, higher discount rates, and modest terminal growth.
For example, a mature company might be modeled with 3–5% growth for a few years and a terminal growth rate below long‑term GDP growth. A riskier, faster‑growing company might use higher near‑term growth but still revert to a conservative terminal rate.
Net debt and equity value
Once you have the present value of cash flows and terminal value, you adjust for net debt. If the company has more debt than cash, you subtract net debt from enterprise value to arrive at equity value. If it has net cash, you add that to the present value of cash flows. This step connects the DCF to the actual capital structure.
Worked example
Imagine a company with:
- Starting free cash flow: $5,000,000
- Growth rate: 8% per year
- Forecast horizon: 10 years
- Discount rate: 10% per year
- Terminal growth: 2% per year
- Net debt: $10,000,000
- Shares outstanding: 50,000,000
The tool will project cash flows for each year, discount them, compute terminal value, discount that, subtract net debt, and divide by shares. You’ll see intrinsic value per share and implied upside relative to the current price you entered.
Margin of safety and decision‑making
Many value investors use a margin of safety—buying only when the market price is significantly below their conservative estimate of intrinsic value. The margin of safety input in this tool lets you see a “target buy price” that reflects your desired buffer. If the current price is above that level, you might wait; if it’s below, you might consider the stock more attractive.
Practical tips
- Use conservative assumptions; it’s better to be roughly right than precisely optimistic.
- Test multiple scenarios (higher/lower growth, different discount rates) to see how sensitive value is.
- Remember that DCF is one tool among many—combine it with qualitative analysis and risk assessment.
- Use the CSV export to store your valuation runs and compare them over time.
DCF won’t tell you exactly what a stock is “worth,” but it will force you to articulate your assumptions and see how they translate into value. That discipline is often more valuable than any single number.
Frequently Asked Questions
How many years should I forecast?
Many investors use 5–10 years for explicit forecasts. Shorter horizons reduce sensitivity to long‑term assumptions but may understate value for durable compounders.
Can I use negative net debt?
Yes. If the company has more cash than debt, net debt is negative. The tool will add that net cash to the present value of cash flows when computing equity value.
What if growth is not constant?
This tool uses a single growth rate for simplicity. In practice, you might model multiple stages (high growth, fade, stable). You can approximate that by running separate scenarios with different growth rates.
Is terminal growth required?
Yes, for this model. Terminal growth should be conservative—typically below long‑term nominal GDP growth—to avoid unrealistic terminal values.
Does this account for dilution?
The tool uses the shares outstanding you enter. If you expect dilution, you can adjust the share count upward to reflect future issuance.
Can I export the schedule?
Yes. Use the Export CSV button to download the year‑by‑year cash flow and discounting schedule for further analysis.
Related tools
Information on this site is for educational purposes only and is not financial, tax, or legal advice. Calculations are estimates and may not reflect actual results. See our Privacy Policy and Disclaimer.