Money saved by producing electricity from PV and Years for payback


1	Legend:
2	The first table in Sheet: "Saved money per year(kWh/kWp * Price)" calculates how much money will an PV roof system save (from not buying electricity from the grid) given the kWh one kWp produces per year and the price of electricity. Assuming one uses all the electricity produced by the PV system and the price of electricity stays constant in the following years.
3
4
5
6
7
8
9	The second table in Sheet "Years for system payback" takes a number from the first table and calculates how many years it will take for one kWp to pay back given the installation cost.
10
11
12
13
14
15	Note: It is also interesting to exclude the "soft cost" (non-hardware BoS) of a PV system and make the same calculations only for the hardware. This is helpful when one is installing the PV system by him/her self and not paying for labor or other expenses.
16
17
18
19
20	Hope you find it helpfull.
21
22	Near accurate examples:
23	Bulgaria: 1250 kWh/kWp with 0.09 eurocents/kWh saves 113 euros per year. With installation cost of 12000-1500 euro/kWp the result is 8-12 years
24
25
26	Germany: 900 kWh/kWp with 0.25 eurocents/kWh saves 225 euro per year, 1700 euro/kWp the result is around 7-8 years
27
28
29	Italy : 1350+ kWh/kWp and 0.20 eurocents/kWh saves 270 euro and with Germany installation cost - the result is less than 7 years
30
31
32	Data taken from (July 2012):
33	www.energy.eu
34	http://www.solarwirtschaft.de/preisindex
35	http://re.jrc.ec.europa.eu/pvgis/
36	Same page but in Google Docs for better column/row selecting:
37	https://docs.google.com/spreadsheet/ccc?key=0Ahl2afL-jL0BdEVGU3dsbllfTzlxMEV0aTNqT0d5Nnc#gid=2
38


