
Users 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 the Joint venture (JV) model of government and/or investor participation of working interests. Also, the model provides insights into gauging economic analysis considering the impact of the 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.
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)GTL CONTROL TAB: This tab addresses 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 and give insights to project evaluation teams.
3)FLAGS: A section that documents the Flags and switches for the entire project model
4)GTL INPUTS: The Model Scenario of asset-specific Locations and the Asset Scenario address model sensitivity, including cost and Gas liquefaction delays.
5)GTL MODEL SCENARIOS: This covers the active working model section from the selected model option in the “GTL INPUTS” Section. This version includes flexible options for project management delays in delivery schedules and cost shifts to gauge the economic value and give insights to project evaluation teams.
6)GTL OPERATING MODEL: This calculates the Gross Operating Cash Flow Model of the active model scenario.
7)DEPRECIATION MODEL: Two models of Depreciation were provided using the 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 Holiday scenarios on several options.
9)PSC MODEL: This model provides a basic method to calculate the production-sharing benefits, assuming contractors and govt participate in the project development. The model utilizes a model for recoverable contractor costs and Contractor Cost and Contractor Tax applicable on Gas to liquid Project processing. Also, this model addresses the profit split by considering the production-based (similar to the Upstream Oil and gas DROP) model and the R-Factor-based scenario for the basics of splitting 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 comprises Company NCF Analysis – With Carry Options, Validation Analysis and Checks, and Division of spoils validations. Again, this model provides a single scenario on participatory working interests and option carry on CAPEX with modeling approaches to ensure repayments are made 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 works as it should.
With this comprehensive 5- or 10-year monthly tool, investors can assess the viability of setting up... Read more
The Mobile App Financial Plan Template in Excel allows you to develop financial projections when lau... Read more
The Food Truck Financial Model helps entrepreneurs, founders, business owners, consultants, and anal... Read more
The Green Hydrogen from Wind Financial Model aims to comprehensively forecast a horizon of 40 years ... Read more
Protect your business secrets with ease using our Simple Mutual Non-Disclosure Agreement Template. S... Read more
The Solar Energy Financial Model Spreadsheet Template in Excel assists you in preparing a sophistica... Read more
Starting a restaurant without a financial plan is like driving a car blindfolded. You wouldn´t do i... Read more
You must log in to submit a review.