META TITLE: How to Create a Cash Flow Projection | 13-Week Guide

Vital Sign Overview: Cash Pulse

Helcyon's Business Vital Signs™ framework monitors five critical health indicators: Cash Pulse (liquidity timing), Revenue Blood Pressure (sales consistency), Customer Heartbeat (retention patterns), Margin Temperature (profitability health), and Growth Oxygen (expansion capacity). Like medical vitals, these signs reveal problems before symptoms appear.

Cash Pulse is the vital sign this article diagnoses. It measures the timing rhythm of money through your business - not how much you have, but when it arrives versus when it leaves. A cash flow projection is the diagnostic instrument for reading Cash Pulse.

The Complexity Threshold: Where Manual Projection Breaks

A 13-week cash flow projection works manually - until it doesn't.

*Manual projection succeeds when:* Revenue under $500K annually. Fewer than 15 customers with predictable payment patterns. Fewer than 10 vendors with stable terms. Seasonal variation under 20%. One person holds the full cash picture in their head.

*Manual projection fails when:* Revenue exceeds $1M annually. Customer count exceeds 25 with varying payment behaviors. Vendor count exceeds 15 with different terms. Seasonal swings exceed 30%. Complexity exceeds what weekly spreadsheet review can track.

At scale, the projection becomes a maintenance burden that gets neglected precisely when it matters most. The spreadsheet shows last Friday's assumptions. Reality changed Monday through Thursday. The gap between projection and truth is where businesses die.

This article teaches you to build the projection. Helcyon watches what happens between updates and alerts you when the projection diverges from reality - the surveillance that manual discipline cannot sustain.

Before Helcyon: The Timing Trap

The owner builds a projection in January. By March, it shows $42,000 ending cash in Week 10. Confidence is high.

What the static projection missed: Customer A's payment pattern shifted from 18 days to 32 days - adding $14,000 to receivables float. A vendor moved from Net-30 to Net-15 without notice - accelerating $8,000 in outflows. Two subscription charges increased by a combined $340/month - $4,080 annually never updated in the model.

By Week 10, actual cash is $19,000. The $23,000 gap between projection and reality represents three months of assumption drift that weekly updates couldn't catch.

After Helcyon: Continuous Cash Pulse Monitoring

Cash Pulse monitoring validates projection assumptions in real-time. Customer A's payment shift triggers an alert in week 2 - the projection adjusts automatically. The vendor term change surfaces on the first invoice - impact calculated immediately. Subscription creep flags the moment charges increase.

Same projection discipline. Same 30-minute weekly updates. Different reliability because monitoring catches what manual review misses.

What a Cash Flow Projection Shows

A cash flow projection is not a budget. A budget tells you what you plan to spend. A projection tells you whether you can afford to spend it when the bill comes due.

The difference matters. A business with $200,000 in annual revenue and 12% net margins can show $24,000 profit on paper while running negative cash for 7 months of the year. Profit is an accounting concept. Cash is what pays rent.

Your Cash Pulse - the rhythm of money moving through your business - determines survival more than your income statement. A business can be profitable and still fail. It happens when the timing of inflows and outflows doesn't align.

A restaurant owner in Phoenix closed after 14 months. Revenue hit $47,000 monthly. Profit margins held at 8%. The problem was timing. She paid suppliers on the 1st. Customers paid on the 15th. Payroll cleared the 5th. For two weeks every month, the account sat empty. One slow week pushed her into overdraft. The fees compounded. She never recovered.

For 10-12 days per month, the account dipped below zero. Her bank charged $35 per overdraft. Three or four overdrafts per month added $1,260-$1,680 annually in fees. Combined with the credit damage and the stress of never knowing if checks would clear, the timing problem became fatal.

Cash flow projections exist to prevent exactly this. They show when money arrives, when it leaves, and whether the gap between those dates will kill you.

Step 1: The 13-Week Cash Flow Framework

Thirteen weeks is the standard window. Long enough to see patterns. Short enough to project with accuracy. Beyond 13 weeks, assumptions compound and projections become speculation.

ACTION: ** Start with your current bank balance. Write down the exact number as of today. For this example, assume $34,500.

ACTION: ** List every expected cash inflow for the next 13 weeks. Be specific. "Customer payments" is useless. "$8,400 from Johnson account, due March 15" is useful. Include:

• Accounts receivable by customer and expected payment date

• Recurring revenue with actual billing dates

• Any loans or investments expected

ACTION: ** List every expected cash outflow by exact date:

• Rent (typically 1st of month): $4,200

• Payroll (biweekly or semimonthly): $12,800 each cycle

• Supplier payments by vendor and due date

• Insurance, subscriptions, utilities with actual billing dates

• Estimated tax payments (quarterly): $3,400

• Loan payments with exact amounts and dates

Ending Cash = Starting Cash + Inflows - Outflows

Week 1 example: Starting cash $34,500. Inflows $11,200 (two customer payments). Outflows $18,600 (rent plus partial payroll). Ending cash $27,100.

Week 1's ending cash becomes Week 2's starting cash. Repeat for 13 weeks. The pattern that emerges shows when cash gets tight and how tight it gets.

A landscaping company did this exercise and found they had 8 weeks with ending balances above $40,000 and 5 weeks with ending balances below $10,000. The pattern corresponded to seasonal revenue cycles they'd never mapped to cash timing before.

Step 3: The Red Zone Threshold

ACTION: ** Identify your minimum operating balance. This is not zero. This is the amount below which operations become unstable.

Calculate it: Take your largest single weekly outflow and multiply by 1.5. If payroll is $12,800 biweekly, your red zone threshold is approximately $19,200. Any projection showing cash below this number requires immediate action.

Most businesses that close had at least 60 days warning in their cash projections. They either didn't have projections or didn't look at them. A study of small business failures found that 82% showed declining cash positions for at least 8 weeks before closure. The warning signs were there. Nobody was watching.

ACTION: ** Build three versions of your projection:

*Base case:* Expected performance based on historical patterns.

*Stress case:* Reduces inflows by 20%, delays payments by 10 days, adds one unexpected $5,000 expense.

*Best case:* Accelerated collections, no surprises, discretionary spending deferred.

If stress case shows negative cash, you need contingency planning. If your business survives a 20% revenue drop with 10-day payment delays, you're reasonably protected. If it doesn't, you know exactly what reserve you need to build.

Step 5: The Update Cadence

ACTION: ** Update projections weekly. Every Friday, extend the window by one week and adjust prior weeks based on actual results.

Compare projected vs. actual for each completed week. If projections consistently miss by more than 15%, investigate why. A $500,000 revenue business that projects accurately within 10% variance has 3x the survival rate during downturns compared to businesses that don't project at all.

Common Projection Mistakes

*Mistake 1: Assuming customers pay on time.* Historical data shows payment patterns. If 40% of your invoices are paid 7-14 days late, build that into projections. A $50,000 receivable due April 1st might arrive April 12th.

*Mistake 2: Forgetting irregular expenses.* Quarterly taxes, annual insurance renewals, equipment maintenance. A business that cleared $8,000 monthly profit forgot a $23,000 annual insurance payment. March projections showed positive cash. April showed crisis.

*Mistake 3: Using averages instead of actuals.* "Revenue averages $42,000 monthly" hides the reality that January is $31,000 and June is $58,000. Project actual expected revenue by month.