| A | B | C | D | |
|---|---|---|---|---|
1 | Inputs | |||
2 | ||||
3 | Number of People in Home (enter a number between 1 and 6) | Current Service ("Gas Instant", "Gas Storage" or "Electric Storage") | ||
4 | 1 | Gas storage | ||
5 | ||||
6 | Do you qualify for the Victorian Rebate? ("Yes" or "No") | Do you have solar? ("Yes" or "No") | ||
7 | yes | No | ||
8 | ||||
9 | Is hot water your last gas appliance? ("Yes" or "No") | |||
10 | no | |||
11 | ||||
12 | ||||
13 | Calculations | |||
14 | ||||
15 | Estimated Current Running Costs | Estimated Heat Pump Running Costs | ||
16 | $365 | $125 | ||
17 | ||||
18 | Yearly Savings | |||
19 | $240 | |||
20 | ||||
21 | Heat Pump Hot Water Cost (Unit) | Payback Period (years) | ||
22 | $1,498 | 6.2 | ||
23 | ||||
24 | Internal Rate of Return - 10 year | Internal Rate of Return - 15 year | ||
25 | 9.6% | 13.7% | ||
26 | ||||