Financial Modelling & Analysis of Renewables Project

Financial Modelling & Analysis of Renewables Project

The objective of this program is to provide knowledge and practical experience about the creation of comprehensive and complex renewables models of wind, solar, hydro, biomass, etc used in financial planning, structuring and fundraising purposes. The participants will gain insights into the step-by-step process of creating financial models, identify risk, put in checks & audits and analyzing the same.

The course equips you with a comprehension of the various concepts in the renewable energy sector. Our curriculum offers in-depth knowledge of the smart financial models prevalent in the renewable energy industry thereby enabling the participants to be actively involved in the renewables energy industry on the international level.

Overview

The course will enable the participants to prepare detailed financial models for your projects in the field of renewable energy and helps them to identify all the cash flows, finance, and performance indicators. The course is designed to ensure that complex concepts are delivered to participants in a simple way. This will assist in their current role and business to analyze, invest and fundraising of renewables projects

Who should attend

Anyone who wants to enhance their expertise in financial modeling for renewables should attend this course, which includes:

  • Middle to senior managers in the renewable industry
  • All professionals who want to deal or currently deal with the project financing of renewables projects
  • Consultants, advisors and other professionals who wish to improve their modeling skills
  • Middle to senior managers from investment banking, banks, financial institution,
  • Finance directors, development directors, directors of strategy;
  • Functional/department heads and decision-making professionals;
  • Business owners, entrepreneurs, investors, and consultants;
  • Any other professionals who want to upgrade their skills in the renewable energy field.

Methodology & Trainer

Non-theoretical methodology, which includes interactive discussions, case studies, interactive games, and assignments to understand the concepts and their applicability.

We carefully choose all our trainers who possess rich and vast experience in the renewables sector. The course will be conducted by an experienced training consultant having more than 18 years of industry experience with some of the worldu2019s leading financial institutions, specializing in investment and fundraising for wind, solar, hydro, biomass, waste-to-energy, geothermal etc projects.

  • Introduction to the renewable energy industry
  • Importance of financial modeling
  • Analysis of project information
  • Steps for creating financial models
  • Proper presentation of various sheets and setting up the model input dashboard
  • Comparison of modeling process for solar, hydro, and wind projects
  • Discussion on the best industry practices and standard for layouts and structure
  • Preparation of the standard model template to ensure consistency between worksheets
  • Develop quarterly and annual flags
  • Other key flags like construction period, operational period, debt period, etc
  • Resource assessment and capacity factor
  • Development and construction cost
  • Electricity pricing like PPA, Feed-In Tariff, merchant etc
  • Regular O& M Costs
  • Financing ratio, Operating costs, seasonality
  • Understand off-take, pre-paid, and power purchase agreements (PPAs) are.
  • Building renewable energy certificates (RECs) and their impact
  • How to combine merchant pricing and PPA in operational estimates
  • Calculation of fundamental revenue
  • Finalize assumptions using resource data like irradiation, wind speeds, and hydro volumes
  • Analyze the data of P99, P95, P90 etc
  • Seasonality modifications in the revenue
  • Building various PPA and merchant sales pricing
  • Build operating and maintenance costs in renewable energy plants
  • Analyze and build fixed and variable maintenance costs for solar, wind and hydro projects etc
  • Funding requirement for wind, solar, hydro, biomass etc
  • Calculation of fund requirement and various resources of funding and source to service the same
  • Calculation of Interest During Construction (IDC)
  • Different ways to model the development and construction costs
  • Schedule of amortization of intangible assets
  • Tax and accounting depreciation, if any
  • Various financing options available for renewable projects
  • Modeling of debt financing and drawdowns
  • Financing fees and interest during construction
  • Review of refinancing in senior debt -construction debt to the term loan
  • Repayment based on cashflows and various debt covenants
  • Various types of repayment structure like an annuity, sculpted, bullet, etc
  • Studying the concept of credit spreads and debt IRR.
  • Calculation of implied default probability with various credit spreads and debt tenors
  • Causes for formulating credit spreads
  • Waterfall mechanism to calculate the debt requirement and cash flow available for debt service as per
  • Repayment based on the project finance requirement like arranger fees, interest, annual fees, repayment etc
  • Preparation of DSRA and other cash reserves in the waterfall mechanism
  • Calculation of the cash flow available to equity shareholders
  • Dividend calculation with its limitations including lender restriction etc
  • Re-financing of on-shore & off-shore wind, geothermal, and hydropower projects
  • How to evaluate the project for re-financing and points to consider
  • Analysis of various project and financial parameters for re-financing
  • Industry practices on handling exceptions
  • Integration of Cash Flows, Income Statement and Balance Sheet as per best renewable industry practices
  • Reviewing the risks in renewable power projects
  • Studying risks by employing break-even, sensitivity, and scenario analyses
  • Credit analysis in renewable financial projects
  • How to take up adjustments based on the risk
  • Stress testing on a model with P50, P90, and P99 data, delays, financing costs etc
  • Assessing the project using economic and financial analysis tools
  • Calculation of LCOE of wind, solar and hydro projects etc
  • Key Factors impacting the performance of the renewable projects of wind, solar and hydro facilities
  • Loans covenant analysis like DSCR, LLCR, PLCR etc
  • Calculation of Equity and Project IRR and the impact of critical variables on themu00a0to determine acceptable resource risk
  • How to insert various test and checks in the model
  • Identify common model errors and fix them
  • Best industry practices
  • Determine the cost of equity and various risk impacting the same
  • Determining the cashflows for valuations
  • Analyzing the capital structure of the projects and its impact on valuation
  • Discussion of multiple methods of valuation and framework for choosing the most appropriate method for renewables projects
  • Discussion on the mechanical complications in the formulation of financial models
  • Studying the modeling difficulties of financial models for renewable energy
  • Date : 05-09 December 2022
  • Time : 09:00 am - 05:00 pm (Asia/Jakarta)
  • Venue : Jakarta
Download Brochure

    Inquiry Form






    Related Public Training

    Financial Modelling & Analysis of Renewables Project
    Startup Valuation
    Live Online Classes

    Startups Valuation and Fund Raising

    The objective of this program is to provide

    Financial Modelling & Analysis of Renewables Project
    Startup Valuation
    Singapore

    Startups Valuation and Fund Raising

    The objective of this program is to provide

    Financial Modelling & Analysis of Renewables Project
    Corporate Finance
    Live Online Classes

    Corporate Finance Masterclass

    The Course will provide participants with a structured

      Inquiry Form