| Available 24 Hours Monday - Friday | 01344208452
Please enter course

Got a quick question or comment?
Send us enquiry.

Enter your details and we will call you back to discuss your requirements

Project Finance Course | Project Finance Courses

  • Highly recommended for Project Finance, Structured Finance & Corporate Finance Professionals
  • This course focuses on how to develop sophisticated and robust project finance models
  • Individuals will learn how to structure a project finance model
  • GUARANTEED LOWEST PRICE IN THE INDUSTR
  • Discover the key ratios used in project finance and how to calculate them in a financial model
  • Courses delivered by world class Financial training instructors in luxury venues 
  • Project Finance Modelling includes material and manuals
  • Book Online or Call 01344 203999 to speak to a Financial training advisor today
Schedule
Course Dates, Locations & Prices (Top) | View Course Info
Course Name Date Location Duration Price Book Online
Project Finance Modelling 04/09/2017 Chorley
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Wrexham
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Milton Keynes
3 days £2749 Book now Enquire
Project Finance Modelling 04/09/2017 London
3 days £2449 Book now Enquire
Project Finance Modelling 04/09/2017 Leicester
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Buxton
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Poole
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Doncaster
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Colchester
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Wakefield
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Warrington
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Heathrow
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Lincoln
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Chatham
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Newcastle
3 days £2749 Book now Enquire
Project Finance Modelling 04/09/2017 Maidstone
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Dereham
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 York
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Stoke-on-Trent
3 days £3049 Book now Enquire
Project Finance Modelling 04/09/2017 Watford
3 days £3049 Book now Enquire

Course Information (Top) | View Dates & Pricing

Description

Introduction

This course focuses on how to develop sophisticated and robust project finance models.

You will build on this in a step-by-step approach until completing a full financial model complete with sensitivity analysis.

The emphasis will be on avoiding common mistakes found in project finance models by anticipating requirements and building in checks at the design stage.

Who Should Attend

  • Project Finance, Structured Finance & Corporate Finance Professionals
  • Analysts
  • Investment Officers
  • Risk Managers
  • Financial Consultants

Course Objectives

Upon completion of this course, candidates should know the following:

  • How to build a model according to modelling best practice
  • Learn how to structure a project finance model
  • How to calculate capital expenditure and construction timelines
  • Build operational cashflow statements
  • Learn how to develop debt tracking accounts
  • Discover the key ratios used in project finance and how to calculate them in a financial model
  • How to model a range of financing structures, including cash sweeps, refinancing and bullet loans
  • Build in sensitivity analysis to your models

Course Content

Project finance modelling

What are financial models used for in project finance?

Introduction to the modelling exercise

  • Developing a project finance model for an independent power project (IPP)
  • How the exercise applies to other types of project What is involved in building a financial model?
  • How to approach the problem
  • Gathering the information you will need
  • Understanding the requirements of the model
  • The structure of a model
  • Materiality

Good modelling practice

  • How to structure your models so that they can easily be understood and audited
  • Separating assumptions from calculations
  • Assumptions required for construction phase calculations
  • Sources of information
  • Project timings
  • Costs and timing of costs

Practical exercise: participants will start to construct their project finance models. They will be taught how to use named ranges and learn how to establish a timeline using date functions. The course director will provide guidance on the use of Excel where necessary and will break to highlight key learning points.

Modelling the effects of inflation

  • The use of real and nominal values
  • How to tackle indexation
  • The importance of timing of the costs

Modelling in multiple currencies

  • Setting up your model to work with more than one currency
  • The use of forward exchange rate curves and purchasing power parity

Construction phase sensitivities

  • Discover how to set up sensitivities

Using lookup functions

  • Introduction to the choice of lookup functions
  • Why we use lookup functions
  • Problems associated with lookup functions

Construction phase funding

  • Modelling interest during construction
  • How to calculate commitment and arrangement fees
  • Building a debt tracking account

Circular references

  • What are they?
  • How do they occur?
  • Why should we avoid them?

Practical exercise: participants will develop a construction funding worksheet including idc, commitment fees and a debt tracking account

Review of first day’s topics

  • Summary and Q&A session

During day two, participants will continue to build their models, adding operating phase revenues and costs

