What Is Financial Modeling? How Analysts Value Stocks

Written by Jim Norris · NorrisAI AlphaLens · Updated August 2026

Quick answer: Financial modeling is the process of building a quantitative representation of a company's financial performance to estimate its intrinsic value. The most common model is a Discounted Cash Flow (DCF), which projects future free cash flows and discounts them back to present value. Models are tools for organizing assumptions and testing their impact — not crystal balls. The output is only as good as the inputs, and the most important skill in financial modeling isn't Excel proficiency — it's judgment about which assumptions are realistic.

Why financial models matter

Valuing a stock requires making explicit assumptions about the future: how fast will revenue grow, what will margins look like, how much capital will the business need. A financial model forces you to be explicit and consistent about these assumptions rather than relying on vague intuition.

Models also let you test sensitivity — how much does the valuation change if revenue growth is 10% instead of 15%? If margins expand by 2% instead of 5%? Understanding which assumptions drive the most value helps you focus your research on the variables that matter most.

The three core financial statements

Every financial model is built on three interconnected statements:

Income statement: revenue, cost of goods sold, gross profit, operating expenses, operating income, interest expense, taxes, net income. Shows profitability over a period.

Balance sheet: assets (what the company owns), liabilities (what it owes), and equity (what's left for shareholders) at a point in time.

Cash flow statement: operating cash flow, investing cash flow, financing cash flow. Shows where cash came from and where it went.

The three statements are linked — changes in the income statement flow through to the balance sheet, and the balance sheet changes drive the cash flow statement. A fully integrated three-statement model captures these linkages automatically.

The DCF model — the core valuation approach

A DCF model projects free cash flow for a defined period (typically 5–10 years) and adds a terminal value representing all cash flows beyond the projection period. Both are discounted back to present value using a discount rate (typically the weighted average cost of capital, or WACC).

The discount rate reflects risk — higher uncertainty warrants a higher discount rate, which reduces the present value of future cash flows. The terminal value often drives 60–80% of the total DCF value — which is why assumptions about long-term growth and margins matter so much.

Professor Aswath Damodaran of NYU Stern Business School — widely regarded as the world's foremost authority on valuation — teaches that a DCF is a story told in numbers. The narrative about the business drives the assumptions; the model translates those assumptions into a value. A model built on an unrealistic narrative produces an unreliable value regardless of how technically sophisticated it is. — Narrative and Numbers, Columbia Business School Press

The three-scenario approach

Rather than building one model with one set of assumptions, professional analysts build three:

Base case: the most realistic outcome given current information.

Bull case: what the company is worth if things go better than expected.

Bear case: what it's worth under adverse conditions.

The current stock price should sit below the base case for there to be a margin of safety. If the stock only makes sense under bull case assumptions, the investor is paying for optimism rather than value.

The most important modeling skill: input judgment

Building the model mechanics is learnable in weeks. Developing sound judgment about what growth rates, margins, and discount rates are realistic for a specific business takes years. The analysts who produce the most useful valuations aren't necessarily the best Excel users — they're the ones who understand the business deeply enough to make honest assumptions.

Common modeling mistakes: using overly optimistic terminal growth rates, ignoring the capital requirements that limit free cash flow, applying the same discount rate to businesses with very different risk profiles, and treating the model output as precise rather than a range of possibilities.

Benjamin Graham taught that valuation is better done approximately than precisely — a rough estimate built on honest assumptions serves investors better than a precise model built on wishful thinking. The model is a framework for thinking, not a calculator that produces the correct answer.

How AlphaLens applies financial modeling

The Fair Value Stress Test — framework #3 — builds the three-scenario DCF approach for any stock, incorporating realistic assumptions about revenue growth, margin evolution, and capital requirements. It shows the range of values rather than a single number, and identifies which assumptions drive the most sensitivity. The Earnings Quality Analyzer first verifies that the inputs are reliable before they go into the model.

Where to go deeper

For a detailed walkthrough of each research framework, see the complete guide to all 15 AlphaLens frameworks.

For definitions of investing terms, see the AlphaLens investing glossary.