Karandikars & Associates

Home About us Indian Indicators Global Indicators Conversion Factors Contact us

Integrated Petrochemicals – Annual Business Plan (Demo)
Steam Cracker with Polymers and Aromatics

Demonstration disclosure:
This interactive model demonstrates the construction of an integrated Annual Business Plan (ABP) for a petrochemical complex. It is intended to showcase analytical capability and methodology, not to provide commercial or investment advice.

This demonstration illustrates how an integrated petrochemical complex Annual Business Plan can be prepared, starting from alternative feedstock pathways — a crude-linked naphtha feedstock and a USGC-priced ethane feedstock — and extending across multiple downstream products within a common analytical framework.

The framework explicitly captures interactions between the steam cracker and downstream units, enabling plant-wise as well as complex-level performance assessment on a consistent analytical basis.

A key objective of this demonstration is to illustrate how planned performance can be translated into a structured analytical model, and subsequently compared with Actual outcomes in a transparent and methodologically consistent manner.

All results are presented at EBITDA level. Capital structure, financing, depreciation, and taxation are deliberately excluded to maintain focus on operating economics and controllable drivers.

Based on the user-selected inputs, the model first constructs a complete Annual Business Plan and presents the results through a structured set of plant-wise and complex-level tables
After reviewing the Plan outputs, the user is provided with an option to simulate Actual performance through selected margin adjustments. This simulation generates a corresponding full suite of Plan vs Actual comparisons, presented separately to preserve analytical clarity.


Key modelling assumptions

  1. Uniform onstream factor of 100% across all plants. This is an intentional simplification to enable quick validation and intuitive cross-checks of throughput and EBITDA magnitudes.
  2. Alternative feedstocks: naphtha linked to crude oil prices, and ethane priced on a USGC basis. Ethylene prices are derived from user-selected naphtha price inputs and ethylene–naphtha deltas, and are applied consistently across both configurations.
  3. Consistent internal transfer pricing within the complex
  4. EBITDA-level analysis only
  5. Calendar-year basis (January–December, 365 days)

User-controlled assumptions

  1. Crude Price ($/bbl)

  2. Naphtha Crack ($/bbl)

  3. Natural Gas Linkage to Crude

  4. USGC FOB Ethane Price (cpg)

  5. USGC-India Ethane Freight ($/t)

  6. Ethane Cost: Other Elements ($/t)

  7. Ethylene – Naphtha Delta ($/t)

  8. Propylene – Naphtha Delta ($/t)

  9. HDPE – Ethylene Delta ($/t)

  10. MEG – Ethylene Delta ($/t)

  11. PP – Propylene Delta ($/t)

  12. Butadiene – Naphtha Delta ($/t)

  13. Benzene – Naphtha Delta ($/t)

  14. Toluene – Naphtha Delta ($/t)

  15. Para-Xylene – Naphtha Delta ($/t)

  16. Pygas Premium over Naphtha ($/t)