This project finance modelling course for corporate professionals covers a range of up to date and industry leading topics.
The trainer has over 30 years’ experience in a wide range of roles in finance. He has delivered training courses on behalf of a number of international training companies since 2005.
For the past 18 years, he has worked as a specialist financial modeller, trainer and analyst for a range of blue-chip clients, building financial models for major projects, structured financing, restructuring, outsourcing and PPP transactions in numerous sectors. He has built, developed and used models to support commercial negotiations, analyse risk, test scenarios and forecast results.
The trainer has trained others in his specialism of financial modelling, running both in-house tailored courses for clients and public courses with major training companies all around the world.
Practical: review an existing model to check for compliance with best practice
Practical: producing a model framework for a renewable energy project using best practice
Practical: adding revenue, production & operating assumptions into the renewable energy model
Practical: Adding CAPEX and depreciation schedules to the renewable energy model
Practical: Add a loans schedule which will feed into the balance sheet, cash flow and income statement of the renewable energy model.
Practical: completing and checking the financial statements in the renewable energy model.
Practical: adding tax and dividend calculations into the renewable energy model.
Practical: add ratios to the renewable energy model and adjust the dividend calculations so they are constrained by covenants based on debt ratios.
Practical: add WACC to the renewable energy model and calculate an availability fee to meet cost of capital requirements
Practical: create a valuation of the equity in the renewable energy model
Exercise: Add break-even calculations, data tables and scenarios to the renewable energy model.
Exercise: Add a succinct management summary to meet the needs of decision-makers who will use the renewable energy model.
The course is designed to help analysts to create and use project financial models on a consistent and focussed basis, specifically for the renewable energy industry.
The principal aim of the course is enable participants to create, use and analyse a project finance model, specifically for the renewable energy industry. This will be done by reviewing best practice in model structures, and then building up calculations stage-by-stage to create an entire model. We will then use Excel tools to analyse outputs, highlight areas of risk and perform sensitivity analysis.
The learning methods used are practical, as practicing newly-learned techniques builds skills more deeply and more effectively. Each section will be covered briefly as a module in a traditional class style, but the real learning experience will be found in the exercises within each module. Suggested solutions to each stage will be provided and discussed, and participants will be encouraged to review their work independently. Further supporting materials and additional exercises will be available for further post-course learning, with ongoing support from the facilitator.
An entire model will be created from scratch. Starting with basic assumptions and input data, delegates will build a model with financial structures, inflation, cash flow waterfall, balance sheet and P&L, tax and dividends, equity returns and valuations, ratios and cover factors, and sensitivities.