Holiday Sale this December 2017 on Deterministic (fixed inputs) and Stochastic (random Monte Carlo Simulation) Power Plant Project Finance Models

December 4th, 2017 No Comments   Posted in project finance models

Holiday Sale this December 2017 on Deterministic (fixed inputs) and Stochastic (random Monte Carlo Simulation) Power Plant Project Finance Models

Flash News:

There is great enthusiasm for the new models as 3 models have been purchased:

Dec 6 – Deterministic (fixed inputs) ADV NatGas Combined Cycle Gas Turbine (CCGT) – USD100

Dec 9 – Deterministic (fixed inputs) ADV NatGas Combined Cycle Gas Turbine (CCGT) – USD100

Dec 12 – Dual-capable Deterministic (fixed inputs) and Stochastic (Monte Carlo simulation random inputs) ADV Mini-hydro (run-of-river) – USD200 (buy one model to do both deterministic and stochastic modeling).

The client would use the mini-hydro model to study the following sensitivities:

1) 2 x 4.00 MW design capacity at 50% availability, 92% load factor and 2% parasitic load for a net capacity factor of 45.08%.  All-in capital cost is 3,523 $/kW while fixed O&M cost is 16.96 ‘000$/kW/year (excluding G&A of 20.00 ‘000$/year) and variable O&M cost is 2.40 $/MWh.

2) Vary the unit capacity of 4.00 MW to minimum and maximum value based on minimum river flow and maximum river flow (from hydrologic study) by using the power equation to predict power output given head (m net head) and river flow (m/s discharge rate).

3) Construction period of 2 years (24 months) with 0 year delay and 1 year (24 months) delay. This will increase construction cost (and thus all-in capital cost due to inflation) as well as first year tariff (feed-in-tariff) needed to meet equity and project returns.

Be part of my growing clientele of project finance modelers and develop your alternative cases or configuration and optimize your business concept and write your own project feasibility studies.

The following models may be downloaded for only USD100 for deterministic (uses fixed inputs) and USD200 for stochastic (uses random inputs using Monte Carlo Simulation) for the all clients this December 1-30, 2017.

To avail of the discount this December, please email me to confirm your order and model type and remit payment via PayPal using also the same email address and PayPal account:

energydataexpert@gmail.com

You may also email me using the email address above to confirm your order and remit payment via bank/wire transfer to the account below:

======

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

======

Once I confirm receipt of payment, I will then email you the deterministic model (cost USD100) and the stochastic (Monte Carlo Simulation) model (cost USD200) should you desire it.

The models for renewable, conventional, fossil, nuclear, energy storage, and combined heat and power (CHP) project finance models are based on a single template so that you can prioritize which power generation technology to apply in a given application for more detailed design and economic study.

Our company (OMT Energy Enterprises) can also provide customization services to provide you with power plant project finance models with fixed inputs (deterministic models) as well as random inputs (stochastic models). If you have an existing model which you want to be audited or upgraded to have stochastic modeling capability, you may also avail of our services at an hourly rate of USD200 per hour for a maximum of 5 hours of charge for customization services.

The model inputs consist of the fixed inputs (independent variables) plus a random component as shown below (based on +/- 10% range, which you can edit in the Sensitivity worksheet):

1) Plant availability factor (% of time) = 94.52% x ( 90% + (110% – 90%) * RAND() )

2) Fuel heating value (GHV) = 5,198 Btu/lb x ( 90% + (110% – 90%) * RAND() )

3) Plant capacity per unit = 12.00 MW/unit x ( 90% + (110% – 90%) * RAND() )

4) Variable O&M cost (at 5.26 $/MWh) = 30.05 $000/MW/year x ( 90% + (110% – 90%) * RAND() )

5) Fixed O&M cost (at 105.63 $/kW/year) = 1,227.64 $000/unit/year x ( 90% + (110% – 90%) * RAND() )

6) Fixed G&A cost = 10.00 $000/year x ( 90% + (110% – 90%) * RAND() )

