Which Orders Fit Your Cash Calendar? Compare Before Borrowing
Compare fictional whole-order combinations, reuse earlier receipts and measure an optional advance against the best no-borrowing alternative.
Estimated reading time: 8 minutes
A cash calendar tests each dated event before ranking orders.
Which combination of orders fits the cash available on each payment date? In this fictional exercise, the best no-borrowing combination ends with $15,200. A stipulated $2,000 advance allows a different combination and raises ending cash to $17,200 after repayment and charges.
The useful comparison isn’t borrowing versus doing nothing. It’s borrowing versus the best combination that already fits without borrowing. A later customer receipt changes that comparison substantially.
Set the cash constraint and the order dates
All amounts below are invented U.S. dollars. Treat these as a small calculation exercise, not customer contracts, a demand forecast or a financing offer.
- Opening cash is $10,000. The chosen floor is $2,000, tested after every cash event. This arbitrary floor isn’t a recommendation or evidence of adequate reserves.
- There’s exactly one order each of A, B and C. Each can be accepted or declined, but not divided or repeated. Every combination is assumed deliverable; staffing and production capacity aren’t additional constraints here.
- Each listed cost is the order’s only cash outflow. Each receipt becomes usable on its exact stated day. There are no intervening transactions.
- Other business obligations, taxes, cancellations, collection losses, returns, residual asset values and restrictions on cash are excluded. The result is selected cash surplus, not total business profit or an affordability determination.
| Order | Cost date | Cash cost | Usable receipt date | Cash receipt |
|---|---|---|---|---|
| A | Day 0 | $6,000 | Day 10 | $9,000 |
| B | Day 0 | $4,000 | Day 30 | $6,300 |
| C | Day 12 | $4,000 | Day 30 | $6,200 |
Before financing charges, the selected cash surpluses are $3,000 for A, $2,300 for B and $2,200 for C. Those positive differences don’t, by themselves, establish which combinations meet the cash floor.
Cash calendar: check every combination without borrowing
For each selection, start with $10,000 and enter only that selection’s dated payments and receipts. At each event, calculate:
Cash after the event = cash before it + usable receipts − cash payments.
There are eight possible subsets, including accepting none. Retain the lowest cash balance as well as the day-30 ending balance.
| Orders accepted | Lowest cash | Day-30 ending cash | Meets the $2,000 floor? |
|---|---|---|---|
| None | $10,000 | $10,000 | Yes |
| A | $4,000 | $13,000 | Yes |
| B | $6,000 | $12,300 | Yes |
| C | $6,000 | $12,200 | Yes |
| A + B | $0 | $15,300 | No |
| A + C | $4,000 | $15,200 | Yes — highest ending cash among passing selections |
| B + C | $2,000 | $14,500 | Yes |
| A + B + C | $0 | $17,500 | No |
A+C is the best no-borrowing selection under these inputs. Its $10,000 of total costs exceeds the $8,000 initially available above the floor, yet it still fits. A costs $6,000 on day 0, leaving $4,000. Its $9,000 receipt raises cash to $13,000 on day 10, before C’s $4,000 cost on day 12.
That’s reuse of an earlier receipt, not additional opening cash. Treating all costs as simultaneous would reject a combination that this dated record can fund. Conversely, A+B ends $100 above A+C but fails the floor immediately: its two day-0 costs consume the full $10,000.
Cash calendar: compare funding with the best feasible alternative
Now add one entirely hypothetical funding option: either borrow nothing or receive exactly $2,000 on day 0 before paying any order costs. The advance has one total financing charge of $300. Repay the $2,000 principal plus that $300 on day 30 after all that day’s customer receipts become usable. There are no earlier repayments or other financing costs.
These are stipulated cash events, not an available product, an APR quote or a claim about lender rules. The exercise doesn’t compare other loan amounts or repayment schedules.
| Checkpoint | A+C, no advance | A+B+C, $2,000 advance |
|---|---|---|
| Day 0, after any advance and order costs | $4,000 | $2,000 |
| Day 10, after A’s receipt | $13,000 | $11,000 |
| Day 12, after C’s cost | $9,000 | $7,000 |
| Day 30, after customer receipts | $15,200 | $19,500 |
| Day 30, after financing repayment if applicable | $15,200 | $17,200 |
The funded selection stays at or above $2,000. Its final repayment is $2,300, reducing $19,500 to $17,200. All three orders now fit, and their combined surplus is greater than any smaller selection’s under the unchanged inputs.
Compare $17,200 with A+C’s $15,200: the modeled improvement is $2,000. Another way to reproduce it’s the additional B order’s $2,300 cash surplus minus the $300 financing charge. The $2,000 principal is received and repaid; it isn’t additional revenue or an extra cost to subtract again.
The $7,200 increase over opening cash isn’t the benefit of borrowing. A+C already produces $5,200 without an advance. Using “do nothing” as the only comparison would conceal that alternative.
The charge tie is $2,300 total, not $2,300 extra
With every original date and order amount unchanged, funded A+B+C produces $2,300 more selected cash surplus before financing charges than A+C. A total financing charge of $2,300 would therefore make their ending cash equal at $15,200.
The stipulated $300 charge is already part of that total. It leaves $2,000 of difference, not permission to add another $2,300. This arithmetic tie isn’t a recommended borrowing price: it assigns no value to risk, excluded costs or flexibility.
Delay A’s receipt and select the orders again
Change only A’s receipt from day 10 to day 20. Keep every other cost, receipt, funding choice and repayment event unchanged. Don’t carry the original winning selection into this new calendar without checking it.
Without borrowing, A+C now reaches $0 on day 12: the $4,000 left after A is spent on C before A pays. B+C still reaches exactly $2,000 and ends with $14,500. Checking all eight subsets makes B+C the best passing no-advance selection.
| Selection and funding | Lowest cash | Ending cash after any repayment | Meets the $2,000 floor? |
|---|---|---|---|
| B+C; no advance | $2,000 | $14,500 | Yes — best without borrowing |
| A+C; no advance | $0 | $15,200 | No |
| A+B; $2,000 advance | $2,000 | $15,000 | Yes — best with the stated funding option |
| A+C; $2,000 advance | $2,000 | $14,900 | Yes |
| A+B+C; $2,000 advance | −$2,000 | $17,200 | No |
All three with the advance still project $17,200 at the end, but their day-12 cash is negative $2,000—$4,000 below the chosen floor. That’s an unfunded projection, not permission to overdraw or evidence that another advance will be available.
A+B with the advance avoids C’s day-12 outflow. It holds $2,000 until A pays on day 20, reaches $17,300 after B pays on day 30, then repays $2,300 to finish at $15,000. A+B without the advance still fails on day 0; the single-order selections finish no higher than $13,000 before any financing charge.
The best funded result now exceeds the best no-borrowing result by only $15,000 − $14,500 = $500. It isn’t the original $2,000 improvement. No order’s receipt amount has changed; the feasible combinations have.
Cash calendar: compare headroom with ending cash
Headroom above the chosen floor is another way to read the same paths. Subtract the $2,000 floor from each path’s lowest cash. Under the original dates, A+C without borrowing has $2,000 headroom: its $4,000 minimum minus the floor.
Original-date A+B+C with the advance has zero headroom because its minimum is exactly $2,000. The delayed-date winning funded A+B path also has zero. Each passes the stated constraint, but passing at equality leaves no room for an extra unmodeled outflow at that minimum.
The cash calendar therefore shows different measures: ending cash ranks the passing selections, while minimum cash and headroom describe their tightest checkpoint. Don’t subtract headroom from ending cash as another expense; it’s a comparison of balances already in the path.
This cash calendar assigns no probability to an unexpected event and recommends no particular floor. A changed receipt or cost still requires the complete path and order selection to be recalculated.
Keep the selection and the funding decision separate
- Write each whole order’s cash events and dates. Keep unconfirmed real-world receipts visibly uncertain; the exercise’s stipulated dates aren’t real-world assurances.
- List the combinations and calculate each cash path. Reject any path below the chosen constraint before ranking ending balances.
- Identify the best passing no-borrowing alternative, including accepting none.
- Add the exact proposed funding and repayment events, then recalculate. Compare against that best no-borrowing alternative—not automatically against doing nothing.
- Change an uncertain receipt date and repeat the selection. A higher final balance can’t repair an earlier unfunded payment date.
This worksheet solves only its stated cash-selection problem. Actual execution capacity, customer reliability, financing access and the rest of the business budget remain outside the calculation.
For the broader calendar, use working-capital cash-gap sizing. If the negotiation concerns when one customer pays rather than which orders to select, compare deposits and milestone payment schedules.
Original fictional cash-selection exercise. No actual customer order, lender offer or business result is represented.
Illustrative stock photo: Tawhid Sadman / WordPress Photo Directory (CC0).


