toolbox
Home / Energy & Sustainability / Community Solar Payback Timeline Calculator

Community Solar Payback Timeline Calculator

This calculator estimates the simple payback timeline for a community solar project using net development cost and annual project cash flow. Revenue can represent subscriber payments, energy sales, renewable credits, or another combined first-year income figure.

It is designed for preliminary project screening rather than detailed financing. Users can test how operating expenses and revenue escalation change the year in which cumulative operating cash flow recovers the net initial investment.

Community solar investment assumptions

$
$
$/yr
$/yr
%
%
years
Result
—
Estimated project simple payback
Net initial investment—
First-year operating cash flow—
Cumulative cash flow at end—
Unrecovered balance at end—

1. Enter total development cost

Include the project costs you want the payback test to recover.

2. Deduct upfront support

Enter grants, rebates, or other incentives that directly reduce the investment basis.

3. Enter first-year revenue

Combine only revenue streams expected in the first operating year.

4. Enter operating expense

Include recurring project costs such as maintenance, insurance, administration, and land payments.

5. Set escalation rates

Apply separate annual growth rates to revenue and operating expense.

6. Review cumulative recovery

The calculator identifies the first year cumulative operating cash flow reaches the net investment.

Net investment = Project cost − Incentives
Cash flow in year t = Revenue₁ × (1 + revenue growth)^(t−1) − Opex₁ × (1 + opex growth)^(t−1)
Payback year = first t where cumulative cash flow ≥ net investment

The model uses annual, undiscounted operating cash flow. It excludes debt service, taxes, depreciation, terminal value, major replacements, and timing within each year.

What the result means

The payback year is when cumulative modeled operating cash flow first equals or exceeds the net project investment.

A project can have an acceptable discounted return even when simple payback is long, or vice versa.

Given: $7.8 million project cost, $1.2 million incentives, $950,000 first-year revenue, $210,000 first-year operating expense, 1.5% revenue growth, and 2% expense growth.

Calculation: Net investment = $6.6 million. First-year cash flow = $740,000. Later years escalate revenue and expense separately. Cumulative operating cash flow first exceeds the net investment in year 9.

Result: Estimated simple payback = 9 years.

The project recovers the modeled net investment during the ninth operating year before financing and tax effects.

Can subscriber acquisition costs be included?

Yes. Include upfront acquisition costs in project cost or recurring program costs in operating expense, depending on when they occur.

Should tax credits be entered as incentives?

Only when you are intentionally modeling them as an upfront reduction and are confident about eligibility and timing. Tax treatment may require professional advice.

What if revenue changes after a contract term?

Use a blended escalation assumption only for screening. A detailed model should enter contract periods and rate changes year by year.

Why does expense growth matter so much?

When expenses grow faster than revenue, annual cash flow can flatten or decline, extending payback or preventing recovery.

How is this different from discounted payback?

Simple payback adds nominal cash flows. Discounted payback reduces future cash flows to present value using a discount rate.