Financial Modelling

Financial Modelling

A hands-on course on forecasting, analysis and valuation

The key to the future of a business can be found in its financial statements. You will develop the skills needed to analyse these statements and understand the practical insights they offer.

Using the financial statements of real ASX-listed companies, you will gain hands-on experience with financial modelling using a proven analytical framework.

Want to talk to someone or need a brochure? Get started!

Key highlights

Learn from finance experts with decades of industry experience

Understand your organisation’s future by analysing its financial history

Develop practical financial modelling skills with hands-on learning

Enquire now

Download Brochure:

Digital badging available

Upcoming courses

DateModeDurationTimeLocationFee 
22 & 29 January, 5 & 12 February  Virtual Learning

19 hours over 4 weeks includes Live Workshops and Online Learning

10am - 12pm AEST

Online $1,290 (incl. GST)

Register now
* Early Bird Discount Applies

You will learn to:

  • Assess the applicability of project finance to an investment opportunity
  • Identify and recommend risk management strategies
  • Propose appropriate transactional structures
  • Identify probable funding sources and costs

Who should attend

  • Accountants
  • Business planners
  • Commercial lawyers
  • Corporate development staff
  • Engineers
  • Equity analysts
  • Research analysts
  • Technical staff moving into managerial roles

What you will learn

Face to Face

Day 1: Creating your model

  • The financial statements
    • Accounting principles
    • Accrual accounting and interrelationships
    • Industry examples
  • Setting up your model
    • Forecasting sales growth and costs
    • Building scenarios
    • Simplifying the published statements
  • Building your model
    • Getting the model to balance
    • Resolving the finance cost circularity

Day 2: Model analysis

  • Ensuring integrity through checks
    • Using your model for ratio analysis
    • Profitability, efficiency, leverage ratios
    • Market-based ratios
  • Using your model for valuation
    • Quick overview of finance theory and discounted cash flow
    • Extrapolating free cash flow
    • Determining enterprise value
    • Understanding the value of equity and share prices

Virtual Learning

Week 1

  • Overview of the financial statements
  • Navigation, fixing references, naming cells, creating lists
  • Shortcut keys and good modelling practice
  • Establishing time frame
  • Transposing and simplifying published financial statement ‘Actuals’

Week 2

  • Forecasting sales and costs
  • Forecasting approaches
  • Creating a balance check in the model
  • Modelling the Income Statement, Cash Flow Statement and Balance Sheet

Week 3

  • Building a Fixed Assets Schedule and modelling
  • Depreciation
  • Working Capital: Receivables, Payables and Inventory
  • Provisions, dividends, and tax

Week 4

  • The loan schedule and debt profile options
  • Managing finance costs and the circular reference
  • Using ratios for investment and credit analysis
  • What if’ analysis and scenarios
  • Using cash flow forecasts for valuation
  • Summary

How you will learn

Face to Face

Set in an interactive classroom environment, you will participate in discussion, sharing first hand experiences while gaining coaching from our expert facilitators.

Designed for experiential learning, our face to face courses provide the opportunity for you to collaborate and network with peers at our North Ryde and Sydney City Campuses.

Virtual Learning

Over the duration of your course, you will participate in online learning and live workshops utilising a custom built platform for your learning. You will also take part in e-learning independently and with your peers to embed learning.

Virtual workshop sessions bring a real-time, social learning environment, where you can share and learn from your peers and your expert facilitator with a limit of 20 participants per course.

Meet your facilitator

James Hay Modelling Financial Statements Finance Short Course Sydney Macquarie University

James Hay

James Hay

James has more than 30 years’ experience as a corporate treasury executive, financial analyst and executive trainer. James has held roles in risk management, corporate finance and project evaluation in the Australian resources sector.

More recently, he has established a corporate advisory and training business, providing investment appraisal and financial educational services to a range of corporate and institutional clients. Through his consulting business, he has presented more than 200 seminars and courses on financial skills, economic modelling and value-based management. Since 2006, he has been an adjunct fellow at the Macquarie Applied Finance Centre in Sydney where he teaches the Resources Industry Investment Analysis, and Financial Statement Analysis and Modelling units.

James holds a Bachelor of Science from Monash University in Applied Mathematics and Earth Science, a Master of Business Administration in Finance and Accounting from Cornell University (New York) and a Bachelor of Letters (Honours) and a PhD in Political Science from the University of Melbourne.

Find out more

P: +61 2 9850 9016
E: professional.education@
business.mq.edu.au

LinkedIn | YouTube

Macquarie University North Ryde campus

North Ryde campus
99 Talavera Road
Macquarie Park NSW 2113 

Macquarie University Sydney city campus at Angel Place

Sydney city campus
Level 24, 123 Pitt Street
Sydney NSW 2000

Enquire now

Back to the top of this page