Financial modelling
Best-practice principles, model reviews, and designing and building a working financial model from scope to outputs.
The whole of financial modelling, built around the structure and the review discipline that carry the marks. Everything you need, nothing you don't.
$95 AUD. One-off payment when it launches. Instant download.
The pack for this subject is in production. Join the list and we will email you the day it launches.
Independent study notes for accounting certification candidates. Not affiliated with any professional body.
What this subject is really about
This is the most hands-on of the electives. You do not answer questions about models, you build one, to a standard someone else could open, trust and review. The subject teaches the discipline that separates a working model from a spreadsheet only its author understands.
It suits candidates in financial planning and analysis, corporate finance, valuation or advisory. The marks reward a model that is well structured, flexible and transparent, and an explanation a non-modeller can follow, so the notes are built as a build checklist and a review checklist rather than a wall of theory.
The four chapters, and what each covers
The subject moves from what a model is to how you review one, then how you design and build it. Here is the whole scope before you enrol.
Introduction to financial modelling
What a model is and where it is heading.
- Types of financial model
- Modelling tools
- The chartered accountant's role
- The future of modelling and technology
Best-practice principles
The structure good models share.
- What best practice means
- Model structure
- Microsoft Excel functionality
Model reviews
Catching errors before a stakeholder does.
- Why we review
- Types of review
- Excel tools that automate a review
Design and build a financial model
From a blank sheet to a finished, maintainable model.
- Design and scope
- Build
- Outputs
- How-to steps for common model types
- Model maintenance
The standards and structure you'll use
The subject teaches best-practice principles rather than one house style. Those principles line up with the recognised modelling standards, and the common thread is simple.
The separation every standard shares. Assumptions in one place, calculations in another, outputs pulling from both.
Flexible, appropriate, structured and transparent. A widely used set of rules for readable, reviewable models.
The Corality and Modano standards, and the ICAEW modelling code, all built on consistency and clarity.
The functions and features that support structure, from consistent formulas to named ranges and controls.
The Excel tools that automate parts of a review, plus checks that flag when a total does not tie.
Building a model so key assumptions can flex, and the outputs move with them.
These references reflect the subject as at the start of 2026. The subject teaches principles rather than mandating one standard, so read them as the common ground the profession shares.
How it's assessed
This subject has no invigilated exam. You build a working model and present it, in one submission with two parts, submitted together in the final week.
Written submission
Use case study data to scope, design and build a working model to best-practice standards. You are marked on the model itself.
Recorded presentation
Present and explain your model to an identified stakeholder, and communicate the insights it produces.
You build it
The whole subject is a build, so the pack is a build checklist, a review checklist and worked examples, not a timed paper.
The traps worth knowing before the assessment
These are the mistakes markers see most often in a built model. Structure and transparency earn the marks.
Mixing inputs into formulas. If a number can change, it is an input and it lives in one place, never hard-coded inside the maths.
Inconsistent row logic. A formula should read the same way across a row, so a reviewer can copy their eye along it and trust it.
Hard-coded numbers hiding in calculations. They are the single hardest error to find in a review, so keep them out from the start.
No checks. A model that cannot tell you when a balance does not balance will let an error reach the stakeholder.
Outputs that do new work. The summary a reader sees should pull from the calculations, not calculate anything itself.
A model only you can follow. The presentation marks reward a model a non-modeller can read, so build for the reviewer, not yourself.
The kind of question you'll face
A short scenario of the kind the subject uses, so you can see what a best-practice build looks like.
Ironbark Renewables Ltd is weighing a solar project and hands you the assumptions on cost, output, price and financing. It needs a three-statement model that lets the board flex the power price and the debt level and see the effect on returns. How do you structure the build?
Separating inputs, calculations and outputs, building consistent logic that flexes with the assumptions, and finishing with checks and a clear output the board can read without you in the room.
The worked example shows the structure, the checks and the output layout, so you can see how a model earns the marks before you build your own.
How to study it around a full-time job
The subject runs over a 7-week study period, six teaching weeks then the assessment. Here is a plan that fits it around work.
Principles first
What a model is and the best-practice principles. Get the inputs, calculations and outputs discipline into your hands early.
Reviews and design
How to review a model, then how to design and scope one before you build. Practise reviewing a broken model to train your eye.
Build and outputs
Build a small model end to end, add checks, and shape outputs a reader can use. Repeat until the structure is automatic.
Break it on purpose
Run your review checklist over your own model, then break something and confirm your checks catch it.
Build and present
Scope, design and build the assessment model, then rehearse the stakeholder walk-through until it is clear and short.
See what's in the pack
A real example of each part of the pack, not stock previews. This is the product doing the talking.
Plain English, assessment ready
The whole subject rewritten to be read fast. Here is the idea every standard shares, as it appears in the notes.
Inputs, calculations, outputs
Almost every best-practice standard reduces to one idea: keep inputs, calculations and outputs apart, and never mix them in a cell. Inputs are entered once and clearly flagged. Calculations read consistently across each row. Outputs pull from the calculations without doing any new work of their own.
The build checklist on one page
- One input, entered once, in one place
- Consistent formula logic left to right, top to bottom
- No hard-coded numbers inside calculations
- Outputs pull from calculations, they do not calculate
- Add checks that flag when a total does not tie
Built like the real thing
Worked builds that mirror the submission, each with the structure and checks laid out.
Common questions
Is it an exam or do I build a model?
You build a model. The assessment asks you to scope, design and build a working model from a case study, then present it. There is no invigilated exam.
Which modelling standard does it follow?
The subject teaches best-practice principles rather than mandating one standard. Those principles line up with FAST, SMART, BPM and the ICAEW code, and our notes teach the common ground between them.
Do I need advanced Excel?
You need to be comfortable in Excel and willing to apply structure. The subject covers the functionality it relies on, and our notes focus on the design decisions rather than obscure functions.
What do I need before I start?
Ethics and Business, or Ethics and Sustainability, is the prerequisite. The subject assumes some financial accounting, management accounting and information technology knowledge.
How much time should I budget?
The subject runs over a 7-week study period and expects about 95 hours in total, roughly 15 hours a week across six teaching weeks plus assessment.
Are these notes affiliated with the program?
No. Summo Notes is an independent study resource and is not affiliated with or endorsed by any professional body.
What is in the pack?
One full subject pack: condensed notes across the four chapters, A build checklist and a review checklist, worked model examples with structure and checks and guidance for the stakeholder presentation.
What does it cost?
$95 AUD when it launches, as a single one-off payment for the whole subject. There is no subscription and no per-chapter pricing.
Everything in one pack
One pack per subject. Notes, a build checklist, a review checklist and worked examples, together.
- +Condensed notes across the four chapters
- +A build checklist and a review checklist
- +Worked model examples with structure and checks
- +Guidance for the stakeholder presentation
One-off payment when it launches. Instant download.
The pack for this subject is in production. Join the list and we will email you the day it launches.
Be first to know when this pack lands
Join the list and we will email you the day the Financial modelling pack launches. No spam, one email.
Summo Notes is an independent study resource and is not affiliated with or endorsed by any professional body.