Return to schedule
SHARE

Financial Modelling for Renewable Energy Projects - APAC

New Call-to-action



You will learn the financial modelling techniques needed to build a best practice financial model suitable for debt structuring, investment analysis and operational scenario evaluation. 

This renewable energy focussed financial modelling course will enable you to

  • Develop tailored financial models for renewable energy projects with essential functionality for wind, hydro or solar projects
  • Master sensitivity and scenario analysis on operational and financial parameters
  • Achieve consistency and accuracy with SMART best practice modelling
  • Analyse effectively investment metrics, credit ratios and operational benchmarks
  • Construct flexible debt repayment functionality and ratio analysis
  • Understand the requirements of a ‘transaction ready’ financial model in the renewable energy sector

Who should attend this course focused on financial modelling for renewable energy?

This course is suitable for anyone who needs to build, review or analyse financial models for a renewable energy project, including hydro, solar or wind. Typical attendees include Analysts, Managers, Senior Managers, Associate Directors, project developers  and CFOs.

Pre-course knowledge 

While no pre-course modelling knowledge is strictly required, it is expected that participants have a good handle on Excel prior to attending the course. Upon registration you are entitled to our introductory material on Excel functions which will give you the confidence and skills to fully absorb the contents of this course.

Course outline

Day one – best practice financial modelling for renewable energy projects

Master proven techniques for best practice modelling resulting in better models built faster

  • Learn to work with the powerful and easy to follow SMART best practice modelling methodology
  • Demonstration of best-practice model architecture for a wind, solar or hydro project
  • Discuss and identify good vs. bad modelling techniques using real-life examples
  • Greatly increase consistency amongst your team in calculation technique and presentation
  • Discuss the life-cycle of a financial model for a renewable energy project, from screening and structuring to financial close
  • Learn the various structural phases of project development and the associated requirements of the financial model
  • Build your understanding of the building block components, key details and challenges of a transaction model
  • Understand the design flow of the model builder, learn how to know where to go next

Develop a model structure that is robust and scalable that can evolve with a typical project or transaction

  • Establish key constants in the model using full scope of Excel range name function
  • Build a flexible timing structure using appropriate date functions and binary flags
  • Construct modularised units that form the building blocks of a professional model including (but not limited to):-
    • Capital expenditure breakdown with contingencies controls
    • Production calculations with multi-path optionality on time-series schedules surrounding a typical renewable energy project (including energy losses)
    • Revenue build up with detailed pricing controls of a typical renewable energy project (PPA or Feed-in Tariffs)
    • Operational and maintenance expenses including fixed and variable items

Understand the structure of cashflow waterfalls and the importance of ‘seniority’

  • Focus on how to calculate (“CFADS”) - Cash Flow Available for Debt Service
  • Learn how to layout line items in an efficient and easy to communicate way
  • Understand the different types of circular references and how to avoid them

Day two – Efficient investor and debt analysis

Integrate project finance term (operational) debt

  • Walk through of term debt structuring and sculpted debt repayment typical for a renewable energy project
  • Discussion of linear and bullet repayment structures in project finance

Construct and analyse debt facilities for credit or investment decisions

  • Learn the importance of credit ratios and their purposes in analysis
  • Build commonly used ratios in banking and finance from first principles
  • Extract key metrics from ratios using a range of advanced Excel functions

Develop a structured financial modelling process for the calculation of  key investment returns

  • Build a typical LCOE calculation and discuss its various methodologies

Take control of robust and rapid sensitivity and scenario analysis through powerful Excel techniques

  • Save time and deliver rapid analysis with our approach to scenario management
  • Use the scenario manager to test the model in all scenarios

schedule

NOV
6-7
9 AM - 5 PMTokyo
register

have a question?

Please enter your first name.
Please enter your last name.
Please enter your valid email.
Please enter your valid contact number.
Please enter your company
Please select your country
Please enter your enquiry