Star Wars Collection Value Analysis

Physical Star Wars Unlimited card collection spread out for cataloguing and valuation
Excel Analytics Data Analysis Dashboard
2024

Results

€776 Total estimated market value
€550 Initial investment
2,304 Cards in the collection
9 Cards holding ~€390 in value (50% of total)
41.6% Of total value held by the top 5 cards

Objective

Understand the economic value of a Star Wars Unlimited card collection: what is the collection worth, how is value distributed across cards and rarities, and what reselling strategy gets closest to break-even while keeping the collection playable?

Approach

Listed every card in an Excel spreadsheet with current selling prices from cardmarket.com. Used conditional formatting to colour-code cards by rarity, availability, and price tier, making it easy to spot where value was concentrated at a glance.

Calculated total market value (€776.51 at time of analysis), broke down value distribution by rarity, and identified the highest-value individual cards. Three Darth Vader cards appear in the collection, matching the maximum allowed per the game's rules.

Key findings

  • Collection is predominantly composed of cards under €3, but total market value reached approximately €776
  • 9 cards out of 2,304 (those above the €15 bracket) hold ~€390, roughly half of total value
  • "Normal" cards hold ~47% of total value (€364 across 2,039 cards), averaging €0.17 per card
  • Top 5 cards represent €323, or 41.6% of total expected value

Three reselling strategies identified based on the analysis:

  1. Sell the top 5 high-value cards (€323, 41.6% of total value) — fastest path to recouping investment
  2. Sell select other high-value individual cards to increase recovery while preserving the playable collection
  3. Bulk sell normal cards to monetise the long tail of low-value inventory
Excel spreadsheet showing the full Star Wars Unlimited card catalogue with conditional formatting by rarity and price tier
Card catalogue in Excel
Overview of the card data structure in Excel including card names, rarities, and current market prices from cardmarket.com
Data overview
Breakdown of the 2,304 cards in the collection by rarity and card type
Total cards breakdown
Chart showing how total market value is distributed across card rarity categories
Value by rarity
Chart showing how total market value is distributed across card types
Value by card type
Expected market value analysis showing total collection value of approximately €776 at time of analysis
Expected market value
The top 5 most valuable cards in the collection, representing €323 or 41.6% of total expected value
Top 5 most valuable cards
Breakdown of the 9 high-value cards (above €15) that hold approximately €390, roughly half of total collection value
High-value card breakdown
Value analysis of the remaining collection after the top high-value cards, showing the long tail of lower-priced cards
Remaining collection value
Excel dashboard summarising the Star Wars Unlimited collection value analysis with key metrics and visualisations
Collection dashboard