Solar project case study

Advanced Renewable Energy Financial Modeling

Build a detailed project finance model of a solar project in Excel, from the start file to the investment dashboard, with sculpted debt, macros, three financial statements and a full valuation. Every step is on video.

See Enrollment Options See the Full Course

  • 15 hours of video
  • Final model in Excel
  • Lifetime access

One of the four core courses of the RVA Certification Program.

5,000+ professionals

86 lessons

Advanced Renewable Energy Financial Modeling: the video of the courseWatch the video

Included in the course

  • XLSBFinal financial modelThe solar project, with its dashboard
  • XLSBStart file and 3 checkpoint filesCompare your work as you build
  • XLSBModel for high interest ratesA second version of the final model
  • PDFInformation memorandumThe project you will model

How it works

From the Start File to the Investment Dashboard

You build the model yourself, sheet by sheet, alongside the videos. Every formula and every macro is built on screen.

  1. See the finished model

    The course opens with the dashboard of the final model, so you know what you are building. Then you download the model start file.

  2. Build along with the videos

    You follow the modeling steps on screen, with the shortcuts shown as they are used. Four quizzes drill the shortcuts.

  3. Compare at the checkpoints

    Three checkpoint files hold the model as it stands at three points of the course, so you can compare your work or continue from there.

  4. Value the project and present it

    You measure the returns from the developer's and the investor's perspective and bring the results into an investment dashboard with charts.

See Enrollment OptionsThis course on its own, or the whole RVA Certification Program.

Inside the course

15 Hours of Video in Five Stages

The width of each stage shows its share of the video time. Select a stage to see what you build in it, and where the RVA Certification Program takes it further.

  1. 3:25:45Framework and revenues

    Stage 1 · Chapter 1 and chapter 2, part 1 of 3 · 3:25:45 of video

    Set Up the Framework and Model the Revenues

    You start with the dashboard of the final model and the model start file, then set up the technical inputs, the scenario selection, the timing sheet with the model timeline, and the macroeconomic inputs. With the contractual relations of a project finance deal and the information memorandum in hand, you model the uses and sources of funds, a checks sheet, power generation with availability, degradation and seasonality, and PPA and merchant revenue. Four quizzes drill the shortcuts.

    In the RVA Certification ProgramExcel DNA for Project Finance Modeling teaches the model timeline, flags, named ranges and keyboard shortcuts.
  2. 2:17:48Costs and reserves

    Stage 2 · Chapter 2, part 2 of 3 · 2:17:48 of video

    Add Operating Costs, Reserve Accounts and Depreciation

    You model the operating expenditures, the major maintenance reserve account, the decommissioning reserve account and the cash reserve of the project company. Working capital adjustments, accounting and tax depreciation, and the income statement follow.

    In the RVA Certification ProgramRVA Body of Knowledge explains the theory behind the models, from energy markets to debt structuring and battery storage.
  3. 4:33:00Debt, equity and taxes

    Stage 3 · Chapter 2, part 3 of 3 · 4:33:00 of video

    Structure the Debt and Break the Circularities

    You model a linear and a sculpted debt repayment structure, the debt service coverage ratio and the debt service reserve account, then shareholder loans, dividends and the three financial statements. Macros written in VBA break the circularities of the model: one for debt interest and principal, one for the capital structure, and a master macro. Corporate and local taxes and the interest barrier complete the stage.

    In the RVA Certification ProgramExpert-Level Project Finance Modeling for Renewable Energy goes on to the LLCR, a debt service reserve facility, cash sweeps and a comparison of two bank proposals.
  4. 2:24:27Valuation

    Stage 4 · Chapter 3 · 2:24:27 of video

    Value the Project From Two Perspectives

    You build the valuation sheet: levered and unlevered IRR and NPV, FCFE over invested equity, and the payback period. Then you compare the developer's and the investor's perspective, and a macro solves for the enterprise value at a target IRR.

    In the RVA Certification ProgramDeal Lab: Battery (BESS) Project Finance Modeling takes the same return metrics to a battery storage project and compares its revenue stacks and risk cases.
  5. 2:24:35Dashboard

    Stage 5 · Chapter 4 · 2:24:35 of video

    Build the Investment Dashboard

    You bring the results into a dashboard: general project information, capital structure, valuation summary, revenue metrics, and investment ratios and multiples. Charts show contracted and merchant revenue, FCFE over equity, the cash flow waterfall and the DSCR. The course closes with the use of different scenarios and the final model.

    In the RVA Certification ProgramHow to Pass a Project Finance Modeling Test has you build a full project finance model from a blank Excel sheet in two hours.

