COLLECTORS & HOBBYISTS · PLAN, COMPARE, EXPORT

Coin Metal Content Inventory

Total the stated metal content of a collection and compare an entered metal price with acquisition costs.

Local calculationsEditable projectsCSV & reports
  1. 1Explore the example
  2. 2Edit your assumptions
  3. 3Compare & export

Loading the worked example…

Your working data

Edit cells directly or import a CSV. Download “Input CSV” for the required column names. Up to 200 rows; scroll the table sideways for additional fields.

What this model includes

One metal and currency per project. Uses your stated mass, purity and price; does not authenticate coins, grade collectibles or provide a market appraisal.

Import and save safely

CSV imports use your current assumptions. Project files restore assumptions, rows and saved scenarios. No automatic saving: download a project before closing this page. Imports are limited to 10 MiB and 200 rows. Calculations run in your browser; the site’s advertising and analytics follow its privacy policy.

Using Coin Metal Content Inventory

Total the stated metal content of a collection and compare an entered metal price with acquisition costs.

  1. Review the preloaded example and the model limits before entering real data.
  2. Adjust entered price per pure-metal gram.
  3. Edit the coin / lot rows or import a CSV using the Input CSV column template.
  4. Open Results & chart to inspect details, sort columns and filter rows.
  5. Capture alternative scenarios, then download a project, result CSV or printable report.

Example

The worked example includes Lot A, Lot B.
Change the first entered price per pure-metal gram setting and compare the result with a saved baseline.

Questions & answers

What does Coin Metal Content Inventory calculate?

Total the stated metal content of a collection and compare an entered metal price with acquisition costs.

What are the important limitations?

One metal and currency per project. Uses your stated mass, purity and price; does not authenticate coins, grade collectibles or provide a market appraisal.

Can I continue my work later?

Yes. Save a project JSON file and reopen it with Import CSV / project. It contains the working data, assumptions and up to four scenarios. Nothing is saved automatically.

What CSV columns do I need?

coin, qty, grams, purity, paid. Download Input CSV for a compatible example. CSV imports keep your current assumptions.

Are these example figures current industry benchmarks?

No. They are illustrative values to demonstrate the model. Replace them with figures appropriate to your situation.

Help improve this tool

Report a problem or suggest an improvement

Describe the issue without pasting private tool input. Feedback goes to our admin inbox.

Find another tool · Read practical guides