Build a Cash Flow Forecast for Your Loan Application

When you apply for a business loan, a cash flow forecast converts your best guess about the future into a document a lender can actually evaluate. Most SBA lenders, community banks, and many online lenders ask for a 12-month projection before they will approve anything above $50,000. Getting the format right matters as much as the numbers themselves, because a well-structured forecast signals to the underwriter that you understand your own business.

This guide walks through how to build a cash flow forecast from scratch, what lenders are really looking for inside the spreadsheet, and how to stress-test your numbers so reviewers trust what they see. A fully worked numerical example is included at each step so you can follow along with your own figures.

Why a 12-Month Cash Flow Forecast Is the Standard

A 12-month window is long enough to capture seasonality and short enough that assumptions stay grounded. SBA Standard Operating Procedures require projections for at least one year on loans above $350,000, and most conventional lenders have adopted the same benchmark because it matches a typical repayment cycle review period. If your loan term is three years, some lenders will ask for a 36-month projection, but the first 12 months receive the most scrutiny.

The forecast covers three columns for each month: cash inflows (revenue collected, not just invoiced), cash outflows (all operating costs plus the proposed loan payment), and the resulting ending cash balance. That ending balance is what the lender watches. If it goes negative in any month, you need to explain why and what you would do about it. Leaving negative months unexplained is one of the most common reasons underwriters request a revision.

Consider a restaurant with $60,000 in average monthly revenue but a slow January and February where revenue drops to $40,000. A forecast that shows flat $60,000 every month immediately triggers skepticism. A forecast that dips in those two months, shows the owner drawing on a $15,000 cash reserve to cover payroll, and then recovers in March tells a coherent story the lender can follow.

What Lenders Actually Evaluate Inside the Numbers

Three qualities determine whether a forecast passes underwriting review: realism of base-case assumptions, inclusion of at least one downside scenario, and internal consistency with your historical statements.

Realism means your revenue growth rate is defensible. If your last 12 months averaged 8% year-over-year growth and your forecast projects 40%, you need a specific reason on a separate assumptions tab: a signed contract, a new product launch date, or a documented market expansion. Without that documentation, the underwriter will discount the high growth and rerun your debt service coverage ratio (DSCR) at a lower figure. Many lenders require a DSCR of at least 1.25, meaning net operating income must be 25% above total annual debt payments. If optimistic revenue is what makes your DSCR clear 1.25, expect pushback.

The downside scenario is a second worksheet where you reduce revenue by 15 to 20 percent and hold expenses flat. If the business still covers its debt payments in that scenario, the lender knows there is a margin of safety. A landscaping company earning $85,000 per month might model a drought year at $68,000 per month. If the loan payment is $4,200 per month and fixed costs are $55,000 per month, the company still shows positive cash flow of $8,800 per month in the downside case. That number is what an experienced underwriter will cite in the approval memo.

Internal consistency means your forecast matches what your bank statements already show. If your statements reveal $72,000 in average monthly deposits and your forecast starts at $95,000, the gap needs an explanation. Lenders reconcile the two documents as a matter of routine. Discrepancies that are not explained are treated as errors rather than legitimate business changes.

How to Build the Spreadsheet Step by Step

Start with a blank spreadsheet and label columns A through N: one for line-item labels and one for each of the 12 months. Row 1 should be the month header. Rows 2 through 10 are revenue lines. Rows 12 through 25 are expense lines. Row 27 is net cash flow (total revenue minus total expenses). Row 28 is beginning cash balance. Row 29 is ending cash balance (beginning balance plus net cash flow). That structure mirrors what most SBA lenders and bank loan officers expect to see.

For revenue lines, break income into sources rather than lumping everything into one cell. A plumbing company might separate residential service calls, commercial maintenance contracts, and equipment sales. A retail store might separate in-store sales, e-commerce, and wholesale. Separating sources makes it easier to defend each growth assumption independently and makes the forecast more credible.

For expense lines, include every cash outflow: cost of goods sold, payroll, rent, utilities, insurance, marketing, loan payments (both existing and the proposed new loan), owner draws, and a miscellaneous buffer of 3 to 5 percent of total revenue. Forgetting to include an existing loan payment is a common mistake that inflates the apparent DSCR. Underwriters will add it back once they see your current liabilities schedule, so leaving it out only creates a discrepancy that slows the process.

