Excel DNA for Project Finance Modeling

5.0 /5

(13)

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

5.0 /5
(13)

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.
Matheus

(5)

Great with a learning by doing approach

The course provides a very good understanding of the basics of Project Finance Modeling, along with good Excel knowledge to accelerate your progress. The standout point of this course is building the model from scratch, which really makes you feel that you are learning and developing a financial model. I’m looking forward to continuing my learning journey in the advanced courses.
Maryem

(5)

Super comprehensive

Loved this course, very comprehensive, very very well explained. There is only one thing I wish was introduced, and that is the concept of debt refinancing/the case of an asset sale in an LBO context. Otherwise, incredible.
Panos

(5)

Great course on Project finance modelling
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.
Gizachew

(5)

Here are the following titles that i covered in excel DNA financial modeling course
Thomas

(5)

Excellent Introduction to Project Finance Modeling

A comprehensive and thorough guide to building a project finance model from scratch. The course includes helpful explanations of key terminology, Excel functions and project finance considerations. The model itself is very robust, clearly laid out and follows best practice modelling standards. The accompanying case study provides practical application, with different cases and assumptions to model in assessing the impact on project returns.
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.
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!
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!
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.

Choose Your RVA Certification Plan

All current & future courses, models, and updates—earn your RVA Certification at your own pace.
Limited-time pricing shown. 30-day guarantee on Yearly & Lifetime.*

Quarterly Access

Start flexible. Explore RVA curriculum without a long commitment. Cancel Anytime.

$297

$ 237 /quarter

Full access to all courses while your plan is active
Eligible to earn RVA Certification during enrollment
Renews every 3 months — cancel anytime
Money-back guarantee applies to Yearly & Lifetime only

Most
Popular

RVA Certification – Yearly Access

Most Popular Plan
30-Day Money-Back Guarantee.*

$497

$ 397 /year

All current courses + new releases for 12 months
Earn your RVA Certification while enrolled
Renews every 12 months — cancel anytime
Includes 30-Day, Put-in-the-Work Money-Back Guarantee (eligibility details below)*

Lifetime Access

One-time payment.
All current & future courses — forever.

$997

$ 697

Best Long-Term Value
Lifetime access to every course, update, and future release
Earn your RVA Certification at your own pace
No renewals or expiry — pay once, keep lifetime access
Includes 30-Day, Put-in-the-Work Money-Back Guarantee (eligibility details below)*

*Guarantee: 30-day money-back applies to Yearly and Lifetime plans only. Quarterly is cancel anytime and not eligible for refunds. Requests must be made within 30 days. Full eligibility criteria are in the FAQ section on the RVA Certification page.

For your security, all orders are processed on a secured server.

Helping over 3000+ students excel in renewable energy finance

Our students have enhanced their careers by mastering financial modeling for renewable energy projects. Here are just a few of their success stories.

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.

by Jeffrey D.

Excel DNA for Project Finance Modeling

Highly recommended!

I can highly encourage everyone interested or working in Renewable Energy Finance to sign up for this course. Lukas provides all the knowledge and skills necessary to build integrated and flexible financial models that live up to the highest industry standards. All in all, the perfect course!

by Nicklas M.

Advanced Renewable Energy Financial Modeling

A must for renewable energy professionals

Lukas has assembled a very thorough course that enables real-world financial modeling experience, along with background literature to understand both theory and practice. This course is invaluable for anyone looking to implement best practice financial models.

by Simon C.

Advanced Renewable Energy Financial Modeling

An excellent learning experience

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

by Heráclito S.

Excel DNA for Project Finance Modeling

Great course

Professional and well arranged, thank you Lukas.

by Faisal I.

Excel DNA for Project Finance Modeling

Building a strong foundation

Excel DNA for Project Finance Modeling by Lukas Duldinger, CFA, is an exceptional course. Despite starting with a higher-level course, I found immense value in revisiting the fundamentals. Lukas presents key concepts clearly, ensuring a solid understanding of both basic and advanced points. Highly recommend it!

by Ioannis T.

Excel DNA for Project Finance Modeling

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 or someone looking to enhance existing skills, this course provides all the 'nuts' and 'bolts' for building robust and dynamic project finance models.

by Gabriel N.

Excel DNA for Project Finance Modeling

Excellent walkthrough on project finance essentials

Having worked in 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!

by Etosha M.

Excel DNA for Project Finance Modeling

Exceptional course

The course is robust and well-structured, thoroughly covering the essentials of project finance modeling. What sets this course apart is Lukas' dedication to teaching, making complex concepts accessible and engaging.

by Ioannis T.

Advanced Renewable Energy Financial Modeling

Excellent course

This is an excellent course. Detailed, easy to follow, and very interesting. These types of courses are worth many times more than the price charged in my opinion. It would take several deals and many months of experience to reach this level.

by Vishal P.

Advanced Renewable Energy Financial Modeling

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.