Financial Modelling Basics: What It Is, Why It Matters, and How to Start

What Is a Financial Model?

A financial model is a quantitative representation of a company's financial performance — past, present, and projected future. It is typically built in a spreadsheet and uses historical financial statements as inputs to project future revenues, expenses, cash flows, and balance sheet positions under various assumptions. Financial models are used to value companies, evaluate investment opportunities, make capital allocation decisions, plan for future financing needs, and run scenario analysis.

Financial modelling is one of the most practically valuable skills in corporate finance, investment banking, private equity, financial planning and analysis (FP&A), and consulting. Students who can build clean, logical, well-documented models are significantly more attractive to employers in these fields than those who cannot.

The Three-Statement Model: The Foundation

The most fundamental financial model is the three-statement model — an integrated model that links the income statement, balance sheet, and cash flow statement. The integration means that a change in any one assumption — revenue growth rate, gross margin, capital expenditure — flows through all three statements consistently, maintaining all the accounting relationships between them.

Building a three-statement model requires a thorough understanding of how the financial statements articulate. Net income flows from the income statement to retained earnings on the balance sheet. Depreciation flows from the income statement to property, plant and equipment on the balance sheet and to operating cash flow on the cash flow statement. Changes in working capital accounts on the balance sheet flow into operating cash flow. If you do not understand these linkages, your model will not balance.

This is why strong financial modelling skills are built on a foundation of strong accounting skills. Review how to read financial statements and practise financial statement questions before diving into modelling.

DCF Valuation: The Most Important Model Type

A discounted cash flow (DCF) model values a company or project by estimating its future free cash flows and discounting them back to present value using an appropriate discount rate. The DCF is theoretically the most correct valuation approach because it focuses on the actual cash-generating capacity of the business, independent of accounting choices.

The key components of a DCF model are: the revenue forecast (typically driven by industry analysis and company-specific growth assumptions), the EBITDA margin (which drives operating cash flows), capital expenditure requirements, working capital changes, the terminal value (which represents the value of all cash flows beyond the explicit forecast period), and the discount rate (typically WACC). A one-percentage-point change in the discount rate or the terminal growth rate can shift the valuation by 20 to 30 percent — which is why sensitivity analysis is always included.

Key Modelling Best Practices

Clean models are as important as accurate models. Financial professionals who review models from junior analysts look immediately at the structure and formatting. Use consistent formatting — assumptions in one colour (typically blue for hardcoded inputs), formulas in another (typically black), and links to other sheets in a third (typically green). Never hardcode numbers into formulas — if a number might change, make it an input.

Structure your model logically. Historical financial statements on the left, then the projection years moving to the right. Key assumptions at the top of the model where they are easy to find and change. Supporting schedules (debt schedule, depreciation schedule, working capital schedule) on separate tabs that feed into the main statements.

Essential Excel Skills for Financial Modelling

Financial models are almost universally built in Microsoft Excel. The Excel skills most frequently needed in financial modelling include: VLOOKUP and INDEX/MATCH for data lookup, IF and nested IF statements for conditional logic, SUMIF and SUMPRODUCT for conditional aggregation, NPV and IRR functions for valuation, data validation for input cells, and circular reference handling for interest calculations in debt schedules.

Learning keyboard shortcuts dramatically improves modelling speed — professional financial modellers navigate entirely by keyboard, rarely touching the mouse. Investing time in learning Excel shortcuts pays returns throughout your finance career.

Where to Use These Skills

Financial modelling is central to roles in investment banking (valuing companies for M&A and IPO transactions), private equity (evaluating potential investments and modelling leveraged buyouts), corporate FP&A (building operating budgets and forecasts), equity research (building company models to support buy/sell recommendations), and consulting (building business case models for client decisions).