|
If I take 60% of $252.48, (since a solar collector system can only provide 60% of water heating), I would have $151.49, which is the amount I would save per year by using the solar collectors.
Dividing that into the $5800, which is the cost for the system, I found that it should take us 38 years to pay this off !? As this was way above the 10-15 years my contact Mr. Kelly predicted, I asked him where I had gone wrong. He informed me that I had forgotten that the price per gigajoule would increase over time. Mr. Kelly suggested that I use a 13% price increase/year, calculated from the ATCO Gas website of gas prices for the past 35 years. He helped me with the spreadsheet below, which takes that increase into consideration. For my family, I found it would take 15 years to payoff the solar collectors.
Payback Time
|


|
Ellie Shifflett Grade 8, Cayley School Last Edited May 1/07 |
|
Gas Price Increase 0.13 (35 year average from ATCO website) Amount Saved in First Year $151.49 |
|
Year |
Cost/year ($) |
total ($) |
|
1 |
151.49 |
151.49 |
|
2 |
171.18 |
322.67 |
|
3 |
193.44 |
516.11 |
|
4 |
218.58 |
734.70 |
|
5 |
247.00 |
981.70 |
|
6 |
279.11 |
1,260.81 |
|
7 |
315.39 |
1,576.20 |
|
8 |
356.40 |
1,932.60 |
|
9 |
402.73 |
2,335.33 |
|
10 |
455.08 |
2,790.41 |
|
11 |
514.24 |
3,304.65 |
|
12 |
581.09 |
3,885.75 |
|
13 |
656.64 |
4,542.38 |
|
14 |
742.00 |
5,284.38 |
|
15 |
838.46 |
6,122.84 |
|
16 |
947.46 |
7,070.30 |
|
17 |
1,070.63 |
8,140.93 |
|
18 |
1,209.81 |
9,350.74 |
|
19 |
1,367.09 |
10,717.83 |
|
20 |
1,544.81 |
12,262.64 |
|
21 |
1,745.63 |
14,008.27 |
|
22 |
1,972.56 |
15,980.83 |
|
23 |
2,229.00 |
18,209.83 |
|
24 |
2,518.77 |
20,728.60 |
|
25 |
2,846.21 |
23,574.81 |
|
26 |
3,216.21 |
26,791.02 |
|
27 |
3,634.32 |
30,425.34 |
|
28 |
4,106.78 |
34,532.13 |
|
29 |
4,640.67 |
39,172.80 |
|
30 |
5,24.95 |
44,416.75 |
|
Created by Ellie Shifflett and David Kelly |
||