Next Step Academy (Pty) Ltd

FINANCIAL MODELLING AND ANALYSIS

NQF level 6 - 12 credits

Learn to construct predictive financial models in Excel to inform better capital and operational management and investment decisions.

THIS ACCREDITED TRAINING COURSE PROVIDES YOU WITH:

Easy access to our online material and case studies

We register you on our Agile platform with access to information, analysis and case studies

8 weeks intensive learning

Thirty 30-minute sessions allowing you to complete the training along your current responsibilities

Fast & Friendly Support

We're standing by to answer any general or theme-specific questions you may have. Professional support when you need it most.

COURSE CIRRICULUM

Over the duration of this online short course, you’ll work through the following modules:

Module 1: Using Financial Modelling Effectively
Explore the fundamental skills and best practices required to become proficient in Excel-based financial modelling.

Module 5: Sensitivity and Scenario Analysis
Discover the differing degrees to which varying inputs affect outputs in a model.

Module 2: Accounting Statements
Discover the various accounting statements, their purposes, and how they are related and interpreted.

Module 6: Financial analysis
Explore 21 key ratios for municipalities, benchmark different municipalities against each other.

Module 3: Building the Three Statement Model
Discover how to create a three statement model, comprising the balance sheet, income statement, and cash flow statement.

Module 7: Using Financial Models for Decision-Making in Business
Explore how financial models can be used in strategic business decisions around capital infrastructure development and financial sustainability.

Module 4: Forecasting the Three Statement Model
Explore the various ways of forecasting and extending the three statement model, which is driven by underlying business assumptions.

Module 8: Using Financial Models for Valuation
Discover how financial forecasts can be applied into a discounted cash flow valuation model.

COURSE FACILITATOR

 

Deon van der Westhuizen has been analyzing financial statements of local government for more than 2 decades.   He established MuniratingSA and Municipal monitor, and is a frequent speaker on international events on financial modelling and analysis.  As the technical expert at the University of Stellenbosch School for Public Leadership and as Anchor Faculty at Next Step Academy (Pty) Ltd, he provided technical training to more than 3000 students since 2010.  He is a long-term advisor to Municipal Councils and Municipal Managers on issues of financial sustainability.