Subscribe

CDM Solar PV Model2.xls

June 25th, 2012 Posted in renewable energy

CDM Solar PV Model2.xls

In addition to the worksheets found in the ADV models of the regulator, 5 additional tabs or worksheets have been added (Capex, Opex, Revenues, Project IRR and Sensitivity) into the CDM model which is a financial evaluation without taxes (that distort the economic and technical performance) and debt (pure equity investment). For the RE project to benefit from CDM credits, the project IRR should not be more than 15% p.a.

Solar energy is most available in countries near the equator. It can be harnessed using photo voltaic panels that when connected together in arrays can provide utility scale capacities of 5 MW modules and with 2 modules, could produce 10 MW of power in a given site.

This advanced model for Solar PV makes use of the basic assumptions of the country’s RE regulator for rated capacity (10 x 0.125 MW), capacity factor (14.3%), plant own use (3%), and 0.20% plant degradation rate.

It assumes equipment cost (FOB $/kW), ocean insurance and freight (10%), balance of plant (31%), G&A cost ($/year), O&M cost ($/kW/year), spare parts replacement cost ($/unit/year), substation and transmission line cost ($/km) and distance (km), access road cost ($/km) and distance (km), 2% project development cost, 12% VAT, 1% working capital and 7.5% contingency. VAT recovery is 70% on the 5th year. Days receivable and payable are 30 days.

Construction period is 12 months while operating period is 20 years. Cost of capital is 16% p.a. for 30% equity and 10% p.a. for 70% debt.

Exchange rate is 44.00 PhP/US$.

Incentives provided by the RE Law is applied such as the 7 years income tax holiday, after which a 10% income tax is applied. Property tax of 1.5% applied on 80% of book value. Local business tax is 1% of revenues while DOE 1-94 contribution is 0.01 PhP/kWh sold.

To order, pay and download this model, follow this link:

http://energydataexpert.com/product_info.php?cPath=19_37&products_id=182

The summary worksheet is shown below:

 

Project   Site Name & Location     Balangay
Renewable Energy Source     Solar
Hours per Year 8760
Timing
  Construction Period (from FC) (months) 12
  Operating Period (Yrs from COD) 20
  Yrs from base year CPI & Forex (2009)   for FIT 3
  Yrs from base year CPI (2011) for CAPEX 1
  Yrs from base year CPI (2011) for OPEX 2
Construction Sources and   Uses of Funds, $000
  Uses of Fund:
    EPC (Equipment, Balance of Plant,   Transport, Access Roads) $2,071
    Transmission Line Interconnection   Facility $2,186
    Sub-Station Facility $152
    Development & Other Costs $822
    Construction Contingency $393
    Value Added Tax $210
    Financing Costs $312
    Initial Working Capital $21
  Total Uses of Fund $6,166
  Sources of Fund:
    Debt $4,316
    Equity $1,850
  Total Sources of Fund $6,166
  Construction Unit Costs (US$/kW):
    EPC Cost $1,657
    Plant Cost (Excluding VAT, Financing,   Working Capital) $4,499
    All-in Project Cost $4,933
Model Check:
Balance Sheet   OK
Foreign Debt Amorization   OK
Local Debt Amortization   OK
Depreciation   OK
Sources and Uses of   Funds   OK
Debt-to-Equity Ratio   OK
Base Years
  Base year CPI & Forex for FiT 2009
  Base year CPI for CAPEX 2011
  Base year CPI for OPEX 2011
Commercial Operating Date 2012

 

Technical and EPC   Assumptions
Unit Capacity of Plant   (MW/unit) 0.125
No. of Units (unit) 10.0
Gross Installed Capacity   (MW) 1.25
Plant Availability Factor, % 15.00%
Guaranteed Efficiency   Factor, % 95.00%
Allowance for losses & own use, % 3.00%
Net Capacity Factor after   losses & own use, % 13.83%
Net Electrical Output (MWh   in 1st Year) 1,514
Plant Degration, % p.a.   (1-20 Yrs) 0.20%
             % LC
Equipment Cost ex BOP,   Transport ($000/MW) $1,147.00 0.0%
Insurance, Ocean Freight,   Local Transport 10.0% 100.0%
Balance of Plant (BOP), % of   Equipment Cost 31.0% 66.0%
Transmission Line Distance   (km) 25.00
T/L Cost per km, 69 kV   ($000/km) $84.09 100.0%
Switchyard &   Transformers ($000) $145.83 100.0%
Access Roads ($000/km) $50.00 100.0%
Distance of Access Road (km) 15.00
Dev’t & Other Costs   (land, permits, etc) (% of EPC) 2.0% 100.0%
VAT on importation (70%   recoverable) 12% 100.0%
Initial Working Capital (%   of EPC) 1.00% 100.0%
Contingency (% of Total   Cost) 7.5% 75.0%
SET NPV (F29) TO ZERO BY   VARYING FIT (F30)
Operating Assumptions – NPV (41,921)     Equity IRR
  Feed-in-Tariff (PhP/kWh) – FIT 17.95 9.34%
  Duration of FiT (Yrs) 20     Project IRR
  Tariff post FiT period (PhP/kWh) 7.00 8.58%
  FiT using Asset Base Methodology (PhP/kWh) 28.98
  Annual CER Volume (tCO2e/year) and $/tCO2e                – $5.00
  O&M Cost ($000/unit/year) $4.17
  Spare Parts, Tools & Equipment   ($000/MW/yr) $1.04
  O&M + Spares as % of EPC, T/L, S/S 3.52%
  Refurbishment Cost (% of EPC) 0%
  Timing of Refurbishment (Year from COD) 0
  G&A ($000/year) $25
  Fuel Cost (switch for Biomass: 1=yes, 0=no) 0
    Average Fuel Cost (PhP/mt)       1,297.00
    Fuel Rate (kWh/mt)         700.00
    Average Fuel Consumption (mt/year)                  –
    Average Unit Cost of Fuel (PhP/kWh)               –
  Days Receivable & Payable 30 30
  VAT Recovery 70%
  Timing of VAT recovery (Yrs after COD) 5

 

