Accounting Skills · Online course
Financial Modelling
Accountants building forecasts, budgets, feasibility studies and valuations.
- Self-paced, on demand
- 6 months access
- 26 lessons
- Certificate on completion
- 6 months from confirmed payment
- Study on your phone, tablet or computer
- Certificate when you complete the course
Secure online payment. Your login link arrives by email as soon as payment is confirmed. 48-hour refund policy
Course content
10 modules · 26 lessons
Video 1 · What a Financial Model Is and Modelling Discipline2 lessons
- Part A · Purposes of a model: budget, forecast, feasibility, valuation and fundraising
- Part B · Modelling standards: separation of inputs, calculations and outputs; consistency and transparency
Video 2 · Model Architecture and Layout2 lessons
- Part A · Designing the workbook: cover, assumptions, workings, statements and outputs
- Part B · Timelines, flags, and formatting conventions that make review possible
Video 3 · Excel Skills for Modellers3 lessons
- Part A · Absolute and relative referencing, named ranges and consistent row formulas
- Part B · Lookup, date, and logical functions used in models
- Part C · Circularity, iterative calculation and how to avoid needing them
Video 4 · Revenue and Cost Drivers3 lessons
- Part A · Building revenue from volume and price drivers
- Part B · Cost structure: variable, fixed and step costs
- Part C · Capital expenditure and the depreciation schedule
Video 5 · The Integrated Model: Profit or Loss2 lessons
- Part A · Constructing the forecast profit or loss from the driver sheets
- Part B · Tax, and the treatment of losses carried forward
Video 6 · Balance Sheet and Cash Flow Linkage3 lessons
- Part A · Linking the three statements so the balance sheet balances
- Part B · The cash flow statement inside a model
- Part C · Finding and fixing a balance sheet that does not balance
Video 7 · Working Capital, Debt and Interest3 lessons
- Part A · Working capital assumptions and the working capital schedule
- Part B · Debt schedules, repayment profiles and covenants
- Part C · Interest, the revolver and cash sweep
Video 8 · Scenario and Sensitivity Analysis3 lessons
- Part A · Scenario switches and the scenario manager
- Part B · One-way and two-way data tables
- Part C · Presenting sensitivity results to a decision maker
Video 9 · Valuation3 lessons
- Part A · Discounted cash flow: free cash flow, discount rate and terminal value
- Part B · NPV, IRR, payback and profitability index
- Part C · Relative valuation using multiples and comparable transactions
Video 10 · Model Review, Auditing and Presenting Outputs2 lessons
- Part A · Reviewing someone else’s model: tracing, error checks and reasonableness tests
- Part B · Output sheets, charts and the model summary a client actually reads
Who this is for
Practitioners, students and business owners who want practical skills they can use straight away.
48-hour refund window
Apply within 48 hours of payment if you have watched no more than 10% of any video and have not downloaded course materials. Read the refund policy
Before you enrol
How do I get access?
Pay securely online. As soon as your payment is confirmed, we email you a link to set your password and start learning. Existing learners can sign in with their account.
How long can I study?
6 months from confirmed payment
Will I receive a certificate?
A certificate is available only for courses marked as certificate-bearing, after their completion requirements are met. Professional-exam courses do not issue certificates.
What if I need help or a refund?
Contact support for course or payment questions. Refund eligibility depends on the payment and your learning activity; review the refund policy before paying.

