Project Neptune case study

Expert-Level Project Finance Modeling for Renewable Energy

Work with a professional-grade monthly project finance model the way deal teams do: structure the debt, build in a debt service reserve facility, run ten scenarios and choose between two bank proposals. Every step is on video.

See Enrollment Options See the Full Course

  • 8 hours of video
  • Two final models in Excel
  • Lifetime access

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

5,000+ professionals

57 lessons

Expert-Level Project Finance Modeling for Renewable Energy: the video of the courseWatch the video

Included in the course

  • XLSBModel start fileThe monthly model of Project Neptune
  • XLSBFinal models for Bank 1 and Bank 2One for each bank proposal
  • PDFInformation memorandumThe deal you analyze
  • PDFFinancing partner decisionBank 1 vs. Bank 2, worked through

How it works

From the Information Memorandum to the Financing Decision

You work on Project Neptune the way an analyst works on a live deal, alongside the videos: you set up the model, structure the debt and test the deal.

  1. Read the case

    Project Neptune comes with an information memorandum and a list of analysis tasks. They tell you what the model has to answer.

  2. Set up the model

    You enter the assumptions of the deal into the monthly model and learn what each input drives.

  3. Structure the debt

    You sculpt the senior debt to a target DSCR, add a reserve account and letters of credit, and build a debt service reserve facility into the model.

  4. Run the scenarios and decide

    Ten scenarios test the deal, from the downside scenario to a cash sweep. Then you compare two bank proposals and choose the financing partner.

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

Inside the course

8 Hours of Video in Four Stages

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

  1. 2:41:04Case and inputs

    Stage 1 · Chapters 1 and 2 and chapter 3, part 1 of 2 · 2:41:04 of video

    Meet Project Neptune and Set Up the Model

    After the introduction you read the case study with its analysis tasks and the information memorandum of Project Neptune. Then you get to know the monthly model and enter the assumptions of the deal: general and time-dependent inputs, construction and development costs, power generation and revenue, operating costs and the decommissioning reserve account. Short lessons explain the EPC agreement, interbank offered rates, the power purchase agreement and P50, P75 and P90 energy yield. Two quizzes check the basics.

    In the RVA Certification ProgramAdvanced Renewable Energy Financial Modeling builds a detailed model with sculpted debt, valuation and an investment dashboard.
  2. 1:51:00Debt structuring

    Stage 2 · Chapter 3, part 2 of 2 · 1:51:00 of video

    Structure the Senior Debt

    Short lessons explain the DSCR, debt sculpting with a target DSCR, the LLCR and interest rate swaps. Then you set up the sculpted tranche of the senior debt, the debt service reserve account and the letters of credit. Equity, shareholder loan, dividend and tax assumptions complete the debt sizing case. Two quizzes cover interest rate swaps and letters of credit.

    In the RVA Certification ProgramRVA Body of Knowledge explains the theory behind the models, from energy markets to debt structuring and battery storage.
  3. 1:07:49Reserve facility

    Stage 3 · Chapter 4 · 1:07:49 of video

    Build a Debt Service Reserve Facility Into the Model

    This is the hands-on modeling part of the course: you implement a debt service reserve facility in the model, step by step. A case study then compares the facility with the reserve account and shows what each does to the IRR.

    In the RVA Certification ProgramHow to Ace the Toughest Project Finance Modeling Tests covers three financial statements, debt sizing on P50 and P99, and two mock interview exams.
  4. 2:31:17Scenarios and decision

    Stage 4 · Chapters 5 and 6 · 2:31:17 of video

    Run Ten Scenarios and Choose the Bank

    You run ten scenarios on the proposal of the first bank: debt sizing, the equity base case, breakeven energy yield, merchant breakeven price, lower merchant prices, a downside scenario, an extended lifetime, a fully merchant case with full equity, an Opex sensitivity and a cash sweep. Then you run all scenarios for the proposal of the second bank and decide which financing partner to choose.

    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.

Expert-Level Project Finance Modeling for Renewable Energy is one of the four core courses of the RVA Certification Program.

The full course

Everything in the Course

Six chapters with 57 lessons and 8 hours of video. You receive the model start file, a checkpoint file, the final models for both bank proposals and the documents of the case study.

5.0 /5
(8)

