Your Complete Dcf Model Checklist for Stock Analysis

Your Complete Dcf Model Checklist for Stock Analysis

A DCF model converts a company's projected free cash flows into a present-day intrinsic value estimate. The math is not complicated. The difficulty is in the inputs: a wrong free cash flow projection, a miscalibrated discount rate, or a terminal value assumption that does not survive scrutiny will each produce a number that looks precise but is actually misleading. This checklist covers every item you need to verify before trusting any DCF model output enough to act on it.

Work through each section in order. Every box matters.

Key Takeaways

• A DCF model is built in five stages: historical free cash flow, forward projections, discount rate, terminal value, and equity bridge. Errors in any stage compound into the final result.
• Terminal value accounts for 60-80% of most DCF results, so the terminal growth rate assumption deserves more scrutiny than most investors give it.
• Sensitivity analysis is not optional. A model without a range is false precision.
• Apple (AAPL) at P/E 28.3 and ROIC 45.1% shows how capital efficiency justifies richer assumptions in the growth and terminal value stages.
• The ValueMarkers DCF calculator runs four model variants (FCFF, FCFE, Owner Earnings, EV/FCF exit multiple) so you can cross-check outputs without building everything in a spreadsheet.

Section 1: Historical Free Cash Flow

Before projecting anything, verify the historical data. Projections anchored to incorrect or one-year historical figures produce compounding errors over a 10-year horizon.

• Pull at least 5 years of operating cash flow and capital expenditure data from SEC filings (10-K, 10-Q), not from third-party aggregators that may normalize differently.
• Calculate FCF for each year: Operating CF - Capex.
• Compute the 3-year and 5-year CAGR for FCF.
• Identify any one-time items in operating cash flow: litigation settlements, tax refunds, working capital windfalls. Normalize them out.
• Check capital expenditures for step-change investments that inflate one-year capex and will not recur.
• Verify that the FCF trend is consistent with reported earnings. Large, sustained divergences between earnings and FCF signal either accounting issues or a capital-intensive business model that requires separate treatment.

For context: Johnson & Johnson (JNJ) has produced consistent FCF of approximately $17 billion per year over the past three years, supported by a dividend yield of 3.1%. Consistent historical FCF is the strongest foundation for a DCF model.

Section 2: Free Cash Flow Projections

The projection stage is where most DCF models fail. Over-optimism in growth rates is the most common single error.

• Use a two-stage growth model. Apply a near-term rate for years 1-5 and a lower mid-term rate for years 6-10. Do not use a single flat rate across 10 years.
• Anchor near-term growth to a weighted average of: historical FCF CAGR, analyst consensus revenue growth, and management guidance. Weight the conservative end more heavily unless you have specific differentiated insight.
• Do not project revenue growth above 15% for more than 3 consecutive years without a clearly identifiable structural reason (new product category, market expansion with hard data).
• Model margin explicitly. Derive FCF from projected revenue x projected margin. Flat-margin assumptions hide the impact of scale economics or competitive pressure.
• Project capital expenditures separately. Split maintenance capex (sustaining current capacity) from growth capex (expanding it). Maintenance capex is a fixed cost. Growth capex is a variable investment decision.
• Adjust for changes in net working capital. Fast-growing businesses often consume cash in working capital. A company growing revenue at 20% annually needs to fund accounts receivable and inventory growth ahead of cash collection.

Section 3: Discount Rate (WACC)

• Use the 10-year U.S. Treasury yield as your risk-free rate. As of April 2026, that is approximately 4.45%.
• Source the company's beta from at least two providers and use the average. Beta estimates vary significantly across data sources.
• Apply an equity risk premium of 4.5-5.5%. Damodaran's current estimate for the U.S. market sits near 5.0%.
• Cost of Equity = Risk-Free Rate + (Beta x ERP). For AAPL (beta 1.2): 4.45% + (1.2 x 5.0%) = 10.45%.
• For the after-tax cost of debt, use the company's actual weighted average interest rate on outstanding debt, not the current risk-free rate. Apply (1 - effective tax rate) to convert to after-tax.
• Weight by market-value capital structure, not book-value capital structure. Use current equity market cap and book value of debt.
• Confirm WACC is above the risk-free rate by at least 4-5 percentage points for any equity DCF. Anything below that implies an equity risk premium that history does not support.

