Hotline 0703 824 3668 Chat on WhatsAppSuite 2011/2020, Anbeez Plaza, Wuse Zone 5, Abuja
DMC Business School

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
₦70,000
Enrol now
  • 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
  1. Part A · Purposes of a model: budget, forecast, feasibility, valuation and fundraising
  2. Part B · Modelling standards: separation of inputs, calculations and outputs; consistency and transparency
Video 2 · Model Architecture and Layout2 lessons
  1. Part A · Designing the workbook: cover, assumptions, workings, statements and outputs
  2. Part B · Timelines, flags, and formatting conventions that make review possible
Video 3 · Excel Skills for Modellers3 lessons
  1. Part A · Absolute and relative referencing, named ranges and consistent row formulas
  2. Part B · Lookup, date, and logical functions used in models
  3. Part C · Circularity, iterative calculation and how to avoid needing them
Video 4 · Revenue and Cost Drivers3 lessons
  1. Part A · Building revenue from volume and price drivers
  2. Part B · Cost structure: variable, fixed and step costs
  3. Part C · Capital expenditure and the depreciation schedule
Video 5 · The Integrated Model: Profit or Loss2 lessons
  1. Part A · Constructing the forecast profit or loss from the driver sheets
  2. Part B · Tax, and the treatment of losses carried forward
Video 6 · Balance Sheet and Cash Flow Linkage3 lessons
  1. Part A · Linking the three statements so the balance sheet balances
  2. Part B · The cash flow statement inside a model
  3. Part C · Finding and fixing a balance sheet that does not balance
Video 7 · Working Capital, Debt and Interest3 lessons
  1. Part A · Working capital assumptions and the working capital schedule
  2. Part B · Debt schedules, repayment profiles and covenants
  3. Part C · Interest, the revolver and cash sweep
Video 8 · Scenario and Sensitivity Analysis3 lessons
  1. Part A · Scenario switches and the scenario manager
  2. Part B · One-way and two-way data tables
  3. Part C · Presenting sensitivity results to a decision maker
Video 9 · Valuation3 lessons
  1. Part A · Discounted cash flow: free cash flow, discount rate and terminal value
  2. Part B · NPV, IRR, payback and profitability index
  3. Part C · Relative valuation using multiples and comparable transactions
Video 10 · Model Review, Auditing and Presenting Outputs2 lessons
  1. Part A · Reviewing someone else’s model: tracing, error checks and reasonableness tests
  2. 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.

DMC Business SchoolYour pathway to professional exam success and practical business skillsICAN · ATSWA · CITN exam preparationLearn from chartered accountantsStudy at your own pace on any deviceIn partnership with Topnotch Learning Centre