Project cash schedule and funding headroom

Can entered capital cover the month-end cash gap?

A support receipt may improve the final balance without reducing the earlier funding need. Compare the same delivery schedule with entered support timing, later support and no additional uncollected support.

Define the cash boundary

Supply a start month, horizon of 1 to 120 calendar months, one supported currency, cost owner and separately available capital. Enter disjoint delivery and gross eligible cloud outflows for every month. Blank is unknown; explicit zero means a known zero.

Separate cash receipts from promises

Give each customer or support receipt a distinct ID, amount, actual/confirmed/hypothetical status, entered month, earliest/latest collection window and optional sanitized evidence reference. Actual means collected cash. Receipts after the horizon remain visible but do not improve within-horizon totals. Optional credits have a separate confirmation, balance and inclusive validity window; credits are never cash.

Method and limitations

Delivery outflows and eligible cloud outflows are disjoint, additive gross cash costs. Do not enter eligible cloud costs twice or enter already credited costs.

Confirmed credits offset only entered eligible cloud costs within their inclusive validity months, up to remaining balance. Credits never pay delivery costs or create cash.

Customer receipts are already net of any commercial discount. Separate permitted support is another receipt, not another discount.

Actual collected support stays in every case. The no-additional-support case removes only uncollected support. Customer timing stays unchanged in all three cases.

Entered timing includes uncollected support in its entered month. Delayed timing moves only uncollected support to its latest entered month. Neither case predicts collection.

Receipts after the horizon are disclosed but excluded from within-horizon cash and headroom. Cash collected before the horizon belongs in available capital, not another receipt.

Monthly net cash = customer cash + support cash - cash outflow. Cumulative cash starts at zero. Peak funding is the largest negative month-end cumulative balance, or zero.

Headroom = available capital - peak funding. Capital is not revenue. Contribution is within-horizon net cash, not profit; overhead, tax and financing require a separate complete model.

Month-end netting can hide an earlier intramonth cash shortage. No probability, funding eligibility, award, provider price, accounting treatment, work authorization or right to stop is inferred.

One currency throughout, two decimal places, no FX conversion. Each amount and every aggregate must fit a safe integer in minor units. Blank is unknown, not zero.

Your report

Download the complete inputs, receipt registers, all three monthly ledgers, evidence gaps, formulas and limits as a named PDF without email. Inputs remain in the page and are not automatically attached to an optional contact request. Nothing here verifies eligibility, awards funding or authorizes work.