Skip to content
INDEPENDENT FINANCIAL EDUCATION Clear explanations. Better questions.
EasyLoanWorld Your guide to financial clarity
Explore guides
Menu
FINANCIAL GUIDE Business Finance

Expected Collections vs. Payment Deadline: Measure Each Shortfall

Two fictional receipt tables share the same average but produce different shortfall patterns. Calculate each gap before weighting the outcomes.

Wooden hourglass with pink sand beside a yellow pen holder on a desk.
An hourglass and pen holder on a desk. Illustrative stock photograph. Photo: Rashed Hossain / WordPress Photo Directory (CC0).

Estimated reading time: 10 minutes

Expected collections need an outcome-by-outcome check. An $8,000 weighted-average collection doesn’t mean $8,000 will be available for a particular payment. In this fictional exercise, two different collections tables have that same average, yet produce different weights and dollar amounts of shortfall against one $8,000 obligation.

The task is to calculate the gap in each outcome before averaging the gaps. Calculating one gap from average receipts answers a different question.

Fix the deadline and supply the complete outcome tables

Assume two fictional invoices, A and B, for $5,000 each. Each is either paid in full and usable before one payment deadline, or contributes $0 by that deadline. Partial payments are excluded. A later receipt is outside this cutoff exercise; $0 by the deadline doesn’t mean permanent nonpayment or legal default.

The required payment is a stipulated $8,000. The first calculation assigns $0 of other cash to it. There are no other cash flows, obligations or restrictions in this selected test. These assumptions don’t describe a complete business budget.

All the joint weights below are supplied, invented mathematical probabilities. They aren’t measured customer behavior, estimated default rates or a method for predicting actual collections. Each column sums to 100%; exactly one of its four mutually exclusive outcomes occurs inside that fictional model.

Two complete invented joint-weight tables for the same invoices and cutoff
Outcome by the deadline Usable receipts Model I weight Model II weight
Both A and B pay $10,000 64% 80%
Only A pays $5,000 16% 0%
Only B pays $5,000 16% 0%
Neither pays by the deadline $0 4% 20%
Total outcome weight — 100% 100%

As a check, A’s individual payment weight is 64% + 16% = 80% in Model I and 80% + 0% = 80% in Model II. B also has an 80% individual payment weight in both models.

Those individual totals do not determine the joint table. We started with all four supplied weights; we did not infer them from two separate 80% figures. The tables specify differently how the invoice outcomes occur together.

Expected collections: verify the same $8,000 mean

Multiply each outcome’s receipts by its weight, then add:

  • Model I: 0.64 × $10,000 + 0.16 × $5,000 + 0.16 × $5,000 + 0.04 × $0 = $8,000.
  • Model II: 0.80 × $10,000 + 0 × $5,000 + 0 × $5,000 + 0.20 × $0 = $8,000.

This weighted mean is sometimes called an expected value. Here it’s only the result of the invented weights. It isn’t a promised receipt, and $8,000 isn’t even one of the receipt amounts in either table.

If the calculation stops at the mean, the apparent gap is:

Gap from mean receipts = max($8,000 payment − $8,000 mean receipts, $0) = $0.

That zero doesn’t calculate how much is missing in the individual outcomes.

Calculate each positive gap before weighting it

For this worksheet, define the gap as:

Outcome gap = max(payment due − assigned other cash − that outcome’s receipts, $0).

The maximum with zero makes the gap $0 when enough cash is available. It doesn’t enter surplus cash as a negative shortfall.

$8,000 payment and $0 other cash: each gap multiplied by its supplied weight
Outcome Outcome gap Model I: weighted gap contribution Model II: weighted gap contribution
Both pay $0 64% × $0 = $0 80% × $0 = $0
Only A pays $3,000 16% × $3,000 = $480 0% × $3,000 = $0
Only B pays $3,000 16% × $3,000 = $480 0% × $3,000 = $0
Neither pays by the deadline $8,000 4% × $8,000 = $320 20% × $8,000 = $1,600
Weighted mean gap across all outcomes — $1,280 $1,600

Model I’s contributions add to $0 + $480 + $480 + $320 = $1,280. Model II’s add to $0 + $0 + $0 + $1,600 = $1,600.

Both averages include the zero-gap outcomes and their weights. Neither is the conditional average among shortfall outcomes only. The weights still total 100%; they haven’t been rescaled after removing successful outcomes.

This is the distinction: the gap calculated from mean receipts is $0, while the mean of the outcome gaps is positive. The two operations can’t be swapped in this example. Surplus in one mutually exclusive outcome doesn’t transfer into another outcome to pay its bill.

Count shortfall weight separately from its dollar amount

To find the model weight assigned to any shortfall, add the weights of outcomes whose gap exceeds $0:

  • Model I: 16% + 16% + 4% = 36%.
  • Model II: 0% + 0% + 20% = 20%.

Model I assigns more weight to experiencing a shortfall, but its weighted mean dollar gap is smaller. Model II assigns less weight to shortfall, but its positive-weight shortfall outcome is the full $8,000 gap. “How much outcome weight has a gap?” and “What is the weighted mean gap?” are different measurements.

The $1,280 average isn’t a realized bill: Model I’s possible gaps are $0, $3,000 and $8,000. It’s also not a recommended funding or reserve amount, nor an amount that covers every shortfall outcome.

Add $3,000 of assigned cash as a separate scenario

Now stipulate $3,000 of other usable cash for the same $8,000 payment in both models. Keep every invoice amount and every joint weight unchanged. The $3,000 is a scenario input, not a recommended reserve or an assumed new loan.

If both invoices pay, available cash is $13,000 and the gap is $0. If only one pays, available cash is exactly $8,000 and the gap is also $0. Only the neither-paid outcome has a gap: $8,000 − $3,000 = $5,000.

