How to build the 3-statement financial model for a Canadian business plan

Canadian lenders rarely reject a plan because a single projected number is too high. They reject it because the three financial statements don't agree with each other — a profit on paper that the cash never shows up for, or a balance sheet that doesn't balance. A three-statement model fixes that by linking the income statement, balance sheet, and cash-flow statement so they all move from one set of assumptions. This guide covers why lenders want the statements linked, how we model the assumptions behind them using real CRA tax categories, and how to benchmark the result against Canadian industry data.

What is a three-statement financial model?

A three-statement model is one integrated model where the income statement, balance sheet, and cash-flow statement are connected, not built in isolation. Three links hold it together:

• Net income from the income statement flows into retained earnings on the balance sheet.
• Non-cash items (most importantly capital cost allowance) are added back on the cash-flow statement to convert net income into cash from operations.
• Closing cash on the cash-flow statement becomes the cash line on the balance sheet.

Because the three statements share these links, changing one assumption updates all three at once. Raise the sales growth rate and revenue rises, net income rises, retained earnings rise, and cash rises — consistently. That internal consistency is the point. An underwriter can take a dollar of projected revenue and trace it all the way through to the cash available to repay the loan — repayment capacity being the first thing a lender reads a plan for.

Why do lenders want the three statements linked?

Standalone statements can quietly contradict each other. The most common failure: a projection shows healthy profit on the income statement, but the cash-flow statement — if it exists at all — never produces the cash that profit implies, because receivables, inventory, and capital spending were ignored. A linked model closes that gap automatically.

Linking also lets the lender stress-test the file. A credit adjudicator will change one input — push receivables from 30 to 60 days, drop revenue 15% — and watch whether the debt-service coverage ratio (DSCR) still clears their threshold (commonly around 1.2–1.25×, confirm with the specific lender). If the model holds, the file looks robust. If it breaks or has to be re-typed by hand, the underwriter learns the projections were entered as fixed numbers rather than built from drivers.

What we do when we build the model is make the links explicit and the assumptions visible, so the lender can do their own stress test without rebuilding anything. What the lender does is decide whether the resulting coverage and capital structure meet their underwriting criteria.

How do the three statements actually connect?

The mechanics are worth seeing in order, because each statement feeds the next.

Statement	Produces	Flows to
Income statement	Net income (revenue − expenses, including CCA)	Retained earnings on the balance sheet; starting line of the cash-flow statement
Cash-flow statement	Closing cash (net income + non-cash add-backs ± working-capital changes ± financing/investing)	Cash line on the balance sheet
Balance sheet	Assets = liabilities + equity (must balance)	Confirms the model is internally consistent

The reconciliation that trips up most do-it-yourself projections is the non-cash add-back. Capital cost allowance reduces net income but takes no cash out of the business, so it has to be added back on the cash-flow statement. Miss that step and the model understates the cash available to service debt — which is exactly the number the lender is underwriting.

Which CRA expense categories should the model use?

We model operating expenses using the line items on CRA Form T2125, Statement of Business or Professional Activities — the same categories the business will later use to file. Building the projection on the filing taxonomy means the plan reconciles to future tax returns instead of using made-up cost buckets.

The common T2125 Part 4 expense lines (verbatim from canada.ca):

