Personal tools
  • Log in    Register   
You are here: Home → Training → Finance, Valuation, Risk & Modelling → Financial Modelling Masterclass
 
Financial Modelling Masterclass

Financial Modelling Masterclass

A comprehensive 4 day introduction to building a range of models for analysts, finance specialists & managers across all industry sectors – harnessing Excel to structure, examine, evaluate & improve financial & investment decision making

On-Site & Customised Training
Brochure PDF

Course Objectives

Key Learning Outcomes

> Key elements of best practice model design
> How to audit models effectively
> How to design a model to suit your purpose, maximising flexibility and reliability
> Valuation modelling using conventional and new approaches
> Accurate forecasting of corporate cashflows
> Identify and control key sensitivities and scenarios
> How to build advanced techniques and risk into your models to improve decision making
> Practical tips for checking and debugging the model

  

In partnership with

IFF


VALUE ADD
A CD-ROM is supplied containing numerous files/worksheets that illustrate the approach to frequently encountered problem-solving tasks

What Participants Liked & Learnt

"Very practical, excellent insights into corporate finance, extremely knowledgeable and willing to help"
Market Analyst, Rio Tinto

"Richard was a very entertaining presenter with a really good understanding of finance in practice. I now feel I have a solid understanding of mid level Excel upon which to develop further detailed Excel understandinge"
Deal Execution, Babcock and Brown

About the Course

The course involves an initial half day updating and refreshing participants on advanced Excel and general Excel issues relating to model building and model optimisation.

First part of the course involves actually developing/building a model/ worksheet in a problem solving context, examining all possible aspects affecting model design and optimisation.

These practical sessions are supported by detailed step-by-step notes, including screen grabs, so that the exercises can be repeated or revisited at a time subsequent to the course.

There will also be sessions to help develop a robust understanding of model excellence, including an examination of:

  • best practice
  • procedure upon receiving a foreign model
  • planning and designing the model
  • particular issues associated with highly-stressed financings.

The next phase of the course examines and illustrates the modelling approach for a number of specialised contexts, such as LBOs, MBOs, mergers, venture capital and comparative pricing
.
Also the recommended approach to rates of return calculations, depreciation, interest calculations without circularities, cash sweeps, currency exposures etc. will be applied to these model types.

Laptops are required

Course Level
Delegates must be familiar with the basic principles of financial modelling, and the extensive use of Excel. If you require further information to determine whether you are at the correct level to attend the course please email edinfo@iir.com.au

Who Should Attend

The course would be ideal for those who use Excel as a tool in financial decision making. Including corporate executives, business, commercial, financial analysts, bankers, credit analysts, investment analysts, and management consultants.

Online Media Partner

Goint to Meet

 

Document Actions
 
  • © Informa 2008