Mastering Project Finance Models e-Learning

TBC Online any time £2,400.00 Download brochure Request a trial Add to basket

* Claim back your VAT
Find out more

* Claim back your VAT
Find out more

Overview

Mastering Project Finance Models is the most comprehensive e-learning financial modelling course in the market today. Leveraging adult learning principles, the power of multi-media and a structured building block approach, it offers a learning experience that provides a solid foundation in modelling skills for the project finance practitioner.

Screenshots:

 

Course Highlights

By the end of the course you will…

  • Have built a fully scoped Project Finance Model using Microsoft Excel
  • Be able to break down the modelling task into discrete components and build a model component by component
  • Thoroughly understand the logic flow within each model component and the linkages between the components
  • Have learned good design practices, including:
     -
    How to create a model structure that is easy to follow and amend
     -
    How to integrate input data into model calculations
     -
    How to use formatting to improve model usability
     -
    How to build "error checks" so you are alerted if there is an error
  • Know how to use all the key Excel formulae and functions used in project finance models
  • Be able to fix common model “errors” and master shortcuts that save time and make your modelling more efficient
  • Understand how to use your model to carry out different types of analysis

Each topic is comprehensively covered using elearning content, downloadable pdf tutorials and customised excel spreadsheets.


Course Structure

The Course is made up of 16 core modules:

  • Introduction and Overview
  • Model Structure & Layout
  • Model Assumptions & the Project
  • Model Building Steps and Excel Essentials
  • Construction Costs
  • Construction Funding
  • Term Debt Revenues
  • Operating Costs
  • Major Maintenance
  • Depreciation
  • Working Capital
  • Tax
  • Project Cashflow
  • Financial Statements
  • Using the Model

Methodology
Each topic is comprehensively covered using online content, downloadable PDF tutorials and customised Excel spreadsheets.

Included in the price of the course:

  • A license to access the course material on our LMS for 6 months
  • Access to downloadable content including:
         ‐ 16 pdf tutorials (over 350+ pages)
         ‐ 20 spreadsheets (10 to complete your model and 10 to check your work at each step)
  • 3 months of instructor support via e-mail

The Instructor Support Package*:

  • Additional e-mail support for 3 more months
  • U p to 3x40 minute one to one sessions with an assigned instructor via phone or one-on-one screen sharing webinar for further Q&A.
    *This can be purchased at an additional cost of £475


**END USER LICENCE AGREEMENT**

In purchasing this product you are agreeing these Terms and Conditions

