How to use the advanced (regulator) ocean current and tidal current power plant project finance model

July 13th, 2017 No Comments   Posted in financial models

How to use the advanced (regulator) ocean current and tidal current power plant project finance model

(Lord God, bless my website and my readers that they will contribute to my charity fund for the jobless, sickly, needy, homeless, hungry and destitute. God Bless you all my friends for reading my blog and ordering my project finance models. Amen.)

Finding an easy-to-use project finance model for an ocean current and tidal current power plant with built-in data is sometimes difficult as some models don’t have the sophistication of a regulator template model as well as the ease of using the model and viewing immediately the results of a sensitivity change in the inputs to the model.

This is now made easy because the Input & Assumptions worksheet (tab) has combined all the input and output information in a single worksheet and placing the reports in other worksheets such as Tariff Breakdown, Construction Period, Operating Period, Financial Reports and Levelized Tariff.

Following is a sample case study on a tidal current power plant. From the preliminary design and cost estimates, the top management would want to know if the business idea of going into tidal current power development, construction and operation is worth the effort – is it feasible and what are the economic and financial returns for risking capital.

Here are the inputs and outputs of the advanced template model from OMT ENERGY ENTERPRISES:

——————————————————————————————-

Here are the summary of inputs:

all-in capital cost (overnight cost) = 2,473 $/kW (target cost)

EPC cost portion = 1,112 $/kW (computed by model)

refurbishment cost = 5% of EPC cost on the 10th year (overhaul)

fixed O&M cost = 86.19 $/kW/year (target cost) = 203.36 ‘000$/unit/year (computed by goal seek)

variable O&M cost = 2.40 $/MWh (target cost) = 15.89 ‘000$/MW/year (computed by goal seek)

general admin cost = 500.00 ‘000$/year (target cost)

 

Thermal power plant inputs: (not used in tidal current)

Gross heating value of tidal current fuel = 5,198 Btu/lb

Plant heat rate = 13,500 Btu/kWh (25.28% thermal efficiency)

Cost of tidal current fuel = 1.299 PhP/kg = 1,299 PhP/MT

 

Lube oil consumption rate = 5.4 gram/kWh

Density of lube oil = 0.980 kg/Liter

Cost of lube oil = 200.00 PhP/Liter

 

capacity = 3.00 MW/unit x 10 units = 30.00 MW

 

Plant Availability Factor, %                                    86.42% (computed by goal seek)

Load Factor, %                                                      90.00% (assumed)

Allowance for losses & own use, %                      10.00% (assumed)

Net Capacity Factor after losses & own use, %    70.00% (target net capacity factor)

Degradation rate, %                                               0.2%

 

construction period = 24 months (start 2015)

operating period = 20 years (start 2017)

 

Capital cost estimation assumptions and % local cost (LC):

Power plant footprint (ha)                                   6.00

Cost of purchased land (PhP/sqm)                    25.00 (no land lease)

Land cost, $000 $29.82 100.0%
Equipment Cost ex BOP, Transport ($000/MW) $788.72 0.0%
Insurance, Ocean Freight, Local Transport, % of Equipment Cost 10.0% 100.0%
Balance of Plant (BOP), % of Equipment Cost 31.0% 66.0%
Transmission Line Distance (km) 10.00
T/L Cost per km, 69 kV ($000/km) $84.00 100.0%
Switchyard & Transformers ($000) $3,000.00 100.0%
Access Roads ($000/km) $2,200.00 100.0%
Distance of Access Road (km) 10.00
Dev’t & Other Costs (land, permits, etc) (% of EPC) 2.0% 100.0%
VAT on importation (70% recoverable) 12% 100.0%
Customs Duty 0% 100.0%
Initial Working Capital (% of EPC) 1.0% 100.0%
Contingency (% of Total Cost) 7.5% 59.0%

 

Capital cost breakdown (‘000$): (computed values)

Uses of Fund:
    Land Cost $30
   EPC (Equipment, Balance of Plant, Transport) $33,363
   Transmission Line Interconnection Facility $840
   Sub-Station Facility $3,000
   Development & Other Costs (Civil Works, Customs Duty) $22,667
   Construction Contingency $4,490
   Value Added Tax $3,360
   Financing Costs $5,958
   Initial Working Capital $334
