13-Week Cash Flow Forecaster — product cover

Category: Spreadsheets · Financial Spreadsheets

About this product

Know exactly which week cash gets tight — 13 weeks before it happens.

BUILT FOR

  • Fractional CFOs running client cash reviews
  • Small-business owners who want to see the pinch coming, not feel it

HOW IT WORKS

  • Enter your opening balance, minimum-cash line, and any loan covenants in SETUP.
  • List open invoices with the week you realistically expect to collect.
  • Enter expected weekly outflows; the model rolls cash forward, week by week.
  • Read the DASHBOARD: lowest cash, its week, and the first covenant breach.

NO MACROS. Works in Excel, Google Sheets, and LibreOffice.

DISCLAIMERS

  • Sample data is fictional; replace with your own numbers before relying on the output.
  • A planning tool, not financial, tax, or legal advice. Confirm covenant terms with your lender.

$39 · Instant download

What's included

  • A 5-sheet rolling 13-week cash-flow workbook (SETUP, FORECAST, RECEIPTS, DASHBOARD, README)
  • Invoice-level receipts schedule that feeds weekly collections automatically
  • Credit-line model with draws, repayments, and weekly interest
  • Base vs Downside scenario toggle (collection haircut + delay applied by formula)
  • Flags that fire on screen: negative weeks, below your minimum, covenant breaches
  • Quick-Start Guide PDF: the 20-minute Monday roll-forward workflow

Key features

  • Invoice-level receipts schedule → weekly collections feed automatically from the week you realistically expect to collect
  • Credit-line model → draws, repayments, and weekly interest (APR/52) tracked across all 13 weeks
  • Base vs Downside scenario toggle → Downside applies a 20% collection haircut plus a 1-week delay shift, provably changing all 13 AR lines
  • Flags that fire on screen → NEGATIVE, BELOW MINIMUM, and COVENANT BREACH, with 39 flag cells plus 13 breach markers verified
  • Dashboard answers → lowest cash, its week, weeks below minimum, and first breach week at a glance
  • QA-verified → 614/614 checks passed against an independent Python model + LibreOffice recalc, 0 error cells, verified in both scenario positions
  • Proven flag behaviour → Base: BELOW fires on weeks 9/11/12/13 and BREACH fires week 13 (cash $8,157.46 < $15,000 covenant); Downside: BREACH fires from week 7 onward and cash goes negative, demonstrating the draw-planning need

Frequently asked questions

Is this financial, tax, or legal advice?

No — this is a planning tool, not financial, tax, or legal advice. Confirm covenant terms with your lender.

Are the sample numbers real?

No — sample data is fictional; replace it with your own numbers before relying on the output.

What does the Downside scenario change?

It applies a 20% collection haircut plus a 1-week delay shift, changing all 13 weekly AR lines.

What do the flags mean?

NEGATIVE = a week goes below zero; BELOW MINIMUM = cash falls below your minimum-cash line; COVENANT BREACH = cash falls below a covenant threshold you set.

Does it work offline?

Yes — the spreadsheet works in Excel, Google Sheets, and LibreOffice Calc, with 100% native formulas, zero macros, and no add-ins.

13-Week Cash Flow Forecaster — product image

13-Week Cash Flow Forecaster

One 5-sheet rolling cash-flow workbook for fractional CFOs and small-business owners: invoice-level receipts, a credit-line model, Base vs Downside scenarios, and flags that fire on screen for negative weeks, below-minimum weeks, and covenant breaches.

$39

Buy Now on Gumroad

Related products

More Spreadsheets
Landlord Finance OS — product image
Spreadsheets

Landlord Finance OS

Stop drowning in one-spreadsheet-per-property chaos. Track rent, expenses, and cashflow for up to 10 properties — and turn your year into a CPA-ready tax packet mapped to IRS Schedule E lines. Works in Excel & Google Sheets.

BRRRR Deal Analyzer — product image
Spreadsheets

BRRRR Deal Analyzer

Know your numbers before you buy. This BRRRR spreadsheet computes cash left in the deal, refinance proceeds, cashflow, cash-on-cash return and cap rate — and compares 3 deals side by side. 4 sheets, live formulas, 3 sample deals. For Excel, Google Sheets & LibreOffice.