Financial Modeling Training for Energy & Infrastructure Professionals

Financial Modeling for Power Generation Projects Course

Three Days – In-Person & Virtual Delivery

Financial modeling of traditional power projects requires a robust and flexible approach to developing analytical functionality that addresses the needs of sponsors, investors, operators, and project finance banks. This practical, interactive course will help participants develop stronger skills for building and analyzing traditional power project models in a sophisticated environment. Through detailed instruction, case study examples, and workshop modules, attendees will acquire an in-depth understanding of financial model architecture and processes in the power generation sector.

Key Learnings:

• Gain best practices for creating flexible, clean, and robust financial models for power generation projects
• Build a flexible and powerful scenario manager to analyze a 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 analyzing project finance debt and other funding sources
• Represent the construction phase of a power plant in the Excel model
• Model pricing and purchase agreements in power generation
• Forecast and model production metrics
• Gain financial modeling techniques for operational costs and project maintenance
• Review depreciation and tax calculations
• Apply financial return and project return analysis
• Learn scenario management with an efficient financial model structure

Best Practice Project Finance Modeling

Two Days – In-Person & Virtual Delivery

Our Best Practice course is a core introductory session for attendees who have light modeling experience and are looking to learn how to build clean, robust, and flexible financial models. Alongside our experienced instructor, participants will build and sensitize their own project finance model from scratch—building out cashflow waterfalls, analyzing debt facilities, and learning powerful Excel techniques. Whether you’re working on deals related to transportation, digital or social infrastructure, real estate, mining, or conventional or renewable energy, our modeling methodology can help attendees at any experience level refresh and enhance their modeling skills.

Key Learnings:

• Achieve consistent and accurate outputs using our financial modeling methodology
• Learn efficient modeling techniques to help deliver faster, more accurate analysis
• Gain specialized skills to build a flexible and powerful scenario manager to analyze a project’s sensitivity to key drivers
• Discuss the lifecycle of a project finance model, from conception to financial close 
• Develop a robust, scalable model structure that can evolve with a typical project or transaction 
• Understand the structure of cashflow waterfalls and the importance of “seniority”
• Integrate project finance term (operational debt)
• Construct and analyze debt facilities for credit or investment decisions
• Calculate key returns results and understand the role of dividends policy
• Gain control of robust and rapid sensitivity and scenario analysis through powerful Excel techniques

Advanced Project Finance Modeling

Two Days – In-Person & Virtual Delivery

This extensive financial modeling course helps attendees master the advanced techniques required to analyze complex projects and transactions across a broad range of industries. Participants will extend debt modeling capabilities as a mechanism to drive the transaction process, learning powerful techniques for debt sizing, covenant monitoring, and financial statement development.

Focusing on robustness, flexibility, and analytical technique, this course will teach the critical tools needed for various types of project finance professionals to manage a project model from conception to financial close. The session will examine the principles and structured approach needed to achieve modeling consistency, even when working across multiple asset classes.

Whether you’re working on deals within transportation, digital, or social infrastructure; mining; oil and gas; renewables; conventional energy; or real estate, our modeling methodology will teach you how to build clean and robust models that can be used immediately upon returning to the desk.

Is this course right for you?

This course is an excellent fit for professionals looking to develop their modeling skills beyond a basic level. There are no strict prerequisites to taking the advanced session, but it is strongly recommended that participants be comfortable with cashflow waterfalls; DSCR & LLCR; project returns and equity returns; Net Present Value calculation and concept; and modeling construction costs, revenue, and opex.

Key Learnings:

• Expand project finance modeling skills in guiding a transaction from screening to financial close
• Develop the required techniques for debt sizing, covenant monitoring, and advanced debt structures, including lock-up mechanisms and debt sculpting
• Gain understanding of the modeling of Debt Service Reserve Accounts (DSRA)
• Expand toolkit to include alternative debt repayment methods for increased flexibility
• Gain insights on effective modeling of refinancing analysis to help achieve faster, more robust analysis
• Learn powerful techniques for alternative repayment methods for debt sculpting
• Adopt a structured approach to extensive depreciation calculations
• Understand how financial statements are constructed and identify common problems
• Use advanced Excel techniques for rapid and accurate multidimensional sensitivities

Financial Modeling for Digital Infrastructure Projects

Two Days – In-Person & Virtual Delivery

The U.S. digital infrastructure sector offers immense growth opportunities for both domestic and international investors. To seize these opportunities, mastering financial modeling skills tailored to this space is critical.

This interactive training equips participants with the essential tools to evaluate infrastructure projects effectively. Through hands-on exercises, attendees will learn how to construct clean, dynamic, and professional financial models based on the Forvis Mazars methodology. By building a data center model from scratch in Excel, participants will assess project feasibility using cashflow analysis, and key metrics like IRR, NPV, power usage effectiveness, and capacity utilization.

