Subscribe

How to use the advanced (regulator) petcoke-fired SUBCRITICAL power plant project finance model

July 26th, 2017 Posted in financial models

How to use the advanced (regulator) petcoke-fired SUBCRITICAL power plant project finance model

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

EPC cost portion = 2,034 $/kW (computed by model)

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

fixed O&M cost = 37.80 $/kW/year (target cost) = 3,452.00 ‘000$/unit/year (computed by goal seek)

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

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

 

Thermal power plant inputs:

Gross heating value of petcoke fuel = 14,670 Btu/lb

Plant heat rate = 8,800 Btu/kWh (38.77% thermal efficiency)

Cost of petcoke fuel = 100.00 $/MT = 5,030 PhP/MT = 5.030 PhP/kg

 

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 = 110.00 MW/unit x 1 unit = 110.00 MW

 

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

Load Factor, %                                                           95.00% (assumed)

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

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

Degradation rate, %                                                  0.2%

 

construction period = 36 months (start 2016)

operating period = 25 years (start 2019)

 

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

Power plant footprint (ha)                                    20.00

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

Land cost, $000 $397.64 100.0%
Equipment Cost ex BOP, Transport ($000/MW) $1,473.90 12.2%
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) 62.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% 50.1%

 

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

Uses of Fund:
   Land Cost $398
   EPC (Equipment, Balance of Plant, Transport) $203,471
   Transmission Line Interconnection Facility $2,480
   Sub-Station Facility $786
   Development & Other Costs (Civil Works, Customs Duty) $37,713
   Construction Contingency $9,563
   Value Added Tax $17,649
   Financing Costs $35,496
   Initial Working Capital $22,443
Total Uses of Fund – $000 $329,999
                                 – PhP 000 16,597,985
Sources of Fund:
   Debt $230,999
   Equity $99,000
Total Sources of Fund $329,999

 

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

Local Capital = 50 %

Foreign Capital = 50 %

 

Balance Sheet Accounts:

Receivables = 30 days of revenue

Payables    = 30 days of expenses

Inventory    = 120 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 15.00% p.a. target equity returns (IRR)

Debt Share = 70% (50% local, 50% 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) 12
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.80% p.a.

WACC pre-tax = 12.43% p.a.

WACC after-tax = 8.70% p.a.

 

Results of Financial Analysis:

 

First year tariff (Feed-in-Tariff) = 6.16152 P/kWh = 0.12250 USD/kWh

(at zero equity NPV)

 

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

Item PhP 000 PhP/kWh
Fuel        28,602,223 1.52063
Lubes                2,133 0.00011
Var O&M          4,696,641 0.24970
Total        33,300,998 1.77044
MWh net        18,809,472
SRMC        33,300,998 1.77044
Fix O&M        10,264,198 0.54569
Capital Cost        72,329,714 3.84539
LRMC      115,894,910 6.16152

 

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

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

 

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

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

NPV        = 0.00    ‘000$

PAYBACK = 8.66    years

 

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

IRR          = 12.09        % p.a.

NPV        = (2,424,999)  ‘000$ (negative since IRR < 15.00%)

PAYBACK = 6.78        years

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

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

 

Download the complete demo model for a petcoke-fired SUBCRITICAL power plant in PHP and USD currencies are shown below:

ADV Petcoke-Fired PC Subcritical Thermal Model3 – demo5b

ADV Petcoke-Fired PC Subcritical 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:

Petcoke-fired Thermal 110 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 with free guidance on using it. The list price of the petcoke-fired SUBCRITICAL 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

 

 

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>