Want FREE Templates on Organization, Change, & Culture? Download our FREE compilation of 50+ slides. This is an exclusive promotion being run on LinkedIn.

  Please register (it's free!) or login to view the remaining preview.
If you are logged in, your referral link [?] is automatically included below.
EMBED CODE (Copy and Paste)


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


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 [email protected] or ask the author directly by using the form to the right. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Gas Sales & Distribution Model Template Excel document


Gas Sales & Distribution Model Template

Sold by Fin-Wiser Advisory (this author has 47 documents)


Add to Cart

This business document is categorized under the function(s):

It applies to Energy, Materials, & Chemicals

File Type: Excel (xlsm)

File Size: 1.1 MB

Related Topic(s): Oil & Gas

Purchase includes lifetime product updates. After your purchase, you will receive an email to download this document.

This product contains a supplemental DOCX document.

Initial upload date (first version): Oct 27, 2020
Most recent version published: Oct 27, 2020

Ask the Author a Question

Must be logged in Click here to log in



Since 2012, we have provided best practices to over 5,000 businesses and organizations of all sizes across the world—in over 130 countries. Below is just a very small sample of our customer base.

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.


Excel workbook and supporting Word
42-slide PowerPoint deck
15-page Word document
Excel workbook
54-slide PowerPoint deck
40-slide PowerPoint deck
Excel workbook
74-slide PowerPoint deck and supporting ZIP
Excel workbook
Excel workbook



Become your organization's resident expert on...

Digital Transformation
Post-merger Integration (PMI)
Strategy Development
Organizational Design (OD)
Performance Management
Business Transformation
Organizational Culture (OC)
Customer-centric Design (CCD)
Interested in something else? Browse our 500+ Business Toolkits of best practices, each focused on a specific management topic.