Advanced Renewable Energy Financial Modeling is one of the four core courses of the RVA Certification Program.

The full course

Everything in the Course

Four chapters with 86 lessons and 15 hours of video. You receive the model start file, three checkpoint files, the final model in Excel and the Financial Model User Guide.

5.0 /5
(10)

86
Course Introduction
Final Model - Dashboard
Download Start File
Introduction to Start File
Technical Inputs
Scenario Selection
Shortcuts Quiz #1
General Inputs
Shortcuts Quiz #2
Timing Sheet
Model Timeline
Macroeconomics
Shortcuts Quiz #3
Project Finance - Contractual Relations
Information Memorandum
Download Checkpoint File
Uses of Funds
Sources of Funds
Shortcuts Quiz #4
Creating Checks
Checks Sheet
Depreciation Categories
Power Generation Inputs
Availability, Degradation & Seasonality
Net Power Generation
PPA & Merchant Inputs
Generation Allocation (PPA vs Merchant)
PPA & Merchant Revenue
Operational Expenditure Inputs
Operational Expenditures
MMRA Inputs
Major Maintenance Reserve Account
Decommissioning Reserve Account Inputs
Decommissioning Reserve Account
SPV Cash Reserve
Working Capital Adjustments
Accounting & Tax Depreciation
Depreciation Summary & Income Statement
Tax Inputs
Debt Financing Inputs
Linear Debt Repayment Structure
Sculpted Debt Repayment Structure
Applied Debt & Breaking Circularities
Macro Sheet
Debt Interest & Principal Macro
Debt Service Coverage Ratio
Equity Inputs
Shareholder Loan Interest & Principal
Dividends, CFS, ICS & BS
Capital Structure Macro
Master Macro
Interest Barrier
Corporate Tax
Trade Tax, Other Local Taxes & SHL Interest Macro
Unlevered Taxes
Debt Service Reserve Account
Download Checkpoint File 2
Valuation Sheet
Levered Internal Rate of Return (IRR)
Adjusting SHL Payments
Levered Net Present Value (NPV)
FCFE / Invested Equity
Payback Period
Unlevered Project Return
Unlevered Equity Return
Unlevered IRR & NPV
Unlevered FCFE / Equity & Payback Period
Developer's vs. Investor's Perspective
Enterprise Value @Target IRR Macro
Master Macro Developer's Perspective
Master Macro Investor's Perspective
Download Checkpoint File 3
Dashboard Sheet
General Project Info
Capital Structure
Valuation Summary
Revenue Metrics
Investment Ratios & Multiples
Charts Sheet
Contracted vs. Merchant Revenue Chart
FCFE / Equity Chart
Cashflow Waterfall Chart Inputs
Cashflow Waterfall Chart
Debt Service Coverage Ratio Chart
Using Different Scenarios
Download Financial Model End File

instructor

