How to Build a Cash Flow Projection That Survives a Delayed Distribution

A cash flow projection is a dated estimate of money that can actually enter and leave an account. For a family office, its hardest question is rarely the year-end balance. It is whether the right legal entity will have spendable cash when a tax payment, private-fund call or family obligation comes due.

This guide builds a short-horizon projection from verified cash and dated events, then tests what happens if a hoped-for fund distribution does not arrive. The four-week example is fictional. Its method can be extended to a rolling 13-week cash calendar and a separate multi-year private-fund pacing plan.

01What the projection must answer

At a minimum, the office needs four answers: how much cash is available, where it sits, when it moves, and who can authorize a remedy. A consolidated total can hide a shortfall in the entity that actually owes the payment. A readily saleable security may still require trading, settlement, transfer and signatory approvals before it pays a bill.

Use two horizons for different jobs. A rolling weekly calendar, often 13 weeks, controls near-term payments and receipts. A monthly or quarterly multi-year pacing view tests whether existing and proposed private-fund commitments fit the family's longer liquidity policy. NEPC's family-office private-markets guidance calls for looking across capital calls, distributions and known liquidity demands, rather than treating commitment pacing as a return target alone. The long-range model informs policy; it cannot replace a dated near-term cash test.

This projection is about cash, not net asset value, accounting profit or a guarantee of distributions. An uncalled commitment is a possible future cash demand, not an immediate withdrawal. Once the manager issues a valid call notice, the noticed amount and due date belong in the near-term register; keep the remaining unfunded balance separately so the same obligation is not counted twice.

02Build the dated cash register

Make one row for each expected cash event. The minimum fields are entity, account, currency, amount, expected settlement date, source document, status, owner and last verified date. Keep gross inflows and outflows separate until the relevant entity-level calculation; a family cannot assume one entity's money is available to another without a lawful, approved and timely transfer.

• Opening cash: Reconcile the bank balance, then remove restrictions and pending debits. Record the as-of time. Show the policy floor separately so it is not subtracted twice.
• Contracted or noticed outflow: Link the tax instruction, signed agreement, payroll calendar, approved family payment or valid fund-call notice. Use the payment date and responsible payer.
• Confirmed receipt: Keep the documentary source, amount and expected availability date; reconcile it with the receiving account when it settles.
• Modeled flow: Label an expected distribution, sale or unissued future call with its assumption, range and confidence. Stress its timing separately.
• Liquidity source: Include a sale, credit draw or inter-entity transfer only after authority, conditions, haircut, settlement and receiving account are tested.

For a private fund, reconcile total commitment, cumulative paid-in capital, distributions received and remaining unfunded commitment with manager records. A distribution does not automatically reduce the contractual unfunded amount; the fund documents and notices determine any recallable or recycled amount. ILPA's educational cash-flow-model material discusses different modelling approaches because contribution and distribution timing are uncertain. Masttro's forecasting overview also distinguishes calls, distributions and net asset value. Neither source can supply the dates for this family's actual fund.

03A four-week forecast with a delayed distribution

Assume Entity A has US$3.0 million of cleared, unrestricted cash. Its approved minimum operating buffer is US$1.0 million. In week 1 it owes US$0.4 million of tax and US$0.2 million of operations. In week 2 it must pay a noticed US$1.2 million fund call. A US$1.5 million distribution is projected for week 3 but has not been confirmed by the manager. Operating payments of US$0.3 million fall in week 3, and a further US$0.5 million family/operating payment falls in week 4. All amounts are illustrative; no tax amount or fund-flow schedule is implied for a real family.

The baseline appears to finish US$0.9 million above the floor. Without the unconfirmed distribution, Entity A falls US$0.1 million below the floor in week 3 and US$0.6 million below it in week 4. The floor is a test against ending cash, not an additional payment. The four-week calculation is opening cash plus receipts minus payments; it does not treat the fund's entire remaining commitment as a second cash outflow.

The office must identify at least US$0.6 million of additional usable cash for Entity A by week 4, and enough by week 3 to prevent the earlier breach. The decision deadline is earlier than either week if a security must be sold or funds transferred. Record the sale or transfer's settlement date, restrictions, authority and backup. Merely listing a brokerage account with US$0.6 million of securities does not prove the cash will arrive in the paying account on time.

Provisional remedy record for this example

• First breach: Week 3, US$0.1m below floor. Insert the exact first payment time from the source register. By week 4 the required addition rises to US$0.6m.
• Funding source and owner: Treasury must name a source that can put usable cash in Entity A. The source, amount and backup remain unverified.
• Last safe decision date: Unknown until approval, trade, settlement, transfer and cutoff times are documented. Work backward from the first breach time along the longest required sequence, allowing for the office's operating buffer.
• Release test: Cash must arrive before the week-3 breach and leave Entity A at or above its floor through week 4. The remedy and any new commitment remain on hold until the approver sees that evidence.

If approval takes one business day and sale settlement plus transfer takes two more, the decision must begin at least three business days before the first cash need, plus any chosen buffer; the example does not claim those are Entity A's real lead times. If steps can run in parallel, use the actual critical path instead of adding every duration. A calendar-week label alone cannot establish the deadline.

04Stress the forecast before approving new commitments

