Alt Text

Get in touch

Would you like to discuss our training courses in more detail?
Call +61 2 8006 1728
or email us today.

Fundamentals of Financial Modelling and Valuations

This hands-on course covers all key aspects of financial modelling and valuations. You will build your skills with practical exercises and example files and will take away a comprehensive course book.This course has been designed for investment analysts in banking, funds or corporate business. If you develop cashflow and valuations models for investment decisions and transactions, we can help you develop more effective and robust models, in less time and with greater accuracy and transparency.

Who should attend?

  • Financial, transaction and investment analysts
  • Investment bankers
  • Project finance professionals
  • Corporate finance and valuation professionals
  • Finance managers and financial controllers
  • Commercial managers
  • Transaction advisers

Why would I choose this course?

  • Learn to develop financial models in a controlled, structured and transparent way
  • Learn and apply best-practice modelling principles and techniques
  • Develop models for project appraisal and investment decision making
  • Learn more about what Excel can do for you, as well as useful keyboard shortcuts
  • Flexibly model capital expenditure and construction debt
  • Learn how to robustly model debt and debt coverage ratios
  • Increase effectiveness and efficiency of models whilst reducing errors
  • Use a scenario manager and sensitivity analysis to understand risk

What skills do I need to do the course?

  • Intermediate Excel skills
  • An understanding of basic financial terminology (depreciation, capital expenditure, interest)
  • At least one–five years of relevant work experience

What will I learn from this course?

Learn how to apply a managed model development process:

  • Define the aims of a financial model
  • Incorporate stakeholders’ requirements into financial models
  • Find out why it is essential to follow a defined model development process
  • Understand the six stages of model development
  • Define model outputs and design a summary dashboard

Use best-practice standards in your financial models:

  • Find out what ‘best practice’ is and why it is important
  • Learn the 10 golden rules for best practice modelling

Learn professional and efficient model construction set-up:

  • Learn file management and naming conventions
  • Understand custom number and date formats, conditional formatting, and how to save styles
  • Modify the colour palette and integrate corporate colours
  • Develop a template sheet and timeline
  • Schedule events using timing flags
  • Integrate financial statements
  • Implement model checks

Develop and manage operations calculations:

  • Develop operations calculations, considerations and logic structure
  • Apply indexations and escalations
  • Model working capital and the cash flow implications
  • Use control accounts for accurate and efficient model construction

Create flexible CAPEX profiles:

  • Create flexible construction profiles, including the development of S-curves
  • Learn how to manage finances during construction
  • Analyse the impacts of delays, overspends and phasing changes
  • Understand how to model depreciation efficiently

Efficient modelling of debt facilities and ratios:

  • Refinance a construction debt facility
  • Model debt facilities – interest and multiple principal payment mechanisms
  • Model flexible timing, interest only periods, commitment fees
  • Understand the theory and modelling of debt coverage ratios (DCRs)
  • Understand modelling reserve accounts and lockups

Considerations and modelling for tax:

  • Understand the pitfalls and complexities of modelling tax
  • Handle timing differences using deferred tax assets and liabilities
  • Model carried-forward tax losses

Scenario and sensitivity development and management:

  • Learn how to develop a scenario manager
  • Define and run sensitivity tests
  • Use data tables to assist with multi-scenario and sensitivity presentation

Ensure quality, reduce errors and manage risk:

  • Learn quality control techniques, including final testing and peer review
  • Manage handover and issuing models to third parties
  • Learn about including disclaimers in models

Methodologies, techniques and application of valuation:

  • Receive an introduction to the CAPM model and assessment of business risks
  • Get an overview of corporate and assets valuation methodologies
  • Determine discounts rates and WACC
  • Use P/E, EV/EBITDA multiples for valuation and understand their benefits and drawbacks

Options for investment appraisal analysis and their application:

  • Calculate project and equity values, internal rates of return (IRR), yields and payback periods
  • Learn the Excel functions for investment analysis and the functions’ potential pitfalls

Organisations we have trained

Portfolio Image
Alinta Energy
Portfolio Image
Portfolio Image
Louis Dreyfus

In-house and group courses

We can deliver any of our courses anywhere in the world. We can either travel to you or host the course in the most convenient place for your team.

Why should you consider in-house training?

  • Customised content – we can tailor the agenda to suit your exact needs and even incorporate data from your business into the practical exercises.
  • Locally hosted – we travel to you and present either locally or at your premises, reducing the time you spend out of the office.
  • Group size – as in-house courses are often smaller groups, there is even more one-on-one time with the trainer.
  • Costs saving – an in-house course is delivered for a fixed fee regardless of the number attending, and you benefit from added savings on travel, accommodation and time.

The in-house option is ideal for teams of six or more. To talk about whether an in-house course is right for your business, please contact John Stroud on or +61 2 8006 1728.