What Is Financial Modelling? A Practical Introduction for 2026

Financial modelling is the single most requested technical skill in finance recruiting. It appears in nearly every job description for investment banking analyst, private equity associate, equity research associate, corporate development, FP and A, and investor relations roles. It is also the skill that the largest share of candidates feel least prepared to demonstrate confidently in an interview or on a live transaction. This guide explains what financial modelling actually is, what kinds of models exist, and what it takes to become genuinely good at it.

The simplest definition

A financial model is a structured representation, usually built in Excel, of a company’s historical and forecast financial performance. The model takes inputs (operating assumptions, capital structure, valuation parameters) and produces outputs that allow an analyst to value the business, evaluate a transaction, assess the impact of a strategic decision, or stress-test outcomes under alternative scenarios. The discipline of financial modelling is the discipline of building those models in a way that is accurate, auditable, flexible, and presentable to people who will rely on the conclusions.

The three-statement model, the foundation

The fundamental skill in financial modelling is building a three-statement model. This is an integrated forecast of the income statement, balance sheet, and cash flow statement, where all three statements link together correctly. A well-built three-statement model has the property that if you change a single assumption, for example revenue growth in year three, the change flows correctly through revenue, costs, profit, taxes, retained earnings, working capital, and cash. The balance sheet should balance on its own without a hard-coded plug, and the cash flow statement should reconcile exactly to the change in cash on the balance sheet. Building this is harder than it sounds; doing it cleanly is the foundational skill the entire discipline rests on.

The major model types

Different transactions and decisions call for different model architectures.

Three-statement operating model. The foundation. Forecasts income statement, balance sheet, and cash flow statement over a five to ten year horizon.

Discounted cash flow (DCF) model. Values a business by projecting its free cash flows and discounting them back to present value at the weighted average cost of capital (WACC). Sits on top of the three-statement model.

Leveraged buyout (LBO) model. Models a private equity acquisition: purchase price, equity and debt funding, operating forecast for the company under PE ownership, debt schedule with mandatory amortisation and cash sweep, and projected return on exit. Tested in PE recruiting and used on live PE transactions.

Merger model, also called accretion or dilution model. Models the combined financials of an acquirer and target post-acquisition, including financing, synergies, and the impact on earnings per share. Used in M and A advisory.

Initial public offering (IPO) model. Models the company being taken public: offer price range, dilution to existing shareholders, post-IPO capital structure, and underwriter economics.

Sum-of-the-parts model. Values a multi-segment business by valuing each segment separately and summing the results. Used for diversified conglomerates and for breakup analyses.

What makes a good model versus a mediocre one

Mediocre models often produce the wrong number; bad models produce a number that nobody can audit. A good model is built so that every cell traces back to either a hard-coded input or another cell in the model, with no opaque calculations and no embedded values inside formulae. Inputs are colour-coded distinctly from formulae (blue inputs, black formulae is the conventional choice). Section breaks are consistent. The model is broken into clearly labelled tabs (assumptions, operating, debt, three-statement, valuation, returns, sensitivities). Sensitivity tables and scenario switches are built in so the user can stress-test outcomes without rebuilding the model. The model can be picked up by another analyst and understood without verbal handover.

The technical components that distinguish strong modellers

Genuine fluency in financial modelling shows up in a few concrete habits. First, the discipline of forecasting revenue and costs at a granular operational level (volume and price, by product or segment) rather than at an aggregate level. Second, the discipline of building debt schedules that handle every tranche separately, including mandatory amortisation, cash sweep against excess free cash flow, and interest expense resolved through a circular reference (or through an iterative manual override). Third, the discipline of treating working capital consistently across the operating model and the cash flow statement. Fourth, the discipline of presenting outputs (valuation, returns, sensitivities) clearly enough that a busy senior reader can extract the answer in two minutes.

How to learn financial modelling well

Most candidates learn modelling in three layers. A foundational course teaches the mechanics of Excel and the structure of the three financial statements. A transaction-specific course teaches the architecture of LBO, M and A, or DCF models. Live repetition on real or realistic case studies builds pattern recognition. Candidates who recruit successfully into top buy-side and IB seats almost universally complete twenty to thirty hours of structured modelling practice beyond what their degree provided.

Continue Your Finance Education

• What Is Investment Banking
• How to Become an Investment Banker