Run at least a baseline and one downside with the same starting records. For this case, the downside removes the unconfirmed week-3 distribution; another relevant stress could advance an unissued capital call or delay an asset sale. Do not add several scenarios together without explaining whether their risks can occur simultaneously.

The decision rule should be written before the result is known. An example for this family is: do not approve another illiquid commitment while the stressed forecast breaches the US$1.0 million Entity A floor unless a documented, authorized funding source covers the breach before its first due date. That is an illustrative policy choice, not a universal minimum. A different family can set a different floor using its actual spending, debt and risk tolerance.

Test the remedy through the same five questions as the forecast:

1. Source: Which bank balance, security sale, committed credit line or approved transfer will provide the cash? Is it available after existing reservations?
2. Time: When can it settle into Entity A's paying account, including weekends, notice periods and transfer cutoffs?
3. Authority: Who approves the sale, borrowing or inter-entity movement, and who signs the payment?
4. Cost and conditions: What fees, financing terms, collateral requirements, tax consequences or market haircuts need review?
5. Fallback: If the first source fails, who escalates and what alternative is permitted before the payment deadline?

A liquid asset sale, a bank line and a distribution are not interchangeable. The sale has market and settlement risk; the line introduces borrowing terms; the distribution remains outside the family's control until paid. Counsel, tax and treasury specialists should assess the chosen transaction before execution where needed.

05Keep the projection current

Give one person ownership of the cash-event register and another named person authority to approve material assumption changes. Each week, roll the forecast forward: replace the opening balance with reconciled actual cash, mark settled flows as actual, add newly noticed calls, remove expired expectations and explain material variance by event. Preserve the earlier version so an approver can see whether a gap was foreseen and how it was resolved.

Check dates before changing amounts. A projected US$1.5 million receipt that moves from week 3 to week 5 is still US$1.5 million in a long-range view, yet it creates a near-term funding problem. Chronograph's LP forecasting discussion describes how manager activity and exit timing vary; the office's own notice and bank records must control actual cash status.

If the manager later moves the expected receipt to week 5, retain it as a modeled week-5 event. It does not erase the week-3 and week-4 breaches or justify repaying a credit line before the receipt settles and the line's terms permit repayment.

Review the long-range pacing plan when the family makes a new commitment, a manager changes expected calls or distributions, spending policy changes, or the near-term forecast repeatedly needs emergency funding. Compare each new commitment to the whole portfolio's stressed demand, not only its initial draw. Keep assumptions, manager notices and approvals linked to the version that produced the decision.

06A practical template and decision record

A usable workbook or system export can have four connected views. The source register holds dated events and their documents. The entity cash calendar calculates weekly opening cash, inflows, outflows, ending cash and floor headroom. The scenario view changes only documented assumptions, such as the distribution date. The decision log records the first breach, proposed remedy, approver and completion evidence.

For each entity and week, calculate ending cash = opening cash + settled or forecast receipts − settled or forecast payments. Next week's opening cash equals the prior week's ending cash. Calculate headroom = ending cash − the approved floor and flag the first negative result. Keep actual and forecast status in separate fields; when an event settles, replace its forecast row with the actual rather than adding a second row.

Copy these column labels into the dated register: entity | account | currency | event | inflow/outflow | amount | settlement date | actual/confirmed/modelled | source document | owner | last checked. A weekly summary should show opening cash, inflows, outflows, ending cash, floor and headroom for each scenario. It should never silently net Entity A's shortfall against Entity B's balance.

Before circulation, the preparer should be able to answer:

• Does week 1 open to a reconciled account balance, and have restricted or already earmarked amounts been removed?
• Can every near-term fund call be traced to a notice, with the unfunded commitment tracked separately?
• Are the baseline and downside comparable except for the named stress?
• Does any scenario breach an entity-level floor, and is the proposed funding source available before the first breach?
• Who reviewed the assumptions, approved the response and will reconcile next week's actuals?

For fictional Entity A, the provisional decision is a hold: the stressed forecast fails, and the new illiquid commitment is deferred. Treasury owns source, approval and arrival proof; the family approver revisits the commitment only after evidence shows both the week-3 and week-4 floors pass. Adding at least US$0.6 million before week 3 would raise the displayed week-4 stressed balance from US$0.4 million to the US$1.0 million floor, provided no other events change. A later record can mark the remedy approved, implemented and bank-verified with separate dates and evidence. The projection itself neither transfers cash nor grants authority.

07Frequently asked questions

1How far ahead should a cash flow projection run?

Use a weekly near-term window long enough to expose upcoming payment and settlement dates; 13 weeks is a practical operating convention, not a legal rule. Pair it with a monthly or quarterly multi-year pacing view for private commitments. Review both when a material event changes.

2Should expected private-fund distributions count as available cash?

They can appear in a labeled baseline forecast. Until the manager confirms payment and the receipt settles, they should not be treated as cleared money for a mandatory outflow. Stress a delay and compare the resulting cash balance with the paying entity's floor.

3What is the difference between a cash flow projection and a budget?

A budget authorizes or plans spending over a period. A cash flow projection places actual and expected receipts and payments on dates and accounts. A budget can appear affordable for the year while the cash projection reveals a week when payment cannot be made safely.