Model I therefore has 4% shortfall weight and a weighted mean gap of 0.04 × $5,000 = $200. Model II has 20% shortfall weight and a weighted mean gap of 0.20 × $5,000 = $1,000. The other outcome contributions remain zero.

Four results under supplied fictional weights; the payment remains $8,000
Other cash assigned Joint-weight model Weight of outcomes with a shortfall Weighted mean gap, including zero gaps
$0 I 36% $1,280
$0 II 20% $1,600
$3,000 I 4% $200
$3,000 II 20% $1,000

The shortfall-weight ranking reverses: Model I changes from more shortfall weight than Model II to less. That result comes from the supplied outcome tables and the changed cash input. It isn’t a universal ranking of customer groups or collection strategies.

Expected collections: calculate the mean gap only among shortfall outcomes

A conditional mean answers another limited question: within this model’s outcomes that actually have a positive gap, what is the weighted average gap? It excludes zero-gap outcomes and divides by the total weight remaining. Keep it separate from the overall mean already calculated.

With no assigned other cash, Model I’s positive-gap weight is 36% and its overall weighted gap is $1,280. Dividing $1,280 by 0.36 gives about $3,555.56. That’s the conditional mean among its shortfall outcomes, not the overall mean or a new possible receipt.

For Model II, $1,600 divided by 0.20 gives $8,000. Its only positive-weight shortfall outcome has neither invoice paid, so that conditional result matches the full stipulated gap.

Expected collections: reconnect the conditional and overall results

Multiply each conditional mean by its shortfall weight to recover the overall mean: 36% times the unrounded $3,555.555… equals $1,280, and 20% times $8,000 equals $1,600. This check explains why a larger shortfall weight can coexist with a smaller overall dollar gap.

After assigning $3,000 other cash, both models’ only positive-weight shortfall outcome is the $5,000 gap when neither invoice pays. Their conditional mean gaps are therefore both $5,000.

Their overall means still differ: 4% times $5,000 equals $200 for Model I, while 20% times $5,000 equals $1,000 for Model II. Equal conditional severity doesn’t imply equal shortfall weight or equal overall mean.

Expected collections: label each measure before comparing it

Record three separate measures: weight of a positive gap, mean gap across all outcomes and mean gap conditional on a positive gap. If no outcome with positive weight has a shortfall, the conditional mean is undefined; don’t report a fictitious zero-gap subgroup average.

These expected collections calculations continue to use only the supplied invented joint weights. They estimate no real customer’s behavior and prescribe no reserve or borrowing amount. Averages describe the model; the deadline still requires the actual cash in the outcome that occurs.

Find the range when only individual weights are supplied

Consider a separate partial-information exercise using the same two $5,000 invoices, $8,000 payment and $0 assigned other cash. Supply only an invented 80% individual payment weight for each invoice, rather than choosing Model I or Model II’s complete joint table. What can those two inputs establish?

Let q be the weight of both invoices paying by the cutoff, written as a decimal: 0.60 means 60%. Keeping each individual weight at 0.80 forces the four mutually exclusive weights to be:

  • Both pay: q.
  • Only A pays: 0.80 − q.
  • Only B pays: 0.80 − q.
  • Neither pays: q − 0.60, the weight left after the other three.

Every weight must be nonnegative. The neither-paid row requires q ≥ 0.60; each one-paid row requires q ≤ 0.80. Conversely, every q between 0.60 and 0.80 makes all four weights nonnegative, sums them to one, and gives each invoice its stipulated 0.80 total. Therefore 60%–80% is the complete attainable range for the both-paid weight in this exercise.

This does not select a joint table. Model I’s q = 0.64 and Model II’s q = 0.80 are two members of that family. Multiplying the individual weights to select 0.64 would add an independence assumption that this partial-information exercise has not supplied.

The gaps remain $0 when both pay, $3,000 when exactly one pays, and $8,000 when neither pays. Their weighted mean across all outcomes is:

Mean gap = $3,000 × (0.80 − q) + $3,000 × (0.80 − q) + $8,000 × (q − 0.60) = $2,000 × q.

It can therefore range from $1,200 to $1,600, even though mean receipts remain $8,000 throughout. Both endpoints are attainable using the four weights above; this isn’t a confidence interval or an estimated range for real collections.

Keep the other measures separate. The weight of outcomes with any gap is 1 − q, ranging from 40% at q = 0.60 to 20% at q = 0.80. The conditional mean among positive-gap outcomes is ($2,000 × q) ÷ (1 − q): $3,000 at the first endpoint and $8,000 at the second. These are linked results, not independent inputs to mix and match.

The bounds describe what the supplied hypothetical individual weights permit; they don’t validate those weights, estimate customer behavior or prescribe a reserve or borrowing amount. They also don’t replace the earlier complete-table examples or their separate $3,000-assigned-cash scenario.

Use the arithmetic without turning it into a forecast

Keep three checks visible: the weights sum to 100%, every outcome’s gap uses its own receipts, and the weighted mean gap includes zero-gap outcomes. Don’t replace the full joint table with individual payment percentages or replace a cash outcome with the weighted mean.

This exercise doesn’t tell you how to estimate real customer probabilities, what cash reserve to hold, how much to borrow or whether a payment is affordable. It also models no late-payment consequences or funding remedy. Its result is narrower: identical average collections can conceal different shortfall patterns at one deadline.

For a separate cash-allocation worksheet, see testing a proposed business payment against collections and other commitments. For an unweighted dated stress case, see one customer’s delayed payment and the cash calendar.

Original hypothetical arithmetic. All joint weights and amounts are invented; no actual invoice, customer-payment probability, default rate or lender rule is represented.

Illustrative stock photo: Rashed Hossain / WordPress Photo Directory (CC0).