What Is Financial Modeling? Uses, Types and Techniques
By Markets & Investing DeskUpdated Nov 10, 2026
Definition
Financial modeling is building a numerical representation of a company's operations, usually in a spreadsheet, to calculate how future events or decisions change revenue, costs, cash and value.
Key takeaways
- A model links assumptions, supporting schedules, the three financial statements and outputs such as valuation.
- If the linked statements are correct, the balance sheet balances; if not, an error sits somewhere in the chain.
- Most models run base, upside and downside scenarios to show a range of outcomes instead of one number.
- In a DCF model, small changes to the discount rate or terminal growth rate can move the valuation substantially.
Financial modeling is the process of building a numerical representation of a company’s operations, usually in a spreadsheet, so that the effect of a future event or decision can be calculated. A financial model links historical results, current figures and assumptions about the future, then shows how revenue, costs, cash and value change when those assumptions change. Executives use models to plan and allocate resources. Analysts use them to estimate what a business is worth and how events might affect its stock.
How financial modeling works
A model is built in layers, and each layer feeds the next.
Assumptions and drivers. These are the inputs the user can change: sales growth, prices, volumes, cost margins, interest rates, tax rates, capital spending. Keeping them in one clearly marked section lets a reader see what the model takes for granted.
Supporting schedules. Schedules are the building blocks that turn assumptions into line items. A revenue schedule multiplies volume by price. A depreciation schedule spreads capital spending over asset lives. A debt schedule tracks borrowing, repayments and interest. A working capital schedule converts days of receivables, inventory and payables into balance sheet amounts.
The three financial statements. Schedule outputs flow into the income statement, balance sheet and cash flow statement, and the statements link to each other. Net income from the income statement starts the cash flow statement; the change in cash closes the cash flow statement and becomes the cash balance on the balance sheet; depreciation reduces income and raises cash flow; interest from the debt schedule hits the income statement while principal balances sit on the balance sheet. When those links are correct, the balance sheet balances. When it does not, there is an error somewhere in the chain.
Outputs. Valuation, sensitivity tables, charts and a dashboard sit on top. The dashboard pulls together the headline results (revenue, profit, cash flow, valuation, key ratios) and the scenario selector, so a decision-maker does not have to read every sheet.
Most models also run several scenarios: a base case built on the most likely assumptions, an upside case and a downside case. Switching between them shows the range of outcomes rather than a single number.
Example of financial modeling
Hypothetical example. Sales growth shows the basic structure of any model: inputs, a formula and an output.
| Cell | Contents | Type |
|---|---|---|
| A | Prior year sales: $400,000 | Input |
| B | Current year sales: $460,000 | Input |
| C | (B − A) / A | Formula |
Cell C returns 15% growth. The formula is fixed in the model; cells A and B are inputs the user can overwrite. If the user wants to test a price increase that would lift current year sales to $480,000, changing cell B alone recalculates growth to 20%, and in a full model every downstream figure (gross profit, taxes, cash, valuation) would update with it.
Types of financial models
These are the models analysts encounter most often:
- Three-statement model: the linked income statement, balance sheet and cash flow statement that most other models build on.
- Discounted cash flow (DCF) model: one of the most widely used valuation models; it projects future free cash flows and discounts them to today, usually at the weighted average cost of capital.
- Comparable company analysis: values a business against peers using multiples such as enterprise value to EBITDA.
- Project or capital budgeting models: estimate the cost and return of a new project, often judged by net present value and internal rate of return.
- Budget and forecast models: plan spending and resource allocation for the coming periods.
- Transaction models: merger, acquisition and leveraged buyout models used in investment banking and private equity.
- Sensitivity analysis: shows how an output moves when one or two inputs change, often presented as a data table.
Who uses financial models
Bankers use models in commercial and investment banking, sales and trading, and equity research. Public accountants use them for due diligence and valuations. Private equity firms, portfolio managers and research teams rely on them for investment decisions. Inside companies, finance teams use models to raise money, plan growth, set budgets and evaluate projects, from internal changes such as a new strategy to external ones such as new regulation.
Validation and limitations
Because mistakes can be expensive, a model may be sent to an independent party for validation. Banks, project sponsors, companies seeking funding and equity investors may request this to confirm that the calculations are correct and the assumptions are reasonable. A basic sanity check includes confirming the balance sheet balances, cash never goes unexpectedly negative, growth rates and margins are plausible against history, and no inputs are hard-coded inside formulas.
Even a mechanically perfect model has limits:
- Assumption risk. The output can be no better than the inputs. A model that is precise to the dollar can still be wrong if growth or margin assumptions are off.
- Simplification. A model represents a business; it cannot capture every customer, competitor or economic shock.
- Sensitivity. In a DCF, small changes to the discount rate or terminal growth rate can move the valuation substantially.
- Complexity. Large models with many sheets are harder to audit, which makes hidden errors more likely.
Financial modeling vs. related terms
Forecasting estimates future figures; a model is the structure that connects those forecasts so a change in one flows through to the rest. Valuation is one output of a model, not the model itself. Budgeting sets spending targets for a period, while a model can test whether that budget holds up under different scenarios. Accounting records what has already happened; modeling uses that record as the starting point for projecting what might happen next.
The Bottom Line
Financial modeling matters to analysts, bankers, investors and company finance teams who need to test decisions before making them. A sound model keeps inputs in one marked section, avoids hard-coded figures inside formulas and passes basic checks such as a balancing balance sheet. Its results are only as reliable as its assumptions, so users should read outputs as a range shaped by those inputs.
