Financial Modelling offers a practical approach to creating models to underpin sound business decisions.

Challenges for Finance Professionals:

  • Creating models that are transparent, coherent and easily understood
  • Turning scenarios into useful financial models
  • Making sure projections and predictions are sensible and well justified
  • Providing model insights to aid management decision-making
  • Keeping models accurate and reliable as they are revised and expanded

About This Course

Riverstone’s Financial Modelling course offers rigorous training in the use and development of financial models for finance professionals. Participants learn about model design and structure, model presentation, building integrated financial statements and creating scenario and sensitivity analysis. The course includes practical exercises that simulate actual modelling problems, gaining confidence and discipline in model-building. At the end of this course participants will have the skills to develop clear, auditable models which enable quality analysis and decision-making across the organisation.

Business Benefits

  • Provide higher quality financial analysis throughout the organisation
  • Minimise mistakes and enhance trust in forecasts and business cases
  • Provide quicker and better decision-making from clear model outputs
  • Establish a common financial modelling best practice within a finance organisation

Objectives

  • Learn the concepts of financial modelling and structure
  • Design and build up integrated financial modelling
  • Create scenario, sensitivity and what-if analyses in a model
  • Use best-practice format and audit trails to enhance user-friendliness
  • Effectively present model results to finance and non-finance users

Course Content

Module – 1

Setting up a financial model and building projections

  • Overview of best industry practices for financial modeling
  • Importance of historical information
  • Analysis of company and industry information
  • Steps for creating financial models
  • Proper presentation of various sheets and setting up the model input dashboard

 

Module – 2

Preparation of Income statement, cash flow statements and balance sheet

  • Analysis of industry assumptions and their rationale for revenues & costs, assets and liabilities’ assumptions – operating cost, capex, leverage, modeling of historical ratios and trends
  • Shortlisting assumptions and applying adjustments
  • Applying various forecasting tools, etc

 

Module – 3

Importance of key schedules and their application

  • Working capital schedule
  • Fixed assets and depreciation
  • Schedule of amortization of intangible assets
  • Preparation of debt and interest
  • Taxation
  • Equity fundraising
  • Equity gap and funding

 

Module – 4

How to create working capital schedule

  • Components of cash and non-cash working capital
  • Working capital ratios and their interpretation
  • Forecasting working capital requirements

 

Module – 5

How to create Capex and funding schedules including multiple debts

  • Equity and debt fund raising and repayment structure
  • Debt waterfall mechanism
  • Checking debt repayment ratios, leverage, and covenants

 

Module – 6

Integration of income statement, balance sheet, and cash flow statement

  • Industry practices on handling exceptions integration of Cash Flows, Income Statement and Balance Sheet
  • How to handle Circular References in financial modeling

 

Module – 7

Establish scenario and sensitivity analysis

  • Use of data for sensitivity analysis
  • Importance of scenario manager
  • Identifying suitable scenarios and sensitivities and their impact on financial analysis
  • Managing critical pitfalls in the analysis

 

Module – 8

How to analyze the data

  • Data sorting and Data filtering
  • Creating, customizing Pivots Tables, advanced pivot tables, and analysis
  • V-LOOK UP and H-LOOK UP, Macros, and other analysis

 

Module – 9

How to apply different financial analysis techniques on the model

  • Importance of PV, NPV, and IRR and their link with company valuation
  • How to analysis various capital budgeting decisions
  • Calculation of multiple ratios
  • Calculate the weighted average cost of capital using capital asset pricing model (CAPM)
  • Calculation of WACC
  • Investment and exit analysis – equity IRR, project IRR, etc

 

Module – 10

Approaches to applying different valuation techniques in the model

  • Various methods of valuation – DCF, Multiples, comparables, etc
  • Discounted Cash Flow valuation and different multiples based methodologies
  • Importance of terminal valuation
  • Current industry practices followed in company valuation using single or multiple methods
  • Incorporate various adjustments to the publicly available versions of Company valuation

Course Delivery

This course is available as a public course at various locations across Australia, in-house program delivered at your office, or eLearning module. Program duration and delivery can be customised to suit your team’s requirements.

Dates

  • Monday, September 7, 2026.
  • Monday, December 14, 2026