Financial Modeling for Project Finance Somerset West Bay Doha, Doha

Course details

This course will help candidates develop knowledge and understanding of the five golden rules of financial modelling for project finance. While every project will have unique features, and each spread sheet 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 modelling process is quicker and easier for the modeller, and the model is as flexible, robust and comprehensible as possible.

Objectives

Upon the completion of this course the participant will be able to:

• Create models for project finance that are flexible, robust and comprehensible following the five golden rules of financial modelling for project finance
• Know when to break the golden rules lawfully

Target Audience

• Anyone involves in project finance, where everyone’s financial security is dependent on the future performance of a new undertaking

Course Structure

• The course is conducted using a combination of lectures, discussions and practical workshop sessions

Content Highlights

• 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 maximize flexibility
• Timescale
• 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
• Profit and loss, returns and cover factors
• Cash flows and cash balances
• Debugging, checking and presenting, sample data, examples and exercises

Modules:

• Module 1: Introduction & Course Objectives
• Module 2: Overall Model Structure
• Module 3: Inputs & Assumptions
• Module 4: Revenue & Cost Build-Ups
• Module 5: Taxes
• Module 6: Interest and Fee Calculations
• Module 7: Financing Section
• Module 8: Modelling Multiple Drawdowns
• Module 9: Multi-Currency Modelling
• Module 10: Inflation/Escalation Factors
• Module 11: Creation of Balance Sheet
• Module 12: Derivation of Ratios
• Module 13: Comparing Actuals to Previously Modelled Results
• Module 14: Sensitivity Analysis
• Module 15: Risk Reviews
• Module 16: Documenting the Model