57
Course Introduction
Course Objective
Learning Outcomes
Introduction to Project Neptune – Case Study and Analysis Tasks
Project Neptune: Information Memorandum
Project Finance Basics
Project Finance Basics Quiz
Introduction to Advanced Project Finance Model
General Inputs and Assumptions
Understanding Depreciation, Amortization, and Goodwill
Engineering, Procurement, and Construction (EPC) Agreement
Construction and Development Costs
Understanding Interbank Offered Rates
Time-Dependent Inputs
What is a Power Purchase Agreement (PPA)?
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
Renewable Energy Basics Quiz
Power Generation and Revenue Assumptions
Fixed and Variable Operational Expenditures (Opex)
Decommissioning Reserve Account Setup
Interpreting the Debt Service Coverage Ratio (DSCR)
Debt Sculpting with Target DSCR
Understanding the Loan Life Coverage Ratio (LLCR)
Interest Rate Swaps: Understanding and Implementing Hedging Strategies
Interest Rate Swaps Quiz
Senior Debt - Sculpted Tranche
Introduction to a Debt Service Reserve Account (DSRA)
Debt Service Reserve Account (DSRA)
Introduction to Letters of Credit (LCs)
Letters of Credit in Project Finance Quiz
Letters of Credit (LCs)
Equity, Shareholder Loan, and Dividend Assumptions
Tax Assumptions and Finalizing the Debt Sizing Case
Introduction to a Debt Service Reserve Facility (DSRF)
Step-by-Step Implementation of DSRF in the Financial Model
Understanding the Internal Rate of Return (IRR)
Case Study IRR Optimization: DSRA vs. DSRF
Scenario 1: Debt Sizing (Bank 1 Proposal)
Interpreting the Net Present Value (NPV)
Scenario 2: Equity Base Case
Excel’s Power Unveiled: Goal Seek Function
Scenario 3: Breakeven Energy Yield
Scenario 4: Merchant Breakeven Price
Scenario 5: Lower Merchant Prices
Scenario 6: Downside Scenario
Scenario 7: Extended Lifetime
Scenario 8: Fully Merchant & Full Equity
Scenario 9: Opex Sensitivity
The Mechanics of Cash Sweep: How It Works and Why It's Used
Scenario 10: Cash Sweep (Debt Sizing Case)
Running All Scenarios for Bank 2 Proposal
Final Financing Partner Decision: Bank 1 vs. Bank 2
Review of Key Learnings
Case Study Conclusion

instructor

5.0 /5
(8)

  • Avatar
    Gabriela
    (5)
    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!

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

  • Avatar
    VISHAL
    (5)
    Exceptional course. Give it a try!

    This course has been excellent. One of the very best on the market. First the depth of the course and modeling skills are first class. It's clear Lukas has put a lot of effort and thought how to develop this course. What I especially like is the variety of scenarios and cases we model, just as a sponsor would look at it. Lukas walks us through each module and explains the impact it has on the model. One piece of advice I would give anyone is please do the advanced renewable modelling first before trying this course. Being able to develop the model from scratch greatly benefits doing this course which is more to do with using the model. I look forward to more courses like this in the future!

  • Avatar
    Costantino
    (5)
    Very useful for project finance decision making

    The case provided is very useful to understand the typical analysis required to select the best project finance terms

  • Avatar
    Yinka
    (5)
    Best Couse on Project Finance Modeling

    This course is awesome and the best course I have undergone on project finance.

  • Avatar
    Heráclito
    (5)
    Intuitive and relevant

    The Expert-Level Project Finance Modeling for Renewable Energy course by RVI is very intuitive and relevant for professionals working with renewable energy Project. I have the opportunity to learn new financial and engineering concepts and also review old ones in a new perspective. Thank you!

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

  • Avatar
    Marek
    (5)
    amazing

Your options

Take This Course, or Take the Whole Path

Expert-Level Project Finance Modeling for Renewable Energy 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 work through the case:

  • 6 chapters with 57 lessons and 8 hours of video
  • The monthly model: start file and checkpoint file
  • The final models for both bank proposals
  • The documents of Project Neptune, from the information memorandum to the financing decision
  • The certificate of completion

Buy This Course Only

The complete path

RVA Certification Program

9 coursesYearly or Lifetime

This course, and everything around it:

  • Expert-Level Project Finance Modeling for Renewable Energy
  • 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

Want to build a model from scratch first? Start with Advanced Renewable Energy Financial Modeling.

*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

Expert-Level Project Finance Modeling for Renewable Energy is one of the four core courses that the RVA Certification requires. In the core curriculum it follows Advanced Renewable Energy Financial Modeling.

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

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

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

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

Take the Deal From Term Sheet to Financing 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.