Liquefied Petroleum gas Financial Model

This model is used to provide a robust economic analysis of a 1 MTPA liquefied Petroleum Gas (LPG) Processing plant across 3 key product configurations. This model provides useful insights driven by a robust analysis with key cost drivers of capital, operating, fiscal & commercial economic drivers in a typical PLG Development Project This model provides a multi-dimensional scenarios on several project cases with project scenarios showing up to 10 project cases Users just need to update the cases on each project and case scenarios to run this model with flexible economic results to gauge the economic returns across many scenarios using the model considering the impact of Joint venture (JV) model of government and/or investors participation of working interests. Also, the model provides insights into gauging economic analysis considering the impact of Profit sharing (PSC) model of government and/or investors participation towards the business benefits assuming contractors & government participate jointly in the project development. The model provides analysis of recoverable cost for project investors as well as addressing profit split considering 2 profit models (Production-based profit model & R-Factor based scenario) split in profits between partners as well as entitlement economics to arrive at a project cash flow projections.

Liquefied Petroleum gas Financial Model
, ,
, , , , , , ,

Below are  the contents  for the “Multi model case  version sessions”

  • 1)DASHBOARD: This address provides the executive summary of  the project opportunity  with economic results on the model
  • 2)LPG 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.
  • 3)FLAGS: A section that documents the Flags and switch for the entire project model
  • 4)LPG INPUTS: Model Scenario  of Asset specific Locations and  Asset Scenario address model sensitivity including cost and Gas liquefaction delays.
  • 5)LPG MODEL SCENARIOS: This covers the active working model section from the selected model option in the “LPG 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.
  • 6)LPG OPERATING MODEL: This calculates the Gross Operating Cash Flow Model of the active model scenario.
  • 7)DEPRECIATION MODEL: 2 model on Depreciation was provided using Straight line Model and the Bespoke methodology of depreciation, post operations start date.
  • 8)FISCALS: 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.
  • 9)PSC MODEL: This model provides a basics to calculate the production sharing benefits assuming contractors and govt participate in the project development. The model utilizes a model for contractor cost which are recoverable as well as Contractor Cost  and  Contractor Tax applicable  on Gas to liquid Project processing. Also,this model for addressing Profit split considering:- Production- 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.
  • 10)PSC 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
  • 11)EQUITY ANALYSIS: This section includes the Project Lender Cash Flow with Equity IRR and Analysis
  • 12)CHARTS: This robust economic tool finally provides model working charts on key economic results
  • 13)CHECKS: This provides  model validation checks to ensure the model is working as it should.

SINGLE CASE MODEL

The model can run with single project case.

 

MULTI CASE MODEL

This version will run with multiple cases and project scenarios simultaneously.

You must log in to submit a review.