This course aims to cover the applications and techniques that are most commonly required in general Excel modelling. Typical topics covered are modelling best practices, techniques to review and audit models, short-cuts and tips, and applications such as financial statement modelling, cash flow valuation, and project finance are also usually included. Relevant financial theory can be covered were appropriate (such as discounting and the CAPM for the valuation section).

Discussions of the available and appropriate alternatives can be included. For example, concerning financial statement models, we typically discuss the different possible approaches to reconcile and balance a cash flow statement with a balance sheet, ways to deal with circular references, the use of corkscrew structures, and modelling of deferred tax and loss carry-forwards). For cash flow valuation, we typically discuss a range of valuation methods (such as comparables, cash flow methods, derivative methods), before studying cash flow valuation in more detail. A discussion of various terminal value approaches, the discount rate, economic value added, as well as sensitivity analysis is included. The section on project finance covers core calculations commonly required in this area, as well as some of the challenges in implementing such models. By the end of the course, participants should be able to confidently build and interpret models in any of these areas.

Courses can be held over the internet or in-house at any location globally. Contact us to find out more.