Free case study files

How to Pass a Project Finance Modeling Test

Build a full project finance model from a blank Excel sheet in two hours, under real interview pressure, and compare your work with a professional solution. The case study files are free.

Free Preview: Get the Files See the Full Course

  • Case study PDF
  • SOFR forward curve
  • Excel formatting template

50,000+ views on YouTube

5,000+ professionals

How to Pass a 2-Hour Project Finance Modeling Test: the full walkthroughWatch · 2:00:30

Your free files

  • PDFCase studyThe project you will model
  • XLSXSOFR forward curveThe interest rate input
  • XLSXExcel formatting templateCell styles for a clean workbook

How it works

From the First Click to Your Finished Model

The test runs the way a modeling test runs in an interview: you receive a case study, you build the model against the clock, and you compare your work with a professional solution.

  1. Get the files

    Open the Free Preview, create your account, and download the case study PDF, the SOFR forward curve and the Excel formatting template.

  2. Build the model in two hours

    Start from a blank Excel sheet: project cash flows, senior debt sculpted to a target DSCR, and equity returns.

  3. Compare with the walkthrough

    The full walkthrough builds the same model step by step and explains every formula, link and logic choice.

  4. Prepare for the interview

    The full course adds the completed model, 50 interview questions and a cheat sheet for the conversation that follows the test.

Free Preview: Get the FilesFree. Create an account to download the files.

Inside the test

How to Spend Your Two Hours

A suggested time allocation for the six stages of the test. Select a stage to see what it asks of you, and where the RVA Certification Program takes it further.

  1. 15–20 minRead and plan

    Stage 1 of 6 · 15–20 minutes

    Read the Case and Plan

    Read the case study before you open Excel. Mark the key assumptions and the outputs that are asked for, and write down a modeling plan. Many candidates lose time on elements that were not required, and others miss a required output because they started too quickly.

    In the RVA Certification ProgramRVA Body of Knowledge explains the theory that a case study assumes, from energy markets to debt structuring and battery storage.
  2. 15–20 minTimeline and inputs

    Stage 2 of 6 · 15–20 minutes

    Timeline and Inputs

    Start from a blank sheet. Lay out the tabs, the timeline and the inputs in a clean, modular way, so that a reader can follow the logic of the model from the first sheet.

    In the RVA Certification ProgramExcel DNA for Project Finance Modeling teaches the model timeline, flags, named ranges and keyboard shortcuts.
  3. 30–40 minProject cash flows

    Stage 3 of 6 · 30–40 minutes

    Project Cash Flows

    Model generation, revenues and operating costs down to the cash flow available for debt service. Link every line to the inputs and avoid hardcoded values, so that the model holds when an assumption changes.

    In the RVA Certification ProgramAdvanced Renewable Energy Financial Modeling adds PPA and merchant revenue, reserve accounts, working capital, depreciation and tax.
  4. 30 minDebt sculpting

    Stage 4 of 6 · 30 minutes

    Debt Sculpting

    Size the senior debt and sculpt its repayment to the target DSCR. This is the stage that tests whether the structure of your model holds.

    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.
  5. 20–25 minReturns and summary

    Stage 5 of 6 · 20–25 minutes

    Returns and Summary

    Calculate IRR, NPV and cash-on-cash metrics and bring them into a clear summary. A reader who opens your workbook should grasp the key results in seconds.

    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.
  6. RemainingFormat and check

    Stage 6 of 6 · Remaining time

    Formatting and Checks

    Use the time that is left for consistent formatting and a final check of the model. If you run out of time, leave a placeholder assumption with a note.

    In the RVA Certification ProgramExcel DNA for Project Finance Modeling builds integrity, signal and master checks into the model.

Each stage of the test is a subject of the RVA Certification Program.

The full course

Everything in the Course

The Free Preview holds the case study files. The full course adds the walkthrough in the course player, the completed model in Excel, 50 interview questions and a cheat sheet.

5.0 /5
(5)

6
Download Files & Get Ready
2-Hour Project Finance Modeling Test
Project Finance Case Study: Interview Challenge
Core Project Finance Concepts
Soft Skills & Deal Discussion
Project Finance Modeling Interview Cheat Sheet

instructor

5.0 /5
(5)

  • Avatar
    Bala
    (5)
    Very useful to prepare for Interviews

    I felt this course was very helpful and heelped me to prepare for interviews. I wish I bought this course way before Pivotal180

  • Avatar
    Sebastien
    (5)
    Great Training

  • Avatar
    Nurlan
    (5)
    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.

  • Avatar
    Andrey
    (5)
    excellent course

    excellent course with a lot of useful technical insights, clearly presented, with nice tests at the end. Highly recommended.

  • Avatar
    Kristof
    (5)
    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.

Three ways to prepare

Choose How Far You Want to Go

Start with the free files. Add the full course for the interview. Take the RVA Certification Program for everything behind the test.

Start here

Free Preview

Free

The case study files for the 2-hour test.

  • Case study PDF
  • SOFR forward curve (Excel)
  • Excel formatting template

Free Preview: Get the Files

This course

Full Course

1 course1-year access

Everything in the Free Preview, and in addition:

  • The full walkthrough in the course player (2:00:30)
  • The completed model in Excel
  • 50 interview questions in three drills
  • The interview cheat sheet

Buy the Full Course

The complete path

RVA Certification Program

9 coursesYearly or Lifetime

This course, and everything behind the test:

  • 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

Pass the Test. Then Master What It Tests.

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.

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

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 Your Modeling Test Prepared.

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