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.
Prerequisite(s)
• Delegates should be familiar with Microsoft Excel (though not necessarily expert in the use thereof, as any relevant Excel function pertinent to an exercise will be discussed prior to tackling the exercise).
• Excel knowledge required:
1. Basic Excel skills
a. Opening and closing files
b. Moving around the spreadsheet
c. Inserting and deleting rows and columns
d. Inserting text and formulas
e. Deleting cells
f. Copying formulas
g .Printing
2. Basic formulas (+-*/) e.g. =C5+C7+sum (C9:C12), and =D5*D6/12
3. Formatting.
Outcomes
On completion of this practical, hands-on training course, delegates will:
• Be able to build well-structured, flexible project financial models.
• Be able to apply many of the advanced functions and techniques available in Excel.
• Understand, create, and use scenarios, data tables, sensitivity tables, goal-seeking, etc.
• Be able to apply what they've learnt in the calculation of Wacc, NPV, IRR, loans, free cashflow and break-even points
• Have at their fingertips a comprehensive reference manual and worked examples relating to the building of project financial models.
Time: 08:00 - 16:30
Venue: 4th Floor North Block, Hyde Park Corner, Jan Smuts Ave, Johannesburg, 2196, Johannesburg
More info:
4th Floor North Block, Hyde Park Corner, Jan Smuts Ave, Johannesburg, 2196
