Three-Statement Financial Model in Canada: How It Works | Ledgerive
Home / Knowledge Base / Financial Modeling

Three-Statement Financial Model in Canada

How the income statement, balance sheet and cash flow statement link together, what's different in a Canadian model, and an interactive three-statement builder that balances as you change it.

Summary

A three-statement financial model links the income statement, balance sheet and cash flow statement so every assumption flows through profit, financial position and cash, and the balance sheet balances in every period. Canadian models add specifics: ASPE or IFRS accounting, capital cost allowance for tax, federal and provincial tax rates such as Ontario's new 2.2% small business rate, HST, payroll remittances and SR&ED. This guide explains how the statements connect, what to build in a Canadian model and includes a live three-statement builder.

Many business forecasts are really just a profit and loss projection. They show sales rising and costs following, and they end at net income. What they don't show is whether the company actually has the cash to pay suppliers, fund equipment and meet loan payments while it grows. Profitable businesses run out of cash all the time.

A three-statement model closes that gap. By linking the income statement to the balance sheet and the cash flow statement, it shows how customer payment terms, inventory, capital spending, debt and taxes affect cash month by month. It's the format Canadian banks, BDC, investors and boards expect, because it can't hide a gap: if something is missing, the balance sheet won't balance.

Ledgerive's financial modeling services build integrated three-statement models for Canadian businesses. This guide explains how they work and what makes a Canadian model different.

Need a three-statement model that actually balances?

Book a free 30-minute call and we'll scope a model built for your business, your lender and Canadian tax rules.

1. What a Three-Statement Model Is

The three statements and the question each answers
StatementAnswersKey lines
Income statementIs the business profitable over the period?Revenue, cost of sales, operating expenses, depreciation, interest, tax, net income
Balance sheetWhat does the business own and owe at a point in time?Cash, receivables, inventory, equipment, payables, debt, equity
Cash flow statementWhere did cash come from and go?Operating, investing and financing cash flows
3
Linked statements that must agree every period
11.2%
Combined federal and Ontario small business tax rate from July 1, 2026
26.5%
Combined general corporate rate in Ontario
13%
HST in Ontario, which affects cash timing in the model
  • Net income flows from the income statement to the top of the cash flow statement and into retained earnings on the balance sheet.
  • Depreciation reduces net income but isn't cash, so it's added back in operating cash flow and reduces equipment on the balance sheet.
  • Working capital changes in receivables, inventory and payables adjust operating cash flow and update the balance sheet.
  • Capital spending appears in investing cash flow and increases equipment on the balance sheet.
  • Borrowing, repayments and dividends appear in financing cash flow and change debt and equity.
  • Ending cash on the cash flow statement becomes cash on the balance sheet, and assets equal liabilities plus equity.
The balance check is the model's built-in auditor. If assets don't equal liabilities plus equity, something is missing or double-counted. Our financial model quality assurance checklist lists the checks every model should include.

3. Building It, Step by Step

A practical build order
StepWhat to do
1. Historical statementsEnter two to three years of actuals and the latest balance sheet
2. AssumptionsRevenue drivers, margins, costs, hiring, payment terms, capex and financing
3. Income statementForecast revenue, costs and operating profit from the drivers
4. Supporting schedulesWorking capital, fixed assets and depreciation, debt, tax and equity
5. Balance sheetPull closing balances from the schedules
6. Cash flow statementDerive cash flows from income statement and balance sheet changes
7. Checks and scenariosBalance and cash checks, then base, downside and upside cases

Use monthly periods for the first 12 to 24 months, especially for lenders, and annual periods after that. Keep inputs on one sheet so assumptions are easy to test.

4. What's Different in a Canadian Model

  • Accounting basis: most private companies report under Accounting Standards for Private Enterprises (ASPE); public companies use IFRS. Match the model to your statements.
  • Capital cost allowance: tax depreciation follows CRA classes and rates, which differ from accounting depreciation, so a separate CCA schedule is needed for taxable income.
  • Federal and provincial tax: rates depend on the province and whether income qualifies for the small business deduction.
  • HST or GST/PST: sales tax collected and input tax credits are balance sheet items with their own remittance timing.
  • Payroll costs: CPP, EI and provincial items such as workplace insurance and Ontario's Employer Health Tax.
  • SR&ED and grants: refundable tax credits and government funding, timed to when cash actually arrives.
  • Canadian financing: CSBFP and BDC loan terms, interest-only periods and covenants.

5. Modelling Canadian Corporate Tax

  • Start from accounting profit, add back depreciation and non-deductible items, then deduct capital cost allowance.
  • Apply the right rate: 11.2% combined on the first $500,000 of active business income for eligible Ontario CCPCs from July 1, 2026, and 26.5% above it; see our guide to BDC business plans for how lenders view after-tax cash flow.
  • Prorate for straddle years: a December 31, 2026 year-end blends the old 3.2% and new 2.2% Ontario rates.
  • Model payment timing: instalments generally apply when tax exceeds $3,000, and eligible CCPCs pay the balance within three months of year-end.
  • Carry losses forward so early losses reduce later taxable income.

6. Interactive Three-Statement Builder