7) Cost of fuel = 1.299 PHP/kg x ( 90% + (110% – 90%) * RAND() )

8) Plant heat rate = 12,186 Btu/kWh x ( 90% + (110% – 90%) * RAND() )

9) Exchange rate = 43.00 PHP/USD x ( 90% + (110% – 90%) * RAND() )

10) Capital cost = 1,935 $/kW x ( 90% + (110% – 90%) * RAND() )

The dependent variables that will be simulated using Monte Carlo Simulation and which a distribution curve (when you make bold font the number of random trials) may be generated are as follows:

1) Equity Returns (NPV, IRR, PAYBACK) at 30% equity, 70% debt

2) Project Returns (NPV, IRR, PAYBACK) at 100% equity, 0% debt

3) Net Profit After Tax

4) Pre-Tax WACC

5) Electricity Tariff (Feed-in-Tariff)

The models below are in Philippine Pesos (PHP) and may be converted to any foreign currency by inputting the appropriate exchange rate (e.g. 1 USD = 1.0000 USD; 1 USD = 50.000 PHP, 1 USD = 3.800 MYR, etc.). Then do a global replacement in all worksheets of ‘PHP’ with ‘XXX’, where ‘XXX’ is the foreign currency of the model.

To order directly and immediately the deterministic models for USD100, please click the links below. But if you want the stochastic (Monte Carlo Simulation) models for USD200, you have to order it via email as explained above.

RENEWABLE ENERGY

1) process heat (steam) and power

http://energydataexpert.com/shop/power-generation-technologies/advanced-biomass-cogeneration-project-finance-model-ver-3/

2) bagasse, rice husk or wood waste fired boiler steam turbine generator

http://energydataexpert.com/shop/power-generation-technologies/advanced-biomass-direct-combustion-project-finance-model-ver-3/

3) gasification (thermal conversion in high temperature without oxygen or air)

http://energydataexpert.com/shop/power-generation-technologies/advanced-biomass-gasification-project-finance-model-ver-3/

4) integrated gasification combined cycle (IGCC) technology

http://energydataexpert.com/shop/power-generation-technologies/advanced-biomass-igcc-project-finance-model-ver-3/

5) waste-to-energy (WTE) technology for municipal solid waste (MSW) disposal and treatment

http://energydataexpert.com/shop/power-generation-technologies/advanced-biomass-waste-to-energy-wte-project-finance-model-ver-3-2/

6) waste-to-energy (WTE) pyrolysis technology

http://energydataexpert.com/shop/power-generation-technologies/advanced-biomass-waste-to-energy-wte-pyrolysis-project-finance-model-ver-3/

7) run-of-river (mini-hydro) power plant

http://energydataexpert.com/shop/power-generation-technologies/advanced-mini-hydro-run-of-river-project-finance-model-ver-3/

8) concentrating solar power (CSP) 400 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-concentrating-solar-power-csp-project-finance-model-ver-3/

9) solar PV technology 1 MW Chinese

http://energydataexpert.com/shop/power-generation-technologies/advanced-solar-photo-voltaic-pv-project-finance-model-ver-3-1-mw/

10) solar PV technology 25 MW European and Non-Chinese (Korean, Japanese, US)

http://energydataexpert.com/shop/power-generation-technologies/advanced-solar-photo-voltaic-pv-project-finance-model-ver-3-25-mw/

11) includes 81 wind turbine power curves from onshore WTG manufacturers

http://energydataexpert.com/shop/power-generation-technologies/advanced-onshore-wind-energy-project-finance-model-ver-3-copy/

12) includes 81 wind turbine power curves from offshore WTG manufacturers

http://energydataexpert.com/shop/power-generation-technologies/advanced-offshore-wind-project-finance-model-ver-3/

13) ocean thermal energy conversion (OTEC) technology 10 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-ocean-thermal-energy-conversion-otec-10-mw-project-finance-model-ver-3/

14) ocean thermal energy conversion (OTEC) technology 50 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-ocean-thermal-energy-conversion-otec-project-finance-model-ver-3-50-mw/

