Cash Flow Forecast Kit — 3‑Month Simple Template

What this kit does

This simple, 3‑month cash flow forecast helps you see upcoming cash gaps early, compare best/base/worst scenarios, estimate your cash runway, and choose prioritized actions to avoid emergency decisions. It’s designed for solo entrepreneurs and very small businesses who need a fast, practical view of near‑term liquidity.

Why a 3‑month horizon?

Three months is short enough to act and long enough to include recurring cycles (payroll, rent, receivables). Use this kit weekly or biweekly during risky seasons and monthly for normal planning.

Sheets included in the template

• Starting cash — your current cash & cash equivalents.
• Income forecast by customer or revenue stream — expected cash receipts for each of the next three months (not invoices issued).
• Fixed expenses schedule — rent, subscriptions, loan payments (monthly amounts).
• Variable expense schedule — materials, commissions, ad spend (estimate per month or percent of revenue).
• One‑time payments — any planned single cash outflows in the 90‑day window.
• Runway & scenarios — best/base/worst toggles that adjust income and/or expenses and summarize runway and the highest‑risk month.
• Immediate action checklist — prioritized actions to close a 30‑day shortfall.

Step‑by‑step: how to use the template

1. Enter Starting cash (today's balance).
2. For each of the next three months enter expected cash receipts by customer or revenue stream (use conservative timing—when cash arrives, not when invoiced).
3. List fixed monthly expenses and expected variable expenses for each month.
4. Include any planned one‑time payments on the month they will clear the bank.
5. Calculate Net Cash Change each month = Cash Received − Cash Paid. Then compute Ending Cash for each month = Starting Cash + cumulative Net Changes.
6. Run scenarios: create a base case, then best (e.g., +15% receipts, −5% expenses) and worst (e.g., −20% receipts, +10% expenses) to see how sensitive your runway is.

Key formula

Approximate runway (months) = Current Cash / Average Monthly Net Burn. If net burn is negative (you’re cash positive each month) runway is effectively unlimited in the short run. For precise month‑by‑month planning, look at the first month with Ending Cash < 0.

What to enter in the income sheet

• Customer name or revenue stream
• Expected cash this month, next month, month three
• Flag whether payment is guaranteed (e.g., subscription) or uncertain (proposal, pipeline)

Practical scenario toggles

Use a few simple toggles rather than dozens of assumptions:

• Revenue shift (percent): apply to all uncertain receipts (e.g., −20% worst case).
• Expense tweak (percent): increase or decrease variable costs and discretionary spend.
• Receivable acceleration: convert X% of receivables to cash this month (by offering a discount or chasing payments).

Worked example (short)

Starting cash: $8,000
Month 1 receipts: $5,000; expenses: $9,000 → net change −$4,000 → ending cash $4,000
Month 2 receipts: $6,000; expenses: $7,500 → net change −$1,500 → ending cash $2,500
Month 3 receipts: $7,000; expenses: $7,000 → net change $0 → ending cash $2,500
Average monthly net burn ≈ ($4,000 + $1,500 + $0) / 3 ≈ $1,833 → runway ≈ $8,000 / $1,833 ≈ 4.4 months. But note month‑by‑month shows a critical low in Month 2 with only $2,500 on hand—take action before Month 2.

Immediate action checklist for a 30‑day shortfall (prioritized)

1. Preserve cash immediately
   • Hold non‑essential discretionary spending (ads, new subscriptions).
   • Delay vendor payments where possible and negotiate short extensions.
2. Accelerate incoming cash
   • Invoice now and follow up; offer a small discount for early payment.
   • Ask repeat customers if they can move a purchase forward.
3. Reduce immediate obligations
   • Pause or downscope upcoming projects (renegotiate deliverables or timing).
   • Defer or split one‑time payments where vendors agree.
4. Bridge financing (last resort)
   • Short seller credit lines, credit card, small business line — use only with clear repayment plan.
5. Communicate
   • Tell critical vendors and partners you’re managing timing; transparency helps secure short extensions.

Simple communication templates

Invoice follow‑up (short): “Hi [Name], quick note to check on invoice #[#] due [date]. We can offer a 2% discount if paid in [X days]. Let me know if you need anything to process it.”

Vendor extension request (short): “Hi [Vendor], we have a short timing issue this month—could we move our payment due date from [date] to [new date]? We value the relationship and will make this a one‑time request.”

Triggers & thresholds to watch

• Ending cash < 1× monthly fixed expenses → review immediate cuts and acceleration options.
• Runway < 1 month → escalate to emergency checklist and consider bridge financing only with plan.
• Receivables aging > 30 days rising → tighten collections process and consider partial prepayments on new work.

How to use this kit on a small cadence

• During normal months: update monthly and review scenarios before making discretionary commitments.
• During risk months or growth investments: update weekly for the next 90 days.
• Keep an actionable top 3 list: (1) cash preserving actions, (2) cash accelerating actions, (3) financing options.

Next steps and how we could make this interactive

This HTML kit gives a clear template and actions. To increase usefulness, consider an interactive form that lets you enter current cash, receipts, and expenses and then saves submissions and compares scenarios over time. Interactive features could include:

• Saved forecasts for history and trend analysis
• Scenario toggles with computed summary results and highlighted high‑risk months
• Automated alerts when runway or ending cash hits trigger thresholds
• Prebuilt action checklists that you can mark complete and save

See CapabilityEnhancementNotes for suggested platform enhancements to implement those features.

Quick checklist before you finish

• Did you enter cash receipts when the cash hits the bank (not invoice date)?
• Did you include one‑time payments and large vendor dates?
• Did you run a worst‑case scenario and check the first month where cash could turn negative?
• Do you have a prioritized action list ready if a shortfall appears?