Summary
A business financial model forecasts revenue, costs, profit, cash and the balance sheet from a set of assumptions you can change and test. In Canada, a credible model also reflects HST timing, employer CPP and EI, corporate tax rates such as Ontario's 12.2% small business rate, capital cost allowance and loan schedules. This guide explains how to structure a model, build revenue and cost drivers, add Canadian tax and financing inputs, link the three statements, test scenarios and use the model every month, with a three-year forecast calculator.
Most Canadian owners already forecast in their heads: next month should be busier, the new hire will pay off by spring, the bank will want to see two good years. A financial model writes those beliefs down, connects them, and shows whether they add up to enough cash to run the business.
That matters for more than bank applications. A good model tells you what price you need, how many customers you need to break even, when you can afford the next hire, how much to borrow and what happens if your largest customer leaves. In a year of rising costs and higher borrowing rates, those answers are worth having before decisions are made.
This guide walks through how to build a business model properly. If you'd rather have one built for you, Ledgerive's financial modeling services do exactly that, and our guide to financial modeling services in Canada covers process, pricing and timelines.
Want a model built or reviewed?
Book a free 30-minute call to have an expert build your model or review the one you have.
1. Why Every Canadian Business Needs a Model
- Financing: lenders, BDC, CSBFP lenders and investors expect monthly projections; see our guide to the use of funds and repayment sections of a loan application.
- Cash control: a model shows the lowest cash point months ahead, not after it happens.
- Pricing and growth: test prices, hiring and new locations before committing.
- Valuation and succession: buyers and partners value forecast earnings, not just history.
2. Model Structure and Design Principles
| Section | Contents | Design rule |
|---|---|---|
| Inputs | Prices, volumes, growth, headcount, costs, terms, tax rates, financing | Every assumption entered once, clearly labelled and colour-coded |
| Historical data | Two to three years of accrual financial statements | Ties exactly to your accountant's statements |
| Calculations | Revenue build, payroll, cost schedules, working capital, depreciation, debt | Formulas only, no hard-coded numbers |
| Financial statements | Income statement, balance sheet, cash flow | Linked so the balance sheet always balances |
| Outputs | KPIs, charts, scenarios, lender ratios | One summary page a reader can understand in minutes |
- Monthly first: model at least the first 12 to 24 months monthly, then quarterly or annually.
- Accrual basis: match the method your books and the CRA use; our article on cash basis vs accrual accounting explains why.
- Keep it simple: the right level of detail is the one that drives decisions, not the most possible rows.
3. Forecasting Revenue With Drivers
"Revenue grows 20% a year" isn't a forecast; it's a guess. Driver-based revenue explains where sales come from, so you and your lender can test each piece.
| Business type | Revenue formula |
|---|---|
| Retail and restaurants | Traffic ร conversion ร average transaction ร days open |
| Professional services and agencies | Staff ร available hours ร utilization ร rate ร realization |
| Subscription and SaaS | Opening customers + new โ churned, ร monthly price |
| Manufacturing and distribution | Units by product ร price, limited by capacity |
| Trucking and logistics | Trucks ร loaded kilometres ร rate per kilometre + fuel surcharge |
Sector-specific drivers make a big difference; see our fractional CFO guide for trucking and logistics for cost per kilometre and operating ratio modeling. Always add seasonality and a ramp-up for new locations or products.
4. Costs, People and Canadian Payroll Inputs
- Cost of sales: materials, direct labour, subcontractors and freight as a share of revenue or per unit.
- Headcount schedule: each role with start date, salary and raises; this is usually the largest cost.
- Payroll on-costs: employer CPP (5.95% on pensionable earnings in 2026, plus CPP2 on higher earnings), EI at 1.4 times the 1.63% employee rate, vacation pay, benefits and WSIB.
- Employer Health Tax: Ontario employers with payroll above the $1 million exemption pay EHT at rates up to 1.95%.
- Overhead: rent, utilities, software, insurance, marketing and professional fees, with known increases.
5. Working Capital, Capital Spending and Financing
| Item | How to model it | Cash effect |
|---|---|---|
| Accounts receivable | Revenue ร days to collect รท 365 | Growth ties up cash |
| Inventory | Cost of sales รท turnover, or weeks of supply | More stock, less cash |
| Accounts payable | Purchases ร days to pay รท 365 | Supplier credit funds you |
| Capital spending | Equipment, vehicles, leaseholds by month | Cash out upfront; depreciation over time |
| Debt and equity | Loan draws, interest-only periods, amortization, owner injections | Funds gaps; payments reduce cash |
A growing business can be profitable and still run out of cash because receivables and inventory grow faster than profit. That gap is one of the clearest signs covered in our guide to when a business needs a fractional CFO.
6. Tax Inputs and BN Registration
- Corporate tax: apply the small business rate to eligible income and the general rate above the limit, and model instalments and year-end balances.
- HST timing: HST collected on sales and claimed on purchases moves cash between filing periods; model it on your filing frequency.
- Capital cost allowance: tax depreciation differs from book depreciation; check current immediate expensing rules for new equipment.
- BN registration: every account runs through your nine-digit business number. Make sure GST/HST, payroll and corporate tax accounts are open, and complete BN registration for any new entity in the model.
- Lender checks: due diligence often includes CRA statements under your CRA business number; arrears undermine any forecast.
7. Linking the Three Statements
- Income statement: revenue โ cost of sales โ operating expenses โ depreciation โ interest โ tax = net income.
- Cash flow statement: net income + depreciation โ increases in receivables and inventory + increases in payables โ capital spending ยฑ debt and equity = change in cash.
- Balance sheet: ending cash, receivables, inventory and fixed assets equal liabilities plus equity, with retained earnings growing by net income less dividends.
- The check: assets minus liabilities minus equity must equal zero in every period. If it doesn't, something is missing.
8. Interactive Three-Year Forecast Calculator
This simplified model links revenue, costs, tax, receivables and capital spending into profit and cash for three years. Equipment is depreciated straight-line over five years. Results are illustrative.
9. Scenarios, Checks and Using the Model
- Scenarios: base, downside (for example 15% lower sales or a lost customer) and upside, switched from one input.
- Sensitivity: show how profit and cash change with price, volume, margin and payment terms.
- Reasonableness checks: compare margins and growth with your history and industry; explain any big jumps.
- Error checks: balance sheet balances, cash never silently goes negative, and totals tie across tabs.
- Monthly use: load actual results each month, compare with the plan and reforecast; accurate bookkeeping makes this quick.
- Turn it into decisions: our fractional CFO services review the model with owners monthly, and our business plan services turn it into lender or investor packages.
10. Frequently Asked Questions
What is business financial modeling?
Business financial modeling is building a spreadsheet that forecasts a company's revenue, costs, profit, cash flow and balance sheet from a set of assumptions, such as prices, volumes, hiring and financing. It is used for budgeting, loan and investor applications, pricing, expansion decisions and valuation.
How are the three financial statements linked in a model?
Net income from the income statement flows into retained earnings on the balance sheet and is the starting point of the cash flow statement. Changes in balance sheet items such as receivables, inventory, payables, equipment and debt adjust net income to cash, and the ending cash on the cash flow statement becomes the cash balance on the balance sheet, which must balance every period.
What tax rate should I use in a Canadian financial model?
It depends on the province and the type of corporation. For an Ontario Canadian-controlled private corporation, the combined federal and provincial rate is generally about 12.2% on the first $500,000 of active business income eligible for the small business deduction and about 26.5% on income above that. Other provinces have different rates, so confirm with your accountant.
How far ahead should a financial model forecast?
Most business models forecast three to five years. The first 12 to 24 months are usually monthly so cash shortfalls, seasonality and loan payments are visible, with later years shown quarterly or annually. Start-ups raising investment often forecast five years; lenders focus on the term of the loan.
Should I build my financial model in Excel, Google Sheets or software?
Excel and Google Sheets remain the most common tools because lenders, investors and advisors can open, audit and adjust them easily. Dedicated forecasting software can help with recurring updates and integrations, but a clear, well-documented spreadsheet is usually best for a first model or a financing application.
Summary
A strong Canadian business model separates inputs, calculations and outputs, forecasts revenue from real drivers, includes payroll costs such as CPP, EI and EHT, models working capital, capital spending and debt, and applies HST timing and the right corporate tax rate. Link the three statements, check that the balance sheet balances, test scenarios, keep your CRA business number accounts current and update the model with actual results every month.
Turn your plans into a model you can trust
Ledgerive builds and reviews financial models for businesses across Canada, from start-ups to established companies. Book a free 30-minute call or reach us directly.
Sources: 2026 CPP, CPP2 and EI rates; Canada Revenue Agency, Accounting methods. Corporate tax and EHT rates are summarized for Ontario; confirm current rates with a tax professional. Calculator results are illustrative.