Revenue Forecast Calculator

Forecast your future revenue free — six methods, seasonality, best/worst-case scenarios and CSV export. No signup.

Revenue forecasting explained: how to forecast turnover for a Gibraltar business

A revenue forecast estimates the income your business will generate over the next 6, 12 or 24 months. In Gibraltar it underpins every business plan, licence application and bank facility request — and because the jurisdiction is small and heavily service- and tourism-driven, realistic month-by-month numbers matter more than generic annual guesses.

This free forecaster fits six methods to your actual monthly figures, models seasonality (including the summer tourism peak), draws best-case and worst-case scenario bands, and exports to CSV in pounds. Below: each method in plain English, a worked example in GBP, and the Gibraltar-specific details — no VAT, the July–June tax year — that UK-oriented tools get wrong.

What counts as revenue (and what doesn’t)

Revenue (turnover) is the total value of sales invoiced in a period, before any costs — not profit. Gibraltar’s big simplification: there is no VAT, so unlike UK businesses you don’t strip sales tax out of your history — your invoiced totals are your turnover. Import duty on goods is a cost, not a deduction from revenue.

Enter the same monthly series your bookkeeping shows. Twelve months of history is ideal: enough for the trend methods to work and a full seasonal cycle, which matters in a market where summer footfall transforms retail and hospitality takings.

The six forecasting methods, in plain English

  • Straight-line growth — applies a fixed monthly growth rate to your latest month. Best for steady growers and target-based plans.
  • Moving average — averages recent months and rolls that forward. Best for stable businesses with noisy figures.
  • Linear regression — fits a trend line through your whole history (the maths behind Excel’s FORECAST) and extends it. Best with 6+ months of consistent trend.
  • Exponential smoothing — weights recent months more heavily, reacting faster when momentum shifts.
  • Seasonal forecast — applies monthly seasonal indices on top of growth (summer cruise/tourism peak, Christmas retail). Best when August looks nothing like February.
  • Run rate — holds your average month flat. The conservative baseline, and the standard way to annualise part-year trading.

Top-down vs bottom-up forecasting

The six methods are bottom-up — built from your own data. Top-down starts from the market (“Gibraltar sees 8 million visitors; we’ll capture 0.1 %”) and should only ever be a sanity check, because the share assumption is a guess. A new business with no history should estimate month one from capacity (covers × average spend, billable hours × rate) and grow it straight-line, replacing assumptions with actuals each month.

Worked example: a 12-month forecast in pounds

Say last month’s turnover was £10,000, your history supports about 3 % monthly growth, and you forecast 12 months straight-line:

  1. Month 1: £10,000 × 1.03 = £10,300
  2. Month 2: £10,300 × 1.03 = £10,609
  3. Month 12: £10,000 × 1.03¹² ≈ £14,258
  4. Total forecast turnover for the year ≈ £146,200
  5. With a ±15 % scenario band, month 12 lands between roughly £12,100 (worst case) and £16,400 (best case) — plan fixed costs against the worst case.

Realistic growth rates for Gibraltar businesses

Established small businesses typically grow revenue at low-to-high single digits a year: retail 2–5 %, professional services 4–8 %, tourism and hospitality 5–12 % in good years but with huge seasonal swings — which is why year-on-year comparison beats month-on-month. Compounding deceives: 3 % a month is over 40 % a year, start-up pace rather than a safe planning base.

Gibraltar specifics: no VAT, July–June tax year, tourism seasonality

Gibraltar’s tax year runs 1 July to 30 June, and company tax filings follow financial years that many firms align either to it or to UK-style April accounts — the CSV export lets you total whichever period you report. Corporation tax applies to profits, not turnover, but every profit forecast starts with a defensible revenue line.

Seasonality is the defining local pattern: cruise calls and summer visitors lift retail and hospitality sharply from May to September, while cross-border trade keeps other sectors steadier. The seasonal method models exactly this — compare it against the regression trend to separate calendar effects from real growth.

Project cost calculator

Revenue forecasting FAQs