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 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.