Wall Street Prep

Financial Modeling for Renewable Energy Projects|New York City

Master the skills to efficiently model large-scale projects in the renewable energy sector

Provided in partnership with Corality, the leader in project finance modeling.

What You'll Learn

  • Learn modeling, funding mechanics and operational analysis
  • Taught by experienced bankers
  • Includes Excel model templates

Financial Modeling for Renewable Energy Projects will teach you how to efficiently develop, modify and analyze financial models in the renewable energy sector. You'll learn the financial modeling techniques needed to build a best practice financial model suitable for debt structuring, investment analysis and operational scenario evaluation.

Pricing

Enrollment
$4,500*

Agenda

    • Develop a strong understanding of financial model architecture and process in the renewable energy sector
    • Project documentation: Learn the significance of various document and their impact on the financial modeling process
    • Representing the construction phase of a renewable energy project in the Excel model
    • Modeling of pricing and purchase agreements in renewable energy
    • Forecasting and modeling of production metrics
    • Financial modeling techniques for operational costs and project maintenanceIntegrate project finance debt
    • Extend the model with depreciation calculations
    • Develop a flexible framework for financial modeling of tax liabilities
    • Complete and debug integrated financial statements for full commercial insights
    • Project Return – essential financial model output
    • Master Scenario Management with an efficient financial model structure
    • Build confidence in your analysis through pre-programmed combinations of model inputs
  • Pre-Seminar Excel online training

    This boot camp assumes proficiency in Excel. Enrollment includes access to our popular Excel Crash Course for those who need an Excel refresher.

Who is this boot camp for?

This course is suitable for anyone who needs to build, review or analyze project finance models in the renewable energy sector. It is designed to appeal to project sponsors, bankers and advisors. Typical attendees include analysts, managers, senior managers and associate directors.

Boot Camp Overview

corality-turbinesThis course is guaranteed to boost your project finance career and give you all the tools to reach financial close.

This seminar will give you the skills to efficiently develop, modify and analyze financial models in the renewable energy sector. It will clarify how project finance bankers, investors and external parties will analyze your project, and provide a deep understanding of the flexibility required in scenario analysis by a range of audiences. It will enable you to:

  • Master best practice techniques for financial modeling of renewable energy projects to achieve flexibility and robustness
  • Build a flexible and powerful scenario manager to analyze your project’s sensitivity to key drivers
  • Prepare trusted analysis of commercial outputs tailored to investors and financiers, with a focus on valuation and risk
  • Understand a flexible framework for tax modeling, adaptable to regional jurisdictions
  • Develop flexible funding structures for analysis of project finance debt and other funding sources
  • Learn how to analyze GP/LP flip structures and tax equity for project financing
Pre-course knowledge

While no pre-course modeling knowledge is strictly required, it is expected that participants have a good handle on Excel prior to attending the course. Wall Street Prep registrants receive free access to the Excel Crash Course to satisfy this prerequisite.

Seminar Location

This boot camp will be held in an event space in New York, NY. The exact location will be emailed after enrollment.

Why attend a boot camp?

  • Comprehensive training

    Our live courses pulls no punches. Each boot camp is the same intensive training used to prepare incoming analysts at top financial institutions.

  • Learn by doing

    Attendees “learn by doing” by working through practical exercises and building financial models from scratch using real case studies.

  • Networking opportunity

    Boot camps provide an opportunity to network with MBAs and professionals from industries including investment banking, corp dev and FP&A.

  • Experienced instructors

    Our instructor-practitioners are experienced bankers who give real-world context by connecting training to their own experience on the desk.

  • Excel Mastery

    Our training reinforces speed, efficiency and consistency in Excel that investment banking analysts are expected to have on Day 1.

  • Continuing ed & webinars

    Enrollment includes lifetime access to our continuing education online training platform and our popular monthly webinar series.

Syllabus

Financial Modelling for Renewable Energy Projects

Develop a strong understanding of financial model architecture and process in the renewable energy sector, to ensure the big picture is always in mind

  • Understand how to envision a financial modeling process from beginning to end
  • Recognize the process similarities in modeling for wind, solar of hydro projects and learn which modules can be standardized across energy sources
  • Gain insights into a typical financial model development process – step-by-step – for a renewable energy model
  • Benefit from a flexible timing framework to underpin the model architecture – an essential feature for projects where the dates / timing may change over time (which includes 99% of all projects)
  • Capture the financial implications of delays (construction / operations) in the project time table with a structured financial modeling approach

Project documentation: Learn the significance of various document and their impact on the financial modeling process

  • Discuss major project documents used in renewable transactions and their impact on the financial model
  • Understand how to manage ever-changing documentation and assumptions

Representing the construction phase of a renewable energy project in the Excel model

  • Discuss funding alternatives for renewable energy projects (bank debt, capital markets, government supported structures, export agencies) and how this impacts the financial modeling process
  • Incorporate flexible functionality for construction delays  and/or cost over-runs
  • Integrate typical renewable energy construction contracts and contingencies

Modeling of pricing and purchase agreements in renewable energy

  • Learn about off-take, prepaid and power purchase agreements (PPA)
  • Integrate both PPA and spot pricing into the operational calculations
  • Expand PPA analysis by having variable pricing structures, milestones, and penalties

Forecasting and modeling of production metrics

  • Understand application of different forecasting methods, the appropriate allocation of each
  • Learn to integrate multiple probability exceedance profiles concurrently (e.g., P50, P90
  • Convert gross production to net production by accounting for: Operational ramp up schedules, impact of production unit (e.g. turbines) availability and efficiency, and gains and losses of production such as seasonality of renewable energy.

Financial modeling techniques for operational costs and project maintenance

  • Integrate fixed and variable costs typical of renewable energy projects
  • Learn how to model flexible volume driver controls for variable costs
  • Understand the important role of real vs. nominal costs (escalation) and how to integrate powerful indices
  • Review of leasing structures and application of in renewable energy projects

Integrate project finance debt

  • Develop comprehensive debt modeling mechanics, with a  specific application of annuity repayment using first principle calculation for full transparency
  • Incorporate the functionality of target Debt Service Coverage Ratio repayments
  • Review other repayment options including bullets and linear commonly used in project finance

Extend the model with depreciation calculations

  • Master flexible depreciation calculations for an efficient financial model structure
  • Understand how to develop flexible input structures for analysis of multiple depreciation methods
  • Extend your calculations to capture accounting and tax depreciation separately with only small changes to the model

Develop a flexible framework for financial modeling of tax liabilities

  • Calculate the correct taxable income for tax calculations
  • Incorporate a tax creditor account for correct assignation of tax payable and paid
  • Understand the working of tax loss accounts

Complete and debug integrated financial statements for full commercial insights

  • Master the structure of completed three way financial statements
  • Build in Cashflow Waterfall, Balance Sheet and Income Statement (P&L)
  • Learn how to continuously test and debug the integrated statements

Project Return – essential financial model output

  • Inclusion of best practice net present value (NPV) and internal rate of return (IRR) calculations for the renewable energy project
  • Discussion about key differences between XPNV vs. NPV functions
  • Limitations and dangers in the application of the IRR function

Master Scenario Management with an efficient financial model structure

  • Work faster, better and with more insights using Corality’s Scenario Management solutions
  • Use  commercial scenario analysis to assess the working of the financial model, and to sense check your logic and calculations
  • Build confidence in your analysis through pre-programmed combinations of model inputs

Questions? We're standing by.

To learn more about this boot camp, fill out the form below or call us at: 617-314-7685








X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.