Who should attend

  • Lenders involved in Project Finance
  • Financial Advisors and consultants
  • Agency and Credit Staff
  • Portfolio Managers
  • Project Sponsors
  • Export Credit Agencies
  • Model Auditors
  • Government PPP Executives
  • Contractors
  • Institutional Investors
  • Related Courses

    Agenda

    Introduction to the Course


    Objectives

    The objective of this module is to introduce the learner to the world of project finance models. The learner is shown how all project finance models can be broken down into 10 core components. This module lays the foundation for the building block approach that is followed in the rest of the course.

    Topics Covered
    10 core components of project finance models and their function; linkages between the components; order in which the components should logically be built.

    Model Layout and Best Practice


    Objectives

    The objective of this module is to provide the learner with a thorough understanding of the importance of model layout and struture. In
    addition, a number of modelling best practice topics are covered that help the learner develop good modelling habits from the outset and make the modelling task accurate and efficient.

    Topics Covered
    Model layout and structure; number conventions; cell formatting; proper use of formulas; when to use and not use range names and macros; use of  "error checks"; how to use the Excel cell styles feature.

    Model Assumptions and the Power Project


    Objectives

    The objective of this module is to introduce the learner to the Power Project and key model assumptions that are used to build the Power Project Model over the remainder of the Course.

    Topics Covered
    Key model inputs and the overall contractual structure; importance of a formal Assumptions Book; proper use of the Assumptions Book to record and monitor the source of key model assumptions.


    Model Building Steps and Excel Essentials


    Objectives
    The objective of this module is to provide the learner with a detailed road map of the model construction process using a building block approach. In addition essential Excel features and operations are reviewed.

    Topics Covered
    Building a project finance model in 10 steps; main linkages between the model components; Excel functions, error messages and shortcuts. Essential Excel operations e.g. how to efficiently copy and paste across columns, absolute and relative cell referencing. Excel Add-ins, automatic and manual recalculation.


    Construction Costs


    Objectives

    The objective of this module is to provide the learner with a thorough understanding of how to model construction costs. The inputs required, the main calculations and the outputs are discussed along with their translation into "spreadsheet logic".

    Topics Covered
    Construction costs - main cost items; best way to input cost assumptions into model; how to calculate escalation factors and escalate costs if required; how to model monthly, quarterly and annual dates; how to create construction and operations period flags; how to create linkages to other modules. Excel functions and operations.


    Construction Funding


    Objectives

    The objective of this module is to provide the learner with a clear understanding of how to model different construction funding structures. Different debt and equity drawdown arrangements are discussed along with techniques for making the model flexible so the user can switch from one option to another.

    Topics Covered
    Debt and Equity drawdown arrangements; how to input construction funding assumptions into the model; how to create a "funding waterfall"; conversion of monthly cashflow to quarterly and annual cashflow; Excel functions required for module; "Sources and Uses" of funds" summary.


    Term Debt


    Objectives

    The objective of this module is to provide the learner with the skills to model different Term Debt repayment profiles including quarterly, semi-annual or annual repayments and to integrate these calculations with the rest of the model. The logic required for building a DSRA is also covered

    Topics Covered
    Key inputs; calculations and outputs; how best to input Term Debt assumptions; building credit foncier; equal repayment or 'sculpted' repayment profiles; how to best incorporate different margins; interest only periods; hedging profiles into the Term Debt calculations.


    Revenues


    Objectives

    The objective of this module is to provide the learner with a thorough understanding of how to model Revenue calculations by breaking them down into "Price" and "Quantity" calculations.

    Topics Covered
    Key inputs, calculations and outputs; how best to input assumptions, deriving the "Quantity" and "Price" for a power plant;calculating
    escalation factors; typical tariff components; use of "flags" to switch calculations on and off.


    Operating Costs


    Objectives

    The objective of this module is to provide the learner with a thorough understanding of how cost calculations can be modelled by
    breaking them down into "Fixed" and "Variable" costs.

    Topics Covered
    Key inputs; calculations and outputs; calculating fixed and variable costs after adjusting for inflation; linkages to other modules.


    Major Maintenance


    Objectives
    The objective of this module is to show the learner how to model the main calculations required for the Major Maintenance Module including the Maintenance Reserve Account that is typically required by Lenders.

    Topics Covered
    Setup of the Assumptions Sheet to give the user flexibility in relation to timing of the major maintenance; converting consultant's real dollar estimates to nominal dollar estimates; creating a reserving profile to ensure the project has sufficient funding for major maintenance expenditure; modelling the MRA account; setting up the worksheet so data can flow to other modules that require these calculations.


    Depreciation


    Objectives

    The objective of this module is to provide the learner with the skills and understanding to model different types of depreciation regimes.

    Topics Covered
    Key inputs, depreciation calculations and outputs; different types of depreciation regimes; setting up the model to switch from one type of depreciation to another; incorporating depreciation of future major maintenance into the model; building error checks into the model; Excel functions required to build module.


    Working Capital


    Objectives

    The objective of this module is to instruct the learner about the impact of working capital requirements on project cashflow and the best way to model these impacts in the model calculations.

    Topics Covered
    Calculation of accounts receivables, accounts payable and inventory; Calculating working capital requirements for a modelling period; modelling drawdown and repayments from a working capital facility; incorporating error checks into the calculations.


    Tax


    Objectives
    The objective of this module is to provide the learner with a clear understanding of how to calculate the tax liability of the project company while incorporating any carried forward tax losses from the construction phase and the early years of the operations phase.

    Topics Covered
    Key inputs, calculations and model outputs; calculating taxable income and tax payable; creating a tax loss account to track generation and usage of tax losses from period to period.


    Project Cashflow


    Objectives
    The objective of this module is to provide the learner with a thorough understanding of how to model a cashflow waterfall and key debt and equity metrics.

    Topics Covered
    How to calculate key metrics such as DSCR, Annual DSCR, Average DSCR, Average Loan Life, LLCR, PLCR, Equity IRR, Payback period; creating an annual summary of cashflow for presentation; use of various Excel functions pertaining to this module.


    Financial Statements and Model Summary


    Objectives

    The objective of this module is to show the learner how to create an Income Statement, a Balance Sheet and a Statement of Cashflow. In addition the learner is shown how to create and use a model summary.

    Topics Covered
    Building an Income Statement and calculation of Gross Profit, EBITDA, EBIT, Net profit after tax, Calculation of Balance Sheet items and building an error check, Calculating cash available for distribution, Dividends paid and retained earnings, Summarising results and creating a graph.


    Using the Model & Change Log


    Objectives

    The objective of this module is to show the learner how to carry out different types of analysis using the model.

    Topics Covered
    Sensitivity analysis, scenario analysis, breakeven analysis, cash sweep analysis, creating a Change Log, Printing and presenting results.

    Why us


    We have a combined experience of over 60 years providing learning solutions to the world’s major organisations and are privileged to have contributed to their success. We view our clients as partners and focus on understanding the needs of each organisation we work with to tailor learning solutions to specific requirements.

    We are proud of our record of customer satisfaction. Here is why you should choose us to help you achieve your goals and accelerate your career:

    • Quality – our clients consistently rate our performance ‘excellent’ or ‘outstanding’. Our average overall score awarded to us by our clients is nine out of ten.
    • Track record – we have delivered training solutions for 95% of worlds’ top 100 banks and have trained over 250,000 professionals.
    • Knowledge – our 150 strong team of industry specialist trainers are world leading financial leaders and commentators, ensuring our knowledge base is second to none.
    • Reliability – if we promise it, we deliver it. We have delivered over 20,000 events both in person and online, using simultaneous translation to delegates from over 180 countries.
    • Recognition – we are accredited by the British Accreditation Council and the CPD Certification Service. In an independent review by Feefo we scored 96% on service and 95% on product