Project Finance Modelling Workshop

Monday, June 18

09.00 - 09.15 Welcome and Introduction

09.15 - 12.00

Overview of the Workshop and Project Model Case

  • Presentation of workshop case and review of theory
  • Offtake agreements, completion undertakings and security issues
  • Model objectives - viability, debt capacity, returns (NPV, IRR etc.), sensitivities
  • Setting model targets for debt cover and project returns
  • Review of an existing model to highlight common modelling errors
  • Systematic Design Method
  • Model design and structure - key steps
  • Model layout and design
  • Required sheets and modules
  • Key Excel features and techniques

Practical: producing a model framework using best practice

Production Forecast

  • Modelling techniques
  • Dealing with multiple currencies
  • Nominal vs real figures
  • Modelling production sales and volume
  • Input prices and gross costs

Practical: completing operating statements

12.00 - 13.00 Lunch

13.00 - 17.00

Fixed Assets

  • Construction and interest during construction
  • Accounting depreciation of fixed assets
  • Developing schedules and workings

Practical: CAPEX and depreciation schedules

Project Financing and Cash

  • Review of sources and types of debt finance
  • Developing the project debt capacity
  • Financing and loans
  • Loan drawdown
  • Multiple rates, terms and repayment profiles
  • Varying debt amortisation schedules

Practical: Loans schedule with balance sheet and income statement inputs

Tuesday, June 19

09.00 - 09.15 Recap

09.15 - 12.00

Income Statement and Balance Sheet

  • Bringing together the workings for revenue, assets, debt and
  • Adding income and balance sheet
  • Model checks on consistency
  • Dealing with any circular references

Practical: completing and checking the initial statements

Cash Flow and Ratios

  • International cash flow statement
  • Cash flow to equity and debt providers (CFADS)
  • Loan life / project life ratio
  • Annual debt service ratio
  • Cash extraction and dividend issues
  • Checking the project debt capacity and covenants

12.00 - 13.00 Lunch

13.00 - 17.00

DCF and Project Returns

  • Review of discounting theory
  • Developing a suitable project and equity discount rate
  • Methods of adding terminal value
  • Producing project and equity returns
  • Checking the returns against the project targets

Practical: adding equity valuation to the template

Risk and Sensitivity

  • Assessment of project risks
  • Suitable Excel risk techniques
  • Adding model sensitivities and what-if analysis
  • Dynamic changes and management reporting

Practical: Adding key sensitivity and scenarios

Evaluation and Termination of the Workshop

  Site Map    Policy Statements    Mobile Version
COPYRIGHT © 2017 MONECO