This course will help candidates develop knowledge and understanding of the five golden rules of financial modeling for project finance. While every project will have unique features, and each spreadsheet packages its own special techniques, certain principles apply generally to the construction of project finance models. These principles are the main focus of this course. The course aim includes ensuring that the modeling process is quicker and easier for the modeler, and the model is as flexible, robust and comprehensible as possible.
On successful completion of this course, participants will be able to:
- Create models for project finance that are flexible, robust and comprehensible following the five golden rules of financial modeling for project finance
- Know when to break the golden rules lawfully
- The five golden rules of financial modelling
- Purposes and uses of a model
- Development over project life
- How to start and where to stop
- Design to maximise flexibility
- Consistent signs
- Currency treatment
- Circular and iterative calculations
- Control and identification of sensitivities
- Data, capital costs and finance costs
- Work lines, masks, factors and counters, operations, tariff and tax
- Statement of Comprehensive Income (Profit and Loss Account), returns and cover factors
- Cash flows and cash balances
- Debugging, checking and presenting, sample data, examples and exercises
Anyone involves in project finance, where everyone's financial security is dependent on the future performance of a new undertaking
Managerial Accounting 1: Introductory Managerial Accounting
Either:A Certificate, Diploma or Degree course showing that you have met the objectives of Managerial Accounting 1: Introductory Managerial Accounting (213) and Excel Basic (315)
Or: Work experience of at least six months in an organisation where you have personally been involved in performing work which meets all the intended learning outcomes stated in Managerial Accounting 1: Introductory Managerial Accounting (213) and Excel Basic (315).
Where the applicant does not have the prerequisites stated above, BIBF may require applicants to take and pass a pre-course assessment in order to be admitted to the course. Candidates are responsible for ensuring that they meet the pre-requisites before registering in courses.
The course is conducted using a combination of lectures, discussions and practical workshop sessions. Additional self-study hours of approximately 10 hours are also expected.
Note: This course is examinable
5 days (5 hours per day) with the exam on the final day
Fees: Member Organisations
Covered by levy
Fees: Non Member Organisations