Debt and Equity Assumptions
Local/Foreign Capital Mix:
  Local Capital 70.3%
  Foreign Capital 29.7%
Debt:
  Local & Foreign Upfront & Financing   Fees 2.00%
  Local & Foreign Commitment Fees 0.50%
  Local All-in Interest Rate excluding tax 10.00%
  Local Debt Payment Period (from end of GP)   (Yrs) 10
  Foreign All-in Interest Rate excluding tax 8.00%
  Foreign Debt Payment Period (from end of   GP) (Yrs) 10
  Local and Foreign Grace Period from COD   (months) 6
  Local and Foreign debt Service Reserve   (months) 6
  Debt Ratio 70%
  Total Local Debt ($000) – 30% $2,487
  Total Foreign Debt ($000) – 70% $1,829
    Total Debt Amount ($000) $4,316
Equity: 16%
  Equity Ratio 30%
  Equit Investment $1,850
  Cost of Equity (Onshore Equity IRR) –   Nominal 9.3%
  Cost of Equity (Onshore Equity IRR) – Real 5.1%
WACC pre-tax 9.5%
WACC after-tax 8.6%
Tax Assumptions
  Income Tax Holiday (Yrs) 7
  Income Tax Rate % (after ITH) 10%
  Property tax (from COD) 1.5%
  Property tax valuation rate (% of NBV) 80%
  Local Business Tax 1.0%
  Government Share (from COD) 0.0%
  ER 1-94 Contribution (PhP/kWh) 0.01
  Withholding Tax on Interest (Foreign   Currency) – WHT 10%
  Gross Receipts Tax on Interest (Local Currency) – GRT 5%
Economic Assumptions
  Base Foreign Exchange Rate (PhP/US$) – 2009 47.8125
  Forward Fixed Exchange Rate (2011) 44.0000
  Base Local CPI – 2009 160.00
  Annual Local CPI 4.0%
  Annual US CPI 2.0%
  Annual Peso Depreciation Rate 2.0%

 

Project IRR Pre tax (no escalation) – % Equity –> 100.00%
Year (act)   Year     CapEx
PhP(10^3)
    OpEx
PhP(10^3)
    TPC
PhP(10^3)
    Revenue
PhP(10^3)
    EBITDA
2011 0
2012 0         (262,211.78)           (262,211.78)         (262,211.78)
2013 1               (6,152.31)               (6,152.31)             27,176.30             21,023.99
2014 2               (6,266.74)               (6,266.74)             27,176.30             20,909.56
2015 3               (6,109.42)               (6,109.42)             27,176.30             21,066.88
2016 4               (5,952.09)               (5,952.09)             27,176.30             21,224.21
2017 5               (5,794.76)               (5,794.76)             27,176.30             21,381.54
2018 6               (5,637.43)               (5,637.43)             27,176.30             21,538.87
2019 7               (5,480.11)               (5,480.11)             27,176.30             21,696.19
2020 8               (5,322.78)               (5,322.78)             27,176.30             21,853.52
2021 9               (5,165.45)               (5,165.45)             27,176.30             22,010.85
2022 10               (5,008.13)               (5,008.13)             27,176.30             22,168.17
2023 11               (4,850.80)               (4,850.80)             27,176.30             22,325.50
2024 12               (4,693.47)               (4,693.47)             27,176.30             22,482.83
2025 13               (4,536.14)               (4,536.14)             27,176.30             22,640.16
2026 14               (4,378.82)               (4,378.82)             27,176.30             22,797.48
2027 15               (4,221.49)               (4,221.49)             27,176.30             22,954.81
2028 16               (4,064.16)               (4,064.16)             27,176.30             23,112.14
2029 17               (3,906.84)               (3,906.84)             27,176.30             23,269.46
2030 18               (3,749.51)               (3,749.51)             27,176.30             23,426.79
2031 19               (3,592.18)               (3,592.18)             27,176.30             23,584.12
2032 20               (3,434.86)               (3,434.86)             27,176.30             23,741.44
Totals         (262,211.78)             (98,317.48)           (360,529.26)           543,526.00           182,996.74
 IRR –> 5.53%

 

 

One Response to “CDM Solar PV Model2.xls”

  1. Rebbecca Eisenbrandt Says:

    Renewable energy is always the way to go because it is non polluting and of course does not get depleted. ^

    <a href="See the most current content at our personal homepage
    http://www.caramoantravel.com/caramoan-package/



Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>