This one-year model starts from an illustrative opening balance sheet: cash $100,000, receivables $120,000, inventory $80,000, equipment $300,000, payables $70,000 and debt $200,000, so equity is $330,000. Change the assumptions and watch all three statements update and stay in balance. It's simplified: tax is a flat rate on positive profit, and interest is charged on opening debt.

Income statement drivers

Working capital

Assets and financing

Net income
–
Cash from operations
–
Ending cash
–
Balance check
–

7. Reading the Worked Example

With the default assumptions, the business earns about $163,900 of net income, but operating cash flow is about $175,300 because depreciation is added back while growing receivables and inventory and lower payables absorb some cash. After $60,000 of capital spending and $40,000 of debt repayment, cash rises by about $75,300.

Try raising receivable days from 40 to 90: profit doesn't change, but cash falls sharply. That's exactly the kind of insight a profit-only forecast misses.

8. Who Uses Three-Statement Models, and Why

Common uses in Canadian businesses
UserWhat they look for
Banks and BDCCash available for debt payments, coverage ratios, covenants
InvestorsRunway, burn, unit economics and dilution; see the investor-ready financial model checklist
Buyers and sellersNormalized earnings, working capital and valuation
Owners and boardsBudgets, hiring decisions and cash planning

Models also support business plans in specific sectors, such as our guide to a business plan for beauty salons and spas in Markham. If you're choosing outside help, our guide to hiring a vetted business plan services provider explains what to look for. A typical three-statement model costs about $2,500 to $7,500 with Ledgerive, depending on complexity.

9. HST, Payroll and BN Registration in the Model

A Canadian model should reflect the tax accounts tied to your nine-digit CRA business number.

  • BN registration timing: start-up models should show when BN registration and HST and payroll accounts under your business number begin.
  • HST: HST collected is a liability until remitted; input tax credits reduce it. Model monthly, quarterly or annual filing frequency.
  • Payroll remittances: deductions are usually remitted by the 15th of the following month for regular remitters.
  • Corporate tax: instalments and the year-end balance as current liabilities.
  • History that ties out: historical figures should match your filed returns; our bookkeeping services deliver reconciled actuals.

Common three-statement model mistakes

  • A balance sheet that's forced to balance with a plug figure.
  • Using accounting depreciation for tax instead of capital cost allowance.
  • Ignoring HST timing on large purchases.
  • Interest that doesn't follow the debt schedule.
  • No owner pay or dividends, overstating retained cash.

Need the model inside a lender-ready document? Our business plan services build the plan from it, and our fractional CFO services keep it updated against actual results.

10. Frequently Asked Questions

What is a three-statement financial model?

A three-statement financial model links a company's income statement, balance sheet and cash flow statement so that a change in one assumption, such as sales growth or payment terms, flows through all three. It is the standard format lenders, investors and boards use to test forecasts, because it shows profit, financial position and cash at the same time and must balance in every period.

How are the three financial statements linked?

Net income from the income statement becomes the starting point of the cash flow statement and adds to retained earnings on the balance sheet. Non-cash items such as depreciation are added back, and changes in working capital, capital spending, borrowing, repayments and dividends explain the change in cash. Ending cash from the cash flow statement must equal cash on the balance sheet, and total assets must equal liabilities plus equity.

Do Canadian private companies use IFRS or ASPE?

Most Canadian private companies use Accounting Standards for Private Enterprises (ASPE), while publicly accountable enterprises use IFRS. A private company can choose IFRS, which some do when they plan to go public or report to foreign investors. A financial model should follow the same basis as the company's historical financial statements.

How should taxes be modelled in a Canadian financial model?

Canadian models usually calculate tax on taxable income rather than accounting profit, replacing accounting depreciation with capital cost allowance and applying the right federal and provincial rates. Eligible Canadian-controlled private corporations in Ontario pay a combined 11.2% on the first $500,000 of active business income from July 1, 2026, and 26.5% above it. Instalments, payment deadlines, HST timing and SR&ED refunds also affect cash flow.

How much does a three-statement financial model cost in Canada?

Costs depend on complexity, the number of revenue streams and scenarios, and whether historical data needs cleaning. Ledgerive's typical range for a three-statement model is about $2,500 to $7,500, with simpler loan models from about $1,500 and investor-grade models with detailed scenarios and cap tables costing more.

Summary

A three-statement model links profit, financial position and cash so every assumption flows through and the balance sheet always balances. Canadian models need the right accounting basis, a capital cost allowance schedule, current federal and provincial tax rates, HST and payroll timing, and realistic SR&ED and financing assumptions. Build from clean history tied to your CRA business number filings, add checks and scenarios, and use the builder above to see how working capital and capital spending change cash.

Get a Canadian three-statement model built for you

Ledgerive builds integrated three-statement models for lenders, investors and management teams across Canada. Book a free 30-minute call or reach us directly.

Sources: Ontario Ministry of Finance, Corporate income tax; CRA, Corporation tax rates; CRA, Business number and program accounts.

Disclaimer: The above contents are provided for general guidance only, based on information believed to be accurate and complete, but we cannot guarantee its accuracy or completeness. It does not provide legal advice, nor can it or should it be relied upon. Please contact/consult a qualified tax professional specific to your case.