Financial modelling for project finance deals
This hands-on, practical course covers the essential principles of project finance and the fundamentals of financial modelling to ensure successful project finance deals.
Over the three days of the course we will discuss various aspects of project financial modelling using Excel Spreadsheet techniques, covering most of the useful features so far as they affect the everyday preparation of models.
Participants will pick up a number of useful tips and some interesting techniques to aid in their own endeavours.
The three days will be spent on demonstrating various techniques, interspersed with short hands-on exercises for certain of the more useful areas to reinforce the examples presented.
Participants will build a complete project model, from first principles, in various stages over the three days.
Who should attend
• All persons using Excel spreadsheets.
• All persons involved in the construction and use of financial models, including budgets, projections, evaluations, cash flows, projects, etc.
Content
• Structure of the course
• Installing the required add-ins
• Setting up the Quick access toolbar
• Exercise - customising your Quick access toolbar
• Some useful tips
• Protecting data in spreadsheets
• Naming cells, ranges and formulas
• Creating your own formats
• Creating conditional formats in Excel 2007
• Creating conditional formats in Excel 2003
• Exercises - Conditional formatting
• Validating data and producing drop-down lists
• Displaying messages using an IF statement
• Exercise - Logical tests (1)
• Exercise - Logical tests (2) - Nested Ifs
• Hyperlinks
• Extracting positive and negative balances
• Using the "Offset" function
• Date functions
• Effective and Nominal rates
• Average growth or inflation rate
Modelling
• Types of financial models
• Example of a deterministic model
• Steps in developing a financial model
• Structuring your model
• Model structure
• The integrity of the model
Time: 08:00 - 16:30
Venue: 4th Floor, North Block, Hyde Park Corner, Jan Smuts Avenue, Hyde Park, Johannesburg
More info:
4th Floor, North Wing, Hyde Park Shopping Centre, Jan Smuts Avenue, Hyde Park
