Cellar ROI and Resale Net Calculator

Use this before calling wine an investment

Wine resale can look attractive before fees, storage, insurance, and selling costs are included. This calculator is designed to show the net result after carrying costs so that a headline auction price can be compared with what you actually keep.

Model storage and insurance over the full holding period, not just the purchase year.
Include auction, merchant, payment, and transfer fees where relevant.
Use conservative resale assumptions unless you already have a firm bid.

Resale assumptions to check

Wine investment returns are sensitive to fees. Storage, insurance, seller commission, buyer premium, and exchange-rate movement can turn a headline price gain into a flat result.

This calculator is most useful when comparing scenarios: keeping a case, selling through a merchant, or selling through auction. It does not predict market demand, critic scores, provenance discounts, or liquidity.

Why wine resale returns are easy to overstate

A market price increase is not the same as your return. Storage, insurance, transfer fees, seller commission, buyer premium, shipping, and currency movement can all sit between the headline value and the cash you actually receive.

This calculator is most useful when you run several scenarios. Test a base case, a weak resale case, and a higher-fee case. If a wine only looks attractive in the most optimistic version, the investment case may be thinner than the release offer suggests.

Use the price you could realistically sell at, not only the highest listing you can find.
Include every year of storage for the whole holding period.
Keep provenance and condition in mind, because poor documentation can reduce resale value.

Resale needs a margin of safety

Wine investment returns can be overstated when the calculation ignores spread, seller fees, storage, insurance, currency, and the time it takes to sell. Use the output to see how much price appreciation is needed before the trade is genuinely worthwhile.

A sensible resale case should still work after conservative assumptions. Try lowering the resale price, increasing fees, or extending the storage period to see how quickly the upside disappears. If the return only looks good under perfect conditions, the bottle may be better treated as something to drink rather than an investment.

Best use

Stress-testing a purchase against realistic carrying and exit costs.

Do not skip

Provenance, market liquidity, bonded status, auction fees, and tax treatment.

How It Works

This calculator estimates realized resale return from a wine investment position.

Enter original purchase total, holding period, and annual carrying costs.
Add expected gross sale value plus commission, fixed fees, and tax assumptions.
Review net cash in, net profit or loss, break-even sale value, and annualized return.

FAQ

Why can annualized return show N/A?

If cash-flow assumptions do not produce a positive realizable outcome, annualization may be undefined.

Does tax apply to losses?

In this model, tax applies only when gain before tax is positive.

Can I compare auction vs broker routes?

Yes. Run separate scenarios with different commission and fee assumptions.