Financial Modelling & Analysis of Renewables Project
Schedule
Mon Dec 02 2024 at 09:00 am to Fri Dec 06 2024 at 05:00 pm
UTC+08:00Location
JW Marriott Hotel Kuala Lumpur | Kuala Lumpur, KL
About this Event
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.
<h4> Overview</h4>
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
<h4> Who should attend </h4>
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.
<h4>Methodology </h4>
Non-theoretical methodology, which includes interactive discussions, case studies, interactive games, and assignments to understand the concepts and their applicability.
Trainer
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 world’s leading financial institutions, specializing in investment and fundraising for wind, solar, hydro, biomass, waste-to-energy, geothermal etc projects.
<h4>Module – 1</h4>
<h4>Financial Modelling for Renewables: Introduction</h4>
- 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
<h4> Module – 2</h4>
<h4>Preparation of Layout and timing related information of Renewables Projects</h4>
- 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
<h4> Module – 3</h4>
<h4>Key Drivers of Renewables projects </h4>
- 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
<h4>Module – 4</h4>
<h4>Formulating Pricing and Purchase Agreements for Renewable Energy</h4>
- 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
<h4> Module – 5</h4>
<h4>Building Revenues for Renewables Projects </h4>
- 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
<h4> Module – 6</h4>
<h4>Building Cost for Renewable Energy </h4>
- Build operating and maintenance costs in renewable energy plants
- Analyze and build fixed and variable maintenance costs for solar, wind and hydro projects etc
<h4>Module – 7</h4>
<h4>Model CAPEX for Renewable Energy </h4>
- 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
<h4>Module – 8</h4>
<h4>Building Financing for Renewable Energy </h4>
- 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
<h4> Module – 9</h4>
<h4>Credit Spreads and Financial Return Analysis for Renewable Energy </h4>
- 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
<h4>Module – 10</h4>
<h4>Waterfall mechanism for Renewable Projects </h4>
- 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
<h4> Module – 11</h4>
<h4>Re-financing of the renewable projects </h4>
- Using various financing schemes
- Re-financing of on-shore & offshore 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
<h4> Module – 12</h4>
<h4>Integration of income statement, balance sheet, and cash flow statement</h4>
- Industry practices on handling exceptions
- Integration of Cash Flows, Income Statement and Balance Sheet as per best renewable industry practices
<h4>Module – 13</h4>
<h4>Risk and sensitivity analysis of Renewable Energy</h4>
- 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
<h4> Module – 14</h4>
<h4>How to Analyze the Performance of Renewable Projects </h4>
- 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 them
- to determine acceptable resource risk
<h4> Module – 15</h4>
<h4>How to do model review and control </h4>
- How to insert various test and checks in the model
- Identify common model errors and fix them
- Best industry practices
<h4> Module – 16</h4>
<h4>Valuation of Renewable Energy projects </h4>
- 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
If you need further information, please visit www.riverstonetraining.com.sg or send mail at [email protected] or whatsapp at +65 9730 4250
Riverstone – Corporate Traininghttps://www.riverstonetraining.com.sg
Where is it happening?
JW Marriott Hotel Kuala Lumpur, 183 Jalan Bukit Bintang, Kuala Lumpur, MalaysiaEvent Location & Nearby Stays:
SGD 3803.00