Master the fundamentals of modelling with expert instruction and course content made with and for global banks and financial institutions, renewable energy providers and leading infrastructure firms.

This course will teach you how to construct a model to perform a discounted cash flow analysis for the investment decision and explore the relevant sensitivities. 

You will learn an overall approach to building models and several fundamental techniques and concepts that will prove invaluable in future modelling assignments.

This course is designed to help you:

• Develop and build flexible and robust financial models
• Build integrated financial statements
• Understand and use NPV, IRR and debt cover ratio techniques
• Use audit checks and tests throughout the model development process
• Understand and test model dynamics and performance
• Simplify formulas using logical masks, switches and counters

NOTE: If you are using Microsoft Excel 365, you will need to precede any named range in a formula by a ‘@’ unless told otherwise.

Excel 365 introduced the concept of ‘dynamic array formulas’ where every range is now an array by default and so, when using named ranges, Excel 365 will always look at the entire range as a ‘whole’ instead of ‘individual’ cells. If the goal is to, let’s say, sum an entire named range then no ‘@’ is needed as the intention is Excel to look at the entire range instead of the intersected cell.