Solar Project Finance Model (Excel) | DSCR Sculpting · LLCR/PLCR · DSRA · Covenant Testing · LP/GP Waterfall · P90 Yield
Originally published: 19/08/2026 15:55
Last version published: 12/10/2026 12:39
Publication number: ELQ-90776-2
View all versions & Certificate
certified

Solar Project Finance Model (Excel) | DSCR Sculpting · LLCR/PLCR · DSRA · Covenant Testing · LP/GP Waterfall · P90 Yield

A 22-tab lender-grade solar project finance model: DSCR-sculpted debt with a gearing cap, LLCR/PLCR, construction IDC, a funded DSRA, covenant lock-up and def

Description
Solar Project Finance ModelSingle-asset project finance model for contracted utility-scale solar — built around what a credit committee actually asks about

Most solar models tell you the deal works. This one tells you when it breaks — the exact period the DSCR dips toward the covenant, whether the lock-up traps your distributions, and how much reserve it takes to hold the line.

Of the 53 solar-titled models in a 3,100-listing marketplace catalogue, not one names DSCR sculpting, LLCR, PLCR, DSRA, P90 or LCOE in its title (measured on the live catalogue, 2026-08-02; counting rule: title text only). Those are the six things a credit committee actually asks about. This model is built around them.

The Solar Project Finance Model is a self-contained, single-asset project finance model for lenders' credit teams, investment committees, developers and infrastructure funds underwriting a contracted utility-scale solar project. Enter the plant, the offtake, the financing terms and the tax profile, and the model sizes the senior debt by sculpting it to a target DSCR, caps it at your maximum gearing, builds the full generation-to-equity cash-flow waterfall, and reports the coverage, returns and covenant outcomes a credit committee asks for.

The differentiator is verifiability, not feature count. Most models in this category ask you to trust the number. Every headline figure in this one is recomputed two independent ways — every formula re-derived in an independent engine, and each headline rebuilt from raw inputs in a separate model that shares no formulas with the workbook — and the release passes a five-stage verification chain before it ships.

The Problem

A solar deal lives or dies on the debt number, and the debt number depends on a chain most templates skip: sculpt the debt to a target DSCR, cap it at maximum gearing, fund construction interest without creating a circular reference, hold a reserve, then test the covenant every period. Get one link wrong and the model still balances — it is just wrong in the sponsor's favour. And the whole equity margin can sit inside a resource assumption that never gets stress-tested.

On the shipped deal that is not an abstraction: sculpting to a 1.40x DSCR wants $134.97M of debt, the 75% gearing cap binds first at $120.75M, and at a 0.92 P90/P50 resource ratio the P90 LCOE rises to $75.18/MWh — above the $75.00/MWh PPA the deal is priced on. The entire equity margin lives inside the yield assumption, and the model shows you the exact period it disappears.

Why Not Just Use a Cheaper One?

Solar models run from $30 to $169.95 across a 3,100-listing template catalogue (the handful priced below $30 are country market studies, not models), and NREL's SAM is free and very good at energy yield. Use either if it gives you the right answer. What you are paying for here is arithmetic that has been adversarially checked rather than assumed — and every claim below is one you can check yourself:

  • Every one of the 13,955 formulas is re-derived in an independent engine, and every headline is rebuilt a second time from raw inputs by a separate model that shares no formulas with the workbook.

  • The release passes a five-stage verification chain — including a golden case with a closed-form answer — before it ships.

  • The method has been through an adversarial cross-lab review: a model from a different AI lab, instructed to break the model rather than agree with it, ran against the certified computation build (sha256 434fd80c) from which this release is re-cut. Since that review seven text-label formulas changed (Tax!T6 and Sensitivity!B34:B37 on 2026-08-27, Assumptions!E7's typical-range flag on 2026-08-30 and again on 2026-09-10, Deal Dossier!C62's depreciation label on 2026-09-10) and every stored numeric value is byte-identical, each cut proven cell by cell in the RECUT_*_PROOF.txt files — it rebuilt the model blind from the raw inputs in its own code, matched the capital structure, coverage ratios and both LCOE figures to the cent, matched the return metrics within the documented solver tolerance, and exercised all five optional modules, including forcing a covenant breach and locating the tax-equity flip from the file's own forward test.

  • The debt number is bounded by construction:
    debt = MAX(0, MIN(sculpted debt, maximum gearing × hard capex)).
    That bound is not automatic in DSCR sizing: NREL's SAM carried an unbounded debt fraction that could return debt above 100% of installed cost and negative equity — raised as NREL/SAM issue #534 in February 2021 and fixed that November. Set the PPA price to zero here and the debt floors at zero rather than turning negative; the same bound is reproduced independently by the Layer-B rebuild.

  • Defaults are calibrated to published data (LBNL capex, Lazard LCOE), not invented.

  • Of the 53 solar-titled models in a 3,100-listing marketplace catalogue pulled 2026-08-02, not one names DSCR sculpting, LLCR, PLCR, DSRA, P90 or LCOE in its title. (Counting rule: title text only — a model can implement a mechanic without naming it in the title.)