Total Uses of Fund – $000 $74,041
                                 – PHP 000 3,724,071
Sources of Fund:
   Debt $51,829
   Equity $22,212
Total Sources of Fund $74,041

 

 

Local and Foreign Cost Components (from individual cost item):

Local Capital = 59 %

Foreign Capital = 41 %

 

Balance Sheet Accounts:

Receivables = 30 days of revenue

Payables    = 30 days of expenses

Inventory    = 60 days of consumables

 

Imported Capital Equipment:

Customs duty = 0%

Value added tax (VAT) = 12%

VAT recovery = 70% on 5th year of operation

 

Type of input / output VAT = 0 (none)

Type of incentives = 2 (BOI incentives)

 

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) 1.0%
ER 1-94 Contribution (PHP/kWh) 0.0100
Withholding Tax on Interest (Foreign Currency) – WHT 10%
Gross Receipts Tax on Interest (Local Currency) – GRT 5%
Documentary Stamps Tax (DST) 0.5%
PEZA Incentives (% of gross income) – 0% / 5% 0%
Royalty 0%

 

Capital Structure:

Equity Share = 30% at 16.44% p.a. target equity returns (IRR)

Debt Share = 70% (59% local, 41% foreign)

 

Debt Terms:

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 (mos) 6
Local and Foreign debt Service Reserve (mos) 6

 

Foreign Exchange Rate:

Base Foreign Exchange Rate (PhP/US$) – 2013            48.0000 (construction)

Forward Fixed Exchange Rate (PhP/US$) – 2014           50.2971 (operating)

 

Escalation (CPI):

Annual Local CPI – for OPEX      0.0%            4.0%     for CAPEX (to model construction delay)

Annual US CPI – for OPEX           0.0%            2.0%     for CAPEX (to model construction delay)

 

Weighted Average Cost of Capital:

WACC pre-tax       11.66%

WACC after-tax     10.49%

WACC                   11.36%

 

Results of Financial Analysis:

 

First year tariff (Feed-in-Tariff) = 4.149573 P/kWh = 0.08342 USD/kWh

(at zero equity NPV)

 

Short run marginal cost (SRMC) and Long run marginal cost (LRMC)

Item PhP 000 PhP/kWh
Fuel                     – 0.000
Lubes                4,420 0.001
Var O&M            479,679 0.133
Total            484,099 0.134
MWh net          3,609,295
SRMC            484,099 0.134
Fix O&M          3,365,945 0.933
Capital Cost        11,293,574 3.129
LRMC        15,143,618 4.196

 

Equity Returns: (30% equity, 70% debt)

IRR          = 16.44    % p.a. (target returns)

NPV        = 0.00    ‘000$

PAYBACK = 7.51    years

 

Project Returns: (100% equity, 0% debt)

IRR          = 13.19        % p.a.

NPV        = (522,705)  ‘000$ (negative since IRR < 16.44%)

PAYBACK = 6.30        years

——————————————————————————————-

The above runs were based on goal-seek to make equity NPV = 0 (to meet equity IRR target of 16.44% p.a.).

You can perform sensitivity analysis and save the results in a case column (copy paste value).

You can breakdown the tariff ($/kWh) into its capital ($/kW-month) and variable cost recovery ($/kWh) portions.

You can prepare all-in capital cost breakdown showing interest cost during construction and does model the impact of project construction delays.

You can show the evolution of capacity and generation (degradation) during the operating period and show other revenues, expenses and balance sheet accounts as they change over time during operation years.

You can show the income & expense statement.

You can show the cash flow statement.

You can show the balance sheet.

You can show the debt service cover ratio (DSCR) as it computes the cash flow available for debt service.

It also computes the benefits to cost ratio (B/C) of the project.

Finally, it computes the other financial ratios such as:

LIQUIDITY RATIOS

SOLVENCY RATIOS

EFFICIENCY RATIOS

PROFITABILITY RATIOS

MARKET PROSPECT RATIOS

 

Download the sample file below:

Model Inputs and Results – Tidal Current

 

