DCF Model · The Market Crafters
Valuation Intelligence
5-Year DCF Model
Discounted Cash Flow · Intrinsic Value · Upside Analysis
Press Enter to run
Growth Rate 10.0%
Applied to FCF each year
Discount Rate 10.0%
Required rate of return
Enter a ticker and run the model
to see your intrinsic value estimate
About This Model
Understanding discounted cash flow valuation
What is a DCF Model?

A Discounted Cash Flow model estimates intrinsic value by projecting future free cash flows and discounting them back to today. Money in the future is worth less than money today, so we adjust using a required rate of return.

The result is an enterprise value — divide by diluted shares outstanding to get intrinsic value per share.

When is DCF Most Useful?
  • Stable, cash-generating companies
  • Businesses with predictable margins
  • Mature technology firms
  • Consumer staples & durable franchises
  • Long-term compounders with consistent FCF
Model Assumptions
  • FCF TTM: Free Cash Flow from last 4 quarters
  • Growth Rate: Applied annually to FCF for 5 years
  • Discount Rate: Your required return (default 10%)
  • Terminal Growth: 2.5% perpetual growth after year 5
  • Intrinsic Value: Enterprise value ÷ diluted shares
Limitations

This model does not adjust for net debt or excess cash. A more precise version subtracts net debt from enterprise value to derive equity value.

The upside/downside figure represents theoretical spread based solely on your assumptions — not a buy or sell recommendation.

For informational purposes only · Not financial advice · Data via Financial Modeling Prep

Free Cash Flow Growth Analyzer

Historical FCF · Up to 10 Years
Enter a ticker to begin
CAGR Compound annual growth
Avg YoY Growth Simple average
Total Growth Cumulative period
Latest FCF
Free Cash Flow by Year (USD)
Year Operating CF CapEx Free Cash Flow YoY Change ($) YoY Growth (%)

Revenue Growth Analyzer

Historical Revenue · Up to 10 Years · DCF Input
Enter a ticker to begin
CAGR Compound annual growth
Avg YoY Growth Simple average
Total Growth Cumulative period
Latest Revenue
Revenue by Year (USD)
Year Revenue Gross Profit Operating Income YoY Change ($) YoY Growth (%)

Fundamentals Dashboard

EPS · Margins · Returns · Balance Sheet · Dilution
Enter a ticker to begin
EPS (Diluted)
Net MarginNet Inc / Revenue
ROENet Inc / Equity
Debt / EquityLeverage
Current RatioShort-term health
Op MarginOperating leverage

Profitability

Earnings power over time
Diluted EPS ($)
Net Income

Margin Trends

Margin expansion is usually the #1 stock mover
Gross · Operating · Net Margin (%)

Returns on Capital

How efficiently the business compounds shareholder money
ROE · ROA · ROIC (%)

Balance Sheet Health

Cash vs. debt position and capital structure over time
Cash · Total Debt · Total Equity (USD)

Shares Outstanding

Down = buybacks (shareholder-friendly) · Up = dilution
Weighted Avg Diluted Shares

Full Data Table

Year-by-year breakdown across every metric
Year Revenue Net Income EPS Gross % Op % Net % ROE % ROA % Cash Debt Equity D/E Shares (M)

Valuation Multiples

P/E · P/S · EV/EBITDA · P/FCF · 5-Year History
Enter a ticker to begin
P/E (TTM)
P/S (TTM)
EV/EBITDA
P/FCF (TTM)

5-Year Multiple Trends

Dashed line is 5Y average · green shading = below avg (cheap)
P/E Ratio
P/S Ratio
EV/EBITDA
P/FCF Ratio

Historical Multiples

Year-end ratios · TTM row shows current
YearP/EP/SEV/EBITDAP/FCF

Peer Comparison

Same sector · Similar market cap · TTM values
Loading peer data...
How to Read This · Click to Expand

The Four Multiples

  • P/E (Price / Earnings): How many years of current earnings you're paying for. 15-20x is "normal" for a mature business; 30+ signals high growth expectations; below 10 is either a bargain or a trap.
  • P/S (Price / Sales): Useful when earnings are negative or volatile. Common for software (5-15x) and retail (0.5-2x).
  • EV/EBITDA: Values the whole business (equity + debt − cash) vs cash earnings. Better than P/E for comparing companies with different capital structures.
  • P/FCF (Price / Free Cash Flow): Most honest earnings number; what the business actually generates in cash. Gold standard for mature, cash-producing companies.

Why vs 5-Year Average?

A stock at 20x P/E isn't automatically expensive — you need context. If its 5-year average is 25x, 20x might be a bargain. If its average is 12x, 20x is rich. Comparing to historical self is the simplest valuation sanity check.

The Color Coding

  • Green (below 5Y avg): Currently cheaper than history — starting point for further research
  • Red (above 5Y avg): Currently richer than history — needs extra scrutiny
  • Neutral (within 10% of avg): Fairly valued vs its own history

When Cheap ≠ Buy

A stock can be cheap for a reason — declining business, industry disruption, balance sheet risk. Always cross-check with the Fundamentals dashboard: if margins are shrinking and ROE is dropping, the cheap multiple is warranted. "Cheap" is a starting point, not a conclusion.

Price Chart

Daily Close · 50D · 200D MA · 52W High / Low
Enter a ticker to begin
52W High
52W Low
50-Day MA
200-Day MA
YTD ReturnSince Jan 1
1Y Return52W total

12-Month Price Action

Price vs 50-day and 200-day moving averages