Modelling Financial Statements

Macquarie Graduate School of Management

How long?

  • 2 days
  • in person

Macquarie Graduate School of Management

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.

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.

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

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...

Videos and materials

Reviews

Make sure this course is right for you.

Get unbiased reviews and personalized recommendations.

Modelling Financial Statements at Macquarie Graduate School of Management

From  2290 AUD$1,570

Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.