5.0 /5
(10)

  • Avatar
    Roberto
    (5)
    Best Project Finance Modeling Course

    I have taken the CFI and Wallstreep Prep modeling courses and have found this to be the most complete one by far. Specifically, the debt sizing and debt sculpting macro is something that even banks and financial consultants fail to do properly. The layout and focus on presentation and organization was also very important. The structure where you go along with the video modeling yourself is very helpfull. I missed this in the expert level where you just use the finished model instead of building it yourself. I would recommend adjusting the expert course to be a modelling course that takes de advanced model to the finished expert model and than you run the scenarios analysis. Best,

  • Avatar
    Marek
    (5)
    amazing

    amazing

  • Avatar
    Nicklas
    (5)
    Highly recommended!

    I can highly encourage everyone that is interested and / or working in Renewable Energy Finance to sign up for this course. Lukas provides with you with all the knowledge and skills necessary to build integrated and flexible financial models, that live up to the highest industry standards. He explains everything perfectly and extensively and even repeatedly shows Excel shortcuts. All in all, the perfect course! I really enjoyed it!

  • Avatar
    Ioannis
    (5)
    Advanced Renewable Energy Financial Modeling Review

    The course is robust and well-structured, thoroughly covering the essentials of project finance modeling. The inclusion of real-world case study and practical modeling exercises significantly enhances the learning experience. Lukas Duldinger demonstrates a high level of professionalism and expertise in the field of project finance. What sets this course apart is the instructor's dedication to teaching. He is not just knowledgeable, but also genuinely committed to sharing that knowledge with students. The passion for the subject matter is evident in his teaching style, making complex concepts more accessible and engaging. As a student, I found the course to be immensely valuable. It has deepened my understanding of project finance modeling and equipped me with practical skills that I can apply in real-world scenarios. The lessons are well-paced, and the materials provided are of high quality, serving as great references for future use. This course is a testament to Lukas' expertise and dedication to education in project finance modeling. I highly recommend it to anyone looking to enhance their skills in this area. Whether you are starting from scratch or looking to deepen your existing knowledge, this course offers a wealth of information and insights that are both practical and relevant. I am grateful for the opportunity to have taken this course and for the invaluable knowledge imparted by Lukas. It's an experience that has not only enriched my understanding but also sparked a deeper interest in project finance modeling.

  • Avatar
    Simon
    (5)
    Outstanding Course

    Lukas has assembled a very thorough educational course that enables real world financial modelling experience as well as background literature to understand the theory and practice. Given Lukas has real world experience building and implementing financial models and also understands what happens in practice it is an invaluable course for practitioners, aspiring renewable energy industry participants and anyone looking to implement best practice financial models.

  • Avatar
    VISHAL
    (5)
    Financial modelling

    This is an excellent course. Detailed, easy to follow and very interesting. These types of courses are worth times times more than the price charged in my opinion. It would take several deals and many months of experience to be able to get this this level and it would give you the edge amongst your peers in the workplace.

  • Avatar
    Juan
    (5)
    Great Course

    This is one of the most complete financial models I have seen and is very useful for my projects. It's really worth the investment.

  • Avatar
    Marie
    (5)
    Excellent course!!!

    100% recommended!! Great pace to grasp everything & hands-on practice.

  • Avatar
    Abid
    (5)
    Great course with practical knowledge

    I am working in the project finance field for a few years now and always wanted to learn how to build a project finance model from scratch. The final model is perfectly adjustable to any project and I finally learned how the financial statements work together. Thank you very much for making this knowledge available!

  • Avatar
    James
    (5)
    Great content for affordable price

    I have learned more about project finance modeling in this online course than I did in in-person trainings my employer paid much more for... Thank you so much for putting together this fantastic course!

Your options

Take This Course, or Take the Whole Path

Advanced Renewable Energy Financial Modeling is sold on its own, and it is one of the four core courses of the RVA Certification Program.

This course

This Course Only

1 courseLifetime access

Everything you need to build the model:

  • 4 chapters with 86 lessons and 15 hours of video
  • The model start file and three checkpoint files
  • The final model in Excel, with a version for high interest rates
  • The information memorandum of the case study
  • The certificate of completion

Buy This Course Only

The complete path

RVA Certification Program

9 coursesYearly or Lifetime

This course, and everything around it:

  • Advanced Renewable Energy Financial Modeling
  • All current and future courses, with 50+ hours of video
  • The RVA Body of Knowledge: 42 readings and 800+ practice questions
  • The RVA Certification
  • Tuition Earn-Back of up to 100%*
  • 30-Day Money-Back Guarantee*

Explore the RVA Certification

New to project finance modeling? Start with Excel DNA for Project Finance Modeling. Its Free Preview opens 16 lessons at no cost.

*Earn-Back & 30-Day Guarantee are available only with the RVA Certification Program. Earn-Back applies to the first Yearly payment (cancel anytime) or the full one-time Lifetime fee. One payout per student, capped at 100% of tuition paid (excl. taxes/fees/FX). Not for single-course purchases and not combinable with the 30-day guarantee on the same order. For all details see FAQ on RVA Certification page.

Where this course leads

