Trusted by 25,000+ startup founders, investors and CPAs
Clear Assumptions Fast
Michael Turner, TX
It pulled pricing, costs, and growth into one place, so I stopped juggling messy tabs and finally had a clean set of numbers to review with my partner. We saved about 4 hours on the first pass.
Start Without the Blank Page
Lauren Mitchell, FL
I was stuck before I even opened Excel, but this template gave me a starting point for the whole gas station model. What would have taken a full day of setup was done in under an hour.
One File For Everything
David Collins, GA
The statements and charts were scattered all over my old files, and this brought them into one view. I had a cleaner monthly report ready for my lender meeting, and it saved me a couple of hours of rework.
Model review
What is the financial model of the gas station?
It's an editable five-year workbook that transforms business cards, conversions, recurring customers, basketball, mixing and pricing assumptions into declarations and management reports.
Use the workbook to convert gas station traffic, buyer conversions, repeat purchases, basket sizes, sales mixtures, prices, costs and financial assumptions into a combined forecast.
Changes to editable assumptions and related flow calculations through revenue, expenditure, cash flow, balance sheet, scenarios and reporting summaries.
Operational driver planStart with store movement and customer behaviour, and then track their impact through sales categories and financial results.
revenue engine of retail gas stations
How does the financial model calculate the revenue of the gas station?
The model converts shoppers into buyers, moves repeat customer cohorts, builds monthly orders and units, allocates a mix of categories, and then applies category prices.
01
Change visitors
A new buyer is equal to a visitor to a store multiplied by a visitor's conversion rate to the buyer.
02
Build repeating cohorts
Some new buyers become repeat customers for a certain lifetime.
03
Calculating orders
Monthly orders combine first orders with active recurring customers and the frequency of recurring orders.
04
allocation of units
Orders × average units per order produced units sold and then allocated by the sales mix.
05
Calculation of revenue
The units of the categories shall be valued by period and summed by category and month.
Basic formulaRevenue = units sold × price of the weighted sales category of the mixture
01 / Revenue
How do you enter revenue from gas stations?
The revenue article organizes visitor traffic, buyer conversion, repeat customer behaviour, order size, mix of categories and price of categories that drive forecast retail sales.
Revenue
The revenue view displays editable assumptions for visitor, customer, basket, mix and price.
02 / COGS & OPEX
How are operating costs and expenditure organised?
COGS and OPEX separate costs of goods sold, variable costs and forecast fixed operating expenses.
COGS & OPEX
The COGS & OPEX view shows direct costs, variable costs and fixed costs.
03 / Scenarios
How do you compare low, low and high cases?
The scenario compares the low, basic and high results for revenue, gross margin, contribution margin and EBITDA over five years.
Scenarios
The scenarios shall show charts of low, basic and high financial performance over five years.
04 / Dashboard
What Does the Dashboard Bring Together?
The Dashboard combines configuration controls, scenario multipliers, basic finance, a mix of revenue, profitability, cash flow and return on investment in one look.
Dashboard
The Dashboard combines configuration controls, the outcomes of the scenarios, basic finances and management charts.
Product adjustment
Is the financial model of the gas station right for you?
It is appropriate for buyers whose business is business-to-business; substantially different revenue engines, operating schedules or reporting may require individual modelling.
Model ready
It fits perfectly
Sales start with shoppers and the visitor to buyer conversion rate.
Multiple customers remain active for a specified lifetime and frequency of the order.
Orders are converted into units and then the mix of categories and prices determines the revenue.
You want an editable five-year forecast with screenplays and related financial reports.
Order structure
Think about the model
Your revenue is dependent on another entity, contract, subscription or ability mechanism.
You need an operational schedule that goes beyond the level of visitors and the structure of the model basket.
You really need different reports, funding, or decision analysis.
You need a model architecture built around unique operational or transactional flows.
The indicator is the starting point for planning, not a guarantee of performance.
Financial modelling service for orders
Do you need a pattern that meets your requirements?
The Financial Model Laboratory may build or adapt the model where the revenue logic, operational schedules or reporting requirements differ from that model.
After purchase, you will receive a fully editable financial model of Excel with five-year forecasts, scenario analysis and related financial reports.
01
Book to be edited
Open and edit the model of the gas station in Microsoft Excel or Google Sheets.
02
Forecast five years old
A review of the forecasted five years of revenue, costs, cash flow and profitability.
03
Analysis of scenarios
Compare the Low, Base and High cases using model scenario analysis.
04
Financial statements
See the income statement, the cash flow Report, the balance sheet and the management reports.
Before purchase
Financial model of petrol stations FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the financial model of gas stations calculate revenue?
Revenue start with visitors who turn into new buyers, add active orders from multiple customers, convert orders into units, allocate units by sales mix and apply category prices.
02
What assumptions can I change about the gas station model?
You can edit the launch date, visitors within a week, conversions, recurring customer behavior, order units, category mix, category prices, and monthly seasonality.
03
What can I compare between low, basic and high scenarios?
In view of the scenarios, the low, basic and high paths of revenue, gross margin, contribution margin and EBITDA under the five-year forecast are compared.
04
What financial results are taken into account?
The workbook contains the income statement, the cash flow report, the balance sheet, the dashboard, the summary, the scenarios, the estimates, the ROIC reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab can build or adapt the model to different revenue logic, operational schedules or reporting requirements.
06
Is this workbook a prediction or a guarantee?
This is a planning forecast based on edited assumptions, not a guarantee of business results or financial results.
What Does the Gas Station Financial Model Contain?
This downloadable gas station budget template includes everything you need to build a complete financial plan, from revenue modeling to investor-ready financial statements.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
Revenue
COGS & OPEX
Scenarios
Dashboard
