Skip to content

Financial Modelling Mechanics

Overview

Financial models are the foundation of modern finance.

Whether you work in investment banking, equity research, private equity, corporate finance, FP&A, or consulting, financial models help transform historical financial information into forward-looking insights that support better decision-making.

A financial model is much more than an Excel spreadsheet.

It is a structured representation of how a business operates.

This lesson introduces the mechanics behind financial modelling and explains how professional models are designed before learning how to build one in Excel.

Learning Objectives

After completing this lesson, you should be able to:

  • Understand the purpose of financial modelling.
  • Recognise the components of a professional financial model.
  • Explain how the three financial statements interact.
  • Understand how assumptions drive forecasts.
  • Appreciate why model design is just as important as model calculations.

What is a Financial Model?

A financial model is a simplified representation of a business that helps answer financial questions.

Models allow finance professionals to estimate future performance by combining historical data with reasonable assumptions.

Instead of asking:

"What happened?"

Financial models help answer:

  • What is likely to happen?
  • Why might it happen?
  • What happens if assumptions change?
  • What is the business worth?
  • Should we invest?

Financial modelling transforms historical information into forward-looking decision support.

Why Do Finance Professionals Build Models?

Financial models support decisions across many areas of finance.

Examples include:

  • Valuing a company
  • Forecasting revenue
  • Estimating cash flow
  • Budgeting
  • Capital allocation
  • Investment decisions
  • Acquisitions
  • Debt financing
  • Scenario analysis

Although different industries use different models, the underlying principles remain consistent.

A Financial Model Begins With a Business

Before opening Excel, understand the business.

Ask questions such as:

  • How does the company make money?
  • What drives revenue?
  • What are the major costs?
  • Is the business seasonal?
  • What risks affect performance?
  • Which metrics matter most?

A model should reflect how the business actually operates.

Understanding the business always comes before building the spreadsheet.

The Three Financial Statements

Professional financial models are built around three interconnected financial statements.

Income Statement

Measures profitability over a period.

Key outputs include:

  • Revenue
  • Gross Profit
  • Operating Profit
  • Net Income

Balance Sheet

Represents the company's financial position at a point in time.

It includes:

  • Assets
  • Liabilities
  • Equity

The Balance Sheet must always satisfy:

Assets = Liabilities + Equity

Cash Flow Statement

Tracks how cash moves through the business.

Cash flows are classified into:

  • Operating Activities
  • Investing Activities
  • Financing Activities

Cash is ultimately what sustains a business.

Everything Is Connected

The three financial statements are not independent.

A change in one statement often affects the others.

For example:

Increase Revenue

↓

Higher Net Income

↓

Higher Retained Earnings

↓

Higher Equity

↓

Higher Cash (if collected)

Understanding these relationships is one of the most important skills in financial modelling.

Assumptions Drive Every Model

Financial models are built on assumptions.

Examples include:

  • Revenue growth
  • Gross margin
  • Operating expenses
  • Capital expenditure
  • Working capital
  • Tax rates
  • Interest rates

These assumptions determine future financial performance.

Changing assumptions changes the entire model.

A model is only as credible as the assumptions that support it.

Inputs, Calculations and Outputs

Professional financial models separate information into three layers.

Inputs

Information entered by the user.

Examples:

  • Historical financials
  • Growth assumptions
  • Margin assumptions
  • Discount rate

Calculations

The logic that transforms inputs into forecasts.

Examples include:

  • Revenue forecasts
  • Depreciation schedules
  • Debt schedules
  • Cash flow calculations

Outputs

The information decision-makers use.

Examples include:

  • Financial statements
  • Valuation
  • Charts
  • Ratios
  • Investment recommendations

Separating inputs, calculations and outputs improves transparency and reduces errors.

Good Models Are Easy to Understand

Professional models should be:

  • Logical
  • Consistent
  • Transparent
  • Flexible
  • Easy to audit

Complexity does not make a better model.

Clarity does.

A model should be understandable by someone other than its creator.

The Importance of Model Integrity

Professional financial models must be reliable.

Good models include:

  • Balance checks
  • Error flags
  • Consistency checks
  • Clear assumptions
  • Documented calculations

Building confidence in the model is just as important as producing outputs.

Financial Modelling is an Iterative Process

Financial modelling is rarely linear.

Professionals continuously refine assumptions as new information becomes available.

The process typically follows this cycle.

Understand the Business

↓

Collect Historical Data

↓

Build Assumptions

↓

Forecast Financial Statements

↓

Validate Results

↓

Refine Assumptions

↓

Repeat

Models improve through iteration.

Where AI Fits Into Financial Modelling

Artificial Intelligence does not replace financial modelling.

Instead, it enhances the modelling process.

AI can assist with:

  • Summarising annual reports
  • Identifying business drivers
  • Generating forecasting assumptions
  • Explaining accounting concepts
  • Reviewing formulas
  • Detecting inconsistencies
  • Drafting investment memos

However, finance professionals remain responsible for validating assumptions, checking calculations and exercising professional judgement.

AI accelerates modelling.

It does not replace critical thinking.

Financial Modelling in the AI Finance Lab

Throughout the AI Finance Lab, financial modelling will follow the same structured workflow.

Understand the Business

↓

Read the Annual Report

↓

Analyse Historical Financial Statements

↓

Develop Assumptions

↓

Build the Financial Model

↓

Value the Business

↓

Interpret the Results

↓

Communicate Insights

This mirrors the workflow used by finance professionals in investment banking, private equity, equity research and corporate finance.

Key Takeaways

  • Financial models represent how businesses operate.
  • Models transform historical data into forward-looking insights.
  • Every model is driven by assumptions.
  • The Income Statement, Balance Sheet and Cash Flow Statement are interconnected.
  • Good models are transparent, flexible and easy to audit.
  • AI enhances financial modelling but does not replace professional judgement.

Try It Yourself — Breville Case Study

Open the Breville FY2025 Annual Report included in this repository under the Case Studies > Breville Group section.

Before creating the financial model, study the annual report and answer:

  • How does Breville make money?
  • What are its key revenue drivers?
  • Which costs appear most significant?
  • What factors could influence future growth?
  • Which financial metrics deserve the most attention?

Only after understanding the business should you explore the mechanics of the completed three-statement model.

Goal: Learn to model the business—not just the spreadsheet.

Next Steps

Continue to Learn DCF Mechanics, where you will explore how future cash flows are converted into an estimate of enterprise value using the Discounted Cash Flow (DCF) valuation methodology.