One of the Four Core Courses of the RVA Certification

Advanced Renewable Energy Financial Modeling is one of the four core courses that the RVA Certification requires. In the core curriculum it stands between Excel DNA for Project Finance Modeling and the Expert-Level course.

The destination

Earn the RVA Certification

The RVA Certification is earned by completing the four core courses. From January 1, 2027, it also requires the RVA Body of Knowledge.

  • 9courses
  • 50+hours of video
  • 42readings
  • 800+practice questions

Explore the RVA Certification See Plans

I joined the Renewables Valuation Analyst Programme with no financial modelling experience at all. Since then, I’ve completed the Excel DNA and Advanced courses, and I regularly rebuild the interview-level financial model to keep the model logic and flow fresh. Lukas is a fantastic teacher with incredible depth of knowledge. He’s very responsive through the chat function, and the handbooks that accompany the video lectures add real depth to the learning. I’d highly recommend the programme to anyone starting from scratch, as I did, or looking to build on an existing skill set in renewable energy financial modelling.

Will Hunt Energy M&A Analyst, Carter Jonas

Coming from a private equity and strategic finance background, I had strong financial modeling and underwriting experience but lacked direct exposure to renewable energy. The RVA Certification Program provided a clear, concise overview of how the industry works and translated that knowledge directly into building practical, project-level financial models. The content is detailed, actionable, and easy to follow, making it valuable regardless of your prior experience.

Gavin Smith, CFA Principal, Powering America Capital

As a Chartered Accountant currently working in an investment analysis role with a developer with a prior background in project finance modelling advisory in a large accounting firm, I had a good understanding of modelling best practices for project finance, but was always wary of the potential gaps in my experience from not going through a more traditional route such as investment banking. The RVA Certification was excellent in plugging gaps in my knowledge and really helped with the understanding of the "why" of different concepts in both renewable energy and project finance in a practical manner, and has really helped build my confidence in the sector. I would recommend to someone at any stage in their career.

Richard Akpan Investment Associate, Corporate Development at Energia Group

As someone with over a decade of experience in the renewable energy sector, I highly recommend the Renewables Valuation Analyst Certification Program by RVI. The program offers a comprehensive and practical approach to financial modeling, designed specifically for renewable energy projects. Its depth and clarity make it an invaluable resource for analysts and teams working on real renewable energy transactions.

Jonas Benholz Founder & CEO, IOTA Energy

With many years of experience in infrastructure investing, I highly recommend the RVA Certification Program to anyone working seriously in renewable energy finance. The courses go far beyond Excel mechanics and focus on how project finance models are actually built, structured, and used in real transactions. The models are intuitive, flexible, and immediately applicable — exactly what analyst teams need in practice.

Timo Werner, CFA Fund Manager

EARN BACK UP TO 100% OF TUITION — WORKS ON INDIVIDUAL PLANS

Choose Your RVA Certification Plan

Master financial modeling for solar, wind, and battery storage projects — at your own pace.

Most Popular

Yearly Access

$597/year

Renews every 12 months · Cancel anytime

Get Full Year Access

Earn your RVA Certification while enrolled

All current and future courses included

RVA Body of Knowledge: 42 readings

Tuition Earn-Back eligible (first payment)

30-Day Money-Back Guarantee

Earn-Back and guarantee eligibility details in FAQ

Best long-term value

Lifetime Access

$997

One-time payment, permanent access

Get Lifetime Access

Lifetime access — no renewals, no expiry

All current and future courses included

RVA Body of Knowledge: 42 readings

Tuition Earn-Back fully re-earnable

30-Day Money-Back Guarantee

Earn-Back and guarantee eligibility details in FAQ

Most Popular

Team Yearly

$495 per seat / year

vs. $597/seat on Individual plan · Min. 2 seats

Get Team Access

Standardize modeling skills across your team

All current and future courses during access period

RVA Body of Knowledge: 42 readings

Yearly Renewal opt-in only

30-Day Pilot Period

Best long-term value

Team Lifetime

$797 per seat

vs. $997/seat on Individual plan · Min. 2 seats

Get Team Access

Permanent seats — no renewals, no expiry

All current and future courses included

RVA Body of Knowledge: 42 readings

