← Finance AI LabBradCo. Software Group · Treasury
BradCo. Software Group · Sponsor Weekly Liquidity Pack

13-Week Cash Flow Model

Rolling weekly forecast for BradCo's operating account, term loan service, and $15M revolver. Anchored to the May 31, 2026 month-end close — opening cash ties to the Portfolio Dashboard balance. Tune drivers and scenarios to pressure-test the $4M minimum-liquidity covenant.

Anchor · May 31, 2026 CloseOpening Cash$14.20MForecast WindowJun 1Aug 24, 2026View Portfolio Dashboard →
Scenario
Board-approved plan · Inflows 1.00x · Outflows 1.00x
Base ScenarioBoard-approved plan55% likelihood · base operating case

FY26 board case holds: ARR grows ~14%, DSO stays at 47 days, vendor terms unchanged. Treasury runs to plan with no revolver draw.

Key Drivers
  • ·Net new ARR $1.2M/qtr, renewal gross retention 92%
  • ·Collections track booked invoices at 47 DSO
  • ·Headcount flat at 280 FTE through Q3
  • ·AP terms net-30, no early-pay discounts taken
Trigger Conditions
  • ·DSO drifts >50 days for 2 consecutive weeks
  • ·Any single AR >$500K aged past 60
  • ·Weekly collections miss plan by >10%
Treasury Actions
  • ·Hold revolver undrawn
  • ·Monthly sponsor update only — no escalation

Cash Drivers ($K)

Weekly · every week
Biweekly · W1, W3, W5…
Headcount Ramp → Payroll
+30 FTE over 13 wksPayroll W1 $2,154K → W13 $2,385K
Monthly · W1, W5, W9
Covenants & Revolver
One-off Events
Ending Cash (W13)
$1.73M
Opening $14.20M
Lowest Week
$1.73M
Below covenant
Revolver Available
$10.00M
$5.00M drawn of $15.00M
Covenant Breach
Week 9
Draw revolver or defer AP

Ending Cash Position

$000s · 13 weeks
Min $4.0M
W1
Jun 1
W2
Jun 8
W3
Jun 15
W4
Jun 22
W5
Jun 29
W6
Jul 6
W7
Jul 13
W8
Jul 20
W9
Jul 27
W10
Aug 3
W11
Aug 10
W12
Aug 17
W13
Aug 24
WeekInflowsOutflowsNetEnding Cash
W1Jun 1
280 FTEPay wk
$1,060K($3,609K)$2,549K$11.65M
W2Jun 8
283 FTE
$1,074K($310K)+$764K$12.42M
W3Jun 15
285 FTEPay wk
$1,087K($2,682K)$1,596K$10.82M
W4Jun 22
288 FTE
$1,097K($310K)+$787K$11.61M
W5Jun 29
290 FTEPay wk
$1,104K($3,686K)$2,582K$9.02M
W6Jul 6
293 FTE
$1,350K · Q2 Estimated Tax
$1,107K($1,660K)$553K$8.47M
W7Jul 13
295 FTEPay wk
$1,107K($2,759K)$1,652K$6.82M
W8Jul 20
298 FTE
$2,000K · Strategic Bolt-on (deposit)
$1,104K($2,310K)$1,206K$5.61M
W9Jul 27
300 FTEPay wk
$1,097K($3,763K)$2,666K$2.95M
W10Aug 3
303 FTE
+$850K · ERC Refund Receipt
$1,937K($310K)+$1,627K$4.57M
W11Aug 10
305 FTEPay wk
$1,074K($2,836K)$1,762K$2.81M
W12Aug 17
308 FTE
$1,060K($310K)+$750K$3.56M
W13Aug 24
310 FTEPay wk
$1,045K($2,875K)$1,830K$1.73M
Export & Full Schedule

Take the Base case to the sponsor.

Download the weekly schedule as a CSV (opens directly in Excel or Google Sheets), or open the full line-item-by-week view as a standalone overflow page formatted for printing and PDF export.

Open Full Schedule →