1	Price of electricity:		0.05	0.06	0.07	0.08	0.09	0.10	0.11	0.12	0.13	0.14	0.15	0.16	0.17	0.18	0.19	0.20	0.21	0.22	0.23	0.24	0.25	0.26	0.27	0.28	0.29	0.30	0.31	0.32	0.33	0.34	0.35	0.36	0.37
2	kWh/kWp	600	30	36	42	48	54	60	66	72	78	84	90	96	102	108	114	120	126	132	138	144	150	156	162	168	174	180	186	192	198	204	210	216	222
3	kWh/kWp	650	33	39	46	52	59	65	72	78	85	91	98	104	111	117	124	130	137	143	150	156	163	169	176	182	189	195	202	208	215	221	228	234	241
4	kWh/kWp	700	35	42	49	56	63	70	77	84	91	98	105	112	119	126	133	140	147	154	161	168	175	182	189	196	203	210	217	224	231	238	245	252	259
5	kWh/kWp	750	38	45	53	60	68	75	83	90	98	105	113	120	128	135	143	150	158	165	173	180	188	195	203	210	218	225	233	240	248	255	263	270	278
6	kWh/kWp	800	40	48	56	64	72	80	88	96	104	112	120	128	136	144	152	160	168	176	184	192	200	208	216	224	232	240	248	256	264	272	280	288	296
7	kWh/kWp	850	43	51	60	68	77	85	94	102	111	119	128	136	145	153	162	170	179	187	196	204	213	221	230	238	247	255	264	272	281	289	298	306	315
8	kWh/kWp	900	45	54	63	72	81	90	99	108	117	126	135	144	153	162	171	180	189	198	207	216	225	234	243	252	261	270	279	288	297	306	315	324	333
9	kWh/kWp	950	48	57	67	76	86	95	105	114	124	133	143	152	162	171	181	190	200	209	219	228	238	247	257	266	276	285	295	304	314	323	333	342	352
10	kWh/kWp	1,000	50	60	70	80	90	100	110	120	130	140	150	160	170	180	190	200	210	220	230	240	250	260	270	280	290	300	310	320	330	340	350	360	370
11	kWh/kWp	1,050	53	63	74	84	95	105	116	126	137	147	158	168	179	189	200	210	221	231	242	252	263	273	284	294	305	315	326	336	347	357	368	378	389
12	kWh/kWp	1,100	55	66	77	88	99	110	121	132	143	154	165	176	187	198	209	220	231	242	253	264	275	286	297	308	319	330	341	352	363	374	385	396	407
13	kWh/kWp	1,150	58	69	81	92	104	115	127	138	150	161	173	184	196	207	219	230	242	253	265	276	288	299	311	322	334	345	357	368	380	391	403	414	426
14	kWh/kWp	1,200	60	72	84	96	108	120	132	144	156	168	180	192	204	216	228	240	252	264	276	288	300	312	324	336	348	360	372	384	396	408	420	432	444
15	kWh/kWp	1,250	63	75	88	100	113	125	138	150	163	175	188	200	213	225	238	250	263	275	288	300	313	325	338	350	363	375	388	400	413	425	438	450	463
16	kWh/kWp	1,300	65	78	91	104	117	130	143	156	169	182	195	208	221	234	247	260	273	286	299	312	325	338	351	364	377	390	403	416	429	442	455	468	481
17	kWh/kWp	1,350	68	81	95	108	122	135	149	162	176	189	203	216	230	243	257	270	284	297	311	324	338	351	365	378	392	405	419	432	446	459	473	486	500
18	kWh/kWp	1,400	70	84	98	112	126	140	154	168	182	196	210	224	238	252	266	280	294	308	322	336	350	364	378	392	406	420	434	448	462	476	490	504	518
19	kWh/kWp	1,450	73	87	102	116	131	145	160	174	189	203	218	232	247	261	276	290	305	319	334	348	363	377	392	406	421	435	450	464	479	493	508	522	537
20	kWh/kWp	1,500	75	90	105	120	135	150	165	180	195	210	225	240	255	270	285	300	315	330	345	360	375	390	405	420	435	450	465	480	495	510	525	540	555
21	kWh/kWp	1,550	78	93	109	124	140	155	171	186	202	217	233	248	264	279	295	310	326	341	357	372	388	403	419	434	450	465	481	496	512	527	543	558	574
22	kWh/kWp	1,600	80	96	112	128	144	160	176	192	208	224	240	256	272	288	304	320	336	352	368	384	400	416	432	448	464	480	496	512	528	544	560	576	592
23	kWh/kWp	1,650	83	99	116	132	149	165	182	198	215	231	248	264	281	297	314	330	347	363	380	396	413	429	446	462	479	495	512	528	545	561	578	594	611
24	kWh/kWp	1,700	85	102	119	136	153	170	187	204	221	238	255	272	289	306	323	340	357	374	391	408	425	442	459	476	493	510	527	544	561	578	595	612	629
25	kWh/kWp	1,750	88	105	123	140	158	175	193	210	228	245	263	280	298	315	333	350	368	385	403	420	438	455	473	490	508	525	543	560	578	595	613	630	648
26	kWh/kWp	1,800	90	108	126	144	162	180	198	216	234	252	270	288	306	324	342	360	378	396	414	432	450	468	486	504	522	540	558	576	594	612	630	648	666
27	kWh/kWp	1,850	93	111	130	148	167	185	204	222	241	259	278	296	315	333	352	370	389	407	426	444	463	481	500	518	537	555	574	592	611	629	648	666	685


