Pre-Christmas Sale on all Power Plant Project Finance Models

November 16th, 2017 No Comments   Posted in project finance models

Pre-Christmas Sale on all Power Plant Project Finance Models

Yes, you are right.

Your energy technology selection and financial modeling expert is offering all our global clients a pre-Christmas (November 1-30, 2017) sale of USD200 on all project finance models for conventional, fossil, nuclear, renewable, energy storage and waste heat recovery systems.

To avail of the pre-Christmas sale, just email me at:

energydataexpert@gmail.com

Once I receive your email request and identify the model you need, then make payments thru PayPal using my account:

=====

energydataexpert@gmail.com

=====

or via bank/wire transfer to my current account:

=====

1) Name of Bank Branch & Address:

The Bank of the Philippine Islands (BPI)

Pasig Ortigas Branch

G/F Benpres Building, Exchange Road corner Meralco Avenue

Ortigas Center, PASIG CITY 1605

METRO MANILA, PHILIPPINES

2) Account Name:

Marcial T. Ocampo

3) Account Number:

Current Account = 0205-5062-41

4) SWIFT ID Number = BOPIPHMM

=====

You need to specify the local currency you want, aside from the standard USD currency model, so the tariff calculations will be in your own local currency.

A list of the demo models for the actual models for sale at USD 200 is shown below.

=====

PROJECT FINANCE MODELS (in Philippine Currency)

Try the models below in Philippine Currency (other currencies are available such as USD, EUR, GBP, CNY, THB, MYR, IDR, INR, etc.).

Group 1 – Renewable Energy Technologies:

ADV Biomass Cogeneration Model3 – demo5b

ADV Biomass Direct Combustion Model3 – demo5b

ADV Biomass Gasification Model3 – demo5b

ADV Biomass IGCC Model3 – demo5b

ADV Biomass WTE Model3 – demo5b

ADV Biomass WTE Model3 – pyrolysis – demo5b

ADV Mini-Hydro Model3 – demo5b

ADV Ocean Thermal Model3_10 MW – demo5b

ADV Ocean Thermal Model3_50 MW – demo5b

ADV Tidal Current Model3_30 MW (PHP) – demo5b

ADV Solar PV 1 mw Model3 – demo5b

ADV Solar PV 25 mw Model3 – demo5b

ADV Concentrating Solar Power (CSP) Model3 – demo5b

ADV Wind Offshore Model3 – demo5b

ADV Wind Onshore Model3 – demo5b

Group 2 – Clean Coal Technologies:

ADV Coal-Fired CFB Thermal Model3_50 MW – demo5b

ADV Coal-Fired CFB Thermal Model3_135 MW – demo5b

ADV Coal-Fired PC Subcritical Thermal Model3 – demo5b

ADV Coal-Fired PC Supercritical Thermal Model3 – demo5b

ADV Coal-Fired PC Ultrasupercritical Thermal Model3 – demo5b

Group 3 – Conventional & Fossil & Nuclear Technologies:

ADV Diesel Genset Model3 – demo5b

ADV Fuel Oil Genset Model3 – demo5b

ADV Fuel Oil Thermal Model3 – demo5b

ADV Geo Thermal Model3 – demo5b

ADV Large Hydro Model3 – demo5b

ADV Natgas Combined Cycle Model3 – demo5b

ADV Natgas Simple Cycle Model3 – demo5b

ADV Natgas Thermal Model3 – demo5b

ADV Petcoke-Fired PC Subcritical Thermal Model3 – demo5b

ADV Nuclear PHWR Model3 – demo5b

Group 4 – Combined Heat & Power (CHP) and Waste Heat Recovery (WHR) Systems:

ADV Coal-Fired CFB Thermal Model3_50 MW CHP – demo5b

ADV Diesel Genset and Waste Heat Boiler Model3 – demo5b

ADV Fuel Oil Genset and Waste Heat Boiler Model3 – demo5b

ADV Gasoline Genset and Waste Heat Boiler Model3 – demo5b

ADV Propane Simple Cycle and Waste Heat Boiler Model3 – demo5b

