The Gas Sales & Distribution business plan and valuation model is an excellent tool to assess the financial feasibility of setup and operating a gas sales and distribution business.

The Model 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
7. Integrated Financial Statements
8. Dashboard

Technical Specifications:

1. The model uses Macros (VBA) especially to consider the interest during the construction phase in the Uses of Funds Table. To run the 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.
2. The model is built using Microsoft Excel 2019 version for Windows. Please note, on certain Mac laptops or MS Excel prior to 2007, Excel with Macros can slow down your computer if your PC does not have enough processing power.
3. We advise you 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 us at pushkarkumar@fin-wiser.com 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. The model uses Cell Styles