If a cheaper model gets those things right, it will agree with this one. That is the point — you can check.

Model Structure — 22 TabsKey Methodological Features
  • Senior debt sized by sculpting to a target DSCR — target debt service = CFADS / target DSCR, debt = the present value of that stream at the cost of debt — then capped at maximum gearing on HARD capex.

  • The gearing cap keys off hard capex, not total capex: that is the deliberate break that keeps construction interest from creating a debt → IDC → capex → debt circular reference.

  • LLCR and PLCR computed as the present value of CFADS over the remaining loan or project life, discounted at the cost of debt, over debt outstanding.

  • Construction interest accrues only in active construction months and is funded by equity, so the facility at COD equals the sculpted amount exactly.

  • The DSRA holds N months of forward debt service, is funded at COD from equity, and releases as the debt amortises — changing equity timing only, leaving project IRR, NPV and LCOE untouched.

  • Covenant testing produces per-period breach flags, a distribution lock-up that traps cash, a configurable cure period and an event-of-default flag.

  • The LP/GP waterfall accrues the preferred return on unreturned capital plus unpaid preference, then a full GP catch-up, then the promote split — and conserves cash exactly every period.

  • Analytic lognormal yield quantiles fitted to the one number a resource study reports, the P90/P50 energy ratio — exact quantiles, no simulation noise.

  • Nominal and real LCOE, real via the Fisher relation on the discount rate: lifetime cost is discounted at the nominal rate and only the energy stream at the real rate, so the quoted real price, escalated at inflation, recovers exactly the same lifetime cost as the nominal one.

  • Sub-annual periodicity: annual, semi-annual or quarterly debt service from one input.

  • MACRS uses the IRS Publication 946 Table A-1 half-year-convention percentages, printed in full on the Tax tab, for all six recovery classes — each class sums to 100% and fully recovers the depreciable basis.

  • The investment tax credit reduces the depreciable basis by the share you set (the US rule is 50% of the credit), and is either used against the project's own tax with a carryforward or transferred for cash at a price you set.

  • The tax-equity flip point is a FORWARD test — the first period in which the investor's cumulative after-tax flows, discounted at its target return, turn positive — so the flip introduces no circular reference; loss allocations stop at the capital account unless a deficit restoration obligation is entered.

  • Battery capex joins hard capex rather than sitting alongside it, so switching storage on re-sizes the senior debt; charging energy is grossed up by round-trip efficiency.

  • Mezzanine debt is serviced strictly behind the senior tranche and its senior service is capped at the outstanding payoff amount, so a refinancing at a different rate cannot manufacture phantom debt service.

Calibration

