A walk-through of the inputs, outputs and circularities inside a solar project finance model — and the handful of variables that actually move the needle on IRR, DSCR and bankability.
Why the Model Is the Deal
In project finance, the spreadsheet is not a record of the deal. It is the deal. Lenders size debt off it, sponsors price equity off it, and offtakers negotiate tariffs against it. A solar financial model is the single artefact where engineering, contracts, tax law and capital markets are forced to reconcile in the same row.
Most disputes between developers, lenders and investors are not really disputes about solar. They are disputes about which cells in the model are assumptions, which are derived, and which are quietly circular. This guide unpacks how a bankable solar project finance model is built, and which variables actually move the answer.
The Anatomy of a Solar Project Finance Model
A standard model is organised as a chain of linked schedules, each feeding the next:
1. Inputs — system size, tariff, costs, debt terms, tax rules. 2. Production schedule — annual energy yield, net of degradation and losses. 3. Revenue schedule — production × tariff, with escalators and curtailment. 4. Operating costs — O&M, insurance, land lease, admin, replacements. 5. Depreciation and tax — capital allowances, tax holidays, fiscal-year resets. 6. Debt schedule — drawdown, interest, principal, DSCR sculpting. 7. Equity and shareholder loans — distributions, subordinated interest. 8. Cash flow waterfall — the order in which every dollar is paid out. 9. Returns — Project IRR, Equity IRR, NPV, payback, LCOE.
The discipline of project finance is keeping these schedules internally consistent across 20 to 25 years, in the right currency, on the right fiscal calendar, with the right circular references resolved.
1. Capital Cost (CAPEX)
CAPEX is the most-quoted number in any solar deal, and the most misunderstood. It is not a single line — it is a stack:
- EPC contract price. Modules, inverters, structures, cabling, civils, installation. Usually 70–80% of total CAPEX. - Owner's costs. Permitting, legal, technical advisory, insurance during construction, financing fees. - Development costs. Land acquisition, environmental studies, grid connection charges. - Contingency. Typically 3–7% of EPC, sized against project risk. - IDC (Interest During Construction). Capitalised interest on debt drawn before COD.
A 10% movement in CAPEX rarely moves Project IRR by 10%. It usually moves it by 1.5–2.5 percentage points — but it moves DSCR meaningfully, because debt is sized off CAPEX and serviced off revenue.
2. Energy Yield and Degradation
The revenue line is downstream of physics. Two variables dominate:
- P50 yield (kWh/kWp/year). The expected annual production with 50% probability of being exceeded. Lenders often size debt off P90 — the more conservative case. - Degradation. Modules lose roughly 0.5% of output per year after a higher first-year drop. Over 25 years that compounds to a 12% reduction in production. A model that uses linear degradation against a flat tariff understates late-life cash flow stress.
If your yield assumption is 5% optimistic, your IRR is roughly 5% optimistic — production sits at the top of the waterfall and everything below inherits the error.
3. Tariff Structure and Escalation
The tariff is the single most sensitive variable in most solar models. Three things matter more than the headline number:
- Currency. A USD-denominated PPA in a soft-currency market is a different instrument from a local-currency PPA with FX indexation. The model must handle both legs cleanly. - Escalation. A flat tariff loses ground to inflation; a CPI-indexed tariff transfers inflation risk to the offtaker. Many emerging-market PPAs escalate on the COD anniversary, not the fiscal year — a subtle timing point that materially shifts year-one revenue. - Take-or-pay vs. as-generated. Take-or-pay shifts volume risk to the offtaker. As-generated leaves it with the project, and lenders will discount the case accordingly.
A 50-basis-point change in the tariff escalator can move Equity IRR by more than a full percentage point over a 20-year contract.
4. Operating Costs