Gas Station Financial Model

Gasoline Station Financial Model Template

This financial model template models the expected cash flows for a new gas station including sales from a supermarket and car services station.

The financial model goes over a 10-year horizon projecting the company’s operations in terms of gasoline sales, revenues from the gas station, a supermarket, and car services stop and their respective cost structures.  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. There is also a high-level analysis included with respect to the average monthly budget and the required gas volume sold to have the station break-even on a monthly basis.

The financial model highlights are the following:

– Detailed operating model for gasoline sales volumes by gas type

– Gasoline station can either be bought (CAPEX expense required) or rented (rent expenses)

– High-level model to include revenues and costs from supermarket and car services

– 10-year financial statements projections (Income Statement, Balance Sheet, and Cash Flow Statement)

– Financial ratio analysis

– Debt schedule with 3 layers of financial debt

– Fixed asset schedule

– Calculation of unlevered and levered cash flows

– IRR calculation: unlevered Project IRR, levered IRR, Investor IRR

– Profit split for Promoters and Investors

 

The Model is available as PDF Demo Version and Excel File (Full Version).

Gas Station Executive Summary
Gas Station Executive Summary
Gas Station Financial Ratios
Gas Station Financial Ratios
Projected Gas Sales Volume
Projected Gas Sales Volume
Gas Station Financial Modeling Assumptions
Gas Station Financial Modeling Assumptions
Gas Station Breakeven Analysis
Gas Station Breakeven Analysis
Gas Station Financial Statement Projections
Gas Station Financial Statement Projections
Gas Station Monthly Budget
Gas Station Monthly Budget

 

 

 

 

Industry , , , ,
Summary The Gas Station Financial Model provides you with a framework to plan your new gas station by projecting the financials over a period of 10 years, calculate monthly breakeven for gas sales, calculate IRR's and NPV.
Screenshots / Pictures
Use Cases , , , , , , , , , , ,

You must log in and be a buyer of this download to submit a review.

Leave a Reply