The pre-loaded deal is calibrated to published market data rather than invented:

  • The all-in capex default of $1.61/W AC is the capacity-weighted average for utility-scale PV that came online in 2024, per Lawrence Berkeley National Laboratory's Utility-Scale Solar, 2025 Edition (p. 31).

  • The 28.5% capacity factor sits inside LBNL's 17–31% band of regional averages (p. 5; individual projects run 7–37%, typically ~25%, p. 38).

  • The $75/MWh PPA sits inside the $40–98/MWh unsubsidized utility-scale range in Lazard's LCOE+ v19.0 (2026), p. 26.

Both sources are cited on the START HERE tab and in the Methodology PDF, with a note to verify the current editions. Not affiliated with, sponsored by or endorsed by LBNL or Lazard.

Worked Example — Pre-filled and Tied Out

The workbook opens on a complete fictional deal, "Bidayat Hayat Solar 100": a 100 MW AC plant at $1.61/W ($161.0M capex), a 28.5% capacity factor, a $75/MWh PPA escalating at 1.5%, 18-year senior debt at 6.0% sculpted to a 1.40x target DSCR against a 1.20x covenant, over a 25-year life.

The GP's higher multiple comes from its 20% promote on a 10% stake; its lower IRR comes from the model returning LP capital only — the GP's $4.025M co-investment is not returned as capital — and the model says so on the tab.

At a 0.92 P90/P50 resource ratio the P90 LCOE rises to $75.18/MWh — above the PPA price, which is the point: the entire margin lives inside the yield assumption, and the model shows you exactly where. Replace the inputs with your own and every output re-prices.

Does This Fit Your Deal? — Read Before You Buy

Covered

  • A single contracted utility-scale solar asset

  • DSCR-sculpted senior debt with a gearing cap

  • LLCR and PLCR

  • Construction period with capitalised IDC

  • Funded DSRA

  • Per-period covenant testing with lock-up, cure and event of default

  • LP/GP promote waterfall

  • SL / declining-balance / custom / MACRS depreciation with optional NOL

  • Post-PPA merchant tail

  • Analytic P50–P99 yield

  • Nominal and real LCOE

  • Annual, semi-annual or quarterly periodicity

Five optional modules ship switched OFF so the certified base case is unchanged until you turn one on: MACRS (all six IRS recovery classes), the investment tax credit, a tax-equity partnership flip, battery storage (PV + BESS), and mezzanine debt with senior refinancing.

Not covered, by design

  • The US PTC and a dedicated bonus-depreciation switch

  • Multi-currency / FX

  • Portfolio or fund-level roll-up across SPVs

  • A full Monte Carlo simulation inside the workbook (yield uses exact analytic lognormal quantiles instead, cross-checked against simulation before release)

  • A separate inverter-replacement reserve line — fold periodic replacement capex into the fixed O&M per kW input as a levelised allowance

  • Google Sheets (see the FAQ; this is a hard incompatibility, not a limitation being worked around)

  • Return of the GP's own co-investment: the waterfall returns LP capital only, so the GP is paid through the catch-up and promote alone and the LP and GP figures reflect that (Methodology, section 6)

Suitable For
  • Lenders' credit teams sizing and testing senior debt on a contracted solar asset

  • Investment committees reviewing a sponsor's case with an independent model

  • Renewable-energy developers preparing a financing request or an IC paper

  • Infrastructure and energy-transition funds underwriting single-asset acquisitions

  • Advisors and consultants producing client-facing project finance analysis

Technical SpecificationsHow It Works — The Method, in the Open

No macros, no hidden sheets, no iterative calculation. These are the actual formulas in the shipped workbook, written with each input's name in place of its cell reference and without the period-range guards — open the cell and you will find the same arithmetic:

Generation (Operating Model)

= CapacityMW × 8760 × CapacityFactor × Exceedance × (1 − Degradation)^(year−1) / PeriodsPerYear

Sculpted debt service (Debt Schedule)

= IF(AND(period > 0, in debt term), CFADS / TargetDSCR, 0)

Debt capacity, then the binding constraint

SculptedDebt = SUMPRODUCT(debt-service range / (1 + IntRate/PeriodsPerYear)^period)
MaxDebt = MaxGearing × HardCapex
DebtAmount = MAX(0, MIN(SculptedDebt, MaxDebt))