Download the complete demo model for a tidal current power plant in PHP and USD currencies are shown below:

ADV Tidal Current Model3_30 MW – demo5b

ADV Tidal Current Model3_30 MW (USD) – demo5b

If you have actual data from your OEM and EPC suppliers, kindly share the data with me or simply enter your live data into the above models and see how the results will change immediately before your eyes. Please email me back the updated demo model with your new data so you may share it will all our readers of this blog.

 

To purchase the PHP and USD models at a discount (only USD400 for two models), click the link below:

 

30 mw Tidal Current Project Finance Model Ver. 3 – in USD and PHP Currency

 

You may place your order now and avail of a package for the unlocked model with free guidance on using it. The list price of the tidal current model is USD1,400 and I will give you one-hour free for assistance in putting your input data into the model (via telephone or email or FB messenger).

 

Your energy technology selection expert.

Email me for more details and how to order off-line:

energydataexpert@gmail.com

Visit our on-line digital store to order on-line

www.energydataexpert.com

www.energytechnologyexpert.com

 

Tidal Current Power Plant Model in Various Currencies

May 24th, 2017 No Comments   Posted in financial models

Tidal Current Power Plant Model in Various Currencies

Finding a project finance model template for renewable energy such as ocean current or tidal current power plant using several currencies relative to the US DOLLAR is now made easy.

A good discussion on the various forms of ocean energy (wave, thermal, tidal and current) is available in the power point presentation below:

Ocean Energy (Power Pt)

Following are downloadable sample models for a tidal current power plant in various international currencies that are convertible to local currencies.

The exchange rates are based on the March 14, 2017 conversion table provided by www.xe.com.

The sample model is based on the advanced (regulator) template that is easy to use and understand.

Try the samples below (paste the links below into your browser or Google the demo model):

OCEAN CURRENT OR TIDAL CURRENT POWER PLANT MODELS

Exchange rates are for the month of March 2017.

 

UNITED STATES OF AMERICA – US DOLLAR (1 USD = 1.0000 USD)

ADV Tidal Current Model3_30 MW (USD) – demo5b

Taiwan – Taiwan New Dollar (1 USD = 30.8661 TWD)

ADV Tidal Current Model3_30 MW (TWD) – demo5b

Thailand – Thai Baht (1 USD = 35.2789 THB)

ADV Tidal Current Model3_30 MW (THB) – demo5b

Philippines – Philippine Peso (1 USD = 50.2557 PHP)

ADV Tidal Current Model3_30 MW (PHP) – demo5b

Malaysia – Malaysian Ringgit (1 USD = 4.44976 MYR)

ADV Tidal Current Model3_30 MW (MYR) – demo5b

Indonesia – Indonesian Rupiah (1 USD = 13372.00 IDR)

ADV Tidal Current Model3_30 MW (IDR) – demo5b

India – Rupee (1 USD = 65.4177 INR)

ADV Tidal Current Model3_30 MW (INR) – demo5b

GREAT BRITAIN POUND – GBP (1 USD = 0.817605 GBP)

ADV Tidal Current Model3_30 MW (GBP) – demo5b

EUROPEAN UNION – EURO (1 USD = 1.0765 EUR)

ADV Tidal Current Model3_30 MW (EUR) – demo5b

China – Chinese Yuan Renminbi (1 USD = 6.91388 CNY)

ADV Tidal Current Model3_30 MW (CNY) – demo5

 

OTHER CURRENCIES

The reader may request for other international currencies from the Energy Technology Selection Expert and Project Finance Modeling Expert.

Just email me the Country, name of currency and the base rate and forward rate exchange currency per US DOLLAR, and perhaps the OPEX and CAPEX escalation for the Country and the US escalation to assume too.

OTHER TECHNOLOGIES

There are many more renewable (solar CSP, solar PV, wind offshore, wind onshore, mini-hydro, OTEC), conventional (oil genset, oil thermal, coal thermal, petcoke thermal, gas thermal, combined cycle GT, simple cycle GT, geothermal, large hydro), nuclear power, and waste heat recovery systems (gasoline engine, diesel engine, and gas turbines using natural gas, landfill gas, propane, LPG).

