Gemsmakers · Antique Dealer Tools

Antique Inventory Aging and Markdown Planner

Create a staged markdown plan for aging antique stock while protecting a minimum price after costs and selling fees.

Planning calculator · User-entered estimates · Results are not an appraisal or professional advice.

Calculator

Enter the details you know. Optional advanced fields are kept separate so the main calculation stays easy to use.

Date item entered inventory.
What you paid for the antique.
Current un-discounted asking price.
Target number of days to sell the item.
Storage, insurance, and allocated carrying cost per month.
Percentage deducted from sale proceeds.
Desired minimum dollars left after cost and fees.
Advanced options and comparisons
Markdown at the first checkpoint.
Total markdown from original asking price at stage 2.
Total markdown from original asking price at stage 3.

How to use this calculator

  1. Choose the acquisition date and enter purchase cost, asking price, carrying cost, and fee percentage.
  2. Set the expected turnover period and desired profit floor.
  3. Open Advanced markdown settings to adjust percentage reductions, then review the checkpoint dates and floor warnings.

How the estimate works

A markdown schedule can improve sell-through, but the lowest price should reflect your cost basis and how long you have held the item.

The planner compares planned prices with the estimated price floor at the current age. Longer holding periods raise the floor only when the entered monthly carrying cost is positive; real resale values can still differ from the forecast.

Frequently asked questions

Are markdown percentages compounded?
No. Each planned markdown is calculated from the original asking price so the checkpoints are directly comparable.
Why does the minimum price include carrying cost?
Long-held stock consumes storage, insurance, financing, or overhead that should be considered when evaluating profit.
Can I set a different turnover period?
Yes. The total target period is split into three checkpoints for this simple plan.
Does it tell me the market price?
No. It tests your planned prices against your entered costs. Compare similar sold antiques before changing a listing.
What if every planned price is below the floor?
Consider whether to wait, change sales channel, reduce avoidable costs, or consciously accept a loss rather than treating the floor as a market-value estimate.