Template

Cash Flow Forecast Kit — 3–6 Month Interactive Template

An interactive, fillable 3–6 month cash forecast you can save and update for weekly huddles. Enter starting cash, scenario inflows and outflows (conservative / likely / optimistic) for each month, capture actions if shortfalls appear, and record huddle notes and next steps.

Interactive Tool

Cash Flow Forecast — 3–6 Month Template

Purpose: Avoid surprises by forecasting short-term cash, comparing conservative/likely/optimistic scenarios, and planning responses you can review in weekly huddles.

This interactive template helps you capture starting cash, enter forecasted inflows and outflows for up to six months, and record shortfall actions and huddle follow-ups. Prefer the conservative scenario when planning for risk.

How to use: 1) Enter starting cash. 2) Choose how many months you want to forecast. 3) Fill inflows and outflows for each month and scenario. 4) Review the conservative cumulative net to see potential shortfalls and record actions. 5) Save and bring to weekly huddles to track changes and decisions.

Starting cash balance

Cash on hand at the start date (enter as a positive number).

Months to forecast

Choose how many months you will fill below (3–6). Leave later months blank if you choose fewer.

Forecast start / context

Enter the start month or any context (e.g., 'Starts May 1 — seasonal sales ramp expected').

Month 1 label

Name this column (e.g., May 2026 or Month 1).

Month 1 inflows — Conservative

Expected cash in under a conservative scenario.

Month 1 inflows — Likely

Best estimate of cash in for the month.

Month 1 inflows — Optimistic

Upside inflows (if everything goes well).

Month 1 outflows — Conservative

Expected cash out under a conservative scenario (include payroll, rent, suppliers, loan payments).

Month 1 outflows — Likely

Best estimate of cash out for the month.

Month 1 outflows — Optimistic

Downside or reduced outflows scenario.

Month 2 label

e.g., Jun 2026

Month 2 inflows — Conservative

Month 2 inflows — Likely

Month 2 inflows — Optimistic

Month 2 outflows — Conservative

Month 2 outflows — Likely

Month 2 outflows — Optimistic

Month 3 label

e.g., Jul 2026

Month 3 inflows — Conservative

Month 3 inflows — Likely

Month 3 inflows — Optimistic

Month 3 outflows — Conservative

Month 3 outflows — Likely

Month 3 outflows — Optimistic

Month 4 label

Month 4 inflows — Conservative

Month 4 inflows — Likely

Month 4 inflows — Optimistic

Month 4 outflows — Conservative

Month 4 outflows — Likely

Month 4 outflows — Optimistic

Month 5 label

Month 5 inflows — Conservative

Month 5 inflows — Likely

Month 5 inflows — Optimistic

Month 5 outflows — Conservative

Month 5 outflows — Likely

Month 5 outflows — Optimistic

Month 6 label

Month 6 inflows — Conservative

Month 6 inflows — Likely

Month 6 inflows — Optimistic

Month 6 outflows — Conservative

Month 6 outflows — Likely

Month 6 outflows — Optimistic

Runway guidance (formula)

Runway (months) ≈ (Starting cash + cumulative net inflows) / average monthly outflows. For planning, use the conservative scenario cumulative net. Example: if conservative cumulative net after 3 months is -$6,000 and starting cash is $10,000, remaining cash is $4,000. If typical monthly outflows are $2,000, runway ≈ 2 months.

If a shortfall is likely, consider these actions

Select actions you will consider or assign.

Reduce nonessential expenses

Delay nonessential purchases

Negotiate payment terms with vendors

Accelerate receivables / collections

Seek short-term financing or credit

Run targeted promotions to bring in sales

Use personal or owner funds temporarily

Pause hiring / contractor spend

Planned response if conservative scenario shows a shortfall

Write the specific steps, owners, and trigger points (e.g., 'If cash < $3,000, pause ad spend and notify accountant').

How often will you review this in a huddle?

Weekly huddle notes / decisions

Capture decisions, who will act, and what to watch next week.

Confidence in these estimates

How confident are you in the numbers you entered? (1 = low, 5 = high)

1.0 10.0

You can explore this tool now. Sign in or create an account to save your responses and return to them later.

Make this tool part of your work

Save a personal copy, bring it to your team, or tailor the questions and workflow to fit what you are hungry to improve.

Member customization and team collaboration are coming soon.

Discuss Ask the Librarian

Discussion

Comments and conversation will live here.

Cash Flow Forecast Kit — 3–6 Month Interactive Template

Cash Flow Forecast — 3–6 Month Template

Discussion

Services

Explore

Contact