Section 4: Terminal Value

Terminal value is where the most dangerous DCF errors live. A 1% change in the terminal growth rate often changes intrinsic value by more than the entire 10-year explicit cash flow projection.

• Calculate terminal value using the Gordon Growth Model: Terminal Value = FCFn x (1 + g) / (WACC - g).
• Set g below the risk-free rate in all but the most exceptional cases. A perpetual growth rate of 2-3% is defensible for most U.S. large-caps. Rates above 3.5% require explicit justification.
• Cross-check with the EV/EBITDA exit multiple method. Apply a multiple consistent with historical acquisition transactions in the sector. Compare the two terminal values. If they diverge by more than 20%, investigate why.
• Check the terminal value as a percentage of total DCF value. If it exceeds 80%, your near-term cash flows are too small relative to the terminal assumption, usually a sign that the growth rate is too aggressive or the discount rate is too low.
• Verify the denominator in the Gordon Growth Model (WACC - g) is positive and large enough to produce a sensible result. A WACC of 9% and a g of 8.5% creates an absurdly high terminal value. That is a model error, not a discovery.

Section 5: Equity Bridge

The equity bridge converts enterprise value to per-share equity value. Errors here are particularly costly because they directly affect the price you are willing to pay.

• Subtract total debt (including operating lease obligations post-ASC 842) from enterprise value.
• Add cash and cash equivalents and short-term investments. Do not add all "other assets"; only liquid financial instruments belong in the equity bridge.
• Subtract minority interest and preferred equity at market value.
• Add unconsolidated investments and equity stakes at current fair market value.
• Divide by diluted shares outstanding, not basic shares. The diluted share count includes the impact of options, warrants, restricted stock units, and convertible instruments.
• Adjust for expected future dilution if the company has a history of consistent share issuance (more than 1-2% annual growth in share count). Discount per-share intrinsic value accordingly.

Is DCF Fundamental Analysis

Yes, and it is the most direct form. A DCF model connects directly to the economic definition of value: the present value of all future cash flows. No peer comparison is required. No market multiple is applied as a shorthand. The output is derived entirely from the company's own projected cash generation and your required rate of return.

The DCF model's weakness is its sensitivity to inputs, as shown above. That sensitivity is not a reason to avoid it. It is a reason to run sensitivity analysis and apply a margin of safety. The model forces you to make your assumptions explicit, which means you can test them, challenge them, and update them as new data arrives.

A Simplified Common Stock Valuation Model

The full multi-stage DCF model is not always necessary. For stable, dividend-paying businesses, a simplified version using the Gordon Growth Model applied to dividends (rather than FCF) can serve as a quick sanity check:

Value = D1 / (r - g)

Where D1 is the next annual dividend, r is your required return, and g is the dividend growth rate.

For Coca-Cola (KO) with an estimated 2026 dividend of $2.00, a required return of 8%, and a long-term growth rate of 3%: Value = $2.00 / (0.08 - 0.03) = $40. Compare to the market price. If KO trades at $65, the implied return at that price is $2.00 / $65 + 3.0% = 6.1%, below your 8% hurdle.

This simplified model is not a replacement for a full DCF, but it provides a rapid filter for whether a more detailed analysis is worth the time.

Section 6: Sensitivity Table and Margin of Safety

• Build a 5x3 or 5x5 sensitivity table varying the discount rate and the terminal growth rate.
• Identify the range of intrinsic values across your scenario matrix. Buy only below the bear case with a margin of safety.
• Apply a margin of safety appropriate to business quality: 15-20% for high-quality compounders, 30-50% for cyclical or uncertain businesses.
• Confirm the resulting buy price produces a return above WACC across the base and bull scenarios. If it does not, the position is unlikely to generate adequate risk-adjusted returns.

The ValueMarkers DCF calculator runs sensitivity analysis automatically and lets you toggle between four DCF model types (FCFF, FCFE, Owner Earnings, EV/FCF exit multiple) to cross-check your result.

Further reading: Investopedia · CFA Institute

Why discounted cash flow model Matters

This section anchors the discussion on discounted cash flow model. The detailed treatment, formula, and worked examples appear in the body of this article above. The points below summarize the most important takeaways for value investors who want to apply discounted cash flow model in real portfolio decisions. ValueMarkers exposes the underlying data on every covered ticker via the screener and stock profile pages, so the concepts in this article translate directly into actionable filters.

