Automotive

This Fuel Station Financial Model Excel template is a 10-year forecasting, feasibility, and valuation model built for fuel stations, gas stations, petrol stations, and fuel filling stations. It helps operators, petroleum retail developers, investors, lenders, DFIs, acquisition analysts and feasibility consultants assess revenue potential, funding requirements, debt serviceability, breakeven throughput and investor returns before committing capital.

The model converts fuel throughput, pump count, daily vehicle volumes, average tank fill, fuel margin per litre, car wash usage, convenience store spending, operating hours, staffing, CAPEX, working capital, debt funding, equity funding and investor distribution assumptions into automated financial statements, valuation outputs and lender-ready KPIs.

Designed for fuel station business plans, petrol station feasibility studies, bank and DFI funding applications, SBA loan applications, investor presentations, acquisition due diligence and project finance review, the template produces integrated 10-year Income Statement, Balance Sheet and Cash Flow forecasts. Users can test fuel volumes, margin sensitivity, car wash revenue, store revenue, CAPEX, loan repayment, DSCR, IRR, NPV, payback period, DCF valuation, enterprise value, equity value, and investor waterfall returns in a single transparent Excel file.

This fuel station investor model allows users to set and toggle the forecast period for terms ranging from 1 to 10 years.

What makes this fuel station financial model different

1. Comprehensive 10-year fuel retail forecast:
   Model long-term financial performance for a new fuel station development, an existing petrol station acquisition or a fuel retail expansion project.
2. Three independently modelled revenue streams:
   Forecast fuel sales, car wash operations and convenience store revenue separately before consolidating them into the full financial statements.
3. Four fuel grades modelled independently:
   Model up to four different fuel grades, e.g., Regular 93, Regular 95, Premium and Diesel, with separate daily throughput, pricing, margin per litre and escalation assumptions.
4. Daily vehicle throughput logic:
   Calculate potential and served vehicles using operating hours, total pumps, average service time, productivity assumptions, average tank fill and annual growth.
5. Car wash and convenience store revenue:
   Forecast car wash utilisation, revenue per wash, convenience store usage, in-store spending and related revenue growth.
6. CAPEX and fuel retail development costs:
   Model land or leasehold costs, underground tanks, pump islands, canopy, civil works, electrical infrastructure, forecourt equipment, working capital and pre-opening costs.
7. Debt and equity funding analysis:
   Test debt funding, equity contribution, repayment terms, interest costs, capital structure and funding adequacy.
8. Integrated three-statement financials:
   Generate automated Income Statement, Balance Sheet and Cash Flow Statement outputs across the 10-year forecast period.
9. DSCR and lender covenant review:
   Assess debt service coverage across the forecast period for bank, DFI and project finance submissions.
10. Breakeven throughput analysis:
    Calculate the minimum vehicle throughput, sales volume and revenue required to reach EBITDA breakeven under the selected cost structure.
11. DCF valuation and investment outputs:
    Review WACC, DCF valuation, Terminal Value, Enterprise Value, Equity Value, IRR, NPV, payback period, cash-on-cash return and equity multiple.
12. Investor returns waterfall:
    Model preferred return, return of capital and residual profit distributions between equity partners.
13. Completed mock scenario included:
    The template includes a fully worked example of a South African fuel filling station so users can understand the model structure before replacing assumptions with their own site inputs.
14. Transparent Excel structure:
    The model follows an Inputs → Calculations → Outputs workflow, with visible formulas, auditable logic and no manual formula editing required.
15. Dedicated input guidance by tab and cell:
    Includes a structured Model Input Notes & Guidance section that explains the key editable input cells, what each assumption means, and how it links to the gas station financial model forecast.

What you receive upon purchase

• Instant downloadable Excel file in .xlsx format.
• 10-year financial forecast for a fuel station, gas station, and petrol station.
• Year 1 monthly detail and annual consolidation for Years 2 to 10.
• Three revenue streams: fuel sales, car wash and convenience store.
• Four independent fuel grade models.
• Daily vehicle throughput, pump count, productivity, and average tank fill assumptions.
• Car wash utilisation and convenience store spending assumptions.
• CAPEX schedule for fuel retail development costs.
• Working capital, debt funding and equity funding inputs.
• Automated Income Statement, Balance Sheet and Cash Flow Statement.
• DSCR, IRR, NPV, payback period, cash-on-cash return and equity multiple outputs.
• WACC, DCF valuation, Terminal Value, Enterprise Value and Equity Value.
• Breakeven analysis for minimum vehicle throughput and EBITDA breakeven.
• Investor returns waterfall.
• Dashboard, charts, ratios and key operating metrics.
• Completed fuel filling station mock scenario.
• Dedicated Model Input Notes & Guidance (User Guide) section covering the key editable input cells across the main model tabs.

Who should use this model?

This Fuel Station Financial Model Excel template is designed for fuel station operators, petroleum retail developers, gas station entrepreneurs, petrol station owners, private investors, equity partners, commercial banks, development finance institutions, SBA loan applicants, acquisition analysts, M&A advisors, feasibility consultants and business plan writers preparing fuel station forecasts, funding applications, investor submissions, feasibility studies or acquisition valuation work.

Preview the Fuel Station Financial Model before purchasing

This product page includes a step-by-step video walkthrough and sample PDF preview pages so users can see exactly how the Fuel Station Financial Model Excel template is structured before purchasing.

The walkthrough shows the full Inputs → Calculations → Outputs flow, including site assumptions, fuel grades, daily vehicle throughput, fuel revenue, car wash revenue, convenience store revenue, CAPEX, working capital, debt funding, financial statements, DSCR, breakeven analysis, dashboard KPIs, DCF valuation and investor waterfall outputs.

This preview is useful for anyone who needs a lender-ready fuel station forecast, a gas station business plan model, a petrol station feasibility model, or an investor-ready fuel retail financial model without building a spreadsheet from scratch.