Financial Modelling – a Practical Approach

The University of Auckland Business School

How long?

  • 1 day
  • online

What are the topics?

The University of Auckland Business School

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.

Who should attend

  • Corporate development specialists
  • Financial analysts
  • Asset and wealth managers
  • Equity research analysts
  • Management consultants
  • Chartered accountants
  • Corporate finance professionals

About the course

A comprehensive introduction to corporate financial modelling using Excel

Corporate financial modelling uses the financial statements of real New Zealand and Australian companies to develop an understanding of how to build corporate financial models. Market leading modelling methods and techniques are used throughout the programs to give the participants practical and pragmatic modelling skills.

Topics covered

Corporate financial modelling is designed for participants with a good working knowledge of Excel. It focuses on producing fully integrated three statement models and associated ratio analysis of a corporate company.

  • Time saving shortcuts and settings
  • Practical model design and construction
  • Financial statement linkages
  • Steps to modelling
  • Modelling without circular references
  • Modelling with circular references
  • Correcting errors in models

Outcomes

You will:

  • Increase your general Excel modelling skill and efficiency, learning lots of tips and tricks to enhance your day to day modelling
  • Be able to construct a fully functioning three statement model using a framework that works every time
  • Know how to build and model with or without circular references efficiently and safely
  • Correctly identify common errors that are made in corporate financial models, whether used for analysis for forecasting purposes
  • Take away some core modelling rules that you will be able to apply to any Excel model

Your organisation will:

  • Benefit from course participants’ increased ability to build corporate financial models in Excel, quickly and efficiently

Experts

Mary Farmer

Mary Farmer is an experienced finance, modelling and accountancy trainer with a background in investment banking and financial services. Since 2007, Mary has undertaken a variety of training roles, including undergraduate, graduate and professional exam training as well as financial training for...

Videos and materials

Financial Modelling – a Practical Approach at The University of Auckland Business School

From  1195 NZD$832

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.

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.