| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||
2 | Energy Offers Analyser | ||||||||
3 | |||||||||
4 | |||||||||
5 | Notes | ||||||||
6 | |||||||||
7 | If you want to make changes to this spreadsheet you first need go to the File menu and either "Download as" an Excel format, or "Make a copy" if you are signed in to a Google account. | ||||||||
8 | |||||||||
9 | This calculator assumes time of use metering, and compares a limited set of offers currently available (as at 16 August 2012) in NSW. The contract parameters also assume you have solar PV (please select whether you are on a gross or net metering system). The contract parameters are usually different if you do not have solar PV. | ||||||||
10 | |||||||||
11 | Enter parameters for your house in the yellow shaded cells, for example: | 1,450 | |||||||
12 | |||||||||
13 | The contract parameters are in the blue shaded cells, for example: | 47.77 | |||||||
14 | Change these parameters once you have spoken to your energy retailer and they have made you an offer specific to you. | ||||||||
15 | |||||||||
16 | All dollars include GST unless stated otherwise. | ||||||||
17 | |||||||||
18 | This calculator is provided as is and no warranty is made as to its accuracy. | ||||||||
19 | |||||||||
20 | Consumption | Solar Generation | |||||||
21 | My House | kWh/yr | % Total | kWh/yr | % Total | ||||
22 | |||||||||
23 | Peak | 3,000 | 21.4% | 650 | 10.0% | ||||
24 | Shoulder | 7,000 | 50.0% | 3,250 | 50.0% | ||||
25 | Off peak | 4,000 | 28.6% | 0 | 0.0% | ||||
26 | Exported to the grid | n/a | n/a | 2,600 | 40.0% | ||||
27 | Total | 14,000 | 100.0% | 6,500 | 100.0% | ||||
28 | |||||||||
29 | Solar connection type (Net or Gross) | Gross | |||||||
30 | |||||||||
31 | Government solar feed-in tariff (c/kWh) | 60.00 | |||||||
32 | |||||||||
33 | Electricity Offers | TruEnergy Contract | Energy Aust Contract | AGL Contract | Other | Energy Aust No Contract | |||
34 | |||||||||
35 | Offer Details | ||||||||
36 | Peak | cents/kWh ex GST | 45.80 | 47.77 | 47.77 | 47.77 | |||
37 | Shoulder | cents/kWh ex GST | 21.00 | 19.40 | 19.40 | 19.40 | |||
38 | Off peak | cents/kWh ex GST | 13.10 | 11.90 | 11.90 | 11.90 | |||
39 | Daily service charge | cents/day ex GST | 80.00 | 74.70 | 74.70 | 74.70 | |||
40 | Government solar feed-in tariff | cents/kWh | 60.00 | 60.00 | 60.00 | 60.00 | 60.00 | ||
41 | Retailer solar feed-in tariff | cents/kWh | 6.00 | 0.00 | 8.00 | 0.00 | |||
42 | Discount % | 16.50% | 12.00% | 7.00% | 0.00% | ||||
43 | Discount off net or gross? | Net | Gross | Gross | n/a | ||||
44 | Discount off usage only or total bill? | Total | Usage | Usage | n/a | ||||
45 | |||||||||
46 | Calculations | ||||||||
47 | Consumption cost before discount | $3,705 | $3,594 | $3,594 | $0 | $3,594 | |||
48 | Service charge before discount | $321 | $300 | $300 | $0 | $300 | |||
49 | Gross cost before discount | $4,026 | $3,894 | $3,894 | $0 | $3,894 | |||
50 | Less: government solar feed-in tariff | ($3,900) | ($3,900) | ($3,900) | $0 | ($3,900) | |||
51 | Less: retailer solar feed-in tariff | ($390) | $0 | ($520) | $0 | $0 | |||
52 | Net cost (rebate) before discount | ($264) | ($6) | ($526) | $0 | ($6) | |||
53 | Less: discount | $0 | ($431) | ($252) | $0 | $0 | |||
54 | Net cost (rebate) after discount | ($264) | ($438) | ($778) | n/a | ($6) | |||
55 | Effective headline discount % | 10.0% | 11.1% | 19.8% | 0.0% | 0.0% | |||
56 | |||||||||
57 | Results | ||||||||
58 | Best offer is … | AGL Contract | |||||||
59 | Extra cost relative to the best deal | $514 | $340 | $0 | n/a | $772 | |||
60 | Gross cost before discount | cents/kWh | 28.76 | 27.81 | 27.81 | n/a | 27.81 | ||
61 | |||||||||
62 | Chart | ||||||||
63 | Offer | TruEnergy Contract | Energy Aust Contract | AGL Contract | Other | Energy Aust No Contract | |||
64 | Net cost (rebate) after discount | ($264) | ($438) | ($778) | $0 | ($6) | |||
65 | |||||||||
66 | |||||||||
67 | |||||||||
68 | |||||||||
69 | |||||||||
70 | |||||||||
71 | |||||||||
72 | |||||||||
73 | |||||||||
74 | |||||||||
75 | |||||||||
76 | |||||||||
77 | |||||||||
78 | |||||||||
79 | |||||||||
80 | |||||||||
81 | |||||||||
82 | |||||||||
83 | |||||||||
84 | |||||||||
85 | |||||||||
86 | |||||||||
87 | |||||||||
88 | |||||||||