Financial Modelling Basics: What Every Finance Graduate Must Know

When a finance manager says "build me a model for this," they are not asking for something from an investment banking textbook. They are asking you to create a structured Excel spreadsheet that takes business assumptions, projects financial outcomes, and helps answer a specific business question — will this product be profitable? What happens to margins if raw material costs rise by 10%? What is the budget for next year if revenue grows at 12%?

Financial modelling, at the level that matters for most finance graduates, is applied business thinking in Excel. It is not a specialised skill reserved for investment bankers or CFA charterholders. CMA professionals use modelling in budgeting, FP&A, costing, plant finance, project evaluation, and management reporting. Business finance, MIS, and corporate finance professionals use it daily. The Corporate Finance Institute (CFI) describes financial modelling as combining accounting, finance, and business metrics to create a forecast of a company's future results — a skill that supports planning, analysis, and decision-making across every type of finance role.

A financial model is a structured Excel spreadsheet that translates business assumptions into projected financial outputs. The key word is "structured" — a good model has a clear, logical architecture where changes in one assumption automatically flow through to all connected outputs. It is not a collection of ad hoc calculations; it is a disciplined representation of how a business generates revenue, incurs costs, and produces profit and cash flow.

CFI describes the qualities of a good financial model clearly: it should be logical, clear, linked properly, easy to review, and easy to explain. These qualities are directly relevant to what finance interviewers and managers evaluate — not whether the model is impressively complex, but whether it is understandable, auditable, and defensible.

A basic financial model answers business questions like:

• What will profit look like if sales grow by 15% next year?
• How does a 5% rise in raw material cost affect gross margin?
• Is this new product financially viable?
• What is the estimated budget for next year based on current growth trends?
• What happens to cash flow if collection days worsen from 45 to 60?

These are business questions — not academic exercises. The model is the tool for answering them systematically rather than through guesswork or manual recalculation.

IMA's FP&A guidance specifically describes financial modelling as part of the FP&A decision-support function — a framework that many CMA graduates enter. For the full FP&A career guide, read our blog on FP&A analyst career guide.

Every financial model, regardless of complexity, contains the same core structural components. Understanding these components is the conceptual foundation before touching Excel:

• Assumptions section: All variables that drive the model — revenue growth rate, gross margin %, cost inflation %, working capital days, capex schedule. Assumptions should be clearly separated from calculations so that anyone reviewing the model can see exactly what drives the output. Good models have a single source of truth for each assumption; calculations reference that source rather than hard-coding numbers throughout.
• Projected Income Statement (P&L): Revenue, cost of goods sold, gross profit, operating expenses (broken into categories), EBITDA, depreciation, EBIT, interest, and profit before/after tax — projected for the relevant time horizon (monthly, quarterly, or annual).
• Balance Sheet: Assets (fixed assets, working capital: debtors, inventory, creditors), liabilities, and equity. In a three-statement model, the balance sheet is driven by P&L outputs (retained earnings, depreciation → net block) and working capital assumptions.
• Cash Flow Statement: Operating cash flow (starting from EBITDA, adjusting for working capital changes, taxes), investing cash flow (capex), and financing cash flow (debt, dividends). The cash flow statement balances to the net change in cash on the balance sheet.
• Scenario analysis: Base case (most likely), optimistic case (best assumptions), and pessimistic case (stress assumptions). The model should allow switching between scenarios easily — ideally via a dropdown or switch cell — so decision-makers can see the range of financial outcomes.

The most conceptually important skill in financial modelling is understanding how the three financial statements link together. CFI specifically notes that building a model requires solid accounting fundamentals and an understanding of how accounts connect. Here is how the connections work:

The acid test: In a correctly built three-statement model, the cash balance on the balance sheet equals the closing cash from the cash flow statement for every period. If these do not match, there is an error somewhere. This linkage test is the first thing a reviewer checks in any model.

