30-Year Cash Flow Engine
Year-by-year projections including MACRS, ITC, bonus depreciation, REC revenue, PPA escalation, O&M, and loan amortization. Outputs NPV, payback, cash-on-cash, and break-even year.
The Engine
Built like an institutional model. Operated like a SaaS app.
Everything that powers SolarProforma.ai — the math, the workflow, the integrations, the security — laid out for the analysts who want to verify before they trust.
Your Excel proforma is the weakest link in the deal.
Days, not minutes
Every assumption change ripples through formulas. One typo and you re-build the model from scratch.
One bad cell breaks the deal
Lenders find the error after diligence, not before. Closing slips by weeks.
No two models agree
Every analyst has their own template. There is no source of truth your investor will sign off on.
SolarProforma.ai fixes all three.
What's Inside
The four engine modules.
Newton-Raphson IRR Solver
Conditional IRR — unlevered when there's no loan, levered when there is. Converges on non-trivial cash flows that closed-form solvers miss. Verified to four decimal places against an industry benchmark every release.
Physics-Grade Production
Solcast TMY + PVLib simulation with PVWatts as fallback. Address-to-production in seconds. Energy Community auto-detected via ArcGIS.
Custom Hardware Vault
Upload your own PAN/OND files. The model parses them, stores them by tenant, and applies the correct module/inverter parameters to every analysis.
The Workflow
From address to bankable proforma in five steps.
-
01
Pin the project
Enter address, system size, and tilt. We pull weather + solar resource.
Project Address1234 Industrial Pkwy, Stonington, CT 06378System250 kWTilt10°☀ TMY pulled · 1,287 kWh/kW -
02
Pick the hardware
Choose from the catalog or upload custom PAN/OND.
HardwareMModuleTrina Vertex 540WIInverterSMA Tripower 110CatalogPANOND -
03
Set the financials
ITC %, depreciation, PPA terms, escalation, loan, O&M. Sensible defaults pre-filled.
ITC %40%MACRS5-yearEscalation2.5%/yrLoan60% / 7.0% / 20yrAuto-filled -
04
Run + Compare
30-year proforma in seconds. Stress-test with 4 scenarios side-by-side.
CashLoanPPAPrepaid14.2%19.8%11.4%16.7%★ Loan: best IRR 19.8%IRR comparison · 250 kW -
05
AI Analysis + Chat
Get a feasibility report instantly. Then ask follow-up questions — the assistant knows your project.
AI Project AssistantYHow can I improve the IRR?Switching to a loan at 60% LTV would push IRR from 14.2% to 19.8%. The ITC step-up alone adds 3.1 points.
Scenario Analysis
Four scenarios. One screen. Defensible decisions.
Compare module choices, financing structures, or PPA terms side-by-side. See IRR, NPV, EBITDA, and payback move in real time. Export to PDF for the lender.
- Cash, Loan, Standard PPA, and Prepaid PPA in one view
- Auto-highlight the winning scenario
- One-click PDF export with capital stack waterfall
Scenario Comparison · Acme Manufacturing · 250 kW
Live
| Metric | Cash | Loan | Std PPA | Prepaid |
|---|---|---|---|---|
| IRR | 14.2% | 19.8% | — | 22.1% |
| NPV @ 7% | $842K | $611K | $402K | $1.04M |
| Year-1 Cash | -$0.63M | -$0.13M | $24K | -$0.42M |
| Payback | 6.4 yrs | 5.1 yrs | 8.2 yrs | 4.8 yrs |
| 25-Yr Sav. | $1.97M | $1.74M | $1.18M | $2.15M |
★ Best scenario auto-detected · Click any column to compare details
12 months of utility bills Parsing…
Jan · 8,420 kWh · $1,243
Feb · 7,890 kWh · $1,168
Mar · 9,210 kWh · $1,358
+ 9 more months
AI-Powered Intake
Drop in a utility bill. Get parsed data in seconds.
Stop transcribing 12 months of bills. Drag in PDFs and our AI extracts kWh by month, rate schedule, demand peaks, and feeds them straight into your offset model.
Encrypted in transit and at rest. No vendor lock-in.
The Output Proof
From complex math to boardroom-ready PDFs in 3 seconds.
Generate beautiful, branded one-pagers that answer the CFO's three biggest questions:
- 1What do I pay today?Capex, financing terms, Year-0 cash impact.
- 2What do I save?25-year cash flow, NPV, IRR, payback.
- 3What's my new rate?Effective $/kWh post-solar with the utility blend.
Solar Investment ProposalAcme Manufacturing — 250 kW System
Proforma AI
Cost$0.63M
25-Yr Sav.$1.97M
IRR19.39%
Cash Flow · 25 yrs
Generated by SolarProforma.ai05.05.2026 · v3.0
Transparent, Bankable Math.
Export full shadow-models to Excel any time. Built to pass rigorous third-party engineering and tax-equity audits without a manual reconciliation pass.
- Formula-driven Excel export (not protected, not flattened)
- Audit-ready methodology appendix on every PDF
- Industry benchmark — IRR verified to four decimals every release
Bank-Grade Security for Your Deal Desk.
AES-256 encryption in transit and at rest. Your project margins, client utility data, and tax models stay strictly confidential. Your data is never shared, sold, or used to train anything.
- Tenant-isolated database — your hardware vault is yours alone
- SOC 2 Type II in progress (Enterprise tier on launch)
- US-hosted infrastructure · daily encrypted backups
Try the engine on your next deal.
Your first three projects are free. No credit card required.
Common Questions
Answers before you model.
What is commercial solar financial modeling?
Commercial solar financial modeling is the process of projecting a C&I solar project's economics over its full operating life — typically 25 to 30 years. A complete model combines an energy production forecast with capital cost, operating expense, financing terms and the federal tax position: the Investment Tax Credit, any domestic content adder, and MACRS depreciation. It resolves those inputs into the metrics a lender or tax-equity partner will actually underwrite against, principally IRR, NPV and payback period. SolarProforma.ai builds that model from your production data through to a CFO-ready proforma, and compares ownership, lease, PPA and prepaid PPA cases side by side. Compare plan tiers or request a model review.
How do you calculate solar project IRR?
Internal rate of return is the discount rate at which a project's net present value equals zero. Because that rate cannot be isolated algebraically, it has to be solved iteratively from the project's yearly cash flows — net operating income, debt service, tax credits and depreciation benefits. SolarProforma.ai uses a Newton-Raphson solver with a bisection fallback, so it still converges on cash flows that change sign more than once, which closed-form approximations handle unreliably. IRR, NPV and payback are produced for every scenario on each plan tier.