This self-paced course teaches you how to build a fully integrated corporate financial model from scratch using structured Excel techniques and internationally recognized best practices. You’ll work through a detailed case study—AfyaLink, a healthcare business—modeling revenue, costs, financing, working capital, equity, valuation, and dashboards. 


By the end of the course, you'll be able to:
 

  • Design clear, auditable models aligned with the FAST Standard 

  • Build three-statement models with supporting schedules 

  • Run valuations using DCF and multiples approaches 

  • Present insights through dashboards and scenario analysis 

 

1. Revenue Modelling 

  • Consultation Revenue 

  • Laboratory Revenue 

  • Pharmacy Revenue 

  • Inpatient Boarding Revenue 

  • Short Stay 

  • Long Stay 

  • Radiology Revenue 

  • Simple Procedures 

  • Complex Procedures 

 

2. Direct Costs (Cost of Sales) 

  • Understanding Direct Costs: Material, Labour, Overhead 

  • Consultation Cost 

  • Laboratory Cost 

  • Pharmacy Cost 

  • Inpatient Boarding Cost 

  • Radiology Cost 

 

3. Operating Expenses 

  • Commonsizing and Trend Analysis 

  • Conditional Formatting for Cost Insights 

  • Salaries & Wages 

  • Senior Management 

  • Medical Staff 

  • Support Staff 

  • Other Staff Costs 

  • Legal Fees 

  • Rent & Rates 

  • Repairs & Maintenance 

  • Insurance 

  • Licenses & Accreditation 

 

4. Depreciation & Amortisation 

  • Overview of Depreciation & Amortisation Theory 

  • Building Calculation Blocks for Asset Classes 

  • Medical Equipment 

  • Motor Vehicles 

  • Fixtures & Fittings 

  • Intangible Assets 

  • Outpatient Centers 

  • Linking to Financial Statements: 

  • Profit & Loss 

  • Balance Sheet 

  • Cash Flow 

 

5. Financing Costs 

  • Interest Expense Modelling 

  • Loan Balances and Schedules 

  • Principal Repayment Flows 

 

6. Taxation 

  • Forecasting Tax Expense 

  • Modelling Tax Paid and Deferred Tax 

 

7. Working Capital 

  • Trade Debtors 

  • Inventory 

  • Trade Creditors 

  • Working Capital Adjustments in Cash Flow 

 

8. Equity 

  • Equity Movements 

  • Retained Earnings 

  • Dividends 

  • Retained Cash Flow Analysis 

 

9. Ratio Analysis 

  • Profitability Ratios 

  • Liquidity Ratios 

  • Leverage Ratios 

  • Return Ratios 

  • Growth Ratios 

 

10. Valuation 

  • EV/EBITDA and EV/Sales Multiples 

  • Cost of Capital and Discount Factor 

  • Discounted Cash Flow (DCF) 

  • Net Asset Value Approach 

  • Weighted Equity Value Calculation 

 

11. Scenario & Sensitivity Analysis 

  • Setting Up Scenarios 

  • Sensitivity Tables 

  • Interactive Dashboards 

  • Graphical Outputs for Presentation 

 

12. Output Sheets 

  • Income Statement (SCI) 

  • Balance Sheet (SFP) 

  • Cash Flow Statement (SCFA) 

  • Executive Dashboards with KPIs 

 

Resources and Learning Approach 

  • Excel-based lessons with real-time demonstrations 

  • Practice using the AfyaLink case study 

  • Assignments and checks for understanding after each module 

 

Certification 

Learners who complete all modules and assessments will receive a Certificate of Completion. 
For those seeking formal FAST accreditation, a separate FAST Financial Modeller Exam is available. 


This is a free introductory course into FAST financial modelling

Objective

 At the end of the course the beginners will be able to:

  • Have the confidence to design and build a model from scratch
  • Understand and apply modelling best practice based on the FAST financial modelling standards
  • Understand important Excel functions and use them to build the foundations of a robust, reliable and flexible financial model
  • Review and validate all types of financial models.


Prerequisites

The key prerequisites are a fair MS Excel knowledge which will ensure a quality learning experience for all participants. This is not intended to be a basic Excel course.


Course Outline

The courses are based around a corporate finance case study where participants are required to value a company and compute key ratios. The course teaches participantsthe building blocks for successful financial modelling: 

  • Using the FAST Standard for financial modelling 
  • Understanding the accounting, tax, and finance issues
  • Forecasting operating financial model variables
  • Planning the model 
  • Building the model in a structured manner and building in flexibility

The case is launched immediately after the introduction, and is used to illustrate, reinforce and test all of the principles and methods taught.

Objective

At the end of the course the beginners will be able to:

  • Have the confidence to design and build a model from scratch
  • Understandand apply modelling best practice based on the FASTfinancial modelling standards
  • Understand important Excel functions and use them to build the foundations of a robust, reliable and flexible financial model
  • Review and validate all types of financial models

Prerequisite

The key prerequisites are a fair MS Excel knowledge which will ensure a quality learning experience for all participants. This is NOT intended to be a basic Excel course.

Course Outline

The courses are based around a project finance case study where participants are required to value a company and compute key ratios. The course teaches participants the building blocksfor successful financial modelling:

  • Using the FAST standard for financial modelling
  • Understandingtheaccounting,taxandfinanceissues
  • Forecasting operating financial model variables
  • Planning the model
  • Building the model in a structured manner and building in flexibility.

The case study is launched immediately after the introduction and is used to illustrate, reinforce and test all the principles and methods taught.