ADV Simple Cycle and Waste Heat Boiler Model3 – demo5b

=====

 

How to use the advanced (regulator) geothermal power plant project finance model

July 24th, 2017 No Comments   Posted in financial models

How to use the advanced (regulator) geothermal power plant project finance model

Finding an easy-to-use project finance model for a geothermal 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 geothermal power plant. From the preliminary design and cost estimates, the top management would want to know if the business idea of going into geothermal 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) = 6,243 $/kW (target cost)

EPC cost portion = 3,753 $/kW (computed by model)

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

fixed O&M cost = 132.00 $/kW/year (target cost) = 5,942.85 ‘000$/unit/year (computed by goal seek)

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

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

 

Thermal power plant inputs:

Gross heating value of geothermal fuel = 1,104 Btu/lb (geothermal steam)

Plant heat rate = 34,121 Btu/kWh (10.00% thermal efficiency)

Cost per mmBtu = 2.273 $/mmBtu

Cost of geothermal steam = 2.154 $/GJ = 5.53 $/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 = 50.00 MW/unit x 1 unit = 50.00 MW

 

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

Load Factor, %                                                     97.00% (assumed)

allowance for losses & own use, %                       5.00% (assumed)

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

Degradation rate, %                                               0.5%

 

construction period = 48 months (start 2014)

operating period = 25 years (start 2018)

 

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

Power plant footprint (ha)                                   30.00

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

Land cost, $000 $99.41 100.0%
Equipment Cost ex BOP, Transport ($000/MW) $2,990.42 11.4%
Insurance, Ocean Freight, Local Transport, % of Equipment Cost 4.5% 100.0%
Balance of Plant (BOP), % of Equipment Cost 21.0% 100.0%
Transmission Line Distance (km) 10.00
T/L Cost per km, 69 kV ($000/km) $40.00 100.0%
Switchyard & Transformers ($000) $786.21 100.0%
Access Roads ($000/km) $181.82 100.0%
Distance of Access Road (km) 10.00
Dev’t & Other Costs (land, permits, etc) (% of EPC) 15.0% 100.0%
VAT on importation (70% recoverable) 12% 100.0%
Customs Duty 3% 100.0%
Initial Working Capital (% of EPC) 11.0% 100.0%
Contingency (% of Total Cost) 4.0% 49.2%

 

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

Uses of Fund:
   Land Cost $99
   EPC (Equipment, Balance of Plant, Transport) $187,649
   Transmission Line Interconnection Facility $400
   Sub-Station Facility $786
   Development & Other Costs (Civil Works, Customs Duty) $34,971
   Construction Contingency $8,752
   Value Added Tax $16,437
   Financing Costs $42,422
   Initial Working Capital $20,641
Total Uses of Fund – $000 $312,158
                                 – PhP 000 15,700,654
Sources of Fund:
   Debt $218,511
   Equity $93,647
Total Sources of Fund $312,158

 

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

Local Capital = 49 %

Foreign Capital = 51 %

 

Balance Sheet Accounts:

Receivables = 30 days of revenue

Payables    = 30 days of expenses

Inventory    = 60 days of consumables

 

Imported Capital Equipment:

Customs duty = 3%

Value added tax (VAT) = 12%

VAT recovery = 0% on 5th year of operation

 

Type of input / output VAT = 1 (with VAT)

Type of incentives = 1 (NO incentives)

 

Tax Assumptions:

Income Tax Holiday (yrs) 0
Income Tax Rate % (after ITH) 30%
Property tax (from COD) 2.0%
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 1%
Documentary Stamps Tax (DST) 0.5%
PEZA Incentives (% of gross income) – 0% / 5% 0%
Royalty 0%

 

Capital Structure:

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

