Ataski
Sign up free
Sample workspace — example data, not your own. Sign up free to run it on your own.
Financial Analyst Today Performance Forecast Business model Decisions Reports
⋯
Today Performance Forecast Business model Decisions Reports Data & settings
Data & settings
✦ Ask the analyst

Available on every tab in your workspace — answers come with sources, the period, the calculation, and a confidence level.

What happens to cash if collections slip two weeks? How did this forecast change since the last close, and why?

Answers run on your connected books after signup. The sample keeps every number deterministic — it never improvises a reply.

13-week cash

Your current weekly cash forecast — pick a named scenario to see when and why cash changes.

 Download Excel Download CSV
Example Cash base · current 13-week forecast · from 2026-05-25 13 weeks · weekly · direct method Scenario changes pinned to Forecast · April close · v1 Base only Win the Harbor District bid Equipment replacement year
Opening cash
$918,000
Week 13 · Base
$924,332
Week 13 · Scenario
$872,012
−$52,320
Minimum cash · Scenario
$442,658
No breach in 13 weeks
Weekly ending cash — Base vs Scenario
$442,658 $683,495 $924,332 W1 W4 W7 W10 W13 W1 · 2026-05-25 — Base $844,590 · Scenario $827,150 · Δ −$17,440 W1 · 2026-05-25 — Base $844,590 · Scenario $827,150 · Δ −$17,440 W2 · 2026-06-01 — Base $771,179 · Scenario $753,739 · Δ −$17,440 W2 · 2026-06-01 — Base $771,179 · Scenario $753,739 · Δ −$17,440 W3 · 2026-06-08 — Base $697,769 · Scenario $680,329 · Δ −$17,440 W3 · 2026-06-08 — Base $697,769 · Scenario $680,329 · Δ −$17,440 W4 · 2026-06-15 — Base $624,359 · Scenario $606,919 · Δ −$17,440 W4 · 2026-06-15 — Base $624,359 · Scenario $606,919 · Δ −$17,440 W5 · 2026-06-22 — Base $550,948 · Scenario $533,508 · Δ −$17,440 W5 · 2026-06-22 — Base $550,948 · Scenario $533,508 · Δ −$17,440 W6 · 2026-06-29 — Base $477,538 · Scenario $442,658 · Δ −$34,880 W6 · 2026-06-29 — Base $477,538 · Scenario $442,658 · Δ −$34,880 W7 · 2026-07-06 — Base $510,794 · Scenario $475,914 · Δ −$34,880 W7 · 2026-07-06 — Base $510,794 · Scenario $475,914 · Δ −$34,880 W8 · 2026-07-13 — Base $544,051 · Scenario $509,171 · Δ −$34,880 W8 · 2026-07-13 — Base $544,051 · Scenario $509,171 · Δ −$34,880 W9 · 2026-07-20 — Base $577,307 · Scenario $542,427 · Δ −$34,880 W9 · 2026-07-20 — Base $577,307 · Scenario $542,427 · Δ −$34,880 W10 · 2026-07-27 — Base $610,563 · Scenario $558,243 · Δ −$52,320 W10 · 2026-07-27 — Base $610,563 · Scenario $558,243 · Δ −$52,320 W11 · 2026-08-03 — Base $857,820 · Scenario $805,500 · Δ −$52,320 W11 · 2026-08-03 — Base $857,820 · Scenario $805,500 · Δ −$52,320 W12 · 2026-08-10 — Base $891,076 · Scenario $838,756 · Δ −$52,320 W12 · 2026-08-10 — Base $891,076 · Scenario $838,756 · Δ −$52,320 W13 · 2026-08-17 — Base $924,332 · Scenario $872,012 · Δ −$52,320 W13 · 2026-08-17 — Base $924,332 · Scenario $872,012 · Δ −$52,320
Base (current forecast) Scenario

Why cash changed

  • Monthly equipment / capital spend: $0 → $17,440 — Three dated payments of $17,440 at each forecast month start

Timing assumptions

  • Capex is modeled as one payment at each forecast month start (weeks 1, 6 and 10) — assumed timing, no dated invoices.

Monthly ending cash in Scenarios and Week-13 cash here use different horizons and methods (12-month monthly model vs 13-week direct method) — the deltas are not meant to match.

Weekly cash bridge

Scroll sideways for the scenario columns →

Week Opening Receipts Payments Ending · Base Ending · Scenario Δ
W1 2026-05-25 $918,000 $503,464 $576,875 $844,590 $827,150 −$17,440
W2 2026-06-01 $844,590 $503,464 $576,875 $771,179 $753,739 −$17,440
W3 2026-06-08 $771,179 $503,464 $576,875 $697,769 $680,329 −$17,440
W4 2026-06-15 $697,769 $503,464 $576,875 $624,359 $606,919 −$17,440
W5 2026-06-22 $624,359 $503,464 $576,875 $550,948 $533,508 −$17,440
W6 2026-06-29 $550,948 $503,464 $576,875 $477,538 $442,658 −$34,880
W7 2026-07-06 $477,538 $503,464 $470,208 $510,794 $475,914 −$34,880
W8 2026-07-13 $510,794 $503,464 $470,208 $544,051 $509,171 −$34,880
W9 2026-07-20 $544,051 $503,464 $470,208 $577,307 $542,427 −$34,880
W10 2026-07-27 $577,307 $503,464 $470,208 $610,563 $558,243 −$52,320
W11 2026-08-03 $610,563 $717,464 $470,208 $857,820 $805,500 −$52,320
W12 2026-08-10 $857,820 $503,464 $470,208 $891,076 $838,756 −$52,320
W13 2026-08-17 $891,076 $503,464 $470,208 $924,332 $872,012 −$52,320

Opening + receipts − payments = ending, every week. Opening, receipts and payments shown are the Base forecast; the scenario column re-times and re-sizes them per the drivers above.

Model your own scenario See the prepared response

This is a worked example on sample numbers — sign up to test your own decisions against your approved forecast.

Cash composition (13-week totals)

New invoicing collected 6,545,035
Payroll & overhead 745,774
Supplier payments 6,006,928

Forecast basis · where the Base numbers come from

Opening cash $918,000 · configured bank balance · week 1 starts 2026-05-25 Example
AR collections no opening AR pool
New invoicing $2,180,000/month Estimated
Collection lag 8 weeks Example
Supplier payments $1,787,600/month Estimated
Payment lag 6 weeks Example
Scheduled one-offs 0 payments · 1 receipts in the window Example

Simplifications: no seasonality signal — new invoicing modelled at a flat run-rate; downside collection haircut is the conservative default (0.70×), not derived from observed variance

Direct method: receipts = AR aging buckets × the collection curve + recurring / new-invoicing run-rate at the observed collection lag + dated one-off receipts. Payments = weekly cost run-rate + DPO-timed supplier spend + dated one-offs. A selected scenario re-times and re-sizes these streams per its drivers — it is never a statistical band.