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.
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.
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.
One zip file: the model with a worked example, a blank copy and a 15-page PDF user guide. Single-user license.
Secure checkout by Stripe. The free project finance model and the free debt sculpting model stay free.

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

Saltbrush Solar, a fictional 150 MWac solar plant with a 15-year PPA and a merchant tail. Amounts in $ millions:
| Measure | Value |
|---|---|
| Total project cost / senior debt / equity | 182.2 / 132.0 / 50.2 |
| Gearing (limit 80%) | 72.5% |
| IDC, fees and DSRA funded in construction | 14.6 |
| P50: minimum DSCR / LLCR at COD / PLCR | 1.35x / 1.37x / 1.54x |
| P90: minimum DSCR / equity IRR | 1.21x / 6.34% |
| P99: minimum DSCR / years in lock-up | 1.09x / 3 |
| P50: equity IRR / project IRR / multiple | 9.12% / 6.94% / 3.42x |

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.
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.
Yes. Enter the wind assessment's capacity factor and uncertainty and set degradation to zero. Any project whose revenue is energy times price works.
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.
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.
Yes: Project Finance Modeling ($149 at launch) teaches the whole analysis on the same project and includes this model.