Solar quotes.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	Technical Specs
2	Number of panels	26	26	27	31	28	29	32	24	30	33
3	Watts per panel (per hour)	400	365	395	360	380	365	340	440	365	320
4	Number of inverters	26	26		1	28	2	32	1	30	1
5	System size	10.4	9.5	10.66	11.16	10.64	10.585	10.88	10.56	10.95	10.56
6	Price per Watt (panels only)	$ 2.40	$ 3.25		$ 2.54	$ 2.70	$ 2.50	$ 2.45	$ 2.20	$ 2.57	$ 2.20
7	Price per Watt (inc. dealer fee)	$ 3.47	$ 3.76	$ 3.73	$ 3.19	$ 3.67	$ 3.12	$ 2.45	$ 2.82	$ 2.57	$ 2.60
8	Year 1 Production Est.	14400	14243	14596	15163	15024	15021	15500	15400	14776	14995
9	Panel Manufacturer	Aptos Solar Technology	REC		Aptos Solar Technology	Silfab Solar	REC	Panasonic	Aptos	REC	REC
10	Panel Model	Aptos DNA-144-xx23-400W	REC365AA Alpha Black	Q Cell 395	120-BF26-360W DNA	SIL-380 Elite	REC365AA Alpha	VBHN340SA17	144-BF26-440W DNA	REC365AA Alpha	REC320NP Black-REC ProTrust
11	Efficiency	19.88%	20.90%	19.90%	20.42%	21.40%	20.90%	20.30%	20.21%	20.90%	19.20%
12	Inverter Manufacturer	Enphase Energy	Enphase	SolarEdge	SolarEdge Technologies	Enphase Energy	SMA America	Enphase Energy	Growatt	Enphase Energy	Fronius USA
13	Inverter model	Micro-inverters	IQ7PLUS-72-x-US-240		SE10000H-US	IQ7A-72-2-US-240	SB7000TL-US-12	IQ7X-96-x-US-240	11400TL-XH-US	IQ7PLUS-72-x-US-240	Fronius Primo 10.0-1
14
15	Loan Information
16	Loan term	25	20	25	25	20	20	25	20	12	20
17	Interest rate	1.49%	0.99%	1.99%	1.99%	0.99%	1.99%	1.99%	0.99%	4.99%	2.99%
18
19	Bottom Line - with Credit
20	Base System Price	$ 24,960.00	$ 30,868.56		$ 28,346.00	$ 28,728.00	$ 26,453.00	$ 26,656.00	$ 23,232.00	$ 28,152.00	$ 23,232.00
21	Dealer Fee	$ 11,079.00	$ 4,832.85		$ 7,229.00	$ 10,342.00	$ 6,625.00		$ 6,505.00	$ -	$ 4,182.00
22	Gross system price	$ 36,039.00	$ 35,701.41	$ 39,712.45	$ 35,575.00	$ 39,070.00	$ 33,078.00	$ 26,656.00	$ 29,737.00	$ 28,152.00	$ 27,414.00
23	Less Federal Credit	$ (9,370.14)	$ (9,282.37)	$ (10,325.24)	$ (9,249.50)	$ (10,158.20)	$ (8,600.28)	$ (6,930.56)	$ (7,731.62)	$ (7,319.52)	$ (7,127.64)
24	Loan Amount	$ 26,668.86	$ 26,419.04	$ 29,387.21	$ 26,325.50	$ 28,911.80	$ 24,477.72	$ 19,725.44	$ 22,005.38	$ 20,832.48	$ 20,286.36
25	Total Interest	$ 5,291.10	$ 2,712.60		$ 7,110.60	$ 2,968.55	$ 5,213.36	$ 5,327.90	$ 2,567.52	6898.05	6691.11
26	Net system Price w/ Interest	$ 31,959.96	$ 29,131.64	$ 29,387.21	$ 33,436.10	$ 31,880.35	$ 29,691.08	$ 25,053.34	$ 24,572.90	$ 27,730.53	$ 26,977.47
27	Monthly Payment	$ 106.53	$ 121.38	$ 97.96	$ 111.45	$ 132.83	$ 123.71	$ 83.51	$ 102.39	$ 192.57	$ 112.41
28
29	Bottom Line - without Credit
30	Base System Price	$ 24,960.00	$ 30,868.56		$ 28,346.00	$ 28,728.00	$ 26,453.00	$ 26,656.00	$ 23,232.00	$ 28,152.00	$ 23,232.00
31	Dealer Fee	$ 11,079.00	$ 4,832.85		$ 7,229.00	$ 10,342.00	$ 6,625.00		$ 6,505.00	$ -	$ 4,182.00
32	Gross system price / Loan Amt	$ 36,039.00	$ 35,701.41	$ 39,712.45	$ 35,575.00	$ 39,070.00	$ 33,078.00	$ 26,656.00	$ 29,737.00	$ 28,152.00	$ 27,414.00
33	Total Interest	$ 8,341.73	$ 3,665.68		$ 9,608.91	$ 4,011.55	$ 7,045.07	$ 7,199.87	$ 3,469.63	9321.69	9042.05
34	Net system Price w/ Interest	$ 44,380.73	$ 39,367.09	$ 39,712.45	$ 45,183.91	$ 43,081.55	$ 40,123.07	$ 33,855.87	$ 33,206.63	$ 37,473.69	$ 36,456.05
35	Monthly Payment	$ 147.94	$ 164.03	$ 132.37	$ 150.61	$ 179.51	$ 167.18	$ 112.85	$ 138.36	$ 260.23	$ 151.90
36
37	Warranty Information
38	Panel Warranty (years)	25	25		30	30	25	25	30	25	25
39	Inverter warranty (years)	25	25		25	25	20	25	10	25	20
40	Labor warranty (years)	25	10		25	25	25	25	25	25	25
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