Gas Station Financial Feasibility Model

The Gas Station Financial Feasibility Model Template provides you with a framework to determine the financial feasibility of your next gas station project and come up with an appropriate financing structure. The model calculates the required funding and return (unlevered and levered IRRs) as well as the project’s NPV.

Gasoline Station Financial Model Template
, , , ,
, , , , , , , , , , , , ,

This financial feasibility model template in Excel allows you to determine the financial feasibility of a new gas station project and figure out the financing structure.

The financial model includes revenues from various sources including different types of gas sold, a supermarket, a repair shop and a car wash station. Sales revenues are linked to the amount of gas sold wich allows to run different scenarios to build a better understanding on the business case. Profit on gas sales is calculated by using the spread on a per gallon/liter basis between gasoline purchases and sales. The assumptions are then used in a condensed version to build up the expected financial statements such as income statement, balance sheet, and cash flow statement.

 

An overview of the financial model template is provided here:

 

The highlights of the financial model template are the following:

  • Detailed operating model for gasoline sales volumes by gas type
  • Rent/Build Scenario – Gasoline station can either be bought (CAPEX expense required) or rented (rent expenses)
  • Revenues for a supermarket, repair shop or car wash station are linked to the gasoline sales (which is an indicator of the traffic the gasoline station receives)
  • Debt schedule with 3 layers of financial debt
  • Three Statement Model with projections for the Income Statement, Balance Sheet and Cash Flow Statement
  • Forecast of the main financial ratios
  • Free Cash Flow forecast
  • NPV and IRR calculation (levered and unlevered)
  • Uses and sources of Funds table
  • Return calculation for two types of investors (Founders and Investors)
  • IRR

This financial model template allows you to obtain a detailed understanding about the economics of your gas station business and investment case.

 

The financial model is available in two versions in Excel and as PDF Previews:

Light Version:

  • 5 Year Forecast only
  • No sensitivity tables

Full Version

  • 10 Year Forecast
  • Monthly Forecast and Budgets for the first 3 years
  • Break-even analysis
  • Sensitivity tables, Easy Scaling Factors for Key Value Drivers and Tornado Diagram

 

 

Add to wish list
Purchase Excluding 0% tax

 

 

 

Write a Review

Get these templates too for a discount!

Price: $149.95

This is a collection of financial model templates in Excel for businesses in the Manufacturing industry and its related sectors.

Add to wish list
Add to cart Excluding 0% tax

Price: $170.00

  This is a bundle of financial model templates for financial plan templates related to Retail Shops. The following are…

Add to wish list
Add to cart Excluding 0% tax

Price: $180.00

This is a collection of financial model templates for business models related to the Service Industry. You best purchase this…

Add to wish list
Add to cart Excluding 0% tax