Free case files

How to Ace the Toughest Project Finance Modeling Tests

Take on the advanced versions of the modeling test: integrate the three financial statements in a project finance model, size debt on P50 and P99 production, and rehearse with two mock interview exams. The case files are free.

Free Preview: Get the Case Files See the Full Course

  • 2 case studies
  • 2 model start files

New to modeling tests? Start with How to Pass a Project Finance Modeling Test.

5,000+ professionals

50 interview questions

How to Ace the Toughest Project Finance Modeling Tests: the walkthrough of the first challengeWatch · 1:04:05

Your free files

  • PDFCase study 1Three-statement integration
  • XLSXModel start file 1For the three-statement challenge
  • PDFCase study 2P99-constrained debt sizing
  • XLSXModel start file 2For debt sizing on P50 and P99

Inside the course

What the Toughest Tests Ask of You

Two challenges with walkthroughs, a model extension and two mock interview exams. Select a part to see what it asks of you, and where the RVA Certification Program takes it further.

  1. Challenge 1Three financial statements

    Challenge 1 · 1:13:23 of video · 15 quiz questions

    Integrate the Three Financial Statements

    You receive a case study and a model start file. The task: integrate the income statement, the balance sheet and the cash flow statement in a project finance model. Four short lessons explain how the statements interlink, and the walkthrough builds the solution step by step.

    In the RVA Certification ProgramExcel DNA for Project Finance Modeling has a chapter on the three financial statements and builds a balance sheet check into its model.
  2. Challenge 2Debt sizing on P50 and P99

    Challenge 2 · 1:27:44 of video · 6 quiz questions

    Size Debt on P50 and P99 Production

    The second case study sets two DSCR constraints at once: one on P50 production and one on P99 production. Three short lessons cover P50, P75 and P90 energy yield, the standard uncertainty and the Excel function NORM.INV, and the walkthrough models the dual constraint.

    In the RVA Certification ProgramExpert-Level Project Finance Modeling for Renewable Energy covers P50, P75 and P90 energy yield and the standard uncertainty behind them in the setup of its monthly model.
  3. ExtensionTax loss carryforward

    Model extension · Excel model · 5 quiz questions

    Extend the Model with a Tax Loss Carryforward

    The model extension adds a tax loss carryforward account to the project finance model. You download the extended model and check your understanding in a quiz.

    In the RVA Certification ProgramDeal Lab: Battery (BESS) Project Finance Modeling models tax loss carryforwards on the unlevered and on the levered side of a battery storage project.
  4. Final preparationTwo mock interview exams

    Final preparation · 2 mock exams · 24 questions

    Rehearse the Interview

    Two mock interview exams with 12 questions each close the course, together with a game plan for your interview preparation.

    In the RVA Certification ProgramRVA Body of Knowledge holds 42 readings and 800+ practice questions, among them readings on three-statement integration, on P50 and P99 sizing and on tax losses.

Each part of this course is a subject of the RVA Certification Program.

The full course

Everything in the Course

The Free Preview holds the two case studies and the two model start files. The full course adds the two walkthroughs, the extended model with a tax loss carryforward and 50 interview questions, 24 of them in two mock interview exams.

18
Challenge Overview – Integrating the 3 Financial Statements
Interlinking the Financial Statements CFS, IS, and BS
Understanding the Cash Flow Statement (CFS)
Undertanding the Income Statement (IS)
Understanding the Balance Sheet (BS)
How to Integrate the 3 Financial Statements in a Project Finance Model
Interview Prep Quiz: Integrating the 3 Financial Statements
Case Study Overview – Sizing Debt Using P50 and P99 Production
Comparing P50, P75, and P90 Energy Yield
Standard Uncertainty and its Influence on Energy Yield Distribution
Excel: NORM.INV() Function
Sizing Debt on P50 vs. P99 Production – How to Model Dual DSCR Constraints
Interview Prep Quiz: P50 vs. P99 Debt Sizing (Yield-Based Constraints)
Download: Extended Model with Tax Loss Carryforward (TLCF)
Quiz: Tax Loss Carryforward (TLCF) — Purpose & Mechanics
How to Use This Section (Your Interview Prep Game Plan)
Mock Interview Exam 1
Mock Interview Exam 2

instructor

Your options

Take One Step, or the Whole Path

How to Pass and How to Ace are sold separately. The RVA Certification Program includes both, and everything behind the tests.

Step 1 · Start here

How to Pass

1 course1-year access

The standard 2-hour test, from a blank Excel sheet:

  • Free case study files
  • The full walkthrough (2:00:30)
  • The completed model in Excel
  • 50 interview questions and a cheat sheet

See How to Pass

Step 2 · This course

How to Ace

1 course1-year access

Everything in the Free Preview, and in addition:

  • Two walkthroughs and seven short lessons, with 2:41 hours of video
  • The extended model with a tax loss carryforward (Excel)
  • Two mock interview exams
  • 50 interview questions in total

Buy the Full Course

Both steps, and the complete path

RVA Certification Program

9 coursesYearly or Lifetime

Both test courses, and everything behind the tests:

  • How to Pass and How to Ace
  • 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

*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

Ace the Tests. Then Master What They Test.

This course is part of the RVA Certification Program, the complete path from a first model to expert-level project finance modeling for solar, wind and battery storage.

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

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!

by James D.

Advanced Renewable Energy Financial Modeling

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

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!

by Abid M.

Advanced Renewable Energy Financial 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 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

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

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

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

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

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

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

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

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.

by Juan V.

Advanced Renewable Energy Financial 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

Walk Into the Toughest Tests Prepared.

Start with the free case files. When you want the full path, the RVA Certification Program takes you from these challenges to expert-level project finance modeling.