DSRA target

= DSRAMonths/12 × (the forward 12 months of debt service)

LCOE, nominal

= (CapEx + PV of opex at DiscRate) / (PV of generation at DiscRate)

LCOE, real — a Fisher conversion, not a subtraction

real rate = (1 + DiscRate)/(1 + Inflation) − 1

Exceedance factors (Yield)

P90 = P90P50          P75 = P90P50^0.526307          P99 = P90P50^1.815259

Those exponents are the standard-normal quantile ratios z75/z90 and z99/z90, so the P50–P99 fan is a lognormal yield distribution anchored on the P90/P50 ratio you enter — not three numbers typed in by hand.

Sculpting to a 1.40x DSCR on the shipped deal wants $134.97M of debt; the 75% gearing cap binds first, so the model sizes $120.75M and the minimum DSCR comes out at 1.56x rather than the 1.40x target. That is the cap doing its job, and you can watch it happen by moving MaxGearing.

FAQ

Does it work in Google Sheets?
No — this is the one hard incompatibility. The two sensitivity grids are native Excel two-variable Data Tables, which Sheets cannot compute. Import it and those grids arrive as static numbers that no longer respond to your inputs. Everything else would carry across, but the sensitivity analysis is a headline feature, so the honest answer is that this is an Excel product.

Can I break it?
Every input carries a validation bound and a typical-range flag, and 14 integrity checks roll into one master PASS / REVIEW flag on the Checks tab. If you enter something the model cannot reconcile, the master flag turns and tells you which check failed. Nothing is hidden or locked away from you.

Does it do MACRS, the ITC or bonus depreciation?
MACRS: yes, all six IRS recovery classes, using the Publication 946 Table A-1 half-year-convention percentages printed in full on the Tax tab. The investment tax credit: yes, with the 50% depreciable-basis reduction, and either used against the project's own tax with a carryforward or transferred for cash. Bonus depreciation: no dedicated switch — use the custom depreciation schedule. The US PTC is not modelled. All of these ship switched OFF.

Is it really free of circular references?
Yes, and it is structural rather than a setting. The gearing cap keys off HARD capex rather than total capex, which breaks the debt → IDC → capex → debt loop at construction. Iterative calculation is off and the file needs no add-ins.

How do I know the file I downloaded is the file that was released?
SHA256SUMS.txt ships with the download and the Change Log tab carries the released version stamp, mirrored in the workbook's File > Info properties. The certified hash for this release is 0410e1812a717a91 (first 16). Hash the file yourself and compare.

What is pre-filled?
A complete fictional deal, "Bidayat Hayat Solar 100" — 100 MW AC, $1.61/W, 28.5% capacity factor, $75/MWh PPA. Every figure quoted on this page is recomputed from that shipped file, so you can open it and tie out each one before you change anything.

Why $479 when there are $149 solar models?
Because of what the number has to survive. The shipped base case sizes $120.75M of senior debt against a $161M asset, and the model is built so that figure can be defended line by line — every headline in it is independently re-derived twice before release. For a screening case, a cheaper model is the right tool. For a number that goes in front of a credit committee, that difference is what you are buying. For scale: the dedicated software a project team would otherwise licence runs $876–$1,575 per seat per year (PVsyst and HOMER Pro, vendor pricing pages, August 2026), and one solar-plus-storage model was listed at $495 on a major template marketplace (catalogue pull, 2026-08-03). $479 is a one-time purchase, below all three. If a $149 model gets the arithmetic right it will agree with this one — and you can check, which is the entire argument.

About the Author

Built by Hoda Elmorshidy — Financial Controller & Fractional CFO, in senior finance since 2017: IFRS reporting, FP&A, finance automation, Quantitative Analysis, Financial Modeling, and UAE VAT & Corporate Tax.

Practitioner-grade tools, not generic templates.

Disclaimer

