Financial Modeling for Project Finance Qatar Finance & Business Academy
Price: AED 6,052

    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
    Updated on 08 November, 2015

    About 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.

    See all Qatar Finance & Business Academy courses
    Are you from Qatar Finance & Business Academy ? Claim your course!
    Courses you can instantly connect with... Do an online course on Finance starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or