Email me for more details and how to order off-line:

energydataexpert@gmail.com

To order and download the USD and PHP models, paste the link to your browser:

Advanced Tidal Current Project Finance Model (ver. 3) – 30 mw

Visit our on-line digital store to order on-line

www.energydataexpert.com

www.energytechnologyexpert.com

 

Project Finance Models for CLEAN DEVELOPMENT MECHANISM (CDM EDITION)

June 27th, 2012 No Comments   Posted in renewable energy

Project Finance Models for CLEAN DEVELOPMENT MECHANISM (CDM EDITION)

Yes, your energy technology selection and business development expert has developed a low-cost set of project finance models for CDM professionals (engineers, business development, investment bankers, managers) and novice professionals who want to learn and start their career in financial modeling of renewable energy projects.

Just follow this link to order, pay and download your favorite renewable energy project finance model – CLEAN DEVELOPMENT MECHANISM EDITION. More »

Project Finance Models for FEED-IN-TARIFF REGULATOR

June 27th, 2012 1 Comment   Posted in renewable energy

Project Finance Models for FEED-IN-TARIFF REGULATOR

Yes, your energy technology selection and business development expert has developed a low-cost set of project finance models for government feed-in-tariff regulators and novice professionals who want to learn and start their career in financial modeling of renewable energy projects.

Just follow this link to order, pay and download your favorite renewable energy project finance model – FEED-IN-TARIFF REGULATOR EDITION. More »

Project Finance Models for PROFESSIONALS

June 27th, 2012 No Comments   Posted in renewable energy

Project Finance Models for PROFESSIONALS

Yes, your energy technology selection and business development expert has developed a low-cost set of project finance models for professionals (engineers, business development, investment bankers, managers) and novice professionals who want to learn and start their career in financial modeling of renewable energy projects.

Just follow this link to order, pay and download your favorite renewable energy project finance model – PROFESSIONAL EDITION. More »

Project Finance Models for STUDENTS

June 27th, 2012 No Comments   Posted in renewable energy

 Project Finance Models for STUDENTS

Yes, your energy technology selection and business development expert has developed a low-cost set of project finance models for students (college, masteral, PhD) and novice professionals who want to learn and start their career in financial modeling of renewable energy projects.

Just follow this link to order, pay and download your favorite renewable energy project finance model – STUDENT EDITION. More »

CDM Ocean Thermal Model_50 MW2.xls

June 25th, 2012 1 Comment   Posted in renewable energy

CDM Ocean Thermal Model_50 MW2.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.

Ocean Thermal Energy Conversion or OTEC is most adapted in deep waters near the equator where the temperature difference between the surface (30 deg Celsius) and a depth of 1 km (10 deg Celsius) located within 10 km from the shoreline. More »

CDM Ocean Thermal Model_10 MW2.xls

June 25th, 2012 No Comments   Posted in renewable energy

CDM Ocean Thermal Model_10 MW2.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.

Ocean Thermal Energy Conversion or OTEC is most adapted in deep waters near the equator where the temperature difference between the surface (30 deg Celsius) and a depth of 1 km (10 deg Celsius) located within 10 km from the shoreline. More »

MTO Ocean Thermal Model_50 MW.xls

June 24th, 2012 No Comments   Posted in renewable energy

MTO Ocean Thermal Model_50 MW.xls

Ocean Thermal Energy Conversion or OTEC is most adapted in deep waters near the equator where the temperature difference between the surface (30 deg Celsius) and a depth of 1 km (10 deg Celsius) located within 10 km from the shoreline.

This 20 deg Celsius thermal gradient is available throughout the year near the equator and diminishes up to 40 deg North latitude and South latitude, beyond which the OTEC is not technically viable for having a much lower thermal gradient. This provides a very high capacity factor of 91% and it only unavailable when it de-couples during a tropical storm and the OTEC power barge transfers to a safer cove to ride the storm.

This MTO first-year tariff model for OTEC makes use of the basic assumptions of the country’s RE regulator for rated capacity (80 MW), capacity factor (91%), plant own use (36%), and transmission line loss (1.82%). More »

