Free Energy / Solar Financial Model Generator (Excel)
A solar or energy financial model projects generation revenue (MWh × PPA rate) plus renewable-energy credits against panel and plant CAPEX, project debt and O&M costs. Because PPAs typically run 20–25 years, the premium tier models the full contract life; 5-year models are free.
⚡ Generate my Energy / Solar model — free (requires JavaScript)
Key drivers pre-loaded in this template
| MWh × PPA rate | Contracted generation revenue |
| REC income stream | Renewable-energy certificate sales |
| $3M CAPEX, project debt | Infrastructure financing structure |
| WACC ~10% | Contracted-cash-flow discount rate |
What you get
A 15-sheet, fully formula-linked Excel workbook: Assumptions, Revenue, OPEX, CAPEX & Depreciation, Debt, Tax (with loss carryforward), Income Statement, Cash Flow, Balance Sheet, DCF Valuation, Sensitivity tables, a charted KPI Dashboard and an Integrity Check. Free 15-sheet linked Excel download for models up to 5 years (annual or quarterly, no sign-up). Models from 7 to 25 years are a one-time $29 premium download.
Frequently asked questions
Why model a solar project over 25 years?
Solar assets earn contracted revenue across a 20–25 year PPA and panel life; IRR and DCF are only meaningful over the full horizon — exactly what the 25-year premium tier provides.
Does it compute project IRR?
Yes — equity IRR on post-debt cash flows, plus DCF enterprise value with Gordon-Growth terminal value.
Can I include degradation?
Approximate panel degradation by setting slightly negative or low volume growth in later growth bands.
More industry financial models
SaaS / Subscription financial model · Data Center financial model · Real Estate financial model · Manufacturing financial model · Hotel / Hospitality financial model · E-commerce / Retail financial model · Pricing
Free tools
WACC calculator · CAPM calculator · DCF calculator · IRR calculator · Inside the 15-sheet model · Glossary