Here is a worked example for Month 1. A home services business has $48,000 in projected revenue across three lines: $30,000 from recurring maintenance contracts, $12,000 from one-time repairs, and $6,000 from product sales. Expenses total $41,200: $18,000 payroll, $4,500 vehicle costs, $2,800 materials, $3,200 rent and utilities, $1,800 insurance and admin, $5,400 existing loan payment, and $2,800 for the proposed new monthly payment, plus a $1,700 miscellaneous buffer. Net cash flow is $48,000 minus $41,200, which equals $6,800. Beginning cash balance is $22,000. Ending cash balance is $28,800. That ending balance carried forward becomes Month 2's beginning balance. Repeat for all 12 months, adjusting revenue for seasonal patterns and any planned cost changes.

Once your base case is complete, copy the entire sheet into a second tab labeled "Downside" and reduce each revenue line by 15 percent. Leave expenses unchanged. Check whether the ending cash balance stays positive in every month. If it goes negative in one month, note the month and the amount, then add a line item in expenses labeled "Owner capital infusion" to cover the shortfall and explain the source of those funds on your assumptions tab. Lenders are comfortable with owners injecting capital to cover a short-term dip as long as the source is documented (personal savings, a home equity line, an existing business account).

How TurboFunding Helps

TurboFunding works with small business owners who are building toward a lender-ready loan application, and that often starts with understanding what your cash flow numbers actually say. Our funding specialists have reviewed hundreds of applications and can help you identify where a forecast is likely to draw questions before you submit it to a bank or SBA lender. If your business earns at least $10,000 per month, has been operating for 6 or more months, and carries a FICO score of 550 or above, you may qualify for $10,000 to $5,000,000 inbusiness financing through our network. The application takes about 3 minutes and uses a soft credit pull, so checking your options does not affect your score. Whether you need working capital to cover a slow quarter or growth capital to back the revenue projections in your forecast, we match businesses with lenders who fit their profile. Find out More

Frequently Asked Questions

Q. How far back should my historical financials go to support a 12-month forecast?

A. Most lenders want two years of historical tax returns or financial statements. The forecast is compared against that history to verify that your assumptions are grounded in actual performance. If your business is under two years old, provide all available months of bank statements and explain any gaps.

Q. Do I need an accountant to prepare a cash flow forecast, or can I do it myself?

A. You can build the spreadsheet yourself using the structure described above. An accountant adds value by reconciling your forecast to your tax returns and flagging any line items that may raise questions. For loans above $500,000, having a CPA review the document is generally worth the cost. For smaller amounts, a well-organized owner-prepared forecast with a clear assumptions tab is usually acceptable.

Q. What is a realistic revenue growth rate to use in a forecast?

A. Use your actual trailing 12-month growth rate as a baseline, then apply any documented upside separately. If you grew 10% last year and have no signed new contracts, use 10% or slightly below to be conservative. Projecting 30% without documentation is the single most common reason forecasts are sent back for revision.

Q. What DSCR do most lenders require?

A. The SBA standard is 1.25, meaning your net operating income must be at least 25% above total annual debt service including the proposed loan. Community banks generally apply the same threshold. Some alternative lenders will go down to 1.15, but anything below 1.0 means the business cannot cover its debt payments from operations, which is a near-automatic decline at traditional institutions.

Q. Should I include the proposed loan payment in my cash flow forecast?

A. Yes, always. Include both the principal and interest payment as a separate expense line starting in Month 1. The lender will calculate DSCR using the new payment, so your forecast needs to show the business covering it. Omitting it and relying on the lender to add it back yourself creates a credibility problem even if the math still works.

A cash flow forecast is not a prediction. It is a structured argument that your business can repay a loan under realistic conditions. The work you put into building it, labeling assumptions, separating revenue streams, and modeling a downside case, signals to the lender that you are a careful operator who understands the risks. Most small business owners who lose a loan approval over financial projections do so not because the business is actually unqualified but because the documentation did not make the case clearly enough. Build the spreadsheet carefully, reconcile it to your statements, and your forecast becomes one of the strongest parts of your application package. Find out More