Of all the modelling skills, scenario analysis is the one that most directly creates management value — and the one most frequently asked about in finance interviews. Scenario analysis converts a financial model from a single-point forecast into a decision-support tool that shows what happens under different business conditions.

The three standard scenarios for any business model:

• Base case: The most likely scenario based on current trends and management's realistic expectations. Revenue growth at expected rate, costs at standard efficiency, working capital at target days.
• Optimistic case: Business conditions better than expected — higher revenue growth, better margins, faster collections. Shows the upside potential and helps management understand what to aim for.
• Pessimistic case (stress case): Business conditions worse than expected — lower volumes, higher costs, slower collections. Shows the downside risk and helps management plan mitigation actions in advance.

The practical implementation in Excel is simple: create a scenario switch cell that a user can change between "Base," "Optimistic," and "Pessimistic." Use IF formulas to reference different assumption sets based on the scenario selection. The entire model recalculates when the switch is changed, showing the full financial impact of each scenario instantly.

When an interviewer asks "how would you evaluate the financial viability of a new product?" — describing this three-scenario structure demonstrates modelling maturity that very few freshers can do. It shows you understand that finance is not about one precise forecast but about understanding the range of outcomes. For a wider analytics and data perspective, read our blog on data analytics for finance freshers.

The best way to learn financial modelling is to build a model — CFI specifically states that practice is how modelling capability develops. Here is a step-by-step guide for building your first model:

For the Excel fundamentals that underpin this model, read our blog on top Excel functions every finance professional must know. For connecting model outputs to dashboards, read our blog on Power BI for finance professionals.

• Treating modelling as an Excel trick: Fancy formatting, complex formulas, and elaborate visuals do not make a good model. Business logic does. A model must answer the business question it was built for. If you cannot explain what the model shows or why the assumptions are reasonable, it is not a useful model regardless of how it looks.
• Ignoring accounting fundamentals: Without understanding how the three financial statements connect, models become mechanically built but analytically weak. A model where the balance sheet does not balance, or where cash flow does not reconcile to balance sheet cash, has a structural error that an interviewer will immediately identify. Build accounting understanding before building models.
• Starting too advanced: Finance graduates who try to build DCF models, LBO models, or M&A merger models without first being able to build a clean three-statement projected P&L are building on unstable foundations. Start simple. A projected P&L with scenario analysis built correctly is more impressive in an interview than a complex model with errors.
• Hard-coding numbers everywhere: Typing the same growth rate in 12 different cells is how models break. A change to one cell does not update the others, creating inconsistencies. All assumptions should be in a single assumptions section; calculation cells reference that section. This is the single most important modelling discipline.
• Copying templates without understanding them: Using a downloaded model template without being able to explain every formula and every assumption is not modelling skill — it is template operation. If an interviewer asks you to change an assumption or explain a formula you did not build yourself, you will be exposed immediately. Build every formula in your practice models from scratch.

Financial modelling is one of those skills where the gap between "I know what it is" and "I can build one" is surprisingly bridgeable in a few weeks of focused practice. The concepts are not obscure — you already know the P&L, the balance sheet, and the cash flow statement from your CMA or commerce education. What modelling adds is the discipline of linking these statements with assumptions, so that a single change in a revenue growth rate automatically flows through to profit, cash flow, and balance sheet.

That discipline — the habit of building models that are logical, clearly linked, and easy to explain — is what finance employers are testing when they ask about modelling in interviews. They are not testing whether you can build a 50-tab DCF model. They are testing whether you can take a business problem, build a structured analysis, identify the key drivers, and explain what the numbers show.

Start with a simple projected P&L for a business you understand. Add the balance sheet and cash flow. Add scenario analysis. Build a clean one-page summary. Practice explaining it out loud in three minutes. That is financial modelling for a finance graduate in 2026 — practical, business-oriented, and genuinely impressive when done well.

— CMA Rohan Sharma, Career Success Launchpad