Search

Project finance modelling

Category: MASTER COURSE

Gain a robust and flexible methods for building project models, plus training in the established design solutions to the challenges commonly encountered.

Who should attend?
Those working in or alongside the project finance or PFI world, who need to develop the skills to build or interpret integrated Excel based models.

What you will gain
A robust and flexible method for building project models, and established design solutions to the common challenges presented by project models. In particular, you will address the needs for time flexibility, flexible capex linked financing avoiding circularity, and scenario management. The course will be built around a live project case which will model a merchant or tolling IPP power project.

Programme outline
Design principles and best practice.

  • First rule of financial modelling - design, design, design.
  • Modular design, the fundamentals.
  • Design questionnaire.
  • Project and PFI modelling defining in the problems.
  • Creating a flexible non-circular funding scheme.
  • Dealing with varying length forecasting periods.

Time management.

  • Some popular design approaches.
  • Creating a date flexible framework, varying period length from construction to operation.
  • Flexing timing of events - using flags.
  • Flexible consolidation of periods to years - index, offset, sumif.

Construction period sources and uses.

  • Design approach.
  • Dealing with circularity - interest during construction and sizing commitments, using goal seek.
  • Creating a simple funding scheme with term debt and residual equity funding.

Building the model.

  • Lookup tables - alternatives for generating revenues based on different load factors and thermal efficiencies.

Cash flow cascade and reserves.

  • Typical priority of payments.
  • Debt service reserve account.
  • Capital maintenance reserve.
  • Building a cash flow cascade.
  • Accounts integration.

Project ratios.

  • LLCR definition.
  • DSCR definitions.
  • Debt repayment profile optimization.

Model flexibility - scenario management.

  • Implementing alternative debt structures.
  • Excel's scenario manager.
  • Vlookup.
  • Index, choose and offset.
  • Visual basic tools.

Consolidation.

  • Dealing with multiple operating units and consolidating into a pro forma group accounts.
  • Merger accounting.
  • Consolidation eliminations.
  • Consolidation template methodology.

The course starts at 9.00am on each day.  Lunch and refreshments are included, but not accommodation.
12 CPD hours (where applicable)

CIMA work in partnership with BPP Professional Education to offer CPD training courses



Related Events

22/11/2019 09:00:00

Debt modelling (with LBO)

MASTER COURSE

  • Cost:
    GBP 730.00
    Member price: £657. Plus VAT on all prices.
  • Location:
    London
  • Speaker(s):

Discover how to construct a flexible model capable of analysing the suitability of target businesses for a leveraged buy-out.

Find out more

05/12/2019 09:00:00

Financial modelling - advanced (and introduction to VBA)

MASTER COURSE

  • Cost:
    GBP 1,450.00
    Member price: £1,305. Plus VAT on all prices. Accommodation not included.
  • Location:
    London - 2 day course
  • Speaker(s):

Consolidate your Excel skills and learn some more advanced techniques that apply in a corporate finance and financial markets context.

Find out more

09/12/2019 09:00:00

Venture capital and private equity - introduction

MASTER COURSE

  • Cost:
    GBP 1,290.00
    Member price: £1,161. Plus VAT on all prices. Accommodation not included.
  • Location:
    London - two day course
  • Speaker(s):

An explanation of the working of the venture capital and private equity industry, this course gives practical instructions on analysing and structuring transactions, including buy-outs and buy-ins.

Find out more

Project finance modelling

CIMA members and students should log in to MY CIMA before booking to receive the appropriate discount.

Book Now

In-house training 
We can develop tailored training programmes to enhance the finance and business skills of staff across your organisation. To discuss how we can meet your learning and development needs please email us.

Find out more 
If you have any queries please email cima@bpp.com or phone us on: +44 (0)3300 603400.

The venue for this course will be confirmed 14 days before the scheduled date. 

CIMA work in partnership with BPP Professional Education to offer CPD training courses.  

This course will be delivered by BPP Professional Education Limited (“BPP”).  Accordingly, when you sign up for this course, CIMA will pass on the contact details you have provided to BPP so that they can contact you to complete your booking and process payment.  BPP will process any personal information it collects about you in accordance with its privacy policy, which is available at: http://www.bpp.com/professional-education/privacy

The information provided to BPP will not be used by BPP for marketing purposes.

CIMA on demand 

Our catalogue of online CPD training courses designed to fit around your schedule.

Get any 5 courses for just £99 +VAT - limited time only.  

Find out more