Fundraising pledge collection schedule calculator

Calculate remaining pledged face value and probability-weighted future collection with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use remaining pledged face value and probability-weighted future collection to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Pledges: name, expected remaining-payment date, total pledge $, already collected $, supplied chance of remaining collection %
A,2026-10-25,100,20,50 B,2026-11-01,200,0,100
Opening cash, already including any receipts you choose ($)
50
Remaining pledged face value ($)
$280.00
Probability-weighted future collection ($)
$240.00
Expected cash after each dated collection ($)
2026-10-25 A: 90.00; 2026-11-01 B: 290.00
Previously collected amounts in pledge records ($)
$20.00

Try another scenario

Pledges: name, expected remaining-payment date, total pledge $, already collected $, supplied chance of remaining collection %
A,2026-10-25,100,20,100 B,2026-11-01,200,0,100
Opening cash, already including any receipts you choose ($)
50
Remaining pledged face value ($)
$280.00
Probability-weighted future collection ($)
$280.00
Expected cash after each dated collection ($)
2026-10-25 A: 130.00; 2026-11-01 B: 330.00
Previously collected amounts in pledge records ($)
$20.00
Calculation method

Calculation method

Remaining pledged face value ($)

Sum pledge−already collected, rejecting over-collected rows.

Probability-weighted future collection ($)

Sum each remaining face×supplied collection probability, rounded per row to US cents.

Expected cash after each dated collection ($)

Sort supplied future dates and add expected row receipts to entered opening cash; same-day rows retain input order.

Previously collected amounts in pledge records ($)

Show historical collections separately; do not add them again to opening cash.

Symbols and units
a
Pledges: name, expected remaining-payment date, total pledge $, already collected $, supplied chance of remaining collection %
b
Opening cash, already including any receipts you choose ($)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • An expected-value scenario using probabilities and dates you supply. It does not predict donor payment, recognize pledge revenue or treat an expected receipt as available cash.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

Charity Commission: funds and reserves background; no universal reserve target ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.