Debt Share = 70% (49% local, 51% 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 = 10.49% p.a.

WACC pre-tax = 11.98% p.a.

WACC after-tax = 8.39% p.a.

 

Results of Financial Analysis:

 

First year tariff (Feed-in-Tariff) = 12.75915 P/kWh = 0.25368 USD/kWh

(at zero equity NPV)

 

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

Item PhP 000 PhP/kWh
Fuel        38,877,090 4.10548
Lubes              10,985 0.00116
Var O&M          3,999,890 0.42239
Total        42,887,965 4.52903
MWh net          9,469,560
SRMC        42,887,965 4.52903
Fix O&M      13,194,980 1.39341
Capital Cost        64,740,637 6.83671
LRMC      120,823,583 12.75915

SRMC = 4.52903 PHP/kWh (variable O&M + fuel + lubes)

LRMC = 12.75915 PHP/kWh (capital cost + fixed O&M + regulatory + SRMC)

 

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

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

NPV        = 0.00     ‘000$

PAYBACK = 8.90    years

 

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

IRR          = 11.17          % p.a.

NPV        = (2,301,468)  ‘000$ (negative since IRR < 14.00%)

PAYBACK = 6.83           years

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

The above runs were based on goal-seek to make equity NPV = 0 (to meet equity IRR target of 14.00% 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 – Geothermal

 

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

ADV Geo Thermal Model3 – demo5b

ADV Geo Thermal Model3 (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, click the link below:

Geothermal 50 mw Power 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 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

 

Geothermal Project Finance Model Template (Financials Tab) – free demo

April 17th, 2016 No Comments   Posted in power generation

Geothermal Project Finance Model Template (Financials Tab) – free demo

This is the latest project finance model template (financials tab or worksheet) that your energy technology selection expert has developed for the geothermal power generation technology using energy stored on the earth’s crust. Familiarize with the template and if interested, get the full unlocked version for your immediate use. I can also provide data input service or customize further the model.

Energy stored on the earth’s crust during its creation, and its continued regeneration from nuclear reactions inside the earth to heat water that percolates into the earth’s crust is a continuing source of saturated and superheated steam which can be used to drive steam turbines in single and double flash steam cycles (but releasing the spent geothermal steam to the atmosphere), or using a binary fluid to capture the heat from geothermal fluids without the attendant problem of treating the spent geothermal fluid other than re-injecting it back to mother earth in an end-less cycle.

More »

Steam Cycle and Rankin Cycle Project Finance Model Template (Financials Tab) – free demo

April 17th, 2016 No Comments   Posted in power generation

Steam Cycle and Rankin Cycle Project Finance Model Template (Financials Tab) – free demo

This is the latest project finance model template (financials tab or worksheet) that your energy technology selection expert has developed for the steam cycle and Rankin cycle power generation technology using a variable of energy sources and fossil fuels such as  oil thermal (bunker oil) and gas thermal (natural gas). Familiarize with the template and if interested, get the full unlocked version for your immediate use. I can also provide data input service or customize further the model.

Among the oldest and most versatile power generation technology is based on the steam cycle, also called the Rankin cycle, which consists of a heating source to convert a liquid such as water into saturated steam or superheated steam to drive a steam turbine, and recover the spent steam in the condenser to be pre-heated in a steam drum and then converted to steam in a boiler and superheated further in the super heater of the Rankin cycle.

More »

Advanced (ADV) Project Finance Models for Conventional, Fossil, Nuclear and Renewable Energy Power Generation Technologies – Price List and Specs

September 28th, 2014 No Comments   Posted in cost of power generation

Advanced (ADV) Project Finance Models for Conventional, Fossil, Nuclear and Renewable Energy Power Generation Technologies – Price List and Specs (offer up to Sep 30, 2014 only)

Your power generation technology selection expert is pleased to make a final call to all project finance and power plant modelers to purchase the Advanced (ADV) Project Finance Models for Conventional, Fossil, Nuclear and Renewable Energy Power Generation Technologies.

The model consists of the following worksheets/tabs: More »

Why the Philippines is Lacking in Power Supply Always and is Expensive Compared to its Asian Neighbors

September 24th, 2014 No Comments   Posted in cost of power generation

Why the Philippines is Lacking in Power Supply Always and is Expensive Compared to its Asian Neighbors

Following is the outline of my power point presentation on “Why the Philippines is Lacking in Power Supply Always” and  why the Philippines has one of the highest power rate in Asia and the World.

If you need the pdf version, please email me so I could respond to your request.

 “Why the Philippines is Lacking in Power Supply Always”

By: Marcial T. Ocampo

        Energy Technology Selection and Optimization Consultant at

        OMT Energy Enterprises More »

Summary of inputs and results for project finance models for various power generation technologies – up to Sep 30, 2014 only

September 14th, 2014 No Comments   Posted in cost of power generation

Summary of inputs and results for project finance models for various power generation technologies – up to Sep 30, 2014 only

Dear Friends,

You only have up to September 30, 2014 to purchase the advanced project finance models for conventional, fossil, nuclear and renewable energy power generation technologies.

Beginning Oct 1, 2014, I will be working full-time with a major IPP in the country and I will take a leave in providing project finance models and Feasibility Study and Market Study preparations for a while.

So don’t dilly dally. Order now before I shut down this website for selling such models.

Cheers,

Energy Technology Selection Expert More »

Philippine Energy Data Analytics Service Provider – from your energy technology expert

April 25th, 2014 No Comments   Posted in energy data analytics

Philippine Energy Data Analytics Service Provider  – from your energy technology expert

You might be interested to look into the latest power supply and demand outlook (forecast 2014-2020) from the DOE.

It includes the existing 2011 installed capacity, plus constructed 2012-2013, plus committed 2014-2016 projects, then forecast peak demand, total reserves, total supply available.

Aside from the committed, there is also a list of indicative projects as well as future capacity additions for base load, mid-merit and peak load from the power development plan of DOE (from their optimized expansion planning modelling exercise). More »

New 2013 Price List of my Project Finance Models & Technical Tool Kits

January 17th, 2013 1 Comment   Posted in financial models

New 2013 Price List of my Project Finance Models & Technical Tool Kits

After the successful sale of my models and tool kits, I am happy to annouce the new price lists of my financial models, optimization tools and power plant emission calculation tool kits.

Order now this Christmass and get a whooping 50% discount on all articles and models. Hurry, this offer ends December 31, 2013. And if you buy two articles or models, the third one will be free! Order now and email me.

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 »

Get Your Project Finance Models the Easy Way – Shopping Cart

Get Your Project Finance Models the Easy Way – Shopping Cart

You can now order on-line your project finance models 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 »

New Simplified Calculation Procedure for Levelized Cost of Energy (LCOE) and Feed-in Tariff

July 28th, 2010 3 Comments   Posted in cost of power generation

New Simplified Calculation Procedure for Levelized Cost of Energy (LCOE) and Feed-in Tariff

As part of the on-going technical preparations for the proposed mini-conference on the Mindanao Power Crisis this coming late August or early September 2010 and the main conference on “Energy & Climate Change”, the workshop coordinator, Mr. Marcial T. Ocampo, has prepared the simplified calculation procedure for calculating the levelized cost of energy (LCOE) and levelized selling price (tariff) for conventional and renewable energy resources.

The result of the simplified formulas using the US NREL formula for generation cost and the RP MTO formula for selling price were compared with the results from a full-blown project finance model and the variance between the two methods were minimal in most of the power generation technologies analyzed.

The input data came from the IEPR research summary of 2007 and from internationally published data on power generation technology by noted experts such as Paul Breeze and yours truly, Marcial Ocampo. More »

ENERGY & CLIMATE CHANGE: A Complete Review of Power Generation Technologies and Impact on Climate Change

July 15th, 2010 5 Comments   Posted in energy & climate change

For:    ________________________ (name of suggested speaker/presentor, discussant/reactor, contributor/donor, exhibitor, participant)

From:  Marcial T. Ocampo

former Executive Director, Philippine Council for Industry & Energy Research & Development (PCIERD)

Department of Science & Technology (DoST)

Republic of the Philippines

Subject: Invitation to Conference on Energy & Climate Change as Speaker/Presentor, Discussant/Reactor, Contributor/Donor, Exhibitor, Participant (top management by invitation)

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

Dear Sir/Madam:

In view of the need to provide stakeholders’ input into the development of a new energy strategy of the incoming administration of President Aquino towards sustainable development, I would like to invite you to solicit your interest and participation on the proposed conference on

ENERGY & CLIMATE CHANGE:  A Complete Review of Power Generation Technologies and Impact on Climate Change

Date: tentative September-October 2010

Venue: To be arranged More »

Project Finance Model for Determining the “Best New Entrant” Power Generation Technology

January 16th, 2010 1 Comment   Posted in financial models

Project Finance Model for Determining the “Best New Entrant” Power Generation Technology

In proposing a new power plant project to address a supply deficiency problem in a given grid, it is important for the project proponent and developer to demonstrate to the investors as well as to the regulator and end-users that the proposed power generation technology solution is the “best new entrant” that will address the power deficiency and provide the cheapest, reliable and stable electricity service. More »

Available Project Finance Models with CDM and Renewable Energy Law Incentives

January 15th, 2010 No Comments   Posted in financial models

Available Project Finance Models with CDM and Renewable Energy Law Incentives

I just finished polishing all my project finance models for the following power generation technologies and are now available for actual runs by project developers, researchers and individuals doing business development.  Using the models below will allow user to determine as quickly as possible the “best new entrant” technology applicable to a particular location given the fuel and energy resource available and the electricity tariff prevailing in the area. More »

How to Optimize Power Plant Design and Configuration (technology, capacity, efficiency, location)

January 11th, 2010 2 Comments   Posted in financial models

How to Optimize Power Plant Design and Configuration (technology, capacity, efficiency, location) – see download file for input data

Optimizing the overall project concept during the plant feasibility study and detailed engineering study is a common problem faced by project developers and EPC contractors.  The question commonly asked by project owners from project developers and designers are:

(1) What engine/manufacturer should be considered (e.g. Siemens, Westinghouse, General Electric, Mitsubishi, Alstom, etc)? More »

Large-Scale Project Finance Models

Large-Scale Project Finance Models:

  1. Oil Thermal Power Plant – 2,000 US$

  2. Pulverized Thermal Power Plant – 4,000 US$

  3. Advance Coal Thermal Power Plant – 6,000 US$

  4. Geothermal Power Plant – 8,000 US$

  5. Simple Gas Turbine Power Plant – 9,000 US$

  6. Combined Cycle Gas Turbine Power Plant – 10,000 US$

  7. Energy Storage Power Plant – 12,000 US$*
  8. Solar Thermal Power Plant – 14,000 US$*
  9. Fuel Cells Power Plant – 16,000 US$*
  10. Ocean Thermal Power Plant – 18,000 US$*
  11. Ocean Wave Power Plant – 20,000 US$*
  12. Tidal Power Plant – 22,000 US$*
  13. Nuclear Power Plant – 30,000 US$*

*Please inquire about payment options directly to me.


Contents:

1) Input (Assumption) Sheet

2) Report (Summary) Sheet

3) Project Cost Sheet (equipment cost, ocean freight, insurance, taxes & duties, brokerage & local shipping, erection & installation, land & right-of-way, project development & contract management, initial stocks & inventories, manpower mobilization & training, working capital, interest during construction, other capitalized expenses)

4) Construction Sheet (construction schedule, equity/loan drawdown, interest during construction)

5) Model Sheet (escalation of items, starting costs, capacity & degradation, heat rate & efficiency degradation, maintenance & overhaul scheduel, available hours, gross generation, plant use & net generation, transmission/distribution line constraints & losses, net electricity sales, revenue items, expense items, income statement, balance sheet, cash flow statement, project & equity IRR, project & equity payback, debt service cover ratio)

6) Depreciation Sheet (evolution of balance sheet accounts, working capital)

7) Loan Amortization Table (interest & principal repayment)

Geothermal Energy

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

GEOTHERMAL ENERGY

  • heat (thermal) from the earth (geo)
  • thermal energy in the rock and fluid that fills fractures and pores within the rock in the earth’s crust.

The earth’s initial energy from its molten state is sustained thru energy input from the sun and radioactive decay deep within the earth.

Price: 28 USD