A 12-month cash-flow projection helps you see when money is expected to enter and leave your business before the transactions happen. It is not a promise about the future. It is a planning model that turns your best current assumptions into a month-by-month view of liquidity.
That distinction matters because profit and cash are not the same thing. A business can record a profitable sale but wait weeks to collect the invoice, while payroll, rent, inventory, and taxes still require cash. The FDIC’s Money Smart for Small Business program describes cash-flow projections as a way to test whether expected receipts will be sufficient to cover expected disbursements. Used well, your projection can reveal a shortage early enough to change course.
This guide walks through a practical 12-month cash-flow projection for a small business. It builds on our broader guide to creating financial projections for your business.
What a 12-month cash-flow projection shows
Your projection begins with the cash available at the start of each month. You then add expected cash inflows, subtract expected cash outflows, and calculate the ending cash balance. That ending balance becomes the next month’s beginning balance.
The basic monthly formula is:
Beginning cash + cash inflows − cash outflows = ending cash
A useful spreadsheet normally includes 12 monthly columns and rows for each meaningful source or use of cash. The purpose is not to create an impressively complicated workbook. It is to answer practical questions:
- When could cash fall below the minimum amount needed to operate?
- Which months require larger inventory, payroll, tax, or equipment payments?
- How much revenue must actually be collected—not merely invoiced—to cover obligations?
- When might the business need to delay spending, accelerate collections, build reserves, or arrange financing?
Step 1: Choose your starting cash balance
Enter the cash the business expects to have available on the first day of Month 1. Include operating checking and savings accounts that are genuinely available for business expenses. Avoid counting unused credit limits as cash. A line of credit may be a potential financing source, but borrowing from it creates both an inflow and a future repayment obligation.
If you are building the projection for an existing company, reconcile your bookkeeping records to current bank balances. If the business has not opened yet, start with the owner investment, committed financing, and other funds expected to be deposited before operations begin.
Step 2: Forecast cash inflows by month
List the money you reasonably expect to collect each month. Common inflows include:
- Cash and card sales collected immediately
- Customer invoices expected to be paid during the month
- Recurring subscription or service revenue
- Owner contributions
- Loan proceeds
- Grants or other documented funding
- Proceeds from selling equipment or other assets
Base your forecast on evidence wherever possible. Existing businesses can begin with prior monthly sales, customer payment patterns, signed contracts, current pipeline, seasonality, and known price changes. New businesses can use realistic customer counts, average transaction values, capacity, conversion assumptions, and market research.
Most importantly, forecast the month cash will be received. If you expect to make a $10,000 sale in March but the customer normally pays 45 days after invoicing, the cash may belong in April or May—not March.
Document every important assumption
Add an assumptions tab or notes column. Record why revenue rises or falls, how quickly customers pay, and which contracts or seasonal patterns support the estimate. Clear assumptions make the projection easier to update and easier to explain to a lender or business partner.
Step 3: Forecast cash outflows
Next, list when the business expects to pay its obligations. Separate recurring operating costs from irregular or one-time expenditures so large payments do not disappear inside a single catch-all category.
Typical cash outflows include:
- Inventory and materials
- Payroll, payroll taxes, and contractor payments
- Rent, utilities, insurance, and software
- Marketing and professional services
- Loan principal and interest
- Equipment and technology purchases
- Owner draws or distributions
- Federal, state, and local tax payments
Use actual payment dates and vendor terms. An annual insurance premium, quarterly software bill, seasonal inventory purchase, or planned equipment replacement can materially change one month even when the annual expense looks manageable.
Taxes deserve their own rows. The IRS explains that federal income tax is generally paid as income is earned or received through withholding or estimated payments, and payment requirements depend on business structure and circumstances. Use current IRS guidance and a qualified tax professional to determine the timing and amount appropriate for your business rather than relying on a generic percentage.
Step 4: Calculate monthly net cash flow and ending cash
For each month, total the inflows and total the outflows. Subtract outflows from inflows to find net cash flow. Then add net cash flow to beginning cash to determine the projected ending balance.
Consider a simplified example:
- Beginning cash: $18,000
- Cash collected: $32,000
- Cash paid out: $37,000
- Net cash flow: −$5,000
- Ending cash: $13,000
A negative net cash-flow month is not automatically a crisis. A seasonal company may deliberately buy inventory before its strongest sales period. The important question is whether the ending cash balance remains sufficient to meet obligations and whether the planned recovery is supported by reasonable assumptions.
Step 5: Set a minimum cash threshold
Choose a minimum operating-cash amount that deserves management attention. This is not a universal rule or a substitute for a full emergency-reserve analysis. It is an internal warning line based on your payroll cycle, fixed obligations, revenue reliability, and access to capital.
Highlight any month that falls below the threshold. Those months are your decision points. Depending on the cause, options may include improving invoice collection, adjusting purchase timing, reducing discretionary spending, negotiating vendor terms, changing owner distributions, or arranging financing before cash becomes urgent.
Step 6: Build three scenarios
A single forecast can create false confidence. Build at least three versions:
- Expected case: your most reasonable current assumptions
- Downside case: slower collections, lower sales, or higher costs
- Upside case: stronger demand with the additional cash needs required to fulfill it
The downside case should be plausible rather than catastrophic. For example, test what happens if customers pay 15 days later, sales are 10% below plan, or a major expense arrives one month early. An upside case also matters because rapid growth can consume cash through inventory, hiring, and receivables before the related revenue is collected.
Step 7: Compare actual results with the projection
A projection becomes useful through regular review. At the end of each month, replace projected figures with actual cash activity, compare the variance, and revise the remaining months.
Ask why the results differed:
- Were sales lower, or were collections simply delayed?
- Did a cost increase permanently or only shift between months?
- Was the original assumption unsupported?
- Did the business add a new customer, employee, product, or financing obligation?
Update the rolling forecast monthly so the business continues to look 12 months ahead. The SBA’s financial-projection guidance emphasizes recording assumptions, comparing actual results with projections, investigating variances, and revising the model as conditions change.
Common cash-flow projection mistakes
Confusing revenue with cash received
Record customer payments when you expect the cash to arrive. Sales recorded under accrual accounting may not be available to pay this month’s bills.
Forgetting irregular expenses
Annual renewals, quarterly taxes, equipment repairs, professional fees, and seasonal purchases often create the largest gaps.
Using one growth percentage for everything
Revenue, labor, inventory, and overhead rarely move in perfect lockstep. Forecast the drivers separately.
Ignoring loan principal
Principal repayment reduces cash even though it is not treated like an ordinary operating expense on the profit-and-loss statement.
Leaving assumptions undocumented
A number without a reason is difficult to defend or improve. Keep a short note for every material estimate.
A simple monthly review routine
- Reconcile cash accounts.
- Enter the month’s actual inflows and outflows.
- Compare actual results with the forecast.
- Investigate the largest variances.
- Update assumptions for the remaining months.
- Add a new month at the end to preserve a rolling 12-month view.
- Decide what action is needed before the next low-cash period.
If you also want to organize household or owner-level cash priorities, the Monthly Budget Planner can help separate personal needs, wants, and financial goals. Keep personal and business records distinct, even when your business supports your household.
Frequently asked questions
How often should I update a 12-month cash-flow projection?
Monthly is a practical minimum for many small businesses. A company with tight cash, rapid growth, seasonal activity, or volatile collections may benefit from weekly short-term monitoring alongside the monthly 12-month model.
Is a cash-flow projection the same as a profit-and-loss forecast?
No. A profit-and-loss forecast estimates revenue and expenses under accounting rules. A cash-flow projection focuses on when cash is actually received and paid. Both are useful, but one cannot reliably replace the other.
Should loan proceeds appear in the projection?
Yes. Record loan proceeds as a financing cash inflow when expected, and record principal and interest payments according to the repayment schedule. Do not treat borrowed money as operating revenue.
What if my projection shows a cash shortage?
Treat the warning as time to investigate—not as a guarantee of failure. Confirm the assumptions, identify what drives the gap, and evaluate operational changes or financing early. Seek advice from an accountant, lender, or qualified business adviser when the decisions are material.
Turn the projection into a decision tool
The value of a 12-month cash-flow projection is not the precision of its first draft. Its value is the visibility it creates. By showing when cash may tighten, which assumptions matter most, and how actual results differ from the plan, the projection gives you time to make better decisions.
Start with the information you have, label every estimate, and improve the model each month. A simple projection that is reviewed and updated is far more useful than a complex spreadsheet that is built once and ignored.
Sources
- FDIC: Money Smart for Small Business
- FDIC: Managing Cash Flow Participant Guide
- U.S. Small Business Administration: Creating Realistic Financial Projections
- IRS: Estimated Taxes
This article is for general educational purposes and does not provide accounting, tax, legal, investment, or lending advice. Business circumstances vary; consult qualified professionals for guidance specific to your situation.
Leave a Reply