Overview
Most financial models in practice are built under pressure, by one person and never checked by anyone else. In high-stakes business environments, a spreadsheet with hidden assumptions, unverified formulas or hard-coded numbers presents a significant compliance and financial risk. A single error in a revenue projection or cash flow model can lead to inaccurate valuations, rejected loan applications or unlawful dividend distributions under section 4 of the Companies Act 71 of 2008.
As artificial intelligence and automated reporting tools become embedded in accounting workflows, the need for robust model design and rigorous verification is critical. Under the technology-related revisions to the IRBA and SAICA codes of professional conduct (effective 15 December 2024), accountants are required to determine whether relying on technology outputs is appropriate for the intended purpose. Furthermore, transferring client financial data into cloud models or public AI platforms triggers strict data protection obligations under sections 19 and 21 of the Protection of Personal Information Act 4 of 2013 (POPIA).
Join Nestene Botha CA(SA) on 10 December 2026 from 10h00 to 12h00 for a practical, step-by-step masterclass on building transparent, driver-based financial models and performing meaningful financial analysis.
Learning objectives
Attending this webinar will equip you with the following skills:
-
Structure financial models to keep inputs, calculations and outputs separate, making every assumption visible and audit-ready.
-
Build driver-based forecasts and evaluate sensitivity using dynamic scenario switches and break-even analysis.
-
Analyse performance using profitability, liquidity, efficiency and gearing ratios to extract actionable business insights.
-
Utilise Power Query, Power BI and simple VBA macros to streamline data cleaning, consolidation, and automated reporting.
-
Apply artificial intelligence safely to draft formulas, explain complex models and build scenario models while maintaining strict POPIA compliance and professional sign-off.
Content
The webinar will cover the following topics:
-
Model Design and Structure
-
Separating inputs, calculations and outputs
-
Building a clean assumptions sheet and consistent timeline
-
Standardising formulas across rows, Excel tables and named ranges
-
Documenting model architecture for seamless peer review
-
-
Advanced Excel Modeling Engine
-
Utilising XLOOKUP, SUMIFS, IF and IFERROR efficiently
-
Leveraging dynamic array formulas (FILTER, UNIQUE)
-
Implementing data validation and scenario switches with CHOOSE
-
-
Driver-Based Forecasting & Cash Flow Projections
-
Modeling driver-based revenue and cost behaviour (fixed vs variable)
-
Calculating working capital cycles (debtors, inventory, and creditors days)
-
Converting operational forecasts into robust cash flow projections
-
-
Scenario and Sensitivity Analysis
-
Setting up best, base and worst-case scenario switches
-
Applying Data Tables, Goal Seek and break-even calculations
-
Using simple regression techniques as a forecast sanity check
-
-
Financial Analysis & Performance Ratios
-
Calculating profitability, liquidity, efficiency and gearing ratios
-
Performing margin analysis and correcting weighted average misconceptions
-
Conducting budget versus actual variance analysis and trend analysis
-
-
Model Integrity, Error Checking & Compliance
-
Embedding control totals, balance checks and circular reference alerts
-
Identifying hard-coded numbers inside formulas
-
Applying technology governance rules under SAICA/IRBA codes and POPIA data security requirements
-
-
Power Query & Power BI Integration
-
Importing, cleaning, appending and merging external datasets
-
Building a simple data model and essential DAX measures (DIVIDE, CALCULATE)
-
Designing P&L dashboards and managing web publishing data-leak risks
-
-
Automation with VBA Macros
-
Recording, editing and refining routine automation macros
-
Automating data refresh and report formatting routines
-
Testing macros safely and knowing when formulas are preferable to VBA
-
-
Artificial Intelligence in Financial Modelling
-
Drafting Excel formulas, Power Query steps and VBA code using AI
-
Prompting AI to deconstruct and explain inherited legacy models
-
Conducting AI output verification, maintaining client confidentiality and exercising professional judgment
-
Obtaining your CPD certificate
This training is compliant with the International Education Standard (IES7) issued by the International Federation of Accountants and recognised for CPD by relevant professional bodies including ACCA, CIMA, IAC, IIA, SAICA and SAIPA.
All attendees are issued with a CPD certificate available in an online profile.
Who should attend?
The following persons will benefit from attending this webinar:
-
Practising accountants including: CA(SA), Professional Accountant (SA), AGA(SA), FCCA, BAP(SA), BA(SA) and ACCA.
-
Registered auditors.
-
Audit managers.
-
Trainee accountants.
Price
-
R 450.00 - Online admission - Individual.
-
Group Price 1 - From R337 per person (up to 5 users)
-
Group Price 2 - From R260 per person (up to 10 users)
-
Group Price 3 - From R224 per person (over 11 users)
Steps to register for the event:
If you already have a profile, login and register for the webinar.
If you don’t have a profile, create a free profile then login and register for the webinar.
Click here to create a free profile (There is no charge to create a profile and gain access to our free Monthly Practice Management Series).
Click here to find out about the Technical Resource Centre & CPD Subscription options.
Additional material
By attending this webinar you will be provided with:
-
A summarised slide presentation.
-
Reference documents and/or course material where available.
-
You can ask questions during the webinar and you will also have access to the presenter after the webinar.
Corporate training solutions
At the Accounting Academy, we recognize the evolving needs of businesses in today's dynamic environment. Beyond our standard webinar offerings, we provide tailored corporate training solutions designed to empower your team with the latest in accounting and professional skills. Whether you're looking for online sessions or face-to-face training, our programs are crafted to ensure a comprehensive and engaging learning experience.
Drawing inspiration from modern training methodologies, our corporate solutions are interactive, adaptable, and focused on real-world applications. We prioritize hands-on learning, ensuring your team can immediately apply their newfound knowledge in practical scenarios.
Interested in a bespoke corporate training experience? Reach out to us at corporate@accountingacademy.co.za or call 010 593 0466. Together, let's design a training program that elevates your team's capabilities and aligns with your organizational goals.
Contact us
Have any questions or need any assistance? Contact us today!
-
Online chat through our website.
-
WhatsApp: Start chatting (+27635026114)
-
Phone: 010 593 0466
-
E-mail: ticket@accountingacademy.co.za



