Guide to Three-Statement Financial Models for SMEs in Canada

Most Canadian SMEs track profit closely. Far fewer can say with confidence what their cash balance will be in six months, how much a new piece of equipment really costs once financing is included, or whether growing sales will strain working capital. Those answers sit in the gaps between the financial statements, and a profit forecast on its own can't show them.

A three-statement model closes those gaps. By linking profit to cash and to the balance sheet, it shows how growth, credit terms, inventory, loans and taxes all interact. It's the format banks expect for larger loans, the structure investors use in due diligence, and the most useful planning tool a growing business can have.

This guide shows Canadian owners and finance leads how a three-statement model works and how to build one. It uses a simple Ontario distribution company with $2 million in revenue as a worked example, so you can follow every link from one statement to the next.

1. Why SMEs Need a Three-Statement Model

• Profit isn't cash. Customers paying late, inventory build-up and loan payments can drain cash even in a profitable year.
• Lenders expect it. Banks and other lenders assess repayment capacity, leverage and liquidity, which require all three statements.
• It catches errors. If the balance sheet doesn't balance, something in the logic is wrong.
• It tests decisions. Hiring, equipment purchases, price changes and new credit terms all flow through to cash and debt.
• It supports valuation and sale. Buyers and investors rely on integrated projections.

2. How the Three Statements Link

Each statement answers a different question, and each feeds the others:

3. Model Structure and Tabs

• Assumptions: all inputs in one place, colour-coded and sourced.
• Historicals: two to three years of actual statements as the starting point.
• Revenue and cost build: driver-based by product, customer or location.
• Supporting schedules: working capital, fixed assets and depreciation, debt, tax and equity.
• Three statements: monthly for at least year one, then quarterly or annual.
• Checks and dashboard: balance check, cash check, key ratios and scenarios.

4. Worked Example: An Ontario SME

An Ontario distributor starts the year with $100,000 in cash, $200,000 of receivables, $150,000 of inventory and $300,000 of equipment, financed by $120,000 of payables, a $250,000 term loan and $380,000 of equity. Its year-one projection (in $ thousands):

Notice that net income and cash from operations are both $166,800 here, but only by coincidence: the $40,000 depreciation add-back exactly offsets the $40,000 net working capital build. In most years they differ, which is exactly why the cash flow statement matters.

5. Supporting Schedules: Working Capital, Capex and Debt

The schedules are where most of the modeling happens. Keep them separate from the statements so assumptions are easy to change.

Cutting the collection period by ten days would free about $55,000 of cash in this example, a decision the three-statement model makes visible immediately.

6. Canadian Tax, HST and BN Registration Inputs

Canadian SME models need Canadian tax mechanics. The starting point is your CRA business number, the nine-digit identifier that links your corporate tax (RC), GST/HST (RT) and payroll (RP) accounts. Each corporation in a group has its own BN and its own set of statements, so multi-entity models need separate tax lines and inter-company eliminations. For a new company, BN registration generally happens at incorporation, for example through the Ontario Business Registry, with program accounts added through the CRA's Business Registration Online service.

• Corporate income tax (RC): eligible Canadian-controlled private corporations generally pay a lower combined rate on active business income up to the small business limit; Ontario's combined small business rate has been 12.2%. Model instalments and year-end balances owing on the balance sheet.
• HST (RT): keep it out of revenue and expenses; show HST payable or receivable on the balance sheet and remittances in cash flow.
• Payroll (RP): include employer CPP, EI and provincial payroll taxes in expenses, and model remittances owing as a short-term liability.
• Tax credits: SR&ED and similar credits are usually received months after year-end, so model them as receivables until cash arrives.

Confirm rates and eligibility with a qualified tax professional before relying on them in a lender or investor model.

7. Integrity Checks and Troubleshooting

• Balance check: total assets minus total liabilities and equity equals zero in every period.
• Cash check: ending cash on the cash flow equals cash on the balance sheet.
• Retained earnings roll-forward: opening + net income − dividends = closing.
• Debt roll-forward: opening + draws − repayments = closing.
• Fixed asset roll-forward: opening + capex − depreciation − disposals = closing.

When the balance check fails, the cause is usually in one of a few places:

8. Using the Model to Make Decisions

• Loan applications: show repayment capacity and debt service coverage; our business plan document checklist for Canadian lenders lists what to send with it.
• Growth planning: see how much working capital faster growth will consume.
• Equipment and hiring: test the effect on profit, cash and debt before committing.
• Dividends and owner pay: decide how much cash can safely leave the business.
• Scenarios: run base, downside and upside cases to stress-test plans.

9. Common Mistakes

• Building statements separately instead of linking them.
• Hard-coding numbers in the statements rather than driving them from schedules.
• Including HST in revenue or forgetting HST balances owing.
• Ignoring working capital, so cash looks better than it will be.
• Plugging the balance sheet with a balancing figure instead of fixing the logic.
• Using the wrong tax rate or missing entities with their own CRA business number.
• Not reconciling the opening balance sheet to the actual financial statements.

Before submitting a model to a lender or investor, run it through our business plan review checklist before submission.

10. Frequently Asked Questions