Skip to main content
These examples use fictitious data, names and figures. Their content and format are illustrative; available results depend on the product you choose and the data you provide.

This case illustrates a possible project for discussion. Profitability, cash flow, receivables and simulation are not automatically included in Cortex: feasibility, data, scope, deliverables and pricing must be assessed first.

Demo reportSample report

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.

24.6K23.3K22.1K20.9K19.6KW1W3W5W7W9W11W13
Expected cash inflows for each of the 13 weeks.
#History
W121.8K
W222.4K
W320.9K
W423.1K
W522.6K
W621.4K
W720.8K
W822.9K
W923.8K
W1024.1K
W1122.3K
W1220.1K
W1320.2K

Explore with the pointer or keyboard. Tap a value to keep its detail visible.

Weekly projection excerpt
WeekInflowsOutflowsClosing balance
W1 (Jun 30 – Jul 6)USD 21,800USD 26,000USD 38,100
W6 (Aug 4 – 10)USD 21,400USD 29,900USD 12,900
W7 (Aug 11 – 17)USD 20,800USD 42,900-USD 9,200
W9 (Aug 25 – 31)USD 23,800USD 19,700-USD 100
W13 (Sep 22 – 28)USD 20,200USD 15,800USD 31,500

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.

Identified liquidity gaps
WeekProjected balanceAssociated movement
W7 (Aug 11 – 17)-USD 9,200Import payment: USD 48,600
W8 (Aug 18 – 24)-USD 4,100Payroll and rent while cash is still negative
W9 (Aug 25 – 31)-USD 100Partial recovery from July collections

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.

Liquidity scenarios
ScenarioAssumptionCash minimumWeeks below zero
BaseCurrent collection and payment calendar.-USD 9,2003
FavorableImport payment split into two installments (W7 and W10).USD 2,1000
AdverseEstimated collections arrive 15 days late.-USD 18,4005

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

Priority: High

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.

Priority: High

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.

Priority: Medium

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

Proposed follow-up
IndicatorReference valueReview period
Weekly cash balance versus projectionA deviation above USD 5,000 triggers a reviewWeekly, updating the model every Friday
Average collection period43 days → proposed target 38 days (a goal, not a projection)Monthly review

Action plan

Follow-up priorities for collections, payments and expenses.

Action plan
ActionSuggested ownerFollow-up metricPriority
Installment proposal to the import supplierManagementAgreed payment calendarHigh
Reminder and collection-call routine (top 20 balances)AdministrationJuly collections received before week 8High
Approval of a USD 20,000 backstop lineManagementLine approved before week 6Medium

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.

Other sample reports

Apply the question to your data

This case illustrates a possible project for discussion. Profitability, cash flow, receivables and simulation are not automatically included in Cortex: feasibility, data, scope, deliverables and pricing must be assessed first.

Cash flow and liquidity needs · Sample report · Valerian Data