Commercial & industrial · Solar ROI

Solar financial modeling tied to your tariff and financing assumptions

Size scenarios for generation, self-consumption, escalation, and capex. Payback, IRR, NPV, and cashflow charts update from the same workbook logic—verify inputs before external disclosure or procurement lock-in.

Formula reference card Hybrid & battery modes PDF summary export Bill intelligence handoff

Open solar financial model Hybrid optimizer

Audience: Finance, energy, and engineering teams aligning on one assumption-tagged business case.

Tariff & escalation Energy rate paths over project life

Self-consumption Onsite use vs export assumptions

Financing modes Cash, loan, lease, PPA-style inputs

Scenario compare Grid-tied, hybrid, battery-augmented

Export trail KPIs trace to workbook formulas

How it works

From assumptions to defendable KPIs

Stack generation, tariff, and finance inputs first—then stress scenarios before capital approval.

Set site & yield inputs

System size, performance ratio, location yield, and losses drive annual kWh production.

Align tariff & use

Blend tariff blocks with self-consumption and optional demand-charge savings assumptions.

Choose financing & life

Discount rate, debt service, O&M, and project life feed IRR, NPV, payback, and DSCR views.

Compare & export

Rotate scenarios, run PDF summary, and hand off consistent figures to demand or bill workspaces.

Deliverables

What you walk away with

Outputs you can trace: charts, KPI tables, and PDFs generated from the same formulas shown on screen.

KPI deck

Payback, IRR, NPV, DSCR, and blended economics tied to your discount and financing fields.

Formula reference

Generation, savings, escalation, NPV, and cashflow definitions visible alongside numbers.

Charts & PDF

Cumulative savings, capex split, payback curve, and downloadable PDF summary.

Linked workflows

Push offsets to demand modeling and seed assumptions from bill intelligence when connected.

Get started

Open the interactive model

Workspace entry. The live tool runs in your browser: adjust assumptions, scenario modes, and financing—charts and KPIs refresh from the same workbook engine.

Open solar financial model Bill audit for tariff context

Inside the workspace

Scenario tools in the workspace

Shortcuts adjust inputs or export PDFs—results still follow the formulas in the reference card.

Scenario mode

Rotate grid-tied, hybrid, off-grid, solar+battery, and generator-blend paths.

Tariff escalation

Step escalation within limits and refresh long-term savings curves.

Financing mode

Cycle cash, loan, lease, and PPA-style structures and review cashflow.

Battery dispatch

Increase modeled battery support and re-check payback and IRR before committing storage capex.

Demand bump

Optional modeled demand-charge savings increment—illustrative unless tied to your bill.

PDF export

Download KPIs, capex breakdown, and recommendation bullets from the current run.

Coverage

Inputs & scenario coverage

Representative controls in the workspace—exact availability follows product releases; validate critical tariff orders with your utility.

Area	What you set	Outputs affected	Notes
Generation	kWp, PR, yield, losses	kWh, savings, payback	Core
Tariff	Country profile, escalation	$/kWh savings, NPV	Core
Financing	Cash, loan, lease, PPA	IRR, DSCR, cashflow	Core
Storage / hybrid	Scenario + dispatch sliders	Battery payback, hybrid path	Verify

FAQ

Solar modeling questions

Are these IRR and NPV figures a guarantee?

No. They are outputs from your stated assumptions and the workbook’s formulas. Treat them as internal decision support until validated against bills, meters, and financing term sheets.

How do I ground the tariff side?

Run bill intelligence first or align manual tariff fields to your latest utility schedule. Garbage-in on tariff dominates garbage-out on savings.

Should sizing follow only my current electricity bill?

Not always. A bill reflects past usage. If you plan more cooling, longer operating hours, or new equipment, expected annual energy and peak demand can exceed what today’s bill implies—size and scenario-test against that future load case, not only historical kWh and peak.

Does this replace an engineer’s PV design?

No. It models financial outcomes from production and cost assumptions. Detailed electrical design, protection, and grid compliance still belong with qualified engineers.

Who is this for?

C&I owners and advisors comparing capex against tariff-backed savings—especially where demand charges and self-consumption materially change ROI.

Ready to stress-test your solar business case?

Align generation, tariff, and finance assumptions in one workspace—then export what your IC or board can trace back to inputs.

Talk to Priwad Open solar financial model