14) ocean current and tidal technology (30 MW) – this is similar to an air wind turbine but under water with a turbine propeller (Taiwan has an operating prototype in Kuroshio and PNOC-EC is venturing into ocean current at the Tablas Strait).

(to follow – you can order it via email – new release)

CONVENTIONAL, FOSSIL AND NUCLEAR ENERGY

1) geothermal power plant 100 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-geo-thermal-project-finance-model-ver-3/

2) large hydro power plant 500 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-large-hydro-impoundment-project-finance-model-ver-3/

3) subcritical circulating fluidized bed (CFB) technology 50 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-coal-fired-circulating-fluidized-cfb-project-finance-model-ver-3-50-mw/

4) subcritical circulating fluidized bed (CFB) technology 135 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-coal-fired-circulating-fluidized-bed-cfb-project-finance-model-ver-3-135-mw/

5) subcritical pulverized coal (PC) technology 400 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-pulverized-coal-pc-subcritical-project-finance-model-ver-3/

6) supercritical pulverized coal (PC) technology 500 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-pulverized-coal-pc-supercritical-project-finance-model-ver-3/

7) ultra-supercritical pulverized coal (PC) technology 650 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-pulverized-coal-pc-ultrasupercritical-project-finance-model-ver-3/

8) diesel-fueled genset (compression ignition engine) technology 50 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-diesel-genset-project-finance-model-ver-3-copy/

9) fuel oil (bunker oil) fired genset (compression ignition engine) technology 100 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-fuel-oil-genset-project-finance-model-ver-3-copy-2/

10) fuel oil (bunker oil) fired oil thermal technology 600 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-fuel-oil-thermal-project-finance-model-ver-3/

11) natural gas combined cycle gas turbine (CCGT) 500 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-natgas-fired-combined-cycle-gas-turbine-ccgt-project-finance-model-ver-3/

12) natural gas simple cycle (open cycle) gas turbine (OCGT) 70 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-natgas-fired-open-cycle-gas-turbine-ocgt-project-finance-model-ver-3/

13) natural gas thermal 200 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-natgas-fired-thermal-project-finance-model-ver-3/

14) petroleum coke (petcoke) fired subcritical thermal 220 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-petcoke-thermal-power-plant-project-finance-model-ver-3/

15) nuclear (uranium) pressurized heavy water reactor (PHWR) technology 1330 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-nuclear-power-phwr-project-finance-model-ver-3/

WASTE HEAT RECOVERY BOILER (DIESEL genset; GASOLINE genset; PROPANE, LPG or NATURAL GAS simple cycle)

1) combined heat and power (CHP) circulating fluidized bed (CFB) technology 50 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-coal-fired-cfb-combined-heat-and-power-chp-project-finance-model-ver-3/

2) diesel genset (diesel, gas oil) and waste heat recovery boiler 3 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-diesel-fired-genset-combined-heat-and-power-chp-project-finance-model-ver-3/

3) fuel oil (bunker) genset and waste heat recovery boiler 3 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-bunker-fired-genset-combined-heat-and-power-chp-project-finance-model-ver-3/

4) gasoline genset (gasoline, land fill gas) and waste heat recovery boiler 3 MW

http://energydataexpert.com/shop/power-generation-technologies/advanced-gasoline-fired-genset-combined-heat-and-power-chp-project-finance-model-ver-3/

5) simple cycle GT (propane, LPG) and waste heat recovery boiler 3 MW (e.g. Capstone)

http://energydataexpert.com/shop/power-generation-technologies/advanced-lpg-fired-genset-combined-heat-and-power-chp-project-finance-model-ver-3/

6) simple cycle GT (natural gas, land fill gas) and waste heat recovery boiler 3 MW (e.g. Capstone)

http://energydataexpert.com/shop/power-generation-technologies/advanced-natgas-fired-genset-combined-heat-and-power-chp-project-finance-model-ver-3/

Cheers,

Your energy technology selection and project finance modeling expert

 

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) 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