What you will learn

• Mastery of Excel functions and shortcut keys that are used in real project models, such as SUMIF/SUMPRODUCT, OFFSET, INDEX/MATCH/LOOKUP, and similar items.

• Understanding the principles of project financing including SPVs, non-recourse structures, due diligence processes, and resource and expenditure frameworks.

• Reading and analyzing data notes like an analyst, extracting assumptions and planning to build the model.

• Familiarity with renewable energy fundamentals including megawatts vs. megawatt hours, full load hours, P50/P75/P90 efficiencies, and how uncertainties drive scenarios.

• Mapping of energy production and implementation of various power purchase agreements (PPAs) including partial risk hedging.

• Construct fixed and variable operating cost drivers, equity and tax inputs, and consistent cost scheduling.

• Correctly connecting the income statement, balance sheet, and cash flow statement to each other and creating integrity and principal checks.

• Add senior debt and equity tables and implement debt service coverage ratio (DSCR) indicators.

• Calculate internal rate of return (IRR), net present value (NPV), cash flow (CoC), perform scenario analysis, and provide decision-ready outputs.

• Ability to build a clean, integrated three-statement financial model from scratch in Excel and convert information notes into structured inputs.

This course is suitable for people who:

• At all levels from beginner to advanced, they intend to learn project finance modeling (professional users can skip the basic theory chapters).

• They work in or are interested in the areas of financial modeling, financial analysis, project finance, infrastructure investment, investment banking, and private equity.

• They want to gain a competitive advantage and differentiate themselves in their careers by learning specialized principles of renewable energy and financial modeling.

Installation Guide

After Extract, view with your favorite player.

Subtitles: None

Quality: 720p