1	Saved money / year (kWh/kWp * Price) - from Sheet1		25	50	75	100	125	150	175	200	225	250	275	300	325	350	375	400	425	450	475	500	525	550	575	600	625
2	Installation cost / kWp	500	20.0	10.0	6.7	5.0	4.0	3.3	2.9	2.5	2.2	2.0	1.8	1.7	1.5	1.4	1.3	1.3	1.2	1.1	1.1	1.0	1.0	0.9	0.9	0.8	0.8
3	Installation cost / kWp	600	24.0	12.0	8.0	6.0	4.8	4.0	3.4	3.0	2.7	2.4	2.2	2.0	1.8	1.7	1.6	1.5	1.4	1.3	1.3	1.2	1.1	1.1	1.0	1.0	1.0
4	Installation cost / kWp	700	28.0	14.0	9.3	7.0	5.6	4.7	4.0	3.5	3.1	2.8	2.5	2.3	2.2	2.0	1.9	1.8	1.6	1.6	1.5	1.4	1.3	1.3	1.2	1.2	1.1
5	Installation cost / kWp	800	32.0	16.0	10.7	8.0	6.4	5.3	4.6	4.0	3.6	3.2	2.9	2.7	2.5	2.3	2.1	2.0	1.9	1.8	1.7	1.6	1.5	1.5	1.4	1.3	1.3
6	Installation cost / kWp	900	36.0	18.0	12.0	9.0	7.2	6.0	5.1	4.5	4.0	3.6	3.3	3.0	2.8	2.6	2.4	2.3	2.1	2.0	1.9	1.8	1.7	1.6	1.6	1.5	1.4
7	Installation cost / kWp	1,000	40.0	20.0	13.3	10.0	8.0	6.7	5.7	5.0	4.4	4.0	3.6	3.3	3.1	2.9	2.7	2.5	2.4	2.2	2.1	2.0	1.9	1.8	1.7	1.7	1.6
8	Installation cost / kWp	1,100	44.0	22.0	14.7	11.0	8.8	7.3	6.3	5.5	4.9	4.4	4.0	3.7	3.4	3.1	2.9	2.8	2.6	2.4	2.3	2.2	2.1	2.0	1.9	1.8	1.8
9	Installation cost / kWp	1,200	48.0	24.0	16.0	12.0	9.6	8.0	6.9	6.0	5.3	4.8	4.4	4.0	3.7	3.4	3.2	3.0	2.8	2.7	2.5	2.4	2.3	2.2	2.1	2.0	1.9
10	Installation cost / kWp	1,300	52.0	26.0	17.3	13.0	10.4	8.7	7.4	6.5	5.8	5.2	4.7	4.3	4.0	3.7	3.5	3.3	3.1	2.9	2.7	2.6	2.5	2.4	2.3	2.2	2.1
11	Installation cost / kWp	1,400	56.0	28.0	18.7	14.0	11.2	9.3	8.0	7.0	6.2	5.6	5.1	4.7	4.3	4.0	3.7	3.5	3.3	3.1	2.9	2.8	2.7	2.5	2.4	2.3	2.2
12	Installation cost / kWp	1,500	60.0	30.0	20.0	15.0	12.0	10.0	8.6	7.5	6.7	6.0	5.5	5.0	4.6	4.3	4.0	3.8	3.5	3.3	3.2	3.0	2.9	2.7	2.6	2.5	2.4
13	Installation cost / kWp	1,600	64.0	32.0	21.3	16.0	12.8	10.7	9.1	8.0	7.1	6.4	5.8	5.3	4.9	4.6	4.3	4.0	3.8	3.6	3.4	3.2	3.0	2.9	2.8	2.7	2.6
14	Installation cost / kWp	1,700	68.0	34.0	22.7	17.0	13.6	11.3	9.7	8.5	7.6	6.8	6.2	5.7	5.2	4.9	4.5	4.3	4.0	3.8	3.6	3.4	3.2	3.1	3.0	2.8	2.7
15	Installation cost / kWp	1,800	72.0	36.0	24.0	18.0	14.4	12.0	10.3	9.0	8.0	7.2	6.5	6.0	5.5	5.1	4.8	4.5	4.2	4.0	3.8	3.6	3.4	3.3	3.1	3.0	2.9
16	Installation cost / kWp	1,900	76.0	38.0	25.3	19.0	15.2	12.7	10.9	9.5	8.4	7.6	6.9	6.3	5.8	5.4	5.1	4.8	4.5	4.2	4.0	3.8	3.6	3.5	3.3	3.2	3.0
17	Installation cost / kWp	2,000	80.0	40.0	26.7	20.0	16.0	13.3	11.4	10.0	8.9	8.0	7.3	6.7	6.2	5.7	5.3	5.0	4.7	4.4	4.2	4.0	3.8	3.6	3.5	3.3	3.2
18	Installation cost / kWp	2,100	84.0	42.0	28.0	21.0	16.8	14.0	12.0	10.5	9.3	8.4	7.6	7.0	6.5	6.0	5.6	5.3	4.9	4.7	4.4	4.2	4.0	3.8	3.7	3.5	3.4
19	Installation cost / kWp	2,200	88.0	44.0	29.3	22.0	17.6	14.7	12.6	11.0	9.8	8.8	8.0	7.3	6.8	6.3	5.9	5.5	5.2	4.9	4.6	4.4	4.2	4.0	3.8	3.7	3.5
20	Installation cost / kWp	2,300	92.0	46.0	30.7	23.0	18.4	15.3	13.1	11.5	10.2	9.2	8.4	7.7	7.1	6.6	6.1	5.8	5.4	5.1	4.8	4.6	4.4	4.2	4.0	3.8	3.7
21	Installation cost / kWp	2,400	96.0	48.0	32.0	24.0	19.2	16.0	13.7	12.0	10.7	9.6	8.7	8.0	7.4	6.9	6.4	6.0	5.6	5.3	5.1	4.8	4.6	4.4	4.2	4.0	3.8
22	Installation cost / kWp	2,500	100.0	50.0	33.3	25.0	20.0	16.7	14.3	12.5	11.1	10.0	9.1	8.3	7.7	7.1	6.7	6.3	5.9	5.6	5.3	5.0	4.8	4.5	4.3	4.2	4.0
23	Installation cost / kWp	2,600	104.0	52.0	34.7	26.0	20.8	17.3	14.9	13.0	11.6	10.4	9.5	8.7	8.0	7.4	6.9	6.5	6.1	5.8	5.5	5.2	5.0	4.7	4.5	4.3	4.2
24	Installation cost / kWp	2,700	108.0	54.0	36.0	27.0	21.6	18.0	15.4	13.5	12.0	10.8	9.8	9.0	8.3	7.7	7.2	6.8	6.4	6.0	5.7	5.4	5.1	4.9	4.7	4.5	4.3
25	Installation cost / kWp	2,800	112.0	56.0	37.3	28.0	22.4	18.7	16.0	14.0	12.4	11.2	10.2	9.3	8.6	8.0	7.5	7.0	6.6	6.2	5.9	5.6	5.3	5.1	4.9	4.7	4.5
26	Installation cost / kWp	2,900	116.0	58.0	38.7	29.0	23.2	19.3	16.6	14.5	12.9	11.6	10.5	9.7	8.9	8.3	7.7	7.3	6.8	6.4	6.1	5.8	5.5	5.3	5.0	4.8	4.6
27	Installation cost / kWp	3,000	120.0	60.0	40.0	30.0	24.0	20.0	17.1	15.0	13.3	12.0	10.9	10.0	9.2	8.6	8.0	7.5	7.1	6.7	6.3	6.0	5.7	5.5	5.2	5.0	4.8
28	Installation cost / kWp	3,100	124.0	62.0	41.3	31.0	24.8	20.7	17.7	15.5	13.8	12.4	11.3	10.3	9.5	8.9	8.3	7.8	7.3	6.9	6.5	6.2	5.9	5.6	5.4	5.2	5.0
29	Installation cost / kWp	3,200	128.0	64.0	42.7	32.0	25.6	21.3	18.3	16.0	14.2	12.8	11.6	10.7	9.8	9.1	8.5	8.0	7.5	7.1	6.7	6.4	6.1	5.8	5.6	5.3	5.1
30	Installation cost / kWp	3,300	132.0	66.0	44.0	33.0	26.4	22.0	18.9	16.5	14.7	13.2	12.0	11.0	10.2	9.4	8.8	8.3	7.8	7.3	6.9	6.6	6.3	6.0	5.7	5.5	5.3
31	Installation cost / kWp	3,400	136.0	68.0	45.3	34.0	27.2	22.7	19.4	17.0	15.1	13.6	12.4	11.3	10.5	9.7	9.1	8.5	8.0	7.6	7.2	6.8	6.5	6.2	5.9	5.7	5.4
32	Installation cost / kWp	3,500	140.0	70.0	46.7	35.0	28.0	23.3	20.0	17.5	15.6	14.0	12.7	11.7	10.8	10.0	9.3	8.8	8.2	7.8	7.4	7.0	6.7	6.4	6.1	5.8	5.6
33	Installation cost / kWp	3,600	144.0	72.0	48.0	36.0	28.8	24.0	20.6	18.0	16.0	14.4	13.1	12.0	11.1	10.3	9.6	9.0	8.5	8.0	7.6	7.2	6.9	6.5	6.3	6.0	5.8
34	Installation cost / kWp	3,700	148.0	74.0	49.3	37.0	29.6	24.7	21.1	18.5	16.4	14.8	13.5	12.3	11.4	10.6	9.9	9.3	8.7	8.2	7.8	7.4	7.0	6.7	6.4	6.2	5.9
35	Installation cost / kWp	3,800	152.0	76.0	50.7	38.0	30.4	25.3	21.7	19.0	16.9	15.2	13.8	12.7	11.7	10.9	10.1	9.5	8.9	8.4	8.0	7.6	7.2	6.9	6.6	6.3	6.1
36	Installation cost / kWp	3,900	156.0	78.0	52.0	39.0	31.2	26.0	22.3	19.5	17.3	15.6	14.2	13.0	12.0	11.1	10.4	9.8	9.2	8.7	8.2	7.8	7.4	7.1	6.8	6.5	6.2
37	Installation cost / kWp	4,000	160.0	80.0	53.3	40.0	32.0	26.7	22.9	20.0	17.8	16.0	14.5	13.3	12.3	11.4	10.7	10.0	9.4	8.9	8.4	8.0	7.6	7.3	7.0	6.7	6.4