That won't be the amount saved. That would be an estimated cost of
electricity. $238632.39

Column a is 21,128
B1 is .17
B2 is B1*1.05
copy down
C1 is A1*B1
copy down
Sum C1:C30

Savings would that sum minus what it cost him to get it using a Solar
array including purchase costs, maintenance cost, battery costs and
replacements for power continuity, any backup power charges from the
utility etc.


Kyle P. wrote:

Hello,
I need to determine how much money a solar array will save one of my
customers over the next thirty years.

I'd like to know the formula to calculate this.

Inputing: 17 Cents per kWh.
21,128 kWh's per year
a 5% increase in the cost of electricity per year. (17cents
per kWh increasing by 5% every year).
over 30 years.

Help Please! Thanks.