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).
|Industry||Car Services, Cleaning, Distribution, Financial Model, Service Businesses|
|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||Break-even, Budgeting, Cash Flow Analysis, DCF Model, Financial Feasibility, Forecast, Forecasting, IRR, NPV, Startup Financial Model, Three Statement Model, Uses and Sources of Funds|
You must log in and be a buyer of this download to submit a review.