تفاصيل الدورة
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
نبذة عن معهد Qatar Finance & Business Academy
Qatar has taken significant steps towards creating a modern, knowledge-based economy, as the basis for a stable and sustainable future.
In order to live up to this revelation, We_They was established in 2009 under the auspices of Qatar Financial Centre Authority - QFCA to raise the financial services industry standards and help organizations and professionals achieve their learning and business objectives, thus aligned with Qatar 2030 vision.
We specialize in providing training and developing the financial sector. We believe that such an investment is a key strategy to support a modern, industrialized, knowledge-based economy.
عرض الجميع دورات Qatar Finance & Business Academy- Chief Financial Officer (CFO) Diploma City of London College of Economics1,089 ريال قطريمدة الدورة التدريبية: Upto 9 Months
- Accounting & Budgeting Inspire London College82 ريال قطري
619 ريال قطريمدة الدورة التدريبية: Upto 1 Week
