5.0 /5
(10)

85
Course Introduction
Course Objective
Learning Outcomes
Project Finance Basics
Role of a Special Purpose Vehicle (SPV) in Project Finance
Differentiation of Equity Investors and Debt Providers (Lenders)
Non-Recourse Financing in Project Finance
Navigating the Due Diligence Process in Project Finance
Project Finance Basics Quiz
Introduction to the Case Study & Information Memorandum
Case Study - Analysis Tasks
Benefits of Using Shortcuts
Mastering the Name Manager in Excel
Excel: EOMONTH() Function
Excel Start File - Basic Formatting & Technical Inputs
Shortcuts Quiz #1
Construction & Operation Dates
Shortcuts Quiz #2
Harnessing the Power of Flags in Financial Models
Excel: IF(), AND() & OR() Function
Model Timeline & Conditional Formatting
Shortcuts Quiz #3
Model Currency
Engineering, Procurement, and Construction (EPC) Agreement
Construction & Development Costs
Excel: ISBLANK() Function
Excel: OFFSET() Function
Integrating Multiple Scenarios into the Model
MW vs. MWh: Clarifying the Difference
Unveiling Full Load Hours
Comparing P50, P75, and P90 Energy Yield
Standard Uncertainty and its Influence on Energy Yield Distribution
Excel: NORM.INV() Function
Excel: SUMIF() Function
Power Generation & Revenue Inputs
Power Purchase Agreements (PPAs) and Their Variants
Renewable Energy Basics Quiz
PPA Inputs & Inflation Assumptions
Construction Payment Plan, Conditional Formatting & First Checks
Electricity Price Forecast
Implementing Integrity, Signal & Master Check
Operational Expenditures (Opex) - Fixed Costs Inputs
Operational Expenditures (Opex) - Variable Costs Inputs
Debt Inputs
Equity & Tax Inputs
Interlinking the Financial Statements CFS, I/S, and BS
Understanding the Cash Flow Statement (CFS)
Undertanding the Income Statement (I/S)
Understanding the Balance Sheet (BS)
Financial Statements Quiz
Excel: MIN() Function
Uses of Funds
Sources of Funds
Excel: SUMPRODUCT() Function
Electricity Generation & Generation Allocation
Excel: INDEX() Function
Excel: MATCH() Function
Excel: LOOKUP() Function
Revenue Prices & Total Revenue
Operational Expenditures (Opex) Flags
Operational Expenditures (Opex) Real Terms
Operational Expenditures (Opex) Nominal Terms
Understanding Depreciation, Amortization, and Goodwill
Depreciation, Amortization, and Goodwill Quiz
Income Statement, Depreciation, Amortization, and Goodwill
Balance Sheet & Corporate Taxes
Senior Debt
Interpreting the Debt Service Coverage Ratio (DSCR)
Excel: AVERAGE() Function
Modeling the Debt Service Coverage Ratio (DSCR)
Excel: ROUND() Function
Equity Funding & Balance Sheet Check
Excel: MAX() Function
Cash Account, Dividend Distribution, and Interlinking CFS, IS & BS
Understanding the Internal Rate of Return (IRR)
Excel: XIRR() Function
Modeling the Internal Rate of Return (IRR)
Interpreting the Net Present Value (NPV)
Excel: XNPV() Function
Modeling the Net Present Value (NPV)
Understanding Cash-on-Cash Return (CoC)
Modeling the Cash-on-Cash Return (CoC)
Return Metrics Quiz
Case Study Scenario Analysis
Final Financial Model Wrap-Up & Additional Case Study Exercises

instructor

5.0 /5
(10)

  • Panos
    (5)
    Great course on Project finance modelling

  • Gabriela
    (5)
    An excellent course

    An excellently organised and explained course for learning and refreshing the basics of a financial model for RES projects. Highly recommended. Lukas is a fantastic teacher and has done an uotstanding job preparing this course.

  • Gizachew
    (5)
    Here are the following titles that i covered in excel DNA financial modeling course

  • R.J.
    (5)
    Great intro to applied finance modelling

    The course provides a great mix of theoretical and practical skills. I really liked how the financing knowledge is applied straight away in the excel modelling. It provides a solid base for everyone who would like to grow their skills in project finance. Can definitely recommend it!

  • Faisal
    (5)
    Great course

    Professional and well arranged, thank you Lukas.

  • Jeffrey
    (5)
    Absolutely superb.

    Fantastic walkthrough of model fundamentals and best practice. Extremely well-paced. An essential course for anyone looking to improve their project finance and modeling skills in the renewables space.

  • Gabriel
    (5)
    Project Finance Modeling

    I can confidently affirm that my experience with Excel DNA for Project Finance Modeling has been truly exceptional. Whether you're a novice, eager to make strides in project finance modeling or someone looking to enhance existing skills, this course provides all the "nuts" and "bolts" for building robust and dynamic project finance models. RVI is a game changer and many thanks to Lucas for the generosity of sharing his wealth of experience, providing invaluable guidance, and showcasing his expertise in the Renewable Energy sector. I am well on my way to becoming a world-class financial modeler.

  • Etosha
    (5)
    Excellent walkthrough on the most essential elements of Project Finance for Renewables.

    Having worked for Utility Solar & BESS development, Lukas covers the absolute essentials. If you find yourself wading into unfamiliar financial and commercial analysis this course will help you!

  • Heráclito
    (5)
    Excellent learning experience and well-made material

    The course support material was simple but easy to understand, the tutor has an excellent capacity to explain and guide you through the modelling tasks.

  • Ioannis
    (5)
    Building a strong foundation

    Excel DNA for Project Finance Modeling by Lukas Duldinger, CFA, is an exceptional course, even after starting with the more advanced. Despite beginning with a higher-level course, I found immense value in revisiting the fundamentals through this well-organized program. Lukas presents key concepts clearly with a specialization in Renewables Energy modeling, ensuring a solid understanding of both basic and some advanced points. The course’s structured approach made the learning process smooth and insightful. I don't regret taking this course at all; in fact, it enhanced my overall knowledge. Highly recommend it for anyone looking to build a robust foundation in project finance modeling.

img

Testimonials

Jonas Benholz

Founder & CEO, IOTA Energy

As someone with over a decade of experience in the renewable energy sector, I highly recommend the Renewables Valuation Analyst Certification Program by RVI. This program provides a comprehensive and practical approach to mastering financial modeling, specifically designed for renewable energy projects. It's an invaluable resource for professionals aiming to excel in this field. The program’s depth and clarity make it an essential tool for anyone serious about advancing their career in renewable energy finance.

Timo Werner, CFA

Fund Manager

With years of experience in the infrastructure investment sector, I highly recommend RVI's Advanced Renewable Energy Financial Modeling course. This course guides students through the step-by-step construction of a project finance model from scratch. The resulting model offers exceptional flexibility, allowing users to model nearly any renewable energy project with a clear, intuitive, and user-friendly interface.