One-time payment

30-Day Pilot Period

Helping over 5,000 students excel in renewable energy & storage finance

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

Project Finance Modeling Test

I used these courses to prepare for a financial modelling test for an Infrastructure role at RBC Capital Markets in London. When I opened the test, I was genuinely surprised by how well the course material mapped to what was being tested — concepts like three-statement modelling, debt sizing and sculpting under a target DSCR, and levered vs unlevered IRR were all directly relevant. The course gave me not just the mechanics but the intuition behind why these tools are used in project finance, which made a real difference when I had to explain my decisions during the debrief. I'm pleased to say I made it through to the final rounds with the team.

by Nurlan A.

How to Pass a Project Finance Modeling Test

Well worth it

Hi, I work in the Solar and BESS space as an Investment Associate and I would highly recommend the RVI courses. - Great best practice content in terms of layouts - Great styles that are downloadable - Easy to follow videos (definitely use 2 screens) and a very well structured course - More complex concepts are well explained and structured (debt sizing and circularity) - Good value for money (I bought the lifetime access).

by David R.

Deal Lab: Battery (BESS) 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

Comprehensive and Practical Approach to Renewable Energy Project Finance

This course delivers exactly what the title promises: Expert-level instruction in renewable energy project finance modelling. The content strikes excellently practical application of financial modelling, making it valuable for both experienced professionals and those seeking to deepen their expertise. Lukas's treatment of financial modeling concepts is methodical and well-structured. The modelling exercises provide hands-on practice that reinforces learning and builds confidence in working with complex financial scenarios. What particularly impressed me was technical expertise to implement every single detail of term sheet and conditions into excel model and visually attractive template design. Moreover, I've never seen the most advanced debt structure model like this in anywhere else. The progression from foundational concepts to advanced modelling techniques is logical and allows participants to build competency incrementally. By the end, I'm equipped to develop sophisticated financial models that capture the true economics of renewable energy investments. Minor note: Additional case studies from emerging renewable topics (Carbon Capture Transportation and Storage, Green Hydrogen etc.) could further strengthen an already excellent curriculum.

by Taek-Hyun K.

Expert-Level Project Finance Modeling for Renewable Energy

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.

by Thomas T.

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

Fantastic and thank you

The course was fantastically organized, with impressive work behind it that truly facilitates learning. It strikes a very balanced mix between theory and hands-on work that couldn't be fully grasped otherwise. Super useful for any professionals looking to refresh or improve their project finance skills. It's best to work with two screens. Highly recommended!

by Gabriela D.

Expert-Level Project Finance Modeling for Renewable Energy

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

Renewables Valuation Analyst (RVA) certification

The course offers a thorough exploration of project finance modeling, equipping learners with essential knowledge, practical skills, and advanced techniques to build confidence in model development. It systematically addresses critical components of project finance models, with step-by-step instruction delivered with clarity and expertise. The curriculum is robust and meticulously designed, making it an invaluable resource for professionals aspiring to excel in the field of project finance.

by Elchin F.

Expert-Level Project Finance Modeling for Renewable Energy

Excellent and Practical Learning Experience

Enjoyed solving the quizzes and applying real project finance concepts. The course was well-structured, professional, and gave me practical tools to approach financial modeling tests with confidence. Highly recommend to anyone preparing for project finance or investment roles.

by Kristof P.

How to Pass a Project Finance Modeling Test

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.

by Matheus A.

Excel DNA for Project Finance Modeling

Expert analysis, with detailed content. Highly recommended.

Explained well, especially with the Secret Sauce handout! Also, the 21 scenarios at the end also assisted in sharpening my sense of the key drivers and relationships.

by Ben Z.

Deal Lab: Battery (BESS) 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

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

Good starting point for understanding the larger grid system

Great course to understand how our grid systems work, what inputs change prices and demand, and the merit based energy system at large.

by Bryce B.

Energy System Fundamentals

Great course

Professional and well arranged, thank you Lukas.

by Faisal I.

Excel DNA for Project Finance Modeling

Build the Model Behind the Investment Decision.

Take this course on its own, or take the whole path: the RVA Certification Program leads from a first model to expert-level project finance modeling for solar, wind and battery storage.