ADV Mini-Hydro Model.xls

June 24th, 2012 Posted in renewable energy

ADV Mini-Hydro Model.xls

Mini-hydro or run-of-river system is carried out mostly in the mountains where a slowly snaking terrain will lend itself to conveying the water via a canal headrace with minimal head loss and then dropping the water head thru the penstock to the power turbines and exiting to the tailrace to rejoin the river flow. As such, it does not need a dam but rather a diversion weir to divert water to the canal headrace.

This advanced feed-in-tariff model for mini-hydro makes use of the basic assumptions of the country’s RE regulator for rated capacity (1 x 6.0 MW), capacity factor (48%), plant own use (2%), and 0.50% plant degradation rate.

It assumes equipment cost (FOB $/kW), ocean insurance and freight (0.0%), balance of plant (0%), 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.5% project development cost, 12% VAT, 5% 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:

The summary worksheet is shown below:


Project   Site Name & Location     Bukidnon
Renewable Energy Source     Mini-Hydro
Hours per Year 8760
  Construction Period (from FC) (months) 12
  Operating Period (Yrs from COD) 20
  Yrs from base year CPI & Forex (2009)   for FIT 4
  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) $13,510
    Transmission Line Interconnection   Facility $2,186
    Sub-Station Facility $520
    Development & Other Costs $653
    Construction Contingency $1,264
    Value Added Tax $1,011
    Financing Costs $1,035
    Initial Working Capital $683
  Total Uses of Fund $20,862
  Sources of Fund:
    Debt $14,604
    Equity $6,259
  Total Sources of Fund $20,862
  Construction Unit Costs (US$/kW):
    EPC Cost $2,252
    Plant Cost (Excluding VAT, Financing,   Working Capital) $3,022
    All-in Project Cost $3,477
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 2013


Technical and EPC   Assumptions
Unit Capacity of Plant   (MW/unit) 6.000
No. of Units (unit) 1.0
Gross Installed Capacity   (MW) 6.00
Plant Availability Factor, % 52.13%
Guaranteed Efficiency   Factor, % 92.00%
Allowance for losses & own use, % 2.00%
Net Capacity Factor after   losses & own use, % 47.00%
Net Electrical Output (MWh   in 1st Year) 24,703
Plant Degration, % p.a.   (1-20 Yrs) 0.50%
0.6              % LC
Equipment Cost ex BOP,   Transport ($000/MW) $2,189.00 43.0%
Insurance, Ocean Freight,   Local Transport 0.0% 100.0%
Balance of Plant (BOP), % of   Equipment Cost 0.0% 100.0%
Transmission Line Distance   (km) 25.00
T/L Cost per km, 69 kV   ($000/km) $84.09 100.0%
Switchyard &   Transformers ($000) $500.00 100.0%
Access Roads ($000/km) $20.00 100.0%
Distance of Access Road (km) 15.00
Dev’t & Other Costs   (land, permits, etc) (% of EPC) 2.5% 100.0%
VAT on importation (70%   recoverable) 12% 100.0%
Initial Working Capital (%   of EPC) 5.00% 100.0%
Contingency (% of Total   Cost) 7.5% 50.0%
Operating Assumptions – NPV 77,574     Equity IRR
  Feed-in-Tariff (PhP/kWh) – FIT 6.15 19.04%
  Duration of FiT (Yrs) 20     Project IRR
  Tariff post FiT period (PhP/kWh) 7.00 15.51%
  FiT using Asset Base Methodology (PhP/kWh) 7.08
  Annual CER Volume (tCO2e/year) and $/tCO2e                – $5.00
  O&M Cost ($000/unit/year) $400.00
  Spare Parts, Tools & Equipment   ($000/MW/yr) $1.00
  O&M + Spares as % of EPC, T/L, S/S 2.47%
  Refurbishment Cost (% of EPC) 0%
  Timing of Refurbishment (Year from COD) 0
  G&A ($000/year) $1
  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 57.9%
  Foreign Capital 42.1%
  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% $5,812
  Total Foreign Debt ($000) – 70% $8,792
    Total Debt Amount ($000) $14,604
Equity: 16%
  Equity Ratio 30%
  Equit Investment $6,259
  Cost of Equity (Onshore Equity IRR) –   Nominal 19.0%
  Cost of Equity (Onshore Equity IRR) – Real 14.5%
WACC pre-tax 12.5%
WACC after-tax 11.3%
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%



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>