Financing of PV Installations
Investment costs 1,500,000.00 € Euros
kWp installed 1000 kWp
Applied interest rate 12%
Duration (years) 10 yrs
Feed-In-Tariff 0.12 Euros
Specific energy production 1450 kWh/kWp
Degradation / yr. 0.5%
Year 0 1 2
Energy generated (ideal) 1450000 1450000 1450000
Degradation 0.0% 0.5% 1.0%
Energy 2 Grid 397,260.3 1,442,750.0 1,435,500.0
CF for yr. #1 100
Returns 47,671.23 € 173,130.00 € 172,260.00 €
Reserves for reinvestment 0 -6,000.00 € -6,000.00 €
Process of reinvestment 6,000.00 € 12,000.00 €
Reserves for maintenance 0 -3,000.00 € -3,000.00 €
Annuity 0 -265,476.25 € -265,476.25 €
Profit / Loss 47,671.23 € -101,346.25 € -102,216.25 €
Accumulated 47,671.23 € -53,675.01 € -155,891.26 €
Year 11 12
Energy generated (ideal) 1450000 1450000
Degradation 5.5% 6.0%
Energy 2 Grid 1,370,250.0 1,363,000.0
Returns 164,430.00 € 163,560.00 €
Reserves for reinvestment -6,000.00 € -6,000.00 €
Process of reinvestment 6,000.00 € 12,000.00 €
Reserves for maintenance -3,000.00 € -3,000.00 €
Annuity 0.00 € 0.00 €
Profit / Loss 155,430.00 € 154,560.00 €
Accumulated -849,511.23 € -694,951.23 €
1500 Euro / kWp
-265,476.25 € Euro / Annuity
Reserves 1 0.4 % of System Cost per yr.
Reserves 2 0.4 % of System Cost per yr.
Maintenance 0.2 % of System Cost per yr.
3 4 5 6 7
1450000 1450000 1450000 1450000 1450000
1.5% 2.0% 2.5% 3.0% 3.5%
1,428,250.0 1,421,000.0 1,413,750.0 1,406,500.0 1,399,250.0
171,390.00 € 170,520.00 € 169,650.00 € 168,780.00 € 167,910.00 €
-6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 €
18,000.00 € 24,000.00 € 30,000.00 € 36,000.00 € 42,000.00 €
-3,000.00 € -3,000.00 € -3,000.00 € -3,000.00 € -3,000.00 €
-265,476.25 € -265,476.25 € -265,476.25 € -265,476.25 € -265,476.25 €
-103,086.25 € -103,956.25 € -104,826.25 € -105,696.25 € -106,566.25 €
-258,977.51 € -362,933.75 € -467,760.00 € -573,456.24 € -680,022.49 €
13 14 15 16 17
1450000 1450000 1450000 1450000 1450000
6.5% 7.0% 7.5% 8.0% 8.5%
1,355,750.0 1,348,500.0 1,341,250.0 1,334,000.0 1,326,750.0
162,690.00 € 161,820.00 € 160,950.00 € 160,080.00 € 159,210.00 €
-6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 €
18,000.00 € 24,000.00 € 30,000.00 € 36,000.00 € 42,000.00 €
-3,000.00 € -3,000.00 € -3,000.00 € -3,000.00 € -3,000.00 €
0.00 € 0.00 € 0.00 € 0.00 € 0.00 €
153,690.00 € 152,820.00 € 151,950.00 € 151,080.00 € 150,210.00 €
-541,261.23 € -388,441.23 € -236,491.23 € -85,411.23 € 64,798.77 €
8 9 10 Sum
1450000 1450000 1450000
4.0% 4.5% 5.0%
1,392,000.0 1,384,750.0 1,377,500.0 14,498,510.3
167,040.00 € 166,170.00 € 165,300.00 € 1,739,821.2
-6,000.00 € -6,000.00 € -6,000.00 € -60,000.0
48,000.00 € 54,000.00 € 60,000.00 €
-3,000.00 € -3,000.00 € -3,000.00 € -30,000.0
-265,476.25 € -265,476.25 € -265,476.25 € -2,654,762.5
-107,436.25 € -108,306.25 € -109,176.25 € -1,004,941.23 €
-787,458.74 € -895,764.98 € -1,004,941.23 €
18 19 20
1450000 1450000 1450000
9.0% 9.5% 10.0%
1,319,500.0 1,312,250.0 1,305,000.0 13,376,250.0
158,340.00 € 157,470.00 € 156,600.00 €
-6,000.00 € -6,000.00 € -6,000.00 €
48,000.00 € 54,000.00 € 60,000.00 €
-3,000.00 € -3,000.00 € -3,000.00 €
0.00 € 0.00 € 0.00 €
149,340.00 € 148,470.00 € 147,600.00 € 1,515,150.00 €
214,138.77 € 362,608.77 € 510,208.77 €
Result
600,000.00 €
400,000.00 €
200,000.00 €
0.00 €
0 2 4 6 8 10 12 14 16 18 20
-200,000.00 €
-400,000.00 €
-600,000.00 €
-800,000.00 €
-1,000,000.00 €
-1,200,000.00 €
year 0 1 2 3 4 5
Result 47,671.23 € -53,675.01 € ########### ########### ########### -467,760.00 €
6 7 8 9 10 11 12
-573,456.24 € -680,022.49 € -787,458.74 € -895,764.98 € ########### ########### ###########
13 14 15 16 17 18
-541,261.23 € -388,441.23 € -236,491.23 € -85,411.23 € 64,798.77 € 214,138.77 €
19 20
362,608.77 € 510,208.77 €
Financing of PV Installations
Total Costs 3,000,000.00 € Euros
kWp installed 1000 kWp
Interest Rate 5%
Years 15 yrs
Feed-In-Tariff 0.25 Euros
Specific Energy 1500 kWh/kWp
Production
Degradation / yr. 0.5 %
Jahr 0 1 2
Erzeugte Energie 1500000 1500000 1500000
Degradation 0.0% 0.5% 1.0%
Eingespeiste Energie 1,500,000.0 1,492,500.0 1,485,000.0
CF for yr. #1 365
Einnahmen 375,000.00 € 373,125.00 € 371,250.00 €
Rücklagen für 0 -6,000.00 € -6,000.00 €
Reinvestition 6,000.00 € 12,000.00 €
Verlauf Reinvestition 0
Rücklagen für Wartung 0 -6,000.00 € -6,000.00 €
Annuity 0 -289,026.86 € -289,026.86 €
Profit / Loss 375,000.00 € 72,098.14 € 70,223.14 €
Kontostand -2,625,000.00 € -2,552,901.86 € -2,482,678.73 €
Jahr 11 12
Erzeugte Energie 1500000 1500000
Degradation 5.5% 6.0%
Eingespeiste Energie 1,417,500.0 1,410,000.0
Einnahmen 354,375.00 € 352,500.00 €
Rücklagen für -6,000.00 € -6,000.00 €
Reinvestition
Verlauf Reinvestition 6,000.00 € 12,000.00 €
Rücklagen für Wartung -6,000.00 € -6,000.00 €
Annuity -289,026.86 € -289,026.86 €
Profit / Loss 53,348.14 € 51,473.14 €
Kontostand -1,935,045.49 € 51,473.14 €
3000 Euro / kWp
-289,026.86 € Euro / Annuity
Ansatz für Rücklagen 0.2 % of System Cost per yr.
Ansatz für Wartung 0.2 % of System Cost per yr.
3 4 5 6 7
1500000 1500000 1500000 1500000 1500000
1.5% 2.0% 2.5% 3.0% 3.5%
1,477,500.0 1,470,000.0 1,462,500.0 1,455,000.0 1,447,500.0
369,375.00 € 367,500.00 € 365,625.00 € 363,750.00 € 361,875.00 €
-6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 €
18,000.00 € 24,000.00 € 30,000.00 € 36,000.00 € 42,000.00 €
-6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 €
-289,026.86 € -289,026.86 € -289,026.86 € -289,026.86 € -289,026.86 €
68,348.14 € 66,473.14 € 64,598.14 € 62,723.14 € 60,848.14 €
-2,414,330.59 € -2,347,857.45 € -2,283,259.31 € -2,220,536.18 € -2,159,688.04 €
13 14 15 16 17
1500000 1500000 1500000 1500000 1500000
6.5% 7.0% 7.5% 8.0% 8.5%
1,402,500.0 1,395,000.0 1,387,500.0 1,380,000.0 1,372,500.0
350,625.00 € 348,750.00 € 346,875.00 € 345,000.00 € 343,125.00 €
-6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 €
18,000.00 € 24,000.00 € 30,000.00 € 36,000.00 € 42,000.00 €
-6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 € -6,000.00 €
-289,026.86 € -289,026.86 € -289,026.86 € 0.00 € 0.00 €
49,598.14 € 47,723.14 € 45,848.14 € 333,000.00 € 331,125.00 €
49,598.14 € 47,723.14 € 45,848.14 € 333,000.00 € 331,125.00 €
8 9 10
1500000 1500000 1500000
4.0% 4.5% 5.0%
1,440,000.0 1,432,500.0 1,425,000.0
360,000.00 € 358,125.00 € 356,250.00 €
-6,000.00 € -6,000.00 € -6,000.00 €
48,000.00 € 54,000.00 € 60,000.00 €
60,000.00 €
-6,000.00 € -6,000.00 € -6,000.00 €
-289,026.86 € -289,026.86 € -289,026.86 €
58,973.14 € 57,098.14 € 55,223.14 €
-2,100,714.90 € -2,043,616.77 € -1,988,393.63 €
18 19 20
1500000 1500000 1500000
9.0% 9.5% 10.0%
1,365,000.0 1,357,500.0 1,350,000.0
341,250.00 € 339,375.00 € 337,500.00 €
-6,000.00 € -6,000.00 € -6,000.00 €
48,000.00 € 54,000.00 € 60,000.00 €
-6,000.00 € -6,000.00 € -6,000.00 €
0.00 € 0.00 € 0.00 €
329,250.00 € 327,375.00 € 325,500.00 €
329,250.00 € 327,375.00 € 325,500.00 €