How to Build a Cash Flow Forecast for a Funding Application
When you apply for a loan or a grant, the reviewer wants to know more than whether your idea is sound. They want to see that your business will have enough cash to keep operating and to meet the new commitment, whether that is a loan payment or costs you must cover before a program pays you. A cash flow forecast answers those questions month by month.
Profit and cash are not the same thing. A business can show a profit on paper and still run short of cash because customers pay late, inventory has to be bought in advance or loan principal falls due. Here is how to build a forecast that a lender or program officer can follow, check and trust.
Start with what the funder asks for
Read the application guide before you open a spreadsheet.
Period and format: Check how far ahead the funder wants you to forecast and whether it supplies its own template. If it does, use it.
A sensible default: If the guide is silent, a monthly forecast for the next 12 months is a practical starting point, with annual totals for later years if the application asks for them.
Consistency: Your forecast must agree with your business plan, projected income statement, use of funds and the amount you request.
A real starting point: Begin with your actual bank balance, or your best estimate of it on the date the forecast starts.
Set up a structure reviewers can follow
A clear layout makes your numbers easy to check. For each month, show:
Opening cash balance
Cash in: customer payments, owner contributions, loan proceeds, grant or contribution payments and other receipts, such as a sales tax refund
Cash out: inventory and materials, wages, rent and utilities, marketing, insurance, professional fees, equipment purchases, loan payments, tax remittances and owner's drawings
Net cash flow for the month (cash in minus cash out)
Closing cash balance, which becomes the opening balance for the next month
Keep your assumptions, such as prices, sales volumes, payment terms and hiring dates, on a separate tab and link each line to them. If you need a starting point, the Business Development Bank of Canada (BDC) offers a free cash flow calculator for 13-week and 12-month forecasts.
Record cash in the month it actually moves
Enter each amount in the month the money arrives in or leaves your bank account, not when you make the sale or receive the bill.
Customer payments: If you invoice on 30-day terms, base your collections on how quickly customers really pay, not on the terms alone.
Supplier payments: Deposits on equipment or inventory may be due weeks before you sell anything.
Payroll: Wages are only part of the cost. As an employer, you also contribute an amount equal to your employees' CPP contributions and 1.4 times their EI premiums, and you remit your share together with the amounts you deduct from their pay. For regular remitters, the remittance due date set by the Canada Revenue Agency (CRA) is the 15th day of the month after you pay your employees.
Sales tax: The GST/HST you collect is not yours to spend. Monthly and quarterly filers must file and pay within one month of the end of each reporting period, while most annual filers must file and make their final payment within three months of their fiscal year-end. If you are registered for Saskatchewan PST, include those remittances too.
Seasonal and irregular costs: Show annual insurance premiums, licence renewals and yearly subscriptions in the month you pay them, and reflect busy and slow seasons, such as a landscaper in Edmonton or a retailer before the holidays.
Show the funding and how you will use it
Reviewers look closely at the financing lines, so make them easy to find.
Loans: Show the loan proceeds in the month you expect to receive them and the payments from the month they begin. Interest shows up on your income statement, but principal repayments do not, so they are easy to miss.
Your own contribution: Show when you will put your own money into the business, and how much.
Grants and contributions: Do not assume program money arrives at the start of a project. Under the federal CanExport SMEs program, for example, the program decides whether an applicant receives a grant or a contribution. At the time of writing, contribution funding is reimbursed after expenses are incurred, and recipients must be able to pay for project activities upfront. Your forecast should show how you will cover those costs until a claim is paid.
Use of funds: Each purchase in your use-of-funds table should appear in the forecast in the month you plan to make it, for the same amount.
Test your forecast before you submit it
A reviewer will test your numbers, so test them first.
Find the low point: Identify the month with the lowest closing balance. If it falls below zero or below a comfortable cash buffer, adjust the plan before you apply.
Run cautious scenarios: Ask what happens if sales come in 20% below plan, customers pay a month later or a key purchase costs more than quoted.
Check repayment capacity: Lenders often look at how comfortably your business can cover its loan payments. BDC describes the debt service coverage ratio as earnings before interest, taxes, depreciation and amortization divided by the principal and interest due over a period, typically one year. What counts as healthy varies between lenders, so ask how yours assesses it.
Cross-check the totals: Make sure your receipts, payroll and purchases line up with your sales forecast, staffing plan and supplier quotes.
Common mistakes to avoid
Treating profit as cash
Leaving out principal repayments or owner's drawings
Counting GST/HST collected as income
Expecting grant money before you have spent and claimed it
Using numbers that do not match the business plan
Including a large "miscellaneous" line with no explanation
Add a short note explaining your key assumptions and their sources, such as quotes, contracts or past sales. A forecast that shows its reasoning is easier to review than one that only shows totals.
How First Global Citizen can help
We help founders and small businesses prepare funding applications, including monthly cash flow forecasts, the assumptions behind them, use-of-funds tables and the business plans they support. We are not a lender or loan broker, and funding decisions always rest with the lender or program. When you need a CPA to review your figures or a lawyer to review an agreement, we can coordinate with independent licensed professionals.
We quote each engagement as a fixed fee in a written proposal before any work begins. Learn more about our business plan and funding readiness services, or book a free consultation to discuss your application.
This article is general information only. It is not legal, tax, accounting or financial advice. Fees and requirements can change, so confirm current details with the relevant government agency or registry. For advice about your situation, consult a qualified professional.
Comments