Updated Checked by the Tax-Services.ca editorial team How we check
Financial modeling in business planning means building a spreadsheet that turns your assumptions into cash, profit and tax, so you can change one number and watch the rest move. It’s less about predicting the future than about finding which assumption can sink you.
What goes into a financial model for a small Canadian business?
Three things, kept apart. First, an assumptions page: prices, unit costs, headcount, payment terms, the loan. Second, the calculations, which only ever point back at that page. Third, the outputs you care about, usually monthly cash balance and yearly profit.
The BDC’s projections guide lists what a full set contains: sales forecast, operating expenses, a cash flow by month for year one, then an income statement and balance sheet. It suggests at least 24 months. A model that stops at twelve hides the second-year cash squeeze.
Most real models fail on discipline, not on maths. A number typed into the middle of a formula is a number nobody will find again in six months. By the time you notice the cash forecast is off, the person who typed it may have left the business, forgotten why, or both.
| Part of the model | What it holds | Who reads it |
|---|---|---|
| Assumptions | Prices, costs, hires, terms, financing | You, first |
| Cash flow | Money in and out by month, year one | Lenders and you |
| Income statement | Yearly projected profit | Lenders, investors |
| Balance sheet | Yearly position | Lenders, investors |
| Scenarios | Most likely, optimistic, pessimistic | You and partners |
How do you build the cash flow part?
Start with the step the BDC describes for the first year.
Plug your expenses and revenues into a cash flow projection that shows monthly inflows and outflows of money for the first 12 months of operations.
6 steps to making financial projections for your new business, BDC, bdc.ca
Each month needs three lines: cash at the start, what came in and went out, and cash at the end. The end balance becomes next month’s start. That chain is the whole trick, and it’s why one wrong payment date in March can show up as a shortfall in June.
How do you test a price before you commit to it?
Hold the cost steady at $60 a unit and move the price. At $90, the profit margin calculator shows a 33.3% gross margin. At $100 it’s 40%. At $110 it’s 45.5%. Ten dollars either way swings margin by six or seven points, which is the kind of sensitivity a model exists to show.
Then ask the useful follow-up. If the lower price sells more, how many extra units do you need to earn the same total profit? Say you sell 1,000 units at $100, so $40,000 of gross profit. At $90 you earn $30 a unit, so you’d need about 1,334 units to match it, a third more volume. A spreadsheet answers that in a minute, and your gut won’t.
What does tax do to the output?
A model that stops at pre-tax profit flatters you. For a Canadian-controlled private corporation, the corporate tax calculator estimates about $35,088 of combined tax on $300,000 of taxable income in Ontario, leaving $264,912. That’s an average rate near 11.7%.
Treat that as a placeholder. It’s for a calendar 2026 year, and Ontario’s small business rate in it is a prorated blend of two rates, not a published figure. Corporations with another year end, associated companies or large passive income will land elsewhere. Put the tax rate on the assumptions page as one cell, and when the real figure arrives from your accountant, you change it once.
Why should the model have three scenarios?
The BDC recommends a most likely, an optimistic and a pessimistic version of each projection. Do it, but be sceptical of your own optimistic case. It’s usually the one you already wanted.
The pessimistic version is where the model earns its keep. Cut sales by a fifth, let customers pay later, and see what month the cash balance goes negative. That date tells you how much cushion to line up before it happens, and lenders will ask the same question.
A cheaper check is to run a single decision through the ROI calculator. Invest $20,000 and get $26,000 back after three years, and it shows a 30% total return and 9.1% a year, without tax or fees. If a simple case doesn’t clear your bar, a fancy model won’t rescue it.
What should a model leave out?
False precision. Forecasting revenue to the nearest dollar in month 30 is theatre. Round the long-range numbers and spend the detail on the first six months, where you can actually compare plan against actuals.
Leave out anything you can’t source. We didn’t find a dependable benchmark for what a typical Canadian small business earns in a given sector, so we haven’t offered one. Statistics Canada publishes financial ratios by industry, which is the better place to look.
If the model feeds a loan application, loan terms belong on the assumptions page too. The loan calculator produces a payment schedule you can paste into the monthly cash flow.
Common questions about financial models
Do I need special software? No. A spreadsheet is enough for most small firms, as long as assumptions sit on their own page and every formula points back to them.
How often should I update it? Drop in the actual numbers every month while the bank statement is fresh. A model that’s six months stale is worse than none, because people still trust it.
Who should check it? Ask your accountant to look at the tax and timing lines. They’ll catch things like a remittance date you forgot or a rate that’s changed.
Where the numbers come from
The contents of a projection set, the 24-month horizon and the three scenarios are from the BDC’s financial projections guide. Margin, return and corporate tax figures come from this site’s calculators, which use round example amounts and 2026 data. The Ontario small business rate is a derived estimate. This site is independent of any lender or government.
Frequently asked questions
What is financial modeling in simple terms?
A spreadsheet that turns your assumptions into cash flow, profit and tax, so you can change one input and see the result.
How many months should a model cover?
The BDC suggests at least 24 months, with monthly detail for the first year.
Do I need three scenarios?
The BDC recommends most likely, optimistic and pessimistic versions. The pessimistic one shows when cash could run out.
Should the model include tax?
Yes. Pre-tax profit overstates what you can reinvest. A corporate tax estimate can sit in one assumption cell and be updated once.
Where do I find industry benchmarks?
Statistics Canada publishes financial ratios for small businesses by industry. We did not confirm sector figures here.
- Self-employed taxes in Canada: income, CPP and GST
How tax works when you are self-employed in Canada: reporting income and expenses, paying both halves of CPP, instalments and when to register for GST