Solar Spreadsheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Solar PV Payback Calculation
2
3		Cost per kW Installed (£)	1,287		Enter your own figures in ORANGE boxes
4		Installed Cost (£)	10,814		PAYBACK reached in year where cells turn GREEN in Accumulative Total
5					Notes:						Year	Power (kW)	Payment
6		Size of the Array (kWp)	8.4		> Calculations ignore the time value of money					Per kW Calculator	2	8600	£ 569.32
7		Load Factor	1		> Assumes inverter lasts 20 years					Energy Saved	2	3000	£ 435.00
8		Solar Radiation Factor	990							Energy purchased	2	1280	£ 185.60
9		Overshading Factor	1				103%						£ 818.72	Total Saving
10		Estimated Output (kWh/annum)	8316				Assumed Annual Rate of Inflation			% of Energy Used on Site	Annual Increase in Energy Cost
11							3%			100%	10%
12	Year	Estimated Output Taking Degradation at 1% loss/year into Account (kWh/annum)	Efficiency of Cells	Up to 4kW FIT (p/kWh)	10+ kW FIT (p/kWh)	inflation compound factor	Generation FIT including inflation (p/wKh)	Export Tariff	Total Generation annual income (£)	Energy Used on Site (kWh)	Energy Cost (p)	Savings from Energy Used (£)	Renewable Heat Incentive Income	Total Income & Saving per year (£)	Accumulative Total (£)	Year
13	1	8316	100%	3.9	4.2	1.03	3.8	5.2	531	3305	15.06	498		1,029	1,029	1
14	2	8316	100%	3.9	4.2	1.06	3.9	5.5	551	3305	14.5	479		1,030	2,059	2
15	3	8316	100%	3.9	4.2	1.09	4.6	5.5	608	3305	15.0	496		1,103	3,162	3
16	4	8233	99%	3.9	4.2	1.13	4.7	5.5	613	3305	27.0	892		1,505	4,667	4
17	5	8151	98%	3.9	4.2	1.16	4.8	6.8	666	3305	37.9	1253		1,919	6,586	5
18	6	8069	97%	3.9	4.2	1.19	5.0	7.1	694	3305	24.7	816		1,510	8,097	6
19	7	7988	96%	3.9	4.2	1.23	5.1	7.4	706	3305	27.2	898		1,604	9,701	7
20	8	7908	95%	3.9	4.2	1.27	5.3	7.7	723	3305	29.9	988		1,711	11,412	8
21	9	7829	94%	3.9	4.2	1.30	5.4	8.0	740	3305	32.9	1087		1,827	13,239	9
22	10	7751	93%	3.9	4.2	1.34	5.6	8.4	758	3305	36.2	1195		1,953	15,192	10
23	11	7674	92%	3.9	4.2	1.38	5.8	8.7	776	3305	39.8	1315		2,091	17,283	11
24	12	7597	91%	3.9	4.2	1.43	5.9	9.0	795	3305	43.8	1446		2,241	19,524	12
25	13	7521	90%	3.9	4.2	1.47	6.1	9.4	814	3305	48.1	1591		2,405	21,929	13
26	14	7446	90%	3.9	4.2	1.51	6.3	9.8	833	3305	52.9	1750		2,583	24,512	14
27	15	7371	89%	3.9	4.2	1.56	6.5	10.2	853	3305	58.2	1925		2,778	27,290	15
28	16	7297	88%	3.9	4.2	1.60	6.7	10.6	874	3305	64.1	2117		2,991	30,281	16
29	17	7224	87%	3.9	4.2	1.65	6.9	11.0	895	3305	70.5	2329		3,224	33,506	17
30	18	7152	86%	3.9	4.2	1.70	7.1	11.4	917	3305	77.5	2562		3,479	36,984	18
31	19	7081	85%	3.9	4.2	1.75	7.3	11.9	939	3305	85.3	2818		3,757	40,741	19
32	20	7010	84%	3.9	4.2	1.81	7.5	12.4	961	3305	93.8	3100		4,061	44,802	20
33	21	6940	83%						-	3305	103.2	3410		3,410	48,212	21
34	22	6870	83%						-	3305	113.5	3751		3,751	51,963	22
35	23	6802	82%						-	3305	124.8	4126		4,126	56,090	23
36	24	6734	81%						-	3305	137.3	4539		4,539	60,628	24
37	25	6666	80%						-	3305	151.1	4993		4,993	65,621	25
38	26	6600	79%						-	3305	166.2	5492		5,492	71,113	26
39	27	6534	79%						-	3305	182.8	6041		6,041	77,154	27
40	28	6468	78%						-	3305	201.1	6645		6,645	83,799	28
41	29	6404	77%						-	3305	221.2	7310		7,310	91,109	29
42	30	6340	76%						-	3305	243.3	8041		8,041	99,149	30
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