Complete Financial Modeling for Project Finance in Excel

Master High-End Financial Modeling for Infrastructure Projects

Learn to build sophisticated financial models for the infrastructure sector with our comprehensive online course. Go from a blank Excel workbook to a fully functional model ready for investment analysis, debt structuring, and operational scenario evaluation. This course provides step-by-step instructions for creating project finance models suitable for analyzing complex transactions.

What You'll Learn:

• Project Finance Fundamentals: Understand the core principles of project finance and its role in assessing risk-reward for infrastructure investments.
• Complex Model Building: Master the financial modeling of complex, real-life project finance transactions from scratch in Excel.
• Debt Optimization: Learn how to sculpt debt to a target DSCR (Debt Service Coverage Ratio).
• Advanced Excel Techniques: Discover best practice macros and VBA codes to avoid circular references and automate tasks.
• Reserve Account Modeling: Model Debt Service Reserve Accounts and Maintenance Reserve Accounts effectively.
• Financing Structures: Model Shareholder Loans, Revolvers, and Blended Equity IRR scenarios.
• End-to-End Model Development: Build project finance models in Excel covering the entire project lifecycle.
• Valuation Analysis: Perform valuation analysis using Discounted Cash Flow (DCF) and Internal Rate of Return (IRR) methods.
• Investor-Ready Models: Prepare trusted project finance models tailored for investors and financiers, with a focus on valuation and risk.
• F.A.S.T. Standards: Develop financial models designed according to F.A.S.T. standards for enhanced credibility.

Why Choose Our Complete Project Finance Modeling Course?

• Realistic Training: Over 9 hours of instructor-led video content provides realistic project finance training you can learn at your own pace. Build complex models and gain practical skills.
• Affordable Investment: Save significantly compared to traditional courses (US$1000 - US$2500) while gaining valuable project finance modeling skills.
• Learn Anytime, Anywhere: Our 100% online course offers flexible learning, accessible from any device.

Course Structure:

1. Project Finance Theory: Review essential components of project finance transactions.
2. Toll Road Case Study: Analyze a real-world toll road project finance case study and explore modeling techniques.
3. Model Construction: Build a fully integrated, 3-statement financial model (Income Statement, Balance Sheet, Cash Flow Statement), covering construction costs and financing fees.
4. Advanced Modeling: Model coverage ratios, debt sculpting, Debt Service Reserve Accounts, Maintenance Reserve Accounts, Revolvers, and Shareholder Loans. Perform DCF and IRR valuation.
5. Automation & Scenario Analysis: Introduce equity first funding method, debt sizing automation, debt service reserve account automation, and scenario analysis.

Who is this course for?

This course is ideal for analysts, managers, senior managers, associate directors, financial advisors, financiers, and CFOs working in infrastructure, oil & gas, or mining sectors. Whether you need to build, review, or analyze project finance models, this course equips you with the necessary skills.

Prerequisites:

• Prior Excel experience in a financial modeling context.
• Basic understanding of investment concepts such as NPV and cash flows.