Pro models

Project Finance Model Excel Template, Pro Edition

A lender-grade model for a contracted solar or wind project: quarterly construction with interest during construction, fees and pro rata drawdowns; debt sculpted on P50 and P90 cover targets with the tax shield; DSRA, maintenance reserve, lock-up and sweep; DSCR, LLCR and PLCR; equity and project XIRR; 32 built-in checks.

Get this model inside the course

Project Finance Modeling includes the model, a 31-page Course Book, an Excel workbook that checks your answers and a 160-question quiz with a final exam: $149 at launch (until 31 December 2026), $50 more than the model alone.

Get the course with the model, $149 → · Read module 4 free

Enter the plant, the PPA, the merchant curve, the costs, the build profile and the term sheet. The workbook funds the construction, sizes and sculpts the debt, runs 25 years of operations and the full waterfall, tests the cover ratios under P50, P90 and P99 on the signed schedule, and computes the sponsor's return on actual dates.

Project Finance Model, Pro Edition: $99

One zip file: the model with a worked example, a blank copy and a 15-page PDF user guide. Single-user license.

Buy now, $99 →

Secure checkout by Stripe. The free project finance model and the free debt sculpting model stay free.

Dashboard of the Project Finance Model, Pro Edition: master check, funding at COD, debt ratios, sponsor returns, downside cases and charts
The Dashboard: master check, funding at COD, debt ratios, returns and the downside on the signed schedule.

What the free models do not do

What the model does, tab by tab

Blue text on a pale yellow fill marks an input; every other cell is a formula.

Dashboard
Master check and warnings, funding at COD, ratios and returns of the selected scenario, P90 and P99 on the signed schedule, two charts.
Inputs
Plant and energy yield, PPA, operating costs and the inverter replacement, construction budget, tax, senior debt terms and targets, merchant curve and margins by year, the build profile, three scenarios.
Sizing
P50 and downside cash flows, the four targets, the backward sculpting with the tax shield, the binding case each year and the signed schedule.
Solve and Construction
The funding loop unrolled in twelve passes, then the final quarterly schedule and the sources and uses at COD.
Model
Twenty-five years: energy, revenue, costs, debt, tax with losses, CFADS, DSCR and the waterfall to distributions.
Ratios and Returns
DSCR, LLCR, PLCR, lock-up and default tests; equity and project XIRR, NPV, multiple, payback, equity value at COD.
Scenarios and Engine
P50, P90 and P99 run in full, side by side, on the same signed schedule.
Checks
32 integrity controls, a master check and 6 deal warnings.
Sizing sheet of the Project Finance Model, Pro Edition: P50 and downside cash flows, targets, backward sculpting and the signed schedule
The Sizing sheet: the sculpting solved backwards from the last debt year, one column at a time.

The worked example

Saltbrush Solar, a fictional 150 MWac solar plant with a 15-year PPA and a merchant tail. Amounts in $ millions:

MeasureValue
Total project cost / senior debt / equity182.2 / 132.0 / 50.2
Gearing (limit 80%)72.5%
IDC, fees and DSRA funded in construction14.6
P50: minimum DSCR / LLCR at COD / PLCR1.35x / 1.37x / 1.54x
P90: minimum DSCR / equity IRR1.21x / 6.34%
P99: minimum DSCR / years in lock-up1.09x / 3
P50: equity IRR / project IRR / multiple9.12% / 6.94% / 3.42x
Checks sheet of the Project Finance Model, Pro Edition
The Checks sheet: 32 integrity controls and a master check.

Technical notes

Questions people ask about it

Does the model use macros or circular references?

No. The construction funding loop is unrolled on its own sheet (twelve passes, each fed by the previous one), the sculpting with the tax shield is solved backwards in closed form, and interest is charged on opening balances. Iterative calculation stays off.

How is it different from the free project finance models?

The free Aurora model works one case of The Project Finance Handbook and the free toll road model sculpts on a single case. The Pro edition is a general tool: quarterly construction with fees, IDC and pro rata drawdowns, two sizing cases (P50 and P90) with period targets and the tax shield, DSRA, MRA, lock-up with trapped cash, merchant sweep, LLCR and PLCR, three scenarios run side by side and 32 checks. The free models stay free.

Does it work for wind?

Yes. Enter the wind assessment's capacity factor and uncertainty and set degradation to zero. Any project whose revenue is energy times price works.

Does it model US tax credits or tax equity?

No. Tax is one rate with straight-line depreciation and losses carried forward. The guide explains the simplifications; the free Aurora model shows the investment tax credit.

Does it work in Google Sheets and LibreOffice?

Yes. It uses standard functions (XIRR, XNPV, MINIFS, SUMPRODUCT) and was recalculated and verified cell by cell in LibreOffice. Charts may look slightly different outside Excel.

Is there a course that uses it?

Yes: Project Finance Modeling ($149 at launch) teaches the whole analysis on the same project and includes this model.

Project Finance Model, Pro Edition: $99

Buy now, $99 →