• Line 8521 — Advertising
• Line 8523 — Meals and entertainment (allowable part only)
• Line 8590 — Bad debts
• Line 8690 — Insurance
• Line 8710 — Interest and bank charges
• Line 8760 — Business taxes, licences, and memberships
• Line 8810 — Office expenses
• Line 8910 — Rent
• Line 8960 — Repairs and maintenance
• Line 9060 — Salaries, wages, and benefits (including employer's contributions)
• Line 9180 — Property taxes
• Line 9200 — Travel expenses
• Line 9281 — Motor vehicle expenses (not including CCA)
• Line 9936 — Capital cost allowance (CCA)
• Line 9945 — Business-use-of-home expenses

Two of these carry modelling nuances worth flagging in the plan:

• Line 9936 (CCA) is tax depreciation on declining-balance classes. It lowers net income but is non-cash, so it must be added back on the cash-flow statement (see above).
• Line 9945 (business-use-of-home) is a restricted deduction — under CRA rules it generally cannot be used to create or increase a business loss, and any unused portion carries forward. Treat it carefully in the model rather than letting it drive net income negative. Confirm the current rule on canada.ca before finalizing.

How do you benchmark the assumptions against Canadian data?

Assumptions are only as credible as the evidence behind them. The primary free Canadian benchmarking source is ISED's Financial Performance Data (FPD) tool. ISED states FPD provides access to more than 1,000 industries across Canada, including more than 30 performance benchmarks to help small businesses see how they measure up to competitors.

How we use it:

• Select the relevant industry (FPD is organized by industry, searchable by keyword and code), then pull the report.
• The report returns industry-average income statement and balance-sheet items, plus financial ratios, for businesses in revenue bands of roughly $30,000–$5M and $5M–$20M, split between profitable and non-profitable firms.
• Compare the projection's gross margin, key expense ratios (rent, salaries, advertising as a percent of revenue), and working-capital structure against the industry average.

Where a projected ratio deviates sharply from the FPD average, we either correct the assumption or explain the deviation in the plan. A lender who sees benchmarked assumptions reads competence; a lender who sees round numbers with no comparator reads guesswork. (Statistics Canada also publishes related SME financial benchmarking data; FPD is the most directly usable for a single-industry comparison.)

What assurance standard applies to projections in a Canadian plan?

This is a point worth getting right, because it is easy to overstate. A business plan's projections are normally management's own forward-looking estimates — they carry no assurance and no accountant's report unless one is specifically engaged.

If a CPA is engaged to compile a forecast or projection, the relevant Canadian guidance is:

• AuG-16, Compilation of a Financial Forecast or Projection — the Assurance and Related Services Guideline that remains the current authoritative guidance for compiling future-oriented financial information.
• Former CPA Canada Handbook Section 4250 (Future-oriented Financial Information) was moved to non-authoritative status in 2020, so it should not be cited as a live standard.
• CSRS 4250 (Compilation Engagements on Future-oriented Financial Information and Pro Forma) is a proposed Canadian Standard on Related Services intended to replace AuG-16. As of mid-2026 it is still in development at the Auditing and Assurance Standards Board and not yet in force — describe it as forthcoming, and confirm the current standard before relying on it.

For most business loan files that need a plan, none of this is triggered: the plan presents management's projections clearly labelled as estimates, with stated assumptions and a base/conservative/optimistic framing. We don't represent projections as audited, reviewed, or compiled unless a CPA has actually performed that engagement.

How long and how detailed should the projection be?

Format expectations are fairly consistent across Canadian lenders and programs:

• Year 1: monthly — the monthly view exposes the low point of the cash balance, where a working-capital shortfall would show up. The Year 1 cash-flow projection is the most-scrutinized part of a loan file.
• Years 2–3: annual — some larger or longer-amortization deals ask for five years.
• Date every assumption and state the scenario (base, conservative, optimistic). A model presented only at its optimistic case reads as naive; showing the conservative case that still services debt reads as disciplined.

Tie the financial model back to the rest of the plan: the revenue line should match the market sizing in the body of the plan, the salaries line should match the staffing plan, and the capital expenditure should match the use-of-funds in the executive summary. A lender who finds the financial model contradicting the narrative stops trusting both.

The bottom line

A three-statement model earns credibility by being internally consistent: net income flows to retained earnings, non-cash CCA is added back to cash, and closing cash lands on the balance sheet — so an underwriter can trace projected revenue all the way to the cash that services the debt. We build the model on CRA Form T2125 expense categories so it reconciles to the business's future filings, benchmark the assumptions against ISED's Financial Performance Data, and label the projections as management's estimates rather than assured numbers. None of this guarantees a lending decision — the lender assesses coverage, collateral, and risk on their own criteria. What a linked, benchmarked, filing-aligned model does is remove the inconsistencies that get plans set aside before underwriting even begins.

Frequently asked questions

What is a three-statement financial model?

A three-statement model links the income statement, balance sheet, and cash-flow statement so they move together from one set of assumptions. Net income from the income statement flows into retained earnings on the balance sheet. Non-cash items like capital cost allowance get added back on the cash-flow statement. Closing cash on the cash-flow statement becomes the cash line on the balance sheet. Change one assumption — a sales growth rate, a payment term — and all three statements update consistently. Lenders ask for linked statements because internal consistency is itself a credibility signal.

Why do lenders want the three statements linked instead of standalone?

Standalone statements can be internally inconsistent — a profit on the income statement that the cash-flow statement never produces, or a balance sheet that doesn't balance. Linked statements close those gaps automatically, so an underwriter can trace a dollar of projected revenue through to the cash available to service debt. It also lets the lender stress-test: change one input and see whether the debt-service coverage ratio still holds. A model that breaks under a small change tells the underwriter the projections were typed in, not built.

Which CRA expense categories should a Canadian projection use?

Model operating expenses using the line items on CRA Form T2125, Statement of Business or Professional Activities — the same categories the business will later file. Common lines include Line 8521 Advertising, Line 8690 Insurance, Line 8910 Rent, Line 9060 Salaries, wages, and benefits, Line 9281 Motor vehicle expenses (not including CCA), Line 9936 Capital cost allowance, and Line 9945 Business-use-of-home expenses. Using the filing categories makes the projection reconcilable to future tax returns and signals to a lender that the numbers map to real reporting.

How does capital cost allowance affect a financial model?

Capital cost allowance (CCA), reported on Line 9936 of Form T2125, is Canada's tax depreciation. It reduces net income on the income statement but is a non-cash deduction — no cash leaves the business when CCA is claimed. On a linked model, CCA is therefore added back on the cash-flow statement to reconcile net income to cash from operations. This is the single most common place standalone projections go wrong: they subtract depreciation from profit but forget to add it back to cash, understating the cash available to service the loan.

What is ISED's Financial Performance Data tool used for?

Financial Performance Data (FPD), published by Innovation, Science and Economic Development Canada, lets you pull industry-average income statement and balance sheet figures for a chosen industry. ISED states the tool covers more than 1,000 industries across Canada with more than 30 performance benchmarks. You select an industry, and the report returns average revenues, expense ratios, and balance-sheet items for businesses in revenue bands of roughly $30,000–$5M and $5M–$20M. It's used to benchmark a projection's margins and cost ratios against comparable firms.

Do Canadian projections need to follow a CPA assurance standard?

A business plan's projections are normally management's own forward-looking estimates and carry no assurance. If a CPA is engaged to compile a forecast or projection, the current authoritative guidance is the Assurance and Related Services Guideline AuG-16, Compilation of a Financial Forecast or Projection. The former CPA Canada Handbook Section 4250 on future-oriented financial information was moved to non-authoritative status in 2020. A proposed standard, CSRS 4250, would replace AuG-16, but as of mid-2026 it is still in development and not yet in force — confirm the current standard before relying on it.

How many years should the projection cover?

Most Canadian lenders and programs expect monthly projections for Year 1 and annual projections for Years 2 and 3 — some ask for five years on larger or longer-amortization deals. The monthly Year 1 view matters most for a loan file because it shows the low point of the cash balance, which is where a working-capital shortfall would appear. Always date the assumptions and state whether figures are a base, conservative, or optimistic case.

Sources

1. Expenses section of Form T2125 — Canada Revenue Agency, 2026
2. Form T2125, Statement of Business or Professional Activities — Canada Revenue Agency, 2026
3. Line 8521 – Advertising — Canada Revenue Agency, 2026
4. Financial Performance Data — Innovation, Science and Economic Development Canada, 2026
5. AuG-16, Compilation of a Financial Forecast or Projection — Assurance and Related Services Guideline (summary), 2024
6. Proposed CSRS 4250, Compilation Engagements on Future-oriented Financial Information and Pro Forma — Exposure Draft — Auditing and Assurance Standards Board (FRAS Canada), 2024
7. Guide to understanding financial statements — BDC, 2026
8. RBC: Create a Business Plan — RBC Royal Bank, 2026