Six-week cash
- End of week 6 GBP 3,760,000 · Floor 1,500,000 · Headroom GBP 2,260,000.
Executive Intelligence · Executive Financial Performance
Cash and Working Capital Outlook
Receivables, payables and inventory timing outlook from verified invoices and payments, as dated ranges.
Demonstration: Rosewell Capital Management (fictional) · Asset management. Fictional data and a scripted answer.
The situation
- Organisation
- Rosewell Capital Management (fictional)
- Who is asking
- Group treasurer
- Industry
- Asset management
- What happened
- A large tax payment and a lumpy fee income fall in the same six weeks, and the treasurer wants to see whether cash stays above its floor.
The question asked
Does cash stay above our floor over the next six weeks if fees arrive late?
What it reads, and who can see the result
- Cash forecast exportWeekly inflows and outflows.
- Tax schedule documentThe payment and its date.
- Reads
- The weekly cash forecast and the tax schedule.
- Does not read
- Client money or accounts.
- Permission
- Treasury read access to the firm's own cash.
- Who sees it
- The treasurer and the CFO.
Try it
Change the assumptions. Every result and the answer below are recomputed from them, and a warning appears when a result crosses a stated limit.
- Fee income received by week 6
- GBP 3,600,000Fees of 900,000 a week, from week 1; late fees slip out of the window.
- Other net flow over six weeks
- -GBP 1,440,000
- Cash at the end of week 6
- GBP 3,760,000Opening cash 4,800,000.
- Headroom over the 1,500,000 floor
- GBP 2,260,000
The answer
Simulated answer. Written for this fictional case, not produced by a live model. Only the figures in it are computed, from what you decided above.
Cash at the end of week 6 is GBP 3,760,000; headroom over the floor is GBP 2,260,000.
Fees are the swing: 2 week(s) late removes 2 week(s) of income from the window [S1]. The tax payment is fixed in date and amount [S2]. The end-point is the number shown; the low point may come earlier in the window.
If headroom turns negative the treasurer's options are known and have different costs: defer discretionary spend, draw a facility or agree a payment plan on the tax. The sooner the choice is made, the cheaper it is.
Relies on: S1 · Six-week cash forecastS2 · Tax payment schedule
No approval is needed for this result: it is read-only insight, and nothing consequential happens because of it.
What it produces
If headroom is negative
- Decide on a facility draw or a deferral plan a fortnight before the tax date.
Limits of this example
- Only the end of the window is computed; a mid-window low is not shown.
- Assumes flat weekly flows apart from fees and tax.
- This is a scripted demonstration on fictional data. No model was called and no real organisation, person or result is shown.
More in Executive Intelligence
- Enterprise Health MonitorOne view of whether the organisation's governed functions are healthy, built only from verified source readings.
- Executive Priority EngineRanks what needs executive attention across modules by stated, inspectable rules (overdue, severity, deadline, owner).
- Cross-Functional IntelligenceShows how an item in one function relates to items in others, using only links that are recorded (a finding to its obligation, a handover to its training).
- Business Performance NarrativeA plain-language summary of verified readings for a period.
- Strategic Planning AdvisorA planning workspace for objectives, assumptions, initiatives, owners and review dates, as recorded by people.
- Market Expansion IntelligenceCompares candidate markets or jurisdictions using verified, dated external data and the organisation's own compliance footprint.
- Competitive IntelligenceRecords competitor facts that a person enters with a source and a date, plus approved public-source feeds.
- Growth Opportunity DiscoverySurfaces opportunities from the organisation's own verified data (for example repeat findings, unused capability, unserved locations) as hypotheses for a person to accep…
The Executive Intelligence story · This capability in the full register