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.
Free case study files
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
50,000+ views on YouTube
5,000+ professionals
Watch · 2:00:30Your free files
How it works
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.
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.
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.
Compare with the walkthrough
The full walkthrough builds the same model step by step and explains every formula, link and logic choice.
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
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.
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.
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.
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.
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.
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.
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
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.
Three ways to prepare
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.
This course
Full Course
1 course1-year access
Everything in the Free Preview, and in addition:
The complete path
RVA Certification Program
9 coursesYearly or Lifetime
This course, and everything behind the test:
*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
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.
Interview preparation
Specialization
Core curriculum Required for the RVA Certification
Energy System FundamentalsHow the grid works, how power prices form, and what solar, wind and batteries change.
Excel DNA for Project Finance ModelingYour first complete model, from the information memorandum to NPV, IRR, CoC and DSCR.
Advanced Renewable Energy Financial ModelingA detailed model with sculpted debt, valuation and an investment dashboard.
Expert-Level Project Finance Modeling for Renewable EnergyA monthly model with advanced debt structures and scenario analysis.
RVA Body of KnowledgeThe theory behind the models. Required from January 1, 2027.
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.
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.
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.
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.
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.
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.
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
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 — 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
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
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
Our students have enhanced their careers by mastering financial modeling for renewable energy & storage projects. Here are just a few of their success stories.
Bala
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
Sebastien
Great Training
Nurlan
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.
Andrey
excellent course
excellent course with a lot of useful technical insights, clearly presented, with nice tests at the end. Highly recommended.
Kristof
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.