2.5 MTPA Petrochemical Project Economic Model (Excel XLSX)

BENEFITS OF THIS EXCEL DOCUMENT

1. Users of this model will be able to gauge the economic returns across many scenarios model ofJoint venture (JV) model of government and/or Investors participation of flexible working interests.
2. The model includes a "Multiple model version" include a "portfolio of project specific scenarios" with full model tabs which gives more options on project evaluations
3. This model provides a basics to calculate the production sharing benefits assuming contractors and government participate in the project development.

OIL & GAS EXCEL DESCRIPTION

2.5 MTPA Petrochemical Project Economic Model is an Excel template (XLSX) with a supplemental PDF document available for immediate download upon purchase.

This model address the economic feasibility of a 2.5 MTPA Petrochemical Project. This model is used to provide a robust economic analysis of a petrochemical plant across various product configurations. This is very useful as it provide a model multiple project cases with drivers of CAPEX and OPEX using similar case scenarios. Users of this model will be able to gauge the economic returns across many scenarios model ofJoint venture (JV) model of government and/or Investors participation of flexible working interests. The model includes a "Multiple model version" include a "portfolio of project specific scenarios" with full model tabs which gives more options on project evaluations .This version includes up to 5 project specific scenarios with full model tabs which are flexible when looking to see specific scenarios in project sections.
Below are the contents for the "Multi model case version sessions".
DASHBOARD: This address provides the executive summary of the project opportunity with economic results on the model
CONTROL TAB: This Address the CAPEX Scenario, OPEX Drivers, Price Sensitivity Inputs, Asset Delivery Schedules, Special Bonus Payment frameworks, and Model Profit Split Share considerations and includes flexible options for project management delays in delivery schedules and cost shifts to gauge the economic value to give insights to project evaluation teams.
INPUTS: Model Scenario of Asset specific Locations and Asset Scenario address model sensitivity including cost and Gas liquefaction delays.
MODEL SCENARIOS: This covers the active working model section from the selected model option in the "KEY INPUTS" Section. This version includes flexible options for project management delays in delivery schedules and cost shifts to gauge the economic value to give insights to project evaluation teams.
OPERATING MODEL: This calculates the Gross Operating Cash Flow Model of the active model scenario.
DEPRECIATION MODEL: 2 model on Depreciation was provided using Straight line Model and the Bespoke methodology of depreciation, post operations start date.
TAX & FISCAL CALCULATIONS: The model addressed fiscal analysis on Assessable profits using Applicable capital allowances using model regulation of the PIA after applicable tax holidays towards the pretax cash flows with Optional Tax Holidays scenarios on several options.
PSC MODEL: This model provides a basics to calculate the production sharing benefits assuming contractors and government participate in the project development. The model utilizes a model for contractor cost which are recoverable as well as Contractor Cost on Petrochemicals and Contractor Tax applicable on Petrochemicals. Also,this model for addressing Profit split considering:- Petro-Chemical- Based (similar to the Upstream Oil and gas DROP) model and R-Factor based scenario for a basics to split the project profits between partners. This also provides a model for entitlement analysis with cost provisions to arrive at a contractor cash flow.

ANALYSIS: This section is comprised of Company NCF Analysis – With Carry Options, Validation Analysis and Checks, Division of spoils validations. Again this model provides a single scenarios on participatory working interests and option carry on CAPEX with modeling approaches to ensure repayments are done on commercial operations start date
EQUITY ANALYSIS: This section includes the Project Lender Cash Flow with Equity IRR and Analysis
BREAKEVEN ANALYSIS: This section provides Breakeven analysis Year on Year on the breakeven Revenue returns
CHARTS: This robust economic tool finally provides a model validation checks to ensure the model is working as it should.

Source: Best Practices in Oil & Gas, Integrated Financial Model Excel: 2.5 MTPA Petrochemical Project Economic Model Excel (XLSX) Spreadsheet, Desyton Energy Advisors