✦ Ask the analyst
Available on every tab in your workspace — answers come with sources, the period, the calculation, and a confidence level.
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.
Why cash changed
- Net hires per month: 0 → 2 — Incremental payroll — each new hire adds $2,771 per week from the month they join
- Monthly equipment / capital spend: $0 → $9,520 — Three dated payments of $9,520 at each forecast month start
Timing assumptions
- New hires join at the start of each forecast month (weeks 1, 6 and 10) — assumed timing.
- 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 | $486,000 | $274,827 | $405,532 | $355,295 | $340,232 | −$15,063 |
| W2 2026-06-01 | $355,295 | $274,827 | $405,532 | $224,590 | $203,984 | −$20,605 |
| W3 2026-06-08 | $224,590 | $274,827 | $405,532 | $93,885 | $67,736 | −$26,148 |
| W4 2026-06-15 | $93,885 | $274,827 | $258,199 | $110,513 | $78,822 | −$31,691 |
| W5 2026-06-22 | $110,513 | $274,827 | $258,199 | $127,141 | $89,907 | −$37,234 |
| W6 2026-06-29 | $127,141 | $274,827 | $258,199 | $143,769 | $85,930 | −$57,839 |
| W7 2026-07-06 | $143,769 | $274,827 | $258,199 | $160,397 | $91,473 | −$68,924 |
| W8 2026-07-13 | $160,397 | $274,827 | $258,199 | $177,025 | $97,016 | −$80,010 |
| W9 2026-07-20 | $177,025 | $274,827 | $258,199 | $193,654 | $102,558 | −$91,095 |
| W10 2026-07-27 | $193,654 | $274,827 | $258,199 | $210,282 | $93,038 | −$117,244 |
| W11 2026-08-03 | $210,282 | $274,827 | $258,199 | $226,910 | $93,038 | −$133,872 |
| W12 2026-08-10 | $226,910 | $274,827 | $258,199 | $243,538 | $93,038 | −$150,500 |
| W13 2026-08-17 | $243,538 | $274,827 | $258,199 | $260,166 | $93,038 | −$167,128 |
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.
This is a worked example on sample numbers — sign up to test your own decisions against your approved forecast.
Cash composition (13-week totals)
Forecast basis · where the Base numbers come from
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