Cash flow projections for a Canadian business loan

Canadian lenders scrutinize cash flow projections more than any other section of a business plan. Most rejected files fail not because the business idea is weak, but because the projections are incomplete, unrealistic, or missing the specific Canadian tax line items lenders expect to see. This guide covers what underwriters actually need — years required, granularity, DSCR targets by lender, scenario analysis, common errors, and the Canadian tax items most projections miss.

How many years of projections — and at what granularity

Standard practice in Canada: 3 years of forecasts, with Year 1 broken down monthly and Years 2–3 quarterly.

Lender / Program	Years required	Year 1 granularity	Years 2–3 granularity
BDC	3 years (standard); 5 years for large commercial files	Monthly	Quarterly
CSBFP (any participating lender)	2–3 years (per program guide)	Monthly	Quarterly
Big six (RBC, TD, BMO, Scotiabank, CIBC, NB)	3 years; 5 years for >$1M files	Monthly	Quarterly or annual
Credit unions	3+ years (lender's discretion)	Monthly	Quarterly

The monthly Year 1 is mandatory because it captures seasonality and working capital timing. A retail business that does 40% of annual sales in Q4 needs to show how it survives Q1–Q3 cash flow. A consulting business with 60-day AR cycles needs to show how it bridges between revenue recognition and cash collection. Annual-only projections obscure both.

The DSCR target: 1.25× is the Canadian norm

Canadian banks generally target a Debt Service Coverage Ratio (DSCR) of at least 1.25× on the modelled cash flow. That means the cash available for debt service must exceed scheduled debt payments by 25%.

DSCR ranges by lender:

• Big-six commercial: ≥1.25× target; some files clear at 1.20× with strong mitigants
• BDC: 1.1–1.2× tolerated, especially for start-ups with strong equity injection
• CSBFP: ~1.20–1.25×; the 85% government guarantee provides some flexibility
• Credit unions: Generally 1.25×, varies by sector

Anything below 1.0× is an automatic decline — the projected cash flow doesn't cover the loan payments. Between 1.0× and 1.2× is the borderline zone where the file might clear with additional collateral, higher equity injection, or a personal guarantee, but it's not a comfortable approval.

Critical detail: the DSCR calculation must appear explicitly in the financial section. A debt schedule showing scheduled principal and interest payments, paired with a DSCR line calculated for each year, is what underwriters look for. A spreadsheet that shows net cash flow but doesn't call out DSCR makes the adjudicator do the math — and they sometimes choose not to.

Scenario analysis: base / downside / upside

Canadian lenders increasingly require scenario analysis on the projections, especially for loans above $250K. The standard pattern:

• Base case — the most likely outcome, based on conservative but realistic assumptions
• Downside case — what happens if revenue is 20–30% below plan, or COGS rises 10–15%, or a major customer leaves
• Upside case — what happens if growth comes faster than expected

The downside case is the one underwriters read most carefully. It must still show DSCR at or above the lender's required threshold. If the downside breaks 1.0× DSCR, the file is at risk regardless of how strong the base case looks.

RBC's published guidance explicitly recommends including key assumptions, sensitivity analysis, and major contracts in the projections section. BDC's underwriting practice follows similar logic. Most rejected files lack any scenario analysis at all — the projection is a single line with no stress testing.

The Canadian tax line items most projections miss

These five Canadian tax items must appear in the cash flow forecast. Missing any of them understates the cash flow required and is a common rejection trigger:

1. GST/HST remittances

Most businesses with annual revenue above $30,000 must register for GST/HST and remit quarterly or monthly (revenue thresholds determine frequency). The projection must show:

• GST/HST collected on sales (a balance sheet item, not income)
• Input tax credits on purchases (reduces the remittance)
• Net remittance to CRA on the quarterly/monthly cycle

A common error: treating GST/HST collected as revenue. It isn't — it's a liability owed to CRA.

2. CPP and EI employer contributions

For every employee on payroll:

• CPP (2026 rates): 5.95% of pensionable earnings, up to a maximum
• EI (2026 rates): 1.66% of insurable earnings (employee) plus 1.4× that for the employer

The projection must include both employer-side contributions as a cash outflow distinct from gross wages. Missing this typically understates payroll cost by 7–8%.

3. Federal and provincial corporate income tax

For incorporated businesses:

• Federal small business tax rate: 9% on the first $500,000 of active business income (CCPC threshold)
• Provincial small business rates: vary (e.g., Ontario 3.2%, BC 2.0%, Alberta 2.0%)
• Combined effective rate: typically 11–13% on the first $500K
• General rate (above the small business limit): combined ~26.5% federally + provincially

Sole proprietorships flow through to personal income tax — different modeling.

4. CCA (Capital Cost Allowance)

CCA is the Canadian equivalent of US tax depreciation. Different asset classes have different rates:

• Class 8 (most equipment): 20% declining balance
• Class 10 (vehicles): 30% declining balance
• Class 1 (buildings): 4% declining balance
• Class 50 (computer equipment): 55% declining balance

CCA affects the income statement (depreciation expense) and the cash flow projection (timing of tax deductions). Most templates auto-calculate this if the depreciation schedule is set up correctly.

5. Employer Health Tax (EHT) — provincial

Applicable in:

• Ontario: 1.95% on annual payroll above $1M (small employer exemption)
• Manitoba: Graduated rates above $2.25M payroll
• Newfoundland and Labrador: 2.0% above $1.5M payroll
• Quebec (FSS): 1.65%–4.26% depending on payroll

Not applicable in BC, Alberta, Saskatchewan, New Brunswick, Nova Scotia, PEI, or the territories.

Common cash flow projection errors

Five patterns that cause Canadian lenders to send projections back:

1. Overly aggressive revenue ramps. Year 2 revenue 2–3× higher than Year 1 with no specific operational decision driving it (new location, new product, signed contract). The fix: tie every growth step to a specific event.

2. Neglected working capital needs. Cash flow that ignores accounts receivable timing, inventory build-up, or accounts payable terms. The fix: model net working capital changes separately, especially for inventory-heavy or seasonal businesses.

3. Missing tax remittances. Items 1–5 above. The fix: build a tax line schedule into the financial model from the start.

4. No buffer for variance. Even the base case should include a small contingency line. A 5% contingency on operating expenses signals competence; zero contingency signals naivety.

5. Mismatched timing. Revenue recognized in Month 3 but cash received in Month 5. Expenses incurred in Month 1 but paid in Month 2. The fix: maintain a clear distinction between income statement (accrual) and cash flow statement (cash) lines.

Tools Canadian businesses use

Most Canadian small-business cash flow projections are built in:

• Excel or Google Sheets — most common; full control over assumptions and formulas
• BDC Cash Flow Projection Tool — free, with a tech-focused template
• Xero free cash flow template — clean, accountant-friendly structure
• LivePlan — paid SaaS, $20–$30/month, includes financial templates
• PlanGuru — paid SaaS for more sophisticated forecasting, used by accountants
• RBC Cash Flow Tool — free, browser-based, simpler but less flexible
• PlanGuru and similar enterprise tools — for larger deals where an accountant builds the model

For a loan under $500K, Excel or Google Sheets with a disciplined template is almost always sufficient. For larger deals or acquisitions, having a CPA review the projections adds credibility.

The bottom line

A cash flow projection that clears Canadian underwriting includes 3 years (monthly Y1, quarterly Y2–3), an explicit DSCR calculation of 1.25× or higher, base/downside/upside scenarios with the downside still clearing the DSCR threshold, and all five Canadian tax line items modelled explicitly. Bridge Note, a Canadian business plan service that writes lender-ready plans for BDC, CSBFP, and big-bank loan applications, sees most rejected files clear approval after the financial assumptions narrative is rewritten and the tax line items are added — projections almost never fail because the business model is wrong, they fail because the modelling is incomplete.

Frequently asked questions

How many years of financial projections do Canadian lenders expect?

Most Canadian lenders expect 3 years. CSBFP asks for 2–3. Big-six and BDC standard is 3 years, with 5 years required for very large loans. Year 1 monthly, Years 2–3 quarterly.

Should cash flow be monthly, quarterly, or annually?

Year 1 must be monthly. Years 2–3 typically quarterly. Annual-only projections almost always trigger requests for more detail.

What DSCR do Canadian banks look for?

≥1.25× is the standard target. BDC guides to 1.1–1.2×. CSBFP files typically clear at 1.20–1.25×. Below 1.0× is an automatic decline.

Do I need sensitivity analysis or multiple scenarios in my projections?

Yes, for most files above $250K. Base / downside / upside on revenue, COGS, and one major expense line. The downside must still clear the lender's DSCR threshold.

Which Canadian tax items must I include in my cash flow forecast?

GST/HST remittances, CPP/EI employer contributions, federal and provincial corporate income tax (CCPC rates if applicable), CCA depreciation, and Employer Health Tax in applicable provinces.

Sources

1. BDC: Cash flow projection tool for tech businesses — BDC
2. Venn: 2026 Guide for the Canada Small Business Financing Program — Venn, 2026
3. Custom CPA: Bank Loan Approval Factors — Business Plan Impact Study — Custom Accounting & CFO Advisory
4. RBC: Create a Business Plan — RBC Royal Bank
5. Xero: Free cash flow projection template (Canada) — Xero
6. Canada.ca: Planning for Success — Government of Canada