Want FREE Templates on Strategy & Transformation? Download our FREE compilation of 50+ slides. This is an exclusive promotion being run on LinkedIn.

Gas Sales & Distribution Model Template   Excel template (XLSM)

Gas Sales & Distribution Model Template (Excel template (XLSM)) Preview Image Gas Sales & Distribution Model Template (Excel template (XLSM)) Preview Image Gas Sales & Distribution Model Template (Excel template (XLSM)) Preview Image Gas Sales & Distribution Model Template (Excel template (XLSM)) Preview Image Gas Sales & Distribution Model Template (Excel template (XLSM)) Preview Image Gas Sales & Distribution Model Template (Excel template (XLSM)) Preview Image Gas Sales & Distribution Model Template (Excel template (XLSM)) Preview Image Gas Sales & Distribution Model Template (Excel template (XLSM)) Preview Image Gas Sales & Distribution Model Template (Excel template (XLSM)) Preview Image Log in to unlock full preview.
Arrow   Unlock all 61 preview images:   Login Register

Gas Sales & Distribution Model Template (Excel XLSM)

File Type: Excel template (XLSM)
Secondary File: Word (DOCX)


Add to Cart


Immediate digital download upon purchase.
Lifetime document updates included with purchase.
Fully editable & customizable XLSM document.
Supplemental DOCX document also included.
Trusted by over 10,000+ organizations.


  1. Project IRR & NPV
  2. Minimum and Average DSCR
  3. Cash Waterfall


This product (Gas Sales & Distribution Model Template) is an Excel template (XLSM) with a supplemental Word document, which you can download immediately upon purchase.

Gas Sales & Distribution Model Template with 3 Statements and Valuation

Project finance is the financing of long-term infrastructure and industrial projects based upon a complex financial structure. Both project debt and equity are used to finance the project. Debt is repaid using the cash flow generated by the operation of the project, rather than other resources of the project owners.

Project Gas Model template is built for a proposal to set up a gas distribution system and includes assumptions related to:
1. LNG carrier purchase and conversion Capex
2. Pipeline and Submarine CAPEX
3. Gas volume Sold Power Plant
4. Gas volume sold to the Third party
5. Fuel Cost
6. Fixed and variable Capex

Model Output includes:
1. Project IRR & NPV
2. Equity IRR & NPV
3. Minimum and Average DSCR
4. Equity Payback Period
5. Cash Waterfall
6. Debt Service Profile

This model will help you in understanding and Modeling of:
1. Flexible capital structuring
2. DSCR (Debt Service coverage ratio)
3. PLCR (Project Life coverage ratio)
4. LLCR (Loan Life coverage ratio)
5. Cash waterfall
6. Project and Equity IRR
7. Gearing ratios

The model is ideal for those looking to achieve the following:

1. Refresh their financial modeling skills
2. Gain an understanding of leading approaches towards financial modeling, in order to build models that are robust and user friendly
in nature.
3. Extend their toolkit for modeling more complex areas of a project finance model in an efficient and flexible manner
4. Understand the very basics of Project Finance

Important Technical Specifications:

The following are important technical specifications that you need to keep in mind before purchasing this model template:

1. Model uses Macros (VBA). To run model optimally, keep macros enabled. In case you do not like Macros, you could manually disable or remove the Macros and will have to rework the model's logic to be used without Macros but it is not recommended by the author. Feel free to refer to the included Macro Documentation (.doc file) as you download the template.

2. Model is built using Microsoft Excel 2010 version.

3. We advice not to delete or insert rows and columns into the model if you are not aware of the model structure as it can distort model functioning. If you need assistance with customizing the model template, the author is more than willing to help you. Simply contact through the Contact Vendor button or you can email and send your model template as well as specifications. We will then get back to you with a quotation for the customization service (billable hours & completion date).

4. Model uses Cell Styles

5. File type is .xlsm

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in Oil & Gas Excel: Gas Sales & Distribution Model Template Excel (XLSM) Spreadsheet, Fin-Wiser Advisory


Add to Cart


File Type: Excel xlsm (XLSM)
Secondary File: Word docx (DOCX)
File Size: 1.1 MB


Author: Fin-Wiser Advisory
Additional documents from author: 66

Fin-wiser is a specialist advisory boutique focused on providing financial modelling, financial analysis, business transformation and business research services.

Our mission is to deliver high-quality Financial Models, Financial Analysis, Operational Transformation and Data Analytics which are custom made as per the business requirements. [read more]

Ask the Author a Question

Must be logged in

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.

Trusted by over 10,000+ Client Organizations
Since 2012, we have provided best practices to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab

Read Customer Testimonials

Customers Also Like These Documents

Related Management Topics

Oil & Gas Integrated Financial Model Valuation Model Example Energy Industry Quality Management & Assurance

Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more.