If you are planning a career in corporate finance, FP&A, investment banking, or financial analysis, there is one skill that will determine your starting salary, your promotion speed, and the quality of the opportunities available to you more than almost anything else: financial modelling.

The ability to build an integrated financial model in Excel — one that correctly links the Income Statement, Balance Sheet, and Cash Flow Statement and allows you to test scenarios and communicate insights — is the single most in-demand practical skill in finance. And it is one of the most consistently underbuilt skills in accounting and finance graduates.

This post explains what financial modelling actually is, why it matters for your career, and what you need to learn — and do — to build the skill from scratch.

What Is Financial Modelling?

A financial model is an Excel spreadsheet that represents a company’s financial performance — historically and projected forward. It connects the Income Statement (revenue, costs, profit), Balance Sheet (assets, liabilities, equity), and Cash Flow Statement (cash generated and used) in a way that allows changes in one assumption to automatically flow through to all three statements.

Financial models are used to: forecast future business performance, evaluate the impact of different strategic decisions, support investment analysis (DCF valuation), prepare for fundraising or M&A, and run annual budgeting and planning processes (FP&A).

The three-statement model is the foundation. Every more complex model — DCF valuation, LBO, M&A, budget — is built on top of a correctly integrated three-statement model.

Why This Skill Determines Your Career Trajectory

Employers distinguish between candidates who have heard of financial modelling and candidates who can build a model. The difference in compensation is significant: financial analysts with strong modelling skills consistently earn $10,000–$20,000 more at entry level than those without, and they advance faster.

For FP&A roles specifically — one of the fastest-growing areas in corporate finance — financial modelling fluency is the baseline expectation, not a differentiator. The 2025 Morgan McKinley Global Workplace Trends report identified Financial Planning & Analysis as one of the top skills in demand, noting that it requires ‘agile financial forecasting, real-time scenario modelling, and delivering well-thought-out insights.’

For investment banking and equity research, the three-statement model is tested directly in technical interviews. Candidates who can build and explain a model — not just talk about it — move to the top of the candidate stack.

What You Need to Learn — In Order

Step 1: Understand the three financial statements and how they connect

Before building a model, you need to understand what each statement shows and how they are linked. Net income flows from the Income Statement into retained earnings on the Balance Sheet. Depreciation from the Income Statement appears as a non-cash add-back on the Cash Flow Statement. Changes in working capital (accounts receivable, inventory, accounts payable) appear on both the Balance Sheet and the Cash Flow Statement.

Step 2: Build the Income Statement forecast

Start with revenue — typically forecast as a growth rate applied to historical revenue or driven by operational assumptions (units sold × price). Then build COGS as a percentage of revenue, operating expenses line by line, and work down to EBIT and net income.

Step 3: Build supporting schedules

Supporting schedules calculate the inputs that flow into the IS and BS: a depreciation schedule for PP&E, a debt schedule showing interest expense and repayments, a working capital schedule showing changes in AR, AP, and inventory, and an equity schedule tracking share capital and retained earnings.

Step 4: Build and link the Balance Sheet

The Balance Sheet should pull from the supporting schedules — PP&E from the depreciation schedule, debt from the debt schedule, equity from the equity schedule. Every cell should be a formula linked to a source, not a hard-coded number. The balance sheet check (Assets = Liabilities + Equity) should be in every forecast period.

Step 5: Build the Cash Flow Statement using the indirect method

The Cash Flow Statement reconciles net income to actual cash movement. It starts with net income, adds back non-cash items (depreciation), adjusts for working capital changes, then adds investing activities (capex) and financing activities (debt, dividends). The ending cash balance must equal the Balance Sheet cash balance — this is the ultimate check that the model is correctly integrated.

The Most Common Mistake New Modellers Make

Hard-coding numbers. A professional financial model has almost no hard-coded values in its calculation cells — everything is a formula that references an input or a prior calculation. When you hard-code a number, the model loses its dynamic properties. If revenue assumptions change, you have to manually update dozens of cells instead of one input. Hard-coded models break constantly and are a red flag to any experienced reviewer.

How to Build This Skill — The Only Way That Actually Works

You cannot learn financial modelling by reading about it. You learn it by building a model — making it wrong, debugging it, fixing it, and making it work. Ideally, you do this with someone who has built models professionally watching your work and catching the errors that new modellers make.

In Implementation Tutoring at AccountingTutorOnline.com, the Three-Statement Financial Modelling course guides you through building a complete model for a realistic company from scratch — historical data to forecast, IS to BS to CF, with a DCF valuation, scenario analysis, and executive dashboard. Every session, you build. Every session, mistakes are caught and corrected in real time.

By the end, you have a model you built yourself, that you can explain line by line, and that you can demonstrate in any finance interview or use in your first finance role.

📅  BOOK YOUR FREE DIAGNOSTIC SESSION Ready to build your first real financial model? Book a session at accountingtutoronline.com/book and we’ll start with your current level.

Related reading: [LINK TO POST 2: How to Prepare for Your First Accounting or Finance Job] |

[LINK TO POST 3: Excel for Accountants — The 7 Skills That Matter] |

[LINK TO IMPLEMENTATION PAGE: Implementation Tutoring — What Is It?]

^{"Are you tired of struggling in accounting class? Let us make accounting easy and enjoyable for you."}