Leading Advisors in Project Finance

PPP/P3 Finance Modelling Course4 day course

Overview

Learn how to construct a robust PPP/P3 model from scratch and use it to price a bid.

This intensive 4-day course is aimed at those seeking a best practice approach to building a PPP/P3 financial model.

You will be introduced to a well-known robust and reliable modelling methodology, and will use it to construct and test a complex model for use in the bidding process. The techniques and concepts learned will prove invaluable in future modelling assignments.

VAT of 20% is required to be levied for training courses conducted in the United Kingdom. Training courses conducted outside the UK may include local sales taxes, where applicable. The fees below are quoted net of any taxes.

 

  • Scheduled Courses

    Date Location Price Register interest
    13-16 November 2017 Toronto CAD$3950
    21-24 May 2018 London £3200

Closed Courses

Where there is demand for multiple delegates from the same firm, it may be better to run a closed course. This is a cost effective method of training participants from the one company, conducted on your chosen date, either at your premises or ours, for up to eight delegates. Please get in touch for further details.

Selected course:

captcha

Alternatively, contact on or

Course Details

Who should attend this course?

The PPP/P3 Finance Modelling course is aimed at those seeking a best practice approach to building a PPP/P3 financial model.

Full course program
  • Day 1

    • Model design and construction
      • The top down approach
      • The Principle of Error Reduction
    • Techniques for quick and efficient modelling
      • Keyboard shortcuts
    • Using range names
      • Pros and cons
    • The Inflation Index
    • The cash flow drivers
      • The unitary charge
      • Variable and fixed costs
      • Working capital
    • Profits and Retained earnings
    • The cash flow and cash balances
    • The cash flow/profit and loss/balance sheet relationship
  • Day 2

    • The Audit Sheet
    • Capital Expenditure and Depreciation
      • Life cycle costs
      • PPE
    • VAT
    • Tax and Accounting
      • Capital allowances
      • Deferred tax
      • Tax losses
  • Day 3

    • Financing
    • Senior debt
    • Peak exposure
    • Interest and circularities
    • Subordinated debt
    • Maintenance and debt service reserves
    • Cash cascade
    • Debt cover ratios
  • Day 4

    • The Unitary Charge
      • Setting the price
      • Setting the escalation formula
      • Developing a financing plan
    • Sensitivity Analysis
    • Scenario Management
    • Reporting

Companies we train

"If you use Excel regularly, the only reason not to go on this course is if you’ve already been on it. Very useful even if you’re an experienced user. "
DfT
"I highly recommend Operis for anyone who wishes to influence his/hers financial modelling skills and knowledge of PPP modelling specifically."
Fulcrum
"Fantastic course. Covered the material at a good pace and went into enough detail to provide real world value."
Bilfinger Re Asset Management
"Extremely knowledgeable instructor, fast paced interactive learning. A go to for any professional looking to up their game."
Duffer Inc
"Great Course with lots to take away!"
Province of New Brunswick
"This course is really useful for developing knowledge and understanding at how to best use excel whilst minimising errors."
DfT
"Good course to improve your modelling techniques. Especially helpful if you want to learn how to build financial models from scratch."
Fulcrum
Contact

Fill in our form and we’ll get back to you:

captcha