This workshop focusses on the underlying mathematics techniques which underpin project finance, energy, leasing and other analysis models. Rather than using a financial calculator such as an HP12C, the workshop demonstrates how to apply financial mathematics to Excel effectively.
Starting with a review of model design, the workshop introduces present and future values and shows how these basic concepts can be used to solve a range of financial mathematics problems. The workshop ranges over complex cash flows, depreciation, structured amortisation, fixed income, derivatives and data analysis.
The workshop is highly practical and each session begins with a discussion of each technique followed by practical exercises. At the end of the workshop, delegates will understand how to apply financial mathematics to Excel spreadsheets.
The programme is taught using formal lectures combined with practical and interactive case studies and exercises to reinforce the concepts covered in each teaching session. Emphasis is placed on delegates gaining practical, hands-on experience of building financial models in Excel.
Comprehensive product notes and modelling software will be provided for future reference. Delegates receive a full pack of Excel software and templates for future reference as part of the course materials.
This is a course for analysts and practitioners who want to use Excel as a tool to assist with the decision making process. Senior financial professionals using Excel spreadsheets who should attend include:
Delegates will be expected to have finance knowledge and a working knowledge of Excel, including:
Exercise: reconstructing a model
Exercise: calculating payments and amortisation for structured loans
Exercise: constructing and valuing a complex cash flow with multiple rates
Exercise: depreciating assets and comparing results
Exercise: modelling bond risks
Exercise: constructing a binomial and a Black Scholes model
Exercise: reviewing a dataset and presenting conclusions