ABCDEFGHIJKLMNOPQRSTUVW
1
YearInvestmentMaintenance
Electricity income
FiT income
Diverter Investment
Diverter savingTotalAssumptionsCash ISA
Other investment
AnnuityCash ISAFinancing Method
2
3
0-£11,600.00£0.00-£11,600.00Initial investment£11,600.00-£11,600.00-£11,600.00-£11,600.00-£11,600.00£0.00
4
1£0.00£730.37£0.00£0.00£730.37ISA savings rate5.00%£580.00£0.00£580.00£580.00£730.37
5
2£0.00£730.37£0.00£0.00£730.37Annual maintenance (£)0£580.00£0.00£580.00£580.00£730.37
6
3£0.00£730.37£0.00£0.00£730.37FiT/kw (p inc export)0£580.00£0.00£580.00£580.00£730.37
7
4£0.00£730.37£0.00£0.00£730.37Inverter replacement cost (£)1450£580.00£0.00£580.00£580.00£730.37
8
5£0.00£730.37£0.00£0.00£730.37Gen Electricity usage (%)59£580.00£0.00£580.00£580.00£730.37
9
6£0.00£730.37£0.00£0.00£730.37Electricity cost per kw/h (p)24£580.00£0.00£580.00£580.00£730.37
10
7£0.00£730.37£0.00£0.00£730.37Annual generation (kw/h)5158£580.00£0.00£580.00£580.00£730.37
11
8£0.00£730.37£0.00£0.00£730.37Diverter investment0£580.00£0.00£580.00£580.00£730.37
12
9£0.00£730.37£0.00£0.00£730.37Diverter kw/h savings (year)0£580.00£0.00£580.00£580.00£730.37
13
10£0.00£730.37£0.00£0.00£730.37Assumed gas price (p)9£580.00£0.00£580.00£12,180.00£730.37
14
11£0.00£730.37£0.00£0.00£730.37Diverter replacement cost0£580.00£0.00£730.37
15
12-£1,450.00£0.00£730.37£0.00-£719.63Other investment rate0.00%£580.00£0.00-£719.63
16
13£0.00£730.37£0.00£0.00£730.37Annuity Rate5.00%£580.00£0.00£730.37
17
14£0.00£730.37£0.00£0.00£730.37Finance cost0.00%£580.00£0.00£730.37
18
15£0.00£730.37£0.00£0.00£730.37
Inverter and diverter replaced at year 12
£580.00£0.00£730.37
19
16£0.00£730.37£0.00£0.00£730.37FiT lasts 20 years£580.00£0.00£730.37
20
17£0.00£730.37£0.00£0.00£730.37
Assumed gas price should include boiler wear/tear & efficiencies
£580.00£0.00£730.37
21
18£0.00£730.37£0.00£0.00£730.37£580.00£0.00£730.37
22
19£0.00£730.37£0.00£0.00£730.37£580.00£0.00£730.37
23
20£0.00£730.37£0.00£0.00£730.37£12,180.00£0.00£730.37
24
£0.00£0.00
25
£0.00£0.00
26
£0.00£0.00
27
£0.00£0.00
28
£11,600.00-£11,600.00
29
30
ROI %1.25%5.0%0.0%
31
Total CF's-£13,050.00£0.00£14,607.46£0.00£0.00£0.00£1,557.46£11,600.00£0.00£1,557.46
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100