Year

1
No Assumptions A

1 Life time of PV Years 20 1

2 Rated Capacity of PV System (RC) KWp 20 2
Module Efficiency (ME) % 18% 3
Hours/Year Hours 8,760 4
3 Yield (RC * ME * hours/year) kwh/year 1,800 5
4 Degradation Factor % 1.0% 6
5 % Own Consumption % 100% 7
6 DU Total Customer Charge PHP/kWh 4 8
7 Annual Increase in DU/Generation Charge % 1% 9
8 % Net Export % 0% 10
9 DU Generation Charge PHP/kWh 5.4951 11
10 Operations and Maintenance/Year/KWp PHP 250 12
Cost of installed PV System PHP/kWp 13
11 Cost of installed PV System total PHP #VALUE! 14
15
Key Performance Indicators 16
Total Solar Energy Produced kwh 32,777 17
Total Cost PHP #VALUE! 18
Total Savings PHP 43,863 19
Break Even Year 8 20
Internal Rate of Return % #VALUE!
Total

Developed by Markus Dietrich, GIZ Consultant

Total Solar Solar Energy DU Total Avoided Cost Solar Energy Generation
Energy Own Customer Export Charge
Produced Consumption Charge

kWh kWh PHP/KWH PHP kWh PHP/KWH

3 - 4(per year) B*5 6 + 7(per year) C*D B*8 9 + 7(per year)

B C D E F G

1,800 1,800 4.0000 7,200 - 5.4951

1,782 1,782 4.0400 7,199 - 5.5501
1,764 1,764 4.0804 7,199 - 5.6056
1,747 1,747 4.1212 7,198 - 5.6616
1,729 1,729 4.1624 7,197 - 5.7182
1,712 1,712 4.2040 7,196 - 5.7754
1,695 1,695 4.2461 7,196 - 5.8332
1,678 1,678 4.2885 7,195 - 5.8915
1,661 1,661 4.3314 7,194 - 5.9504
1,644 1,644 4.3747 7,194 - 6.0099
1,628 1,628 4.4185 7,193 - 6.0700
1,612 1,612 4.4627 7,192 - 6.1307
1,595 1,595 4.5073 7,191 - 6.1920
1,580 1,580 4.5524 7,191 - 6.2539
1,564 1,564 4.5979 7,190 - 6.3165
1,548 1,548 4.6439 7,189 - 6.3796
1,533 1,533 4.6903 7,188 - 6.4434
1,517 1,517 4.7372 7,188 - 6.5079
1,502 1,502 4.7846 7,187 - 6.5729
1,487 1,487 4.8324 7,186 - 6.6387

32,777 32,777 143,863 -

23.2258064516
Yield
kwh/year kwp kwh/kwp
Leyte 15871 11.76 1349.57482993
QC 31750 22.05 1439.90929705
Uni Solar 15930 11 1448.18181818
Pasig Meralco 6870 6.16 1115.25974026
BPI 3932 5 786.4
Toyota 86800 62 1400

Average Yield kw 1400

Credit from Savings O&M Total Savings Investment and
Export Cumulative
Savings

PHP PHP PHP PHP PHP

F*G E+H 2 * 10 I-J 11 - K

H I J K L
#VALUE!
- 7,200 5,000 2,200 #VALUE!
- 7,199 5,000 2,199 #VALUE!
- 7,199 5,000 2,199 #VALUE!
- 7,198 5,000 2,198 #VALUE!
- 7,197 5,000 2,197 #VALUE!
- 7,196 5,000 2,196 #VALUE!
- 7,196 5,000 2,196 #VALUE!
- 7,195 5,000 2,195 #VALUE!
- 7,194 5,000 2,194 #VALUE!
- 7,194 5,000 2,194 #VALUE!
- 7,193 5,000 2,193 #VALUE!
- 7,192 5,000 2,192 #VALUE!
- 7,191 5,000 2,191 #VALUE!
- 7,191 5,000 2,191 #VALUE!
- 7,190 5,000 2,190 #VALUE!
- 7,189 5,000 2,189 #VALUE!
- 7,188 5,000 2,188 #VALUE!
- 7,188 5,000 2,188 #VALUE!
- 7,187 5,000 2,187 #VALUE!
- 7,186 5,000 2,186 #VALUE!

- 143,863 100,000 43,863