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 Maltese business

A revenue forecast estimates the income your business will generate over the next 6, 12 or 24 months. In Malta it anchors every business plan — banks and Malta Enterprise grant applications expect one — and day to day it decides when you can hire, stock up or take on bigger premises.

This free forecaster fits six methods to your actual monthly figures, models seasonality (with tourism front and centre for Malta), draws best-case and worst-case scenario bands, and exports to CSV in euro. Below: each method in plain English, a worked example, and the Malta-specific details — VAT exemption thresholds, the summer season — that generic tools skip.

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. VAT-registered businesses forecast net of VAT: the 18 % you collect belongs to the Commissioner for Tax and Customs, so a €1,180 invoice contributes €1,000 to turnover. Entering gross figures inflates every forecast by nearly a fifth.

Use the same monthly series your accounts show. Twelve months of history is ideal — enough for the trend methods and a full seasonal cycle, which matters in an economy where summer transforms 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 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 market size (“Malta welcomes 3 million tourists; 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 monthly.

Worked example: a 12-month forecast in euro

Say last month’s turnover was €9,000 (net of VAT), your history supports about 3 % monthly growth, and you forecast 12 months straight-line:

  1. Month 1: €9,000 × 1.03 = €9,270
  2. Month 2: €9,270 × 1.03 = €9,548
  3. Month 12: €9,000 × 1.03¹² ≈ €12,832
  4. Total forecast turnover for the year ≈ €131,500
  5. With a ±15 % scenario band, month 12 lands between roughly €10,900 (worst case) and €14,800 (best case) — plan fixed costs against the worst case.

Realistic growth rates for Maltese small businesses

Established Maltese SMEs 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 — 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.

Malta specifics: VAT thresholds and the summer season

The financial year follows the calendar year for most businesses, so the table runs on ordinary months. On tax: small undertakings below the VAT exemption threshold (€35,000 of annual turnover for most activities) can register as exempt under Article 11 — and a growth forecast shows months in advance when you will cross that line and need to start charging VAT.

Seasonality is Malta’s defining pattern: June–September transforms hospitality, beach concessions and attractions, language schools peak in summer, and Christmas lifts retail. That is exactly what the seasonal method models — compare it against the regression trend to separate the calendar effect from real growth.

Project cost calculator

Revenue forecasting FAQs