This model is an analytical template for financial analysis and decision support. It is not investment, tax, legal or accounting advice, and it is not a substitute for professional due diligence or for your own lender's or auditor's review. Outputs depend entirely on the assumptions you enter. Depreciation, tax-credit and tax-equity mechanics are modelled to published US federal rules as at the build date and are jurisdiction-specific — verify the current rules and your own facts with a qualified tax adviser before relying on any figure. Calibration sources (LBNL, Lazard) carry their own publication dates; verify the current editions.

License & Liability

License grant. You are granted a perpetual, non-exclusive licence to use this workbook for your own or your organization's internal business use — including modelling real deals and sharing outputs with your clients, lenders or investment committee. You may not resell, redistribute, sublicense or publish the file itself, or any derivative that is substantially the workbook, whether free or paid.

"As is." The file is supplied "as is", without warranty of any kind, express or implied, including merchantability or fitness for a particular purpose.

Limitation of liability. To the maximum extent permitted by law, total liability is capped at the greater of the amount you paid for this product and US$100 (LICENSE_AND_DISCLAIMER.md section 4). No liability is accepted for indirect, incidental or consequential loss, or for lost profits, arising from use of the file.

Non-waivable rights. Nothing here limits rights that cannot be excluded under the consumer-protection law of your country.

Governing law. The laws of the United Arab Emirates, without prejudice to any mandatory consumer protections of your own jurisdiction.

Refunds & fixes. This is an instant digital download, sold on a fix-first basis rather than a returns basis. If something is genuinely wrong with the file — it will not open, a formula returns an error, a tab or feature described on this page is missing, or a stated calculation is wrong — contact me through the platform you bought on, or email [email protected], with your order number and a screenshot. I will correct it and send you the updated workbook, free, for 12 months from purchase. If something genuinely cannot be fixed, I will tell you so plainly rather than leave it open. Change-of-mind refunds are not offered: the file is delivered in full and immediately, and the scope is set out before you buy — see "What it does" and "What it does not do" — so you can check the fit first. Outputs that depend on your own assumptions, and anything listed as out of scope, are not defects. Nothing here limits rights that cannot be excluded under the consumer-protection law of your country, and the terms of the platform you bought on also apply.

Trademarks & non-affiliation. Lawrence Berkeley National Laboratory (LBNL) and its Utility-Scale Solar series, Lazard and its LCOE+ series, and the National Renewable Energy Laboratory (NREL) and its SAM software, are cited for methodological calibration and context only; this product is an independent analytical template and is NOT affiliated with, endorsed by, or sponsored by any of them. Microsoft Excel is a trademark of Microsoft Corporation; this product is not affiliated with, endorsed by, or sponsored by Microsoft.

This Best Practice includes
Microsoft Excel workbook (.xlsx), 22 tabs, 13,955 live formulas, 142 named ranges, 7 charts, no macros and no circular

Acquire business license for $479.00

Add to cart

Add to bookmarks

Discuss

Further information

• Size senior debt on a contracted utility-scale solar project by sculpting it to a
target DSCR and capping it at maximum gearing — in closed form, with no circular references
• Test the covenant package the way a lender does: per-period DSCR, distribution
lock-up, cure period and event of default
• Produce the coverage and return set a credit committee asks for — LLCR, PLCR,
project and equity IRR, equity multiple, nominal and real LCOE
• Show where the equity margin actually sits by pricing the deal at P50 through P99
resource outcomes
• Split proceeds through an LP/GP promote waterfall with a full GP catch-up

• A single contracted utility-scale solar asset with a PPA, at financing or IC stage
• Senior debt sized on DSCR sculpting with a gearing cap
• Users who need to defend the debt number to a lender, an IC or an auditor
• Analysts who want every headline figure independently checkable

• Portfolio or fund-level roll-up across multiple SPVs
• Multi-currency or FX-exposed structures
• Merchant-only projects with no contracted offtake
• Users who need the US PTC, a dedicated bonus-depreciation switch, or in-workbook
Monte Carlo simulation
• Google Sheets users — the sensitivity grids are native Excel Data Tables


0.0 / 5 (0 votes)

please wait...