Modelling project revenues

  • How are the revenues of project financed projects structured
  • The reasoning behind tariff structures
  • The differences between capacity, availability and output
  • Modelling bonus and penalty mechanisms
  • Dealing with multiple currency tariffs

Operating revenue assumptions

  • Source of assumptions
  • Operating revenue sensitivities
  • The effects of over / under performance

Practical exercise: participants will build operational revenue calculations including fixed/variable tariff elements and bonus/penalty mechanisms. The course director will also show real life examples of these mechanisms.

Setting up the operating costs calculations

  • Source of assumptions
  • Operating cost sensitivities

Practical exercise: participants will develop operational cost calculations including fixed and variable components applying the relevant indexation to each of the cost items.

Modelling taxation

  • Modelling different types of depreciation
  • Carrying tax losses

Practical exercise: participants will develop tax calculations including depreciation and a tax loss tracking account.

Review of second day’s topics

  • Summary and Q&A session followed by quiz

Determining the project’s debt capacity

  • Sources of funding

Practical exercise: participants will develop funding calculations including base and standby debt tracking accounts and debt service reserve account.

How to model different senior debt structures

  • Refinancing
  • Cash sweep mechanisms
  • Bullet loans

How to construct a cashflow statement

Key funding ratios

  • Introduction to NPV and IRR
  • Calculating cash available for debt service
  • Learn how to calculate annual debt service cover ratios and loan life cover ratios

Practical exercise: participants will develop a cashflow worksheet including calculation of key funding ratios. They will learn how to calculate the debt capacity based on these funding ratios.

Model optimisation

  • Adjusting repayment profiles to maximise debt capacity

Use of macros

  • How they are used in project finance deals
  • The dangers and precautions that could be taken Income statement
  • Pulling together relevant information to produce an income statement
  • Dividends and other points related to equity financing

Balance sheet

  • Constructing a balance sheet
  • Techniques for balancing
  • Using the balance sheet as an internal check on your model

Techniques for project appraisal

  • Evaluating investor returns
  • Using the offset function

Review of first three day’s topics

Summary and Q&A session followed by quiz

Output from financial model

  • Producing reports
  • Examples from real life projects developed by the course director

Risk assessment

  • Sensitivity and break-even / default analysis
  • Pre-completion and post completion risks

Problem solving session: participants are invited to ask questions related to using the models they have built in their own workplaces, or ask questions related to models they have inherited.

Course summary and close

Whats Included?
  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

best-price      customer-charter

FAQs
  • Course Availability

    The spaces remaining on all courses across the website reflect the availability of the maximum printed course materials and equipment available in stock for any given event. If the spaces remaining do not appear, then there is comfortably enough lead time to provision course materials and equipment upon booking.


  • What time shall I arrive at the venue?

    Please arrive at the venue for 08:45am


  • What are the timings of the course?

    The course begins at 9am and finishes around 5pm.


  • Who should attend this course?

    Project Finance, Structured Finance & Corporate Finance Professionals Analysts Investment Officers Risk Managers Financial Consultants


  • Do you offer support for the course?

    We are able to provide support via phone & email prior to attending, during and after the course


  • What is included in the course?

    Delegate pack consisting of course notes and exercises, Manual, Experienced Instructor and Refreshments


  • What is the main focus of this course?

    This course focuses on how to develop sophisticated and robust project finance models.


  • How long until I receive the course confirmation details?

    Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts


Why Choose us?
  • Certified and Approved

    We're accredited by leading training organisations including AXELOS, BCS, The Chartered Institute of IT, APMG, PMI, The Open Group and many more.


  • Best Price Guarantee

    As well as providing the best training in the industry, we'll also provide it at the best price. We'll beat any like for like quote from our competitors.


  • World's Largest Global Training Provider

    We offer training in the more locations than any other provider with over 1200 training locations globally.


  • Trusted by Industry Leading Brands

    We're proud of our range of high-profile clients including brands such as JP Morgan, HSBC, British Airways, BskyB, Sony, AT&T to name only a few


  • Hands-on, Expert Instructor-led Classroom Training

    All our trainers are hand-picked, highly experienced, subject matter experts, who can not only train you but also use real world and practical examples.


  • Dedicated 24/7 Support

    We are here to provide help and guidance before, during and after your training course to make sure you get the most from your training

Reviews
 Contact Us  More Courses

Happy Customers

There hasn't been any testimonials submitted to this topic