Leading Advisors in Project Finance

PPP/P3 Finance Modelling4 days

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.

    • Let us know you're interested


      I have read and accept the Privacy Policy

      captcha

      In-house Courses

      Where there is demand for multiple delegates from the same firm, it may be better to run an in-house 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:


        I have read and accept the Privacy Policy

        captcha
      Course outline
      Download

      Course Details

      Full course program
        • 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
        • The Audit Sheet
        • Capital Expenditure and Depreciation
          • Life cycle costs
          • PPE
        • VAT
        • Tax and Accounting
          • Capital allowances
          • Deferred tax
          • Tax losses
        • Financing
        • Senior debt
        • Peak exposure
        • Interest and circularities
        • Subordinated debt
        • Maintenance and debt service reserves
        • Cash cascade
        • Debt cover ratios
        • 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
      Call

      Jack Clarke+44 207 562 0477

      Email
      Contact
      [contact-form-7 404 "Not Found"]