Do the project economics work?
Test a commercial rooftop solar project, follow the cash from revenue to sponsor return, and see exactly which assumptions move the numbers.
New to project finance? Start here.
Everything below is already filled in with a realistic 1 MW rooftop project, so you never face a blank spreadsheet. You do not need to understand every field to get value from this.
- Change one thing at a time. The three that move returns most are system size, energy price and installed cost.
- Tap any i bubble for a plain-English explanation of what a field is and why it matters.
- Press Run the model. After that, every edit updates the results live.
1. Project and production
Define the asset and estimate how much electricity it will produce.
2. Revenue
Choose how the project earns money or creates customer savings.
3. Costs
Estimate what it costs to build and operate the project.
Advanced: contract and asset life Optional
Advanced: financing assumptions Optional
Advanced: tax and valuation assumptions Optional
Your model results
Follow the project from operating cash flow through debt service and taxes to the sponsor's return.
Reference ranges are educational. Real investor and lender requirements vary by market, contract, financing structure, project stage and risk. Use these bands to build intuition, not to underwrite a deal.
What drives this result?
Compare two decisions side by side
Save the current assumptions as Scenario A, change one input, then save Scenario B. Seeing the same project two ways is the fastest way to learn what actually moves returns.
Annual project cash flow
What to look for: the gap between the navy and blue lines is what the lender takes. When debt is repaid, the blue line jumps up to meet the navy one.
Annual cash flow detail
Nominal dollars. Start with the DSCR column — the highlighted row is the tightest year, and it is the year a lender will focus on. Scroll for all operating years.
| Year | Energy (MWh) | Revenue | Opex | EBITDA | Debt service | Taxes / (benefit) | Project CF | Equity CF | DSCR |
|---|
Where does tax equity fit?
This version assumes term debt plus sponsor equity. In many real projects a tax-equity investor or a tax-credit buyer helps monetize the credit and depreciation when the sponsor cannot use them efficiently. Those structures change the timing and allocation of both cash and tax benefits, so they need a more detailed partnership or transferability model than this one.
Want to understand what is happening behind the numbers?
Create a free Energy Academy account to work through Solar Finance 101, interactive lessons, practical tools and project-finance challenges.
Educational tool only. This simplified model is not investment, tax, legal or accounting advice. Validate assumptions and formulas with qualified professionals before making project decisions.