Cash flow and liquidity needs · Distribuidora Sierra
Example business: Distribuidora Sierra — a food distributor selling on 30–45-day credit while paying suppliers at 15–30 days.
The ten sections organize this illustrative example. Each product report has its own scope and format.
Analysis overview
Cut-off date, horizon and projection frequency.
- Business
- Distribuidora Sierra (fictitious data)
- Cut-off date
- July 1, 2025
- Horizon
- 13 weeks (through September 29, 2025)
- Frequency
- Weekly
Executive summary
Expected availability and critical periods.
With the USD 42,300 opening balance and the current collection and payment calendar, cash turns negative in week 7 (mid-August) with a projected minimum of USD −9,200, recovering from week 10. The gap coincides with a USD 48,600 import payment due before July’s sales collections arrive.
- The gap is one of timing, not profitability: the quarter closes with USD 31,500 in cash.
- Three weeks concentrate the risk: W7, W8 and W9.
- In the adverse scenario (collections 15 days late) the minimum reaches USD −18,400.
Data quality and assumptions
Confirmed versus estimated movements.
Collections for the first 6 weeks come from already-issued invoices with due dates (confirmed). From week 7 onward they are estimated from the sales plan and the observed collection period (43-day average). Payments include every recorded obligation: suppliers, payroll, rent, taxes and the current loan installment.
- 62% of the horizon’s inflows are confirmed; 38% are estimated.
- The import payment (W7) has a contractual date and amount.
- Extraordinary cash sales and uncontracted credit lines are not included.
Starting position
Available balance, expected collections and payment commitments.
Opening balance
USD 42,300
Expected collections (13 weeks)
USD 286,400
Committed payments (13 weeks)
USD 297,200
Projected cash minimum
-USD 9,200
Week 7 (August 18)
Cash projection
Inflows, outflows and balance per week or month.
The weekly projection shows inflows, outflows and the closing balance. Inflows are stable at around USD 22,000 per week; outflows have two spikes: the import in week 7 and the tax payment in week 11.
Projected weekly collections
Expected cash inflows for each of the 13 weeks.
| # | History |
|---|---|
| W1 | 21.8K |
| W2 | 22.4K |
| W3 | 20.9K |
| W4 | 23.1K |
| W5 | 22.6K |
| W6 | 21.4K |
| W7 | 20.8K |
| W8 | 22.9K |
| W9 | 23.8K |
| W10 | 24.1K |
| W11 | 22.3K |
| W12 | 20.1K |
| W13 | 20.2K |
Explore with the pointer or keyboard. Tap a value to keep its detail visible.
Liquidity gaps
Dates, magnitudes and associated movements.
Cash is negative for three consecutive weeks. The gap arises from the mismatch between the import payment (week 7) and July’s sales collections, which arrive between weeks 9 and 11 given the 43-day collection period.
Scenarios
Base, favorable and adverse, with visible assumptions.
The three scenarios move only the stated assumptions; everything else stays the same. None includes new financing.
AI analysis
Explanation of the cash pressures and operational alternatives to evaluate.
Key findings
The gap is calendar-driven, not a results problem
The quarter ends with healthy cash (USD 31,500 after paying the full import). The problem is that one large payment lands five weeks before the collections that fund it.
Evidence: Weekly projection (element 5) and identified gaps (element 6).
Splitting a single payment removes the gap
In the favorable scenario, splitting the import into two installments keeps cash positive across the whole horizon, without new financing.
Evidence: Scenario table (element 7).
The real collection period exceeds the agreed one
Customers pay in 43 days on average against agreed 30–45, with a third of invoices above 45. Each average day of delay holds back roughly USD 4,100 in cash.
Evidence: Observed period in the quality section (element 3) and the invoice annex.
Business interpretation
Before seeking credit, exhaust two operational alternatives: renegotiating the import calendar and pulling July collections forward with reminders or early-payment discounts. Short-term credit remains a backstop if the supplier refuses installments, and its cost should be compared against any early-payment discount offered.
Hypotheses and limitations
- Part of the collection delay concentrates in two large customers; if that pattern is stable, the adverse scenario is more likely than the base in those weeks.
- August’s sales plan may be optimistic versus last year’s seasonality; estimated collections for W9–W13 depend on it.
Prioritized recommendations
Renegotiate the import into two installments
This is the move that turns the base scenario into the favorable one. Propose a 60/40 split between weeks 7 and 10 ahead of the contractual due date.
Collection push on invoices due in July
A reminder before the due date and a call the day after it for the 20 largest balances. Pulling USD 15,000 forward by one week cuts the gap to a third.
Pre-arrange a short-term line as a backstop
Secure approval (not disbursement) of a USD 20,000 line before week 6, to be drawn only if the two measures above do not close the gap.
Proposed follow-up
Action plan
Follow-up priorities for collections, payments and expenses.
Methodology and annexes
Detailed calendar, assumptions and reconciliations.
Direct cash projection: opening balance + collections − payments per week. Confirmed collections use each invoice’s due date adjusted by the observed average delay; estimates apply the 43-day period to the sales plan. Confirmed and estimated movements are distinguished in the annex calendar.
- Annex A: full weekly calendar of inflows and outflows.
- Annex B: sales-plan and collection-period assumptions.
- Annex C: opening-balance reconciliation with bank statements.