Fundraising auction lot performance calculator

Calculate net cash by lot under supplied reserve rule and total lot net cash 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 net cash by lot under supplied reserve rule and total lot net cash to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Lots: name, reserve $, highest supplied bid $, direct preparation cash cost $
A,50,100,20 B,100,80,10
Fee on bids meeting reserve (%)
10
Net cash by lot under supplied reserve rule ($)
A: 70.00; B: -10.00
Total lot net cash ($)
$60.00
Lots whose bids meet reserve
1
Lots below reserve
B

Try another scenario

Lots: name, reserve $, highest supplied bid $, direct preparation cash cost $
A,50,100,20 B,100,120,10
Fee on bids meeting reserve (%)
10
Net cash by lot under supplied reserve rule ($)
A: 70.00; B: 98.00
Total lot net cash ($)
$168.00
Lots whose bids meet reserve
2
Lots below reserve
None
Calculation method

Calculation method

Net cash by lot under supplied reserve rule ($)

If bid≥reserve, bid−rounded bid fee−preparation cost. Otherwise receive zero bid cash but retain preparation cost.

Total lot net cash ($)

Sum signed lot cash.

Lots whose bids meet reserve

Count bids meeting or exceeding the entered reserve.

Lots below reserve

List below-reserve lot names; no sale is assumed for them.

Symbols and units
a
Lots: name, reserve $, highest supplied bid $, direct preparation cash cost $
b
Fee on bids meeting reserve (%)

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

  • A supplied-bid cash illustration, excluding buyer premiums, sales tax, payment failures and noncash donated-lot values. Meeting a numeric reserve is not a completed sale.
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.