Analysis
Optimizing Renewable Energy Project Finance Model
Overview
What this challenge is about.
You are a financial analyst at a renewable energy consultancy. SunPower Iberia has provided detailed cost estimates, PPA terms (20-year fixed price), and local tax incentives. You must build a project finance model in Excel that includes a construction phase (2 years) and operational phase (25 years). The model should incorporate debt financing (70% loan-to-cost, 6% interest, 15-year tenor) and compute annual cash flows, tax shields, and investor returns. Success means the model is transparent, includes a debt schedule with DSCR calculations, and provides a clear recommendation on whether to proceed. Deliver a model file and a one-page investment memo.
The Brief
What you'll do, and what you'll demonstrate.
Build a project finance model to determine the financial feasibility and optimal capital structure for a 50 MW solar farm in Spain.
Earning criteria — what you'll demonstrate
- Build a project finance model with construction and operational phases
- Incorporate debt financing, repayment schedules, and DSCR calculations
- Compute project and equity IRR, NPV, and payback period
- Perform sensitivity analysis on key variables (PPA price, construction cost, interest rate)
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
Careers
Roles this prepares you for.
Real titles. Real skill bridges. Pick the one closest to your trajectory.
Career mappings coming soon.