Project Finance and Investment Modelling
Project Finance and Investment Modelling – Two Day Programme
Introduction
The purpose of the course is for participants to learn how to build a project finance and investment model using best practice principles. This will include the development of integrated financial statements and the mastering of the main Excel techniques (such as forecasting, risk issues, differing scenarios and optimisation). They will learn how to deal with more problematic modelling issues and gain hands-on experience of applying these skills.
The main topics covered are:
• International model design
• Integrated financial statements
• Debt modelling and sizing
• Risk, sensitivity and optimisation
• Gain hands-on modelling experience
Module 1 Overview of the Course and Model Case
- Common modelling errors
- Systematic Design Method
- Model design and structure – key steps
- Key Excel features and techniques
- Practical: producing a model framework using best practice
Module 2 Production Forecast
- Production sales and volume
- Input prices and gross costs
- Practical: completing operating statements
Module 3 Fixed Assets
- Depreciation of fixed assets
- Schedules and workings
- Practical: CAPEX and depreciation schedules
Module 4 Project Financing and Cash
- Financing and loans
- Loan drawdown
- Rate, terms and repayment
- Debt amortisation schedules
- Practical: Loans schedule
Module 5 Income Statement and Balance Sheet
- Adding income and balance sheet
- Model checks on consistency
- Dealing with any circular references
- Practical: completing and checking the initial statements
Module 6 Cash Flow and Ratios
- International cash flow
- Cash flow to equity and debt providers (CFADS)
- Loan life / project life ratio
- Annual debt service ratio
- Interest cover
- Practical: producing single point answers
Module 7 DCF and Initial Value
- Discount rate
- Methods of adding terminal value
- Producing an equity valuation
- Practical: adding equity valuation to the template
Module 8 Risk and Sensitivity
- Adding risk techniques
- What-if analysis
- Dynamic changes
- Practical: Adding sensitivity and scenarios
Questions and Answers