Reselling · liquidation lots

Liquidation pallet profit calculator.

Turn a manifest and your own cost assumptions into downside, base and upside economics before you bid. Nothing is looked up, uploaded or sent anywhere.

Total profit = revenue minus acquisition cash and operating costs. The loaded example uses 100 manifested units and a $700 pallet bid. Its base case recovers 60 units at $40 each, producing $2,400 of revenue, $724 of total profit, a 30.2% margin and a maximum $812.73 bid for a 25% target margin.

Advertisement

Your pallet assumptions

Use one currency consistently. Defaults are a worked example, not typical rates, prices or recovery.

Lot and acquisition
Whole units listed before inspection.
$
%
Enter the auction percentage in your terms; 0 if none.
$
Operating costs
$
Sorting space, disposal, lot-level labour or other costs paid once.
$
Cleaning, testing, repair and packaging averaged per sellable unit.
%
Your own blended marketplace or payment percentage.
$
Flat order, payment or listing cost per recovered unit sold.
$
Enter only the portion you expect to absorb.
%
Used only to solve the maximum pallet bid.
Downside, base and upside cases

Enter a recoverable share and an average realized sale price for each case. The calculator rounds recoverable units down.

%
$
%
$
%
$

Pallet economics

Advertisement

How the liquidation pallet calculation works

Start with the number of units listed on the manifest. For each scenario, the calculator multiplies that count by the recoverable percentage and rounds down to a whole unit. A 60% recovery assumption on 101 manifested units therefore becomes 60 recoverable units, not 60.6. The model then assumes those recoverable units are sold at the average sale price entered for that scenario. It does not assume every manifested unit is sellable, and it does not assign any salvage value to the remainder.

Revenue is recoverable units multiplied by average sale price. Acquisition cash is the pallet bid plus the percentage buyer premium plus inbound freight or pickup. Operating costs combine the fixed lot-level amount, prep per recoverable unit, per-sale cost, seller-paid shipping and the percentage selling fee. Operating profit is revenue minus those operating costs. It answers whether the recovered merchandise covers the work of processing and selling it before paying for the lot itself.

Total profit subtracts acquisition cash from operating profit. Profit margin is total profit divided by revenue. Return on cash is total profit divided by every cash cost in the model: acquisition plus operating costs. Margin and return on cash answer different questions, so both are shown. A pallet can have a reasonable margin but still tie up more cash than another opportunity.

The break-even average sale price solves the total-profit equation for price while holding the scenario recovery rate and all costs fixed. The maximum pallet bid solves the same equation for the bid that leaves the target margin entered. Because the buyer premium is a percentage of the bid, the reverse calculation divides the money available for a bid by one plus that premium. If freight, fees and operating costs already consume the amount available at the target margin, no positive bid can meet the target.

Worked example: 100-unit manifested pallet

Suppose a lot lists 100 units. You enter a $700 bid, a 10% buyer premium, $200 of inbound freight, $100 of fixed handling and disposal, $3 of prep per recoverable unit, a 12% selling fee, $0.30 of per-sale cost and $2 of seller-paid shipping. Acquisition cash is $970: the $700 bid, $70 premium and $200 freight.

In the base case, 60% recovery gives 60 whole recoverable units. At a $40 average sale price, revenue is $2,400. The percentage selling fee is $288, unit-level operating costs are $318, and fixed operating costs are $100, for $706 of operating costs. Operating profit is therefore $1,694. After subtracting $970 of acquisition cash, total profit is $724. That is a 30.2% profit margin and a 43.2% return on $1,676 of total cash outlay. The average sale price breaks even at $26.29. With a 25% target margin, the most you could bid under this base case is $812.73.

The downside case uses 40 recovered units at $32 each. It produces $1,280 of revenue and a $155.60 loss after all modeled costs. Break-even average price is $36.42, and the 25% target-margin bid falls to $267.64. The upside case uses 75 recovered units at $48 each. It produces $3,600 of revenue and $1,700.50 of total profit. Its break-even average is $22.23 and its maximum bid at the same target margin is $1,427.73. These are three calculations on round example inputs, not statements about what a real pallet will recover or sell for.

How to build defensible scenarios

Make the downside case reflect the defects you can plausibly encounter: missing accessories, incomplete sets, restricted products, cosmetic damage, failed testing and categories you cannot sell. Build the base case from the manifest lines you can identify and comparable sold items you have reviewed yourself. Reserve the upside case for a better recovery mix or stronger realized prices that still have evidence behind them. Do not turn retail list price into an average resale price without checking the condition and sales channel.

Run the calculator again when the auction terms change. A buyer premium is applied to the bid, while freight and fixed handling are entered as separate costs. If a seller quotes one landed invoice instead, enter the merchandise portion as the bid, set the premium to zero if already included, and place the rest in freight or fixed operating costs so nothing is counted twice. Add expected returns, chargebacks or storage to fixed or per-unit costs if they matter to your plan.

What this calculator does not cover

For deeper planning, use the reseller bankroll calculator after this one to test how quickly cash can turn, the sell-through calculator once you have sales history, and the inventory carrying cost calculator when slow stock occupies space and capital. For one-item sourcing, the thrift flip profit calculator is the narrower model.

General recordkeeping sources

The calculator's rates, recovery percentages and prices all come from you. The sources below support only the general U.S. recordkeeping context, not any pallet-recovery or resale-price claim.

This is general information, not accounting or tax advice. The tool deliberately does not provide a tax rate or classify any cost for your return.

Common mix-ups

Advertisement

Frequently asked questions

How do I calculate profit on a liquidation pallet?

Estimate how many units will be recoverable, multiply those units by your average sale price, then subtract selling costs, prep, freight, the pallet bid and the buyer premium. This calculator keeps acquisition costs separate from operating costs so the result is easier to audit.

What counts as a recoverable unit?

For this model, a recoverable unit is one you expect to make sale-ready and sell at the scenario's average price. Units expected to be broken, missing, restricted, incomplete or otherwise unsellable belong outside the recovery percentage.

What is the difference between operating profit and total profit?

Operating profit is revenue minus selling fees, per-sale costs, shipping, prep and fixed operating costs. Total profit then subtracts the pallet bid, buyer premium and inbound freight or pickup cost.

How is the break-even average sale price calculated?

The calculator divides all acquisition and non-percentage operating costs by recoverable units and by the share of each sale left after the percentage selling fee. At that average price, total profit is zero.

How is the maximum pallet bid calculated?

The calculator works backward from each scenario's revenue and your target profit margin. It subtracts percentage selling fees and every non-bid cost, then divides the amount left by one plus the buyer-premium percentage.

Does this calculator include marketplace fees?

Yes, but it does not assume a marketplace or publish a fee rate. Enter the percentage fee and per-sale amount that apply to the channel you plan to use.

Are the downside, base and upside cases predictions?

No. They are three sets of recovery-rate and average-price assumptions that you enter. Use them to test a range you can defend from your own manifest review, inspection and comparable sales.

Does this replace an inspection or tax advice?

No. It is a planning model, not an inspection, appraisal, accounting system or tax opinion. Verify the lot, auction terms, restrictions, shipping, sales channel and recordkeeping requirements before buying.