The course blends theoretical knowledge with practical application, covering risk management strategies and exploring financing structures specific to the digital infrastructure sector. Whether you’re a developer, owner, investor or advisor, you’ll gain actionable insights and a strong foundation for making informed financial decisions in this rapidly expanding sector.

Financial Modeling for Renewable Energy Projects

Three Days – In-Person & Virtual Delivery

This training course teaches participants the core skills to efficiently develop, modify, and analyze financial models for renewable energy deals. Our interactive session covers essential topics, including funding mechanics, operational analysis, and investment metrics, equipping attendees with a robust platform for analysis in sophisticated environments.

Key Learnings

• Learn commonly used financing structures applicable across a range of renewable energy subsectors
• Understand best practices and techniques for achieving clean and flexible renewables models
• Gain an understanding of essential Excel functions and powerful shortcuts for professional financial modeling technique support
• Learn about tax modeling frameworks adaptable to different regional jurisdictions
• Understand and prepare flexible funding structures for analyzing project finance debt and other funding sources
• Develop financial modeling techniques for operational costs and maintenance
• Learn how to model construction phase pricing and power purchase agreements
• Develop forecasting and model production metrics
• Conduct project return analysis and other essential financial model analysis
• Incorporate master scenario management with an efficient financial model structure
• Enhance the project capital structure

Mastering Infrastructure Valuations

Two Days – In-Person & Virtual Delivery

In this course, you’ll learn the key concepts for valuation analysis and source information, as well as key methodologies for discount rates and adapting a model for valuation purposes.

Key Learnings

• Gain an in-depth understanding of WACC and CAPM and applying discount rates
• Implement DCF analysis and learn simplification techniques for applying in your models
• Learn how to approach a comparable valuation analysis
• Calculate terminal value and understand its various approaches
• Benchmark and justify your valuation
• Learn specific considerations for infrastructure and energy valuations

Financial Modeling for Acquisition Transactions

Two Days – In-Person & Virtual Delivery

A robust financial model for an acquisition transaction provides deep insights for investors and financiers who need to assess the risks and opportunities relating to a proposed deal. Our modeling course for acquisition transactions is designed to help attendees learn the valuable financial modeling skills needed to assess risk. Mastering the skills taught during this extensive and interactive course will help prepare attendees to tackle challenging deals with flexibility and confidence.

This class will teach participants to build an in-depth model with powerful analytical outputs tailored for investment banks, private equity, and corporate finance executives.

Key Learnings:

• Adopt a systematic approach to debt modeling focused on acquisition transactions
• Develop an evaluation framework of how commercial negotiation drives valuation and investment ratios
• Build flexible modules for myriad financial models, providing in-depth analysis of how key drivers impact the decision criteria of an acquisition transaction
• Analyze investment returns for management, sponsors, and debt financiers in various operating scenarios
• Learn well-established techniques for best practice modeling, helping you build better, faster models
• Discuss the lifecycle of an acquisitions model, from screening and structuring to exit strategies
• Develop best practices for high-level operations forecasting
• Build a working capital forecast and integrate it into a developed model
• Learn a structured approach to PP&E forecasts and depreciation calculations
• Understand how financial statements are constructed and how to identify common problems
• Build and analyze returns and exit strategies through the scenario manager

Financial Modeling for Real Estate Project Development

Two Days – In-Person & Virtual Delivery

Developing real estate projects requires detailed financial analysis of construction, operations, and financing to meet return targets and establish projected results. This interactive course provides experienced instruction for attendees who want to learn the core modeling skills needed to tackle complex issues that may not fit into traditional financial templates or software. Lessons are conveyed through a blend of case study-based financial modeling concepts, theoretical analysis, and demonstration of best practice modeling techniques and solutions. This content will provide participants with actionable knowledge and applied techniques to take back to their desks immediately after course completion.

Key Learnings:

• Develop a new financial model from scratch using our practice modeling techniques for dynamic and transparent analysis
• Discuss the modeling requirements of a real estate project from conception, development, construction, refinance, operating, and sale
• Develop a scalable model structure flexible enough to evolve with a typical project or transaction
• Construct modularized units that form the building blocks of a professional model
• Study the structure of cashflow waterfalls and the importance of ‘seniority’
• Learn time-saving techniques for scenario management and data tables
• Structure debt calculations in both construction and operations, as well as debt facilities for credit or investment decisions
• Review analysis in financing, valuations, and scenario management
• Gain valuable insights on refinancing at completion
• Explore valuation and distributions
• Learn power Excel techniques to control sensitivity and scenario analysis