INTRODUCTION TO FINANCIAL MODELLING

Duration: 2 Days

This course, which we are currently only offering as a private in-house course, is aimed at potential users, developers and reviewers of financial models who wish to improve their modelling capabilities. This two-day course explores the latest financial modelling concepts and guides participants through the end-to-end development of a fully integrated financial model adopting best practice modelling methodology.

The Modular Build-up approach focuses on incrementally building a financial model which results in a clear and transparent model which is easy to understand and manage.

Key topics covered on this course

  • Model setup (sections, worksheets, internal checks etc.)
  • Inputs, scenario manager and running scenarios
  • Dates and flags
  • Escalation
  • Setting up financial statements with opening balances
  • Revenue and operational expenditure drivers
  • Working capital
  • Capital expenditure and depreciation
  • Introduction to debt
  • Introduction to corporate tax
  • Equity and distributions
  • Introduction to valuation methodologies (NPV and IRR)

This course is right for you if you have:

  • General familiarity with Excel in a financial environment
  • Knowledge of basic Excel functions
  • Basic understanding of accounting and finance fundamentals

You don’t need to know:

  • VBA
  • Advanced Excel functions

Ask about training

Other courses coming soon

  • VBA for Project Finance
  • Introduction to Excel
  • Model Review and Audit
“

Really enjoyed the course, excellent trainer, would recommend to others.

“

Webster was a wonderful teacher and was apt and eager to answer all our questions.

“

Webster was a great course instructor and very helpful in every aspect. The course definitely builds confidence in excel and financial modelling and provides you with what you might need when creating your own.

Why choose a JPA course?

  • This is a practical course – get ready to roll up your sleeves and start building a sophisticated integrated 3-way financial model
  • Our presenters are experienced financial modellers who have worked on some of Australia’s biggest infrastructure and M&A transactions
  • Class sizes are limited to maximise your time with the presenters
  • We use real world examples based on our day to day client work, not academic theory