
Build the Full Project Finance Model from Scratch
In this lesson, you’ll construct a complete project finance model from a blank Excel sheet — just like in a real interview test. We’ll calculate project IRRs, sculpt senior debt to a target DSCR, analyze equity returns, and more.
This is the type of challenge real employers use to assess candidates for roles in infrastructure finance, investment banking, and private equity. If you can follow along and complete this under the recommended time limit, you’ll already be ahead of many candidates.
Once you’ve completed this walkthrough, keep refining your skills by experimenting with your own variations — for example:
Adjust revenue and cost assumptions
Test different financing structures
Explore more aggressive or conservative debt sculpting
These variations will help you simulate more advanced scenarios and sharpen your ability to adapt under pressure — a key skill in real-world project finance modeling tests.
Beat the real modeling test—under pressure.
Build a clean, bank-ready project finance model from a blank Excel sheet in under two hours while you’re timed—then benchmark your work against a professional solution and drill core interview questions.
This course is part of the Renewables Valuation Analyst (RVA) Certification by Renewables Valuation Institute (RVI) — a complete, start-to-finish roadmap for mastering renewable energy finance and project finance modeling.
The RVA Certification is the one-stop shop for building bank-ready financial models and valuation skills from A to Z. (On RVI directly, students can even earn back up to 100% of their tuition — see the instructor profile for details.)
What this challenge is
A timed, interview-style simulation that mirrors the exact test format employers use. You’ll work from a concise case study brief and build a fully linked, auditable model step-by-step—exactly as top candidates are expected to perform under time constraints.
How it works
Start Pack: Download the case brief, SOFR forward curve, and model styles template so your build is clean and consistent.
The 2-Hour Assessment: From inputs to outputs—lay out drivers, forecast operating cash flows, sculpt senior debt to a target DSCR, and compute equity IRR and payback.
Full Walkthrough: Watch the complete solution. Every formula, link, and structural choice is explained so you can compare and level up to a professional standard.
Interview Drill (50 Questions): Practice the exact questions you’re likely to face—mix of case-specific and fundamentals—to lock in speed and clarity.
Why this prep wins interviews
Hiring teams grade for two things: sound logic and clean execution—at speed. This format trains both: what to model (and skip), how to keep formatting/audit trails tight, and how to communicate assumptions clearly under pressure.
What you’ll walk away with
A fully working model you built under time pressure—proof you can deliver.
A polished reference to benchmark structure, links, checks, and presentation.
A repeatable playbook you can re-run with new prices, capex/opex, tenor/DSCR, etc., to keep sharpening your edge.
Interview-ready speed, structure, and confidence.
What you’ll learn (at a glance)
Simulate a realistic two-hour modeling test from a blank sheet.
Build a complete project finance model (cash flows → debt sculpting → returns).
Apply structured logic, tidy formatting, and transparent checks.
Communicate assumptions crisply and manage time like a pro.
Pathway to the RVA Certification (optional next step)
This course is one module within the broader RVA Certification—RVI’s complete roadmap covering foundations, advanced debt & equity structures, valuation, and case-study execution across technologies.
Credential: Earn the RVA Certification to signal mastery to employers and clients.
Curriculum depth: Go beyond a single model—gain the full toolkit used in practice.
Extra benefit: On RVI directly, students may be eligible to earn back up to 100% of their tuition (see the instructor profile for details).
Ready to prove it under the clock? Enroll and take the challenge. If you want the full start-to-finish pathway, including advanced courses and credentials, see the RVA Certification on the instructor profile.