A 13-week cash-flow forecast estimates the money entering and leaving your business each week. Before borrowing, use it to identify your lowest cash balance and test whether a proposed payment remains manageable if customers pay late. It is a planning tool, not a guarantee of loan approval or future results.
Thirteen weeks gives you roughly a quarter of weekly detail. This guide uses that horizon as a practical planning choice—not a universal lender requirement. The SBA's financial-management guidance emphasizes bookkeeping, tracking available cash, and cash-flow projections; the worksheet approach below applies those principles to a borrowing decision.
Build the forecast around actual cash dates
Create a spreadsheet with one column for each of the next 13 weeks. Start with cash your business can actually use. Separate restricted funds and money reserved for obligations so you do not mistake every dollar in an account for discretionary spending.
Then add rows for cash receipts: customer collections, cash sales, deposits, and other expected inflows. Use the week money is reasonably expected to arrive, not merely the invoice date. Mark uncertain receipts separately instead of treating every open invoice as certain cash.
For outflows, include payroll, rent, supplier payments, taxes, insurance, subscriptions, owner distributions, existing debt payments, and planned equipment or inventory purchases. Include irregular obligations in the week they fall due. A monthly average can hide the week that payroll and a large supplier bill arrive together.
The IRS's employment-tax deposit guidance illustrates why tax timing deserves its own line: deposit rules and schedules depend on the employer's situation. Use your actual obligations and professional advice, not a generic date copied from a blog.
Use a simple weekly cash equation
For each week, calculate:
Ending cash = beginning cash + cash received − cash paid out.
The next week's beginning cash equals the previous week's ending cash. Keep financing proceeds separate from customer receipts so you can see whether operations generate cash or depend on additional borrowing.
Useful worksheet rows include:
- Beginning available cash.
- Customer receipts and other operating inflows.
- Payroll and related obligations.
- Supplier and inventory payments.
- Rent and other operating expenses.
- Taxes and irregular payments.
- Existing debt payments.
- Proposed financing proceeds, fees, and payments, shown separately.
- Ending cash and a chosen operating cash buffer.
An available credit limit is not a cash receipt. Record a draw only when you reasonably expect it to be available, and account for any applicable fees and repayment terms. Avoid double-counting a financed purchase as both a cash expense and an additional payment without explaining the transaction.
Test a proposed payment with an illustrative example
Suppose a hypothetical business starts a week with $12,000, collects $18,000, and pays $24,000 in existing obligations. It ends with $6,000 before a proposed new debt payment. If that payment is $2,000, ending cash becomes $4,000.
Now suppose $8,000 of the expected collections arrives the following week instead. Current-week receipts fall to $10,000. Ending cash after the same obligations and proposed payment becomes negative $4,000:
$12,000 + $10,000 − $24,000 − $2,000 = −$4,000.
These are invented planning assumptions, not a customer story, an available offer, or a quoted payment. The example shows why a profitable sale does not necessarily provide cash in time for an obligation. Moving that collection to the following week does not erase the immediate shortage.
Repeat this exercise using the actual payment frequency in any offer. Daily, weekly, and monthly payments affect cash timing differently. Include net funding after applicable fees, rather than assuming an advertised amount equals the usable deposit.
Separate a timing gap from a recurring shortfall
A forecast may show a temporary gap followed by identifiable collections. That is different from a business whose normal receipts repeatedly fail to cover normal expenses.
Borrowing can change the timing of available cash, but it also adds repayment obligations. If the forecast stays negative after realistic collections, examine pricing, margins, inventory purchases, customer payment terms, and operating costs with an accountant before treating more debt as the answer.
Build a base case and a slower-collection case. You can also test a delayed project or a larger supplier payment. These are your planning scenarios, not predicted probabilities. Define a minimum cash buffer based on your own essential obligations; there is no single buffer that fits every business.
Keep the forecast useful each week
Replace estimates with actual receipts and payments, explain material differences, and add a new week at the end. Assign someone responsibility for maintaining it. A forecast that is never updated quickly stops describing the business.
Bring it to a funding discussion alongside bank statements, financial reports, and a clear use of funds. Ask how the lender evaluates repayment capacity and what additional projections it needs. A weekly worksheet complements, rather than replaces, formal underwriting.
Common questions
Is a 13-week forecast the same as a profit-and-loss statement?
No. A profit-and-loss statement measures income and expenses under your accounting method. This forecast focuses on when money actually enters or leaves the business.
Does every lender require this exact format?
No. Documentation requirements vary. Ask whether the lender wants weekly detail, monthly projections, or a different format.
Can the forecast prove a loan is affordable?
No. It helps test assumptions, but collections, expenses, and financing terms can change. Review significant borrowing decisions with a qualified financial professional.
Fine Point Lending is a financing marketplace, not a direct lender. If your forecast identifies a funding need, you can explore options while comparing costs, payment timing, eligibility, and provider requirements. Approval and outcomes are not guaranteed.
Sources
SBA: Managing business finances, for bookkeeping and financial-planning fundamentals.
IRS: Employment-tax deposit requirements, for the importance of applying the correct tax-payment schedule. The 13-week worksheet and numerical example are original educational illustrations, not requirements attributed to either agency.