MTO Ocean Thermal Model_10 MW.xls

June 24th, 2012 No Comments   Posted in renewable energy

MTO Ocean Thermal Model_10 MW.xls

Ocean Thermal Energy Conversion or OTEC is most adapted in deep waters near the equator where the temperature difference between the surface (30 deg Celsius) and a depth of 1 km (10 deg Celsius) located within 10 km from the shoreline.

This 20 deg Celsius thermal gradient is available throughout the year near the equator and diminishes up to 40 deg North latitude and South latitude, beyond which the OTEC is not technically viable for having a much lower thermal gradient. This provides a very high capacity factor of 92% and it only unavailable when it de-couples during a tropical storm and the OTEC power barge transfers to a safer cove to ride the storm.

This MTO first-year tariff model for OTEC makes use of the basic assumptions of the country’s RE regulator for rated capacity (16 MW), capacity factor (92%), plant own use (36%), and transmission line loss (0.364%). More »

ADV Ocean Thermal Model_50 MW.xls

June 24th, 2012 No Comments   Posted in renewable energy

ADV Ocean Thermal Model_50 MW.xls

Ocean Thermal Energy Conversion or OTEC is most adapted in deep waters near the equator where the temperature difference between the surface (30 deg Celsius) and a depth of 1 km (10 deg Celsius) located within 10 km from the shoreline.

This 20 deg Celsius thermal gradient is available throughout the year near the equator and diminishes up to 40 deg North latitude and South latitude, beyond which the OTEC is not technically viable for having a much lower thermal gradient. This provides a very high capacity factor of 91% and it only unavailable when it de-couples during a tropical storm and the OTEC power barge transfers to a safer cove to ride the storm. More »

ADV Ocean Thermal Model_10 MW.xls

June 24th, 2012 No Comments   Posted in renewable energy

ADV Ocean Thermal Model_10 MW.xls

Ocean Thermal Energy Conversion or OTEC is most adapted in deep waters near the equator where the temperature difference between the surface (30 deg Celsius) and a depth of 1 km (10 deg Celsius) located within 10 km from the shoreline.

This 20 deg Celsius thermal gradient is available throughout the year near the equator and diminishes up to 40 deg North latitude and South latitude, beyond which the OTEC is not technically viable for having a much lower thermal gradient. This provides a very high capacity factor of 92% and it only unavailable when it de-couples during a tropical storm and the OTEC power barge transfers to a safer cove to ride the storm. More »

Get Your Energy Technology Articles the Easy Way – Shopping Cart

June 19th, 2012 No Comments   Posted in energy technology expert

Get Your Energy Technology Articles the Easy Way – Shopping Cart

You can now order on-line your energy technology articles the easy way – via the Shopping Cart.

Once you have decided to purchase, proceed to order via the shopping cart and pay thru PayPal thru your bank account or your credit card and download immediately the models. More »

Ocean Energy

The file (657 KB) will cover the following topics:

OCEAN ENERGY

Wave energy – winds generate large ocean waves that can be used to generate power from its potential and kinetic energy.

Ocean temperature energy conversion (OTEC) – temperature gradient between the surface and bottom of the ocean can be utilized in a heat engine to generate power

Tidal energy – caused by lunar and solar gravitational forces acting together with that from the earth on the ocean waters to create tidal flows manifested by the rise and fall of waters that vary daily and seasonally from a few centimeters up to 8-10 meters in some parts of the world. The potential energy of the tides is tapped to generate power.

Topics – Ocean Energy

  • Ocean Energy
  • Energy from Oceans (OTEC, Wave, Hydro, Tidal)
  • Efficiency & Types of OTEC (Open, Closed, Hybrid)
  • Ocean Waves: Potential, Progressive Wave Motion, Power Density
  • Devices that Convert Ocean Wave to Energy
  • Ocean Wave Power Plants
  • Tidal Energy, Its Potential
  • Types of Tidal Power Plants (Single-Pool, Modulated, Two-Pool)
  • Tidal Energy Power Plants
  • Cost of Ocean & Tidal Power
  • Benefits from Ocean & Tidal Energy
  • Environmental Impact & Risks

Price: 26 USD