Key inputs for discounted cash flow model

See the main discussion of discounted cash flow model in the sections above for the full treatment, including the inputs, the calculation methodology, the typical sector benchmarks, and the most common pitfalls to avoid. The ValueMarkers screener lets value investors filter the full universe of 100,000+ stocks across 73 exchanges using discounted cash flow model alongside the rest of the 120-indicator composite, with sector percentiles and historical trends shown on every stock profile.

Sector benchmarks for discounted cash flow model

See the main discussion of discounted cash flow model in the sections above for the full treatment, including the inputs, the calculation methodology, the typical sector benchmarks, and the most common pitfalls to avoid. The ValueMarkers screener lets value investors filter the full universe of 100,000+ stocks across 73 exchanges using discounted cash flow model alongside the rest of the 120-indicator composite, with sector percentiles and historical trends shown on every stock profile.

Frequently Asked Questions

is dcf fundamental analysis

Yes. DCF is the most direct form of fundamental analysis. It values a business based on its own cash-generating ability rather than by comparing it to peer company multiples. Unlike relative valuation, DCF produces an intrinsic value estimate that does not depend on other companies being correctly priced. Every other valuation multiple is a compressed DCF model with implicit growth and discount rate assumptions baked in.

a simplified common stock valuation model

The Gordon Growth Model is the standard simplified stock valuation approach: Value = D1 / (r - g), where D1 is the next expected dividend, r is the required rate of return, and g is the perpetual growth rate. It works best for mature, stable dividend payers like JNJ (3.1% yield) and KO (3.0% yield). The model breaks down for companies that do not pay dividends, are in rapid-growth phases, or have volatile earnings.

how to build a stock valuation model

To build a stock valuation model, start by selecting the appropriate method for the business type: DCF for companies with predictable free cash flows, EV/EBITDA relative valuation for cyclical businesses, or sum-of-the-parts for conglomerates. For a DCF model, gather five years of free cash flow history, project forward using a two-stage growth model, calculate WACC, compute terminal value using the Gordon Growth Model or an exit multiple, and bridge to per-share equity value by subtracting net debt and dividing by diluted shares outstanding.

a simplified model for portfolio analysis pdf

For portfolio-level valuation analysis, a simplified model applies a consistent discount rate framework across all holdings and scores each position against its intrinsic value estimate. The ValueMarkers VMCI Score provides a pre-built screening framework: Value (35%), Quality (30%), Integrity (15%), Growth (12%), and Risk (8%). This five-pillar structure serves as a portfolio analysis model by standardizing how you compare businesses across different sectors and growth profiles. Our screener applies this framework across 120 indicators.

what is the dcf

DCF stands for discounted cash flow. It is a valuation method that estimates the intrinsic value of a business or asset by projecting its future free cash flows and discounting each one back to present value at a required rate of return (WACC). The sum of all discounted cash flows, including the terminal value, gives you the enterprise value. Subtract net debt to get equity value, then divide by shares outstanding for per-share intrinsic value.

how to do a dcf model

To do a DCF model: (1) calculate historical free cash flow as operating cash flow minus capital expenditures, (2) project FCF for 5-10 years using a two-stage growth rate, (3) calculate WACC as the weighted average of cost of equity and after-tax cost of debt, (4) discount each projected FCF to present value, (5) add a terminal value using FCFn x (1+g) / (WACC - g), (6) sum the discounted FCFs and terminal value to get enterprise value, (7) subtract net debt and divide by diluted shares outstanding to get per-share intrinsic value, and (8) compare to market price with a margin of safety buffer.

Use the ValueMarkers DCF calculator to build your DCF model without a spreadsheet, with built-in sensitivity analysis across four model variants.

Written by Javier Sanz, Founder of ValueMarkers. Last updated April 2026.

Ready to find your next value investment?

ValueMarkers tracks 120+ fundamental indicators across 100,000+ stocks on 73 global exchanges. Run the methodology above in seconds with our stock screener, or see today's top-ranked names on the leaderboard.

Related tools: DCF Calculator · Methodology · Compare ValueMarkers

Disclaimer: This content is for informational and educational purposes only and does not constitute investment advice, a recommendation, or an offer to buy or sell any security. Past performance does not guarantee future results. Consult a licensed financial advisor before making investment decisions.