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 project revenue for a Canadian business
A revenue forecast estimates the income your business will generate over the next 6, 12 or 24 months. Canadian lenders — from the big banks to BDC — ask for one with every financing application, and internally it is the number that decides when you can hire, buy inventory or sign a lease.
This free forecaster fits six methods to your actual monthly figures, models seasonality, draws best-case and worst-case scenario bands, and exports to CSV in Canadian dollars. Below: each method in plain English, a worked example in dollars, and the Canadian specifics — GST/HST treatment, fiscal-year choices and realistic growth rates — that static templates ignore.
What counts as revenue (and what doesn’t)
Revenue is your total sales for a period before expenses — the top line, not profit. Forecast net of GST/HST: the tax you collect belongs to the CRA, so a $1,130 invoice in Ontario (13 % HST) contributes $1,000 of revenue. The $30,000 small-supplier threshold that triggers mandatory GST/HST registration is also measured on your rolling four-quarter revenue — a growth forecast is exactly the tool that tells you when you will cross it.
Enter the same monthly series your books report (QuickBooks, Xero and Wave all export monthly income). Twelve months is ideal: enough to detect a trend and a full seasonal cycle.
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 planning.
- 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 math 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 (holiday retail peak, summer tourism, winter trades slowdown). Best when months differ structurally.
- Run rate — holds your average month flat. The conservative baseline, and the standard way to annualize 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 (“Canadians spend $10B on this; we’ll capture 0.01 %”) and should only ever be a sanity check: lenders discount it because the share assumption is a guess. Pre-revenue businesses should build month one from capacity (units × price, billable hours × rate), forecast straight-line, and swap in actuals monthly.
Worked example: a 12-month projection in Canadian dollars
Say last month’s revenue was $13,000 (net of HST), your history supports about 3 % monthly growth, and you project 12 months straight-line:
- Month 1: $13,000 × 1.03 = $13,390
- Month 2: $13,390 × 1.03 = $13,792
- Month 12: $13,000 × 1.03¹² ≈ $18,535
- Total projected revenue for the year ≈ $190,000
- With a ±15 % scenario band, month 12 lands between roughly $15,800 and $21,300 — budget against the low end.
Realistic growth rates for Canadian small businesses
Established Canadian SMEs typically grow revenue at low-to-high single digits annually: retail 2–5 %, professional services 4–8 %, e-commerce and SaaS often 10–25 %+ while scaling. Compounding hides aggression — 3 % monthly is over 40 % a year. Keep the base case at a rate you would bet payroll on and let the optimistic band carry the upside.
Canadian specifics: fiscal years, taxes and seasonality
Sole proprietors report on the calendar year; corporations may choose any fiscal year-end. This forecaster labels rows by calendar month, which matches how accounting software exports revenue — and the CSV lets you total any custom fiscal period.
Canadian seasonality is pronounced: December retail peaks, summer tourism highs, and weather-driven slowdowns for construction and trades in deep winter. The seasonal method models exactly this — pick the retail or tourism preset, or compare a seasonal forecast against the regression trend to see how much timing (rather than growth) drives your months.
