Gas Station & Convenience Store Model
Consumer Financial Model (Free Excel Download)
Plan gas-station economics through fuel volume, margin per gallon, convenience sales, car wash revenue, labor, rent, inventory, and site-level cash flow.
professionals from Deloitte
Used by professionals from
About this model
This model helps you assess a fuel station with a convenience store, car wash, or food offer. It brings fuel volumes, shop traffic, product sales, and ancillary services together with supply costs, staffing, site expenses, and equipment maintenance.
Use it to evaluate a purchase, redevelopment, or operating plan. Test traffic, fuel margins, shop sales, and capital investment to see how they affect cash flow and site value.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Gas Station & Convenience Store Model
- Store network inputs: Year-1 store count, new stores per year, tanks per store
- Fuel volume & pricing: gallons per store, volume growth, gallons per transaction, wholesale cost and its inflation, the fixed cents-per-gallon markup, card share and interchange rate
- Store traffic & basket: walk-in conversion rate, destination traffic per store/day, basket size and growth, tobacco/beverage/food-service category shares and their annual drift
- Merchandise cost ratios: tobacco, packaged beverages & snacks, food service, and grocery & other, each with its own cost-of-goods ratio
- Cost structure: cashiers, store managers and corporate FTE and wages, benefits load, wage growth, occupancy and utilities per store, UST compliance and environmental premiums per tank, marketing %, G&A %, merchandise shrink %, card share on merchandise, depreciation %
- Tax: corporate tax rate on EBIT
- Capital & working capital: maintenance capex %, new-store buildout cost, fuel/merchandise inventory days, card settlement float days, fuel/merchandise payable days, base-year working capital
- Valuation: WACC, terminal growth, net debt, shares outstanding
Gas Station & Convenience Store Model: How the Template Values Fuel and Retail Cash Flow
This gas station financial model template evaluates a multi-site fuel and convenience store operator over seven years. It shows how fuel volume, store traffic, product mix, and operating costs interact to produce cash flow and site value.
The template is designed for investors, operators, and analysts assessing a purchase, redevelopment, or operating plan.
How Fuel Demand and Store Traffic Are Connected
The model begins with a store estate that rolls forward from opening plus new stores. Each site sells a set number of gallons per year, growing modestly.
- Those gallons translate into fuel transactions, and a fixed walk-in conversion rate turns a portion of those transactions into convenience store visits. A separate destination traffic line captures customers who never buy fuel.
- This structure mechanically links fuel volume growth to merchandise traffic growth, so a slow fuel year is also a slow store year, reflecting how these businesses operate on the ground.
Why Fuel Margin Compresses Even When the Markup Is Fixed
Retail fuel price is set as wholesale cost plus a fixed cents-per-gallon markup. Wholesale cost inflates annually, but the markup never changes.
- Card processing cost is charged as a percentage of the dollar sale, so as the pump price rises, card fees consume a growing share of that fixed markup. The model computes net fuel margin per gallon by subtracting card cost from the gross markup.
- This mechanic causes net margin per gallon to decay over time purely from inflation, even though the operator's pricing decision remains constant.
How Merchandise Mix and Cost Structure Shape Profitability
Convenience store revenue is built from four merchandise categories, each with its own cost ratio. Tobacco is the low-margin, high-volume category, while food service carries the highest margin.
- Over the forecast, the mix drifts slightly toward food service, so blended merchandise gross margin rises modestly. On the cost side, cashiers and managers scale with store count, while corporate headcount remains fixed.
- Card fees are charged separately on fuel and merchandise sales, and underground storage tank compliance costs scale with the number of tanks.
What the Cash Flow and Valuation Outputs Show
The model produces an unlevered free cash flow bridge: net operating profit after tax, plus depreciation, less capital expenditure and changes in working capital.
- Working capital includes fuel and merchandise inventory, card settlement float, and payables.
- Discounting these cash flows at a weighted average cost of capital and adding a terminal value yields enterprise value, then equity value and value per share.
- A dashboard summarizes key metrics such as fuel gallons, net fuel margin per gallon, merchandise revenue, EBITDA, and enterprise value, allowing users to compare operating trends alongside the valuation output.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a gas station financial model?+
A gas station financial model captures the seven-year operating economics and intrinsic value of a multi-site fuel and convenience store operator - two businesses sharing one canopy. It rolls a store estate forward into fuel volume and pricing, prices card processing costs against a fixed cents-per-gallon markup, derives convenience-store traffic from fuel transactions, splits merchandise revenue across four categories, and discounts an unlevered free-cash-flow stream to enterprise value, equity value and value per share.
Why does net fuel margin per gallon compress over time?+
Because the operator's markup is fixed in cents per gallon, but credit-card interchange is charged as a percentage of the dollar price at the pump. As wholesale fuel cost inflates and the pump price rises with it, the dollar amount card processors take a cut of grows every year, even though the markup itself never changes. That percentage-based cost eats a growing share of a fixed-cents revenue line - net margin per gallon falls from $0.1336 to $0.1126 over the model's seven years with no change in the operator's own pricing decisions.
Why does convenience-store revenue depend on fuel volume?+
Because the model derives store traffic from fuel transactions via a walk-in conversion rate rather than assuming an independent customer count. A share of every fill-up becomes a store visit, topped up by a smaller destination-traffic line for customers who never buy fuel. This mechanically links the two engines: fuel volume growth from store openings and per-site gallon growth drives merchandise traffic growth even though no merchandise-specific volume assumption exists.
Why does EBITDA margin dilute even as EBITDA dollars keep growing?+
Because fuel revenue is dominated by wholesale cost pass-through - every dollar of wholesale-price inflation shows up as revenue, but almost none of it becomes profit under a fixed-cents markup. As that inflation compounds, revenue grows faster than the business's actual gross profit, so EBITDA margin as a percentage of total revenue eases from 3.79% to 3.35% even while EBITDA dollars compound at roughly 7%/yr on store growth and the merchandise mix shift. It is a genuine structural feature of a fuel-price-inflated revenue base, not a modeling error.
Have more financial modelling questions? Contact us
Related templates
Grocery Store Chain Model
Plan and value a supermarket chain using department sales per square foot, inventory shrinkage, gross margins, and a DCF.
Car Wash Roll-Up Model
5-year express car-wash roll-up: membership economics, multi-site EBITDA, sponsor IRR and exit multiple arbitrage.
EV Charging Network Model
Financial model for EV charging station network with capex, utilization, revenue, and ROI.
E-Commerce Unit Economics
P&L model for e-commerce business with CAC, LTV, gross margin, and unit economics.
