Compare courses

Macquarie Graduate School of Management

Available dates

Dec 2—3, 2019
2 days
Sydney, Australia
AUD 3600 ≈USD 2456
AUD 1800 per day


Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with Macquarie Graduate School of Management.

Full disclaimer.

About the course

A hands-on boot camp 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.

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

Program outcomes

This program equips you with an understanding of financial statements and their significance. You will gain the practical skills to analyse the statements and create your own Excel-based models to reveal insights about your organisation’s future.

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

What you'll learn

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

Who should attend

This program is designed for:

  • accountants
  • business planners
  • commercial lawyers
  • corporate development staff
  • engineers
  • equity analysts
  • research analysts
  • technical staff moving into managerial roles.

Trust the experts

James Hay

James Hay has over 30 years’ experience as a corporate treasury executive, financial analyst and executive trainer. He has worked in risk management, corporate finance and evaluation in the Australian resources sector, and presented over 200 seminars and courses on financial skills, economic mode...


Course reviews

Downloadable files