Calculator Example

Modellname Referencenumber Purchaseprice Flightprice Purchaseprice total Margin Seller Sellprice w/tax Sellprice me Profit Link Actions
Rolex Submariner Date Starbucks 126610LV
€
600,00 € 9.445,00 € 7 %
€
13.832,77 € 4.387,77 € https://www.chrono24.de/search/index.htm?condition=101&countryIds=DEcyId=EUR&dosearch=true&maxAgeInDays=0&pageSize=60&query=116503&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&usedOrNew=new
Rolex Submariner Date Starbucks 126610LV
€
600,00 € 11.520,00 € 7 %
€
13.832,77 € 2.312,77 € https://www.chrono24.de/search/index.htm?condition=101&countryIds=DE¤cyId=EUR&dosearch=true&maxAgeInDays=0&pageSize=60&query=116503&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&usedOrNew=new
Rolex Daytona stahlgold 116503
€
600,00 € 18.148,00 € 7 %
€
21.882,35 € 3.734,35 € https://www.chrono24.de/search/index.htm?condition=101&countryIds=DE¤cyId=EUR&dosearch=true&maxAgeInDays=0&pageSize=60&query=116503&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&usedOrNew=new
Rolex Submariner Gelbgold 126613LN
€
600,00 € 14.924,00 € 7 %
€
13.676,47 € -1.247,53 € https://www.chrono24.de/search/index.htm?countryIds=DE¤cyId=EUR&dosearch=true&maxAgeInDays=0&pageSize=60&query=126613LN&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&usedOrNew=new&watchTypes=U&year=2022
Rolex Submariner Date Starbucks 126610LV
€
600,00 € 10.920,00 € 7 %
€
13.285,71 € 2.365,71 € https://www.chrono24.de/search/index.htm?countryIds=DE¤cyId=EUR&dosearch=true&maxAgeInDays=0&pageSize=60&query=126610LV&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&usedOrNew=new&year=2022
Milgauss Oyster 116400GV
€
600,00 € 10.140,00 € 7 %
€
10.777,06 € 637,06 € https://www.chrono24.de/search/index.htm?countryIds=DE¤cyId=EUR&dosearch=true&maxAgeInDays=0&pageSize=60&query=116400GV&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&usedOrNew=new&year=2022
SEA-DWELLER gelbgold 126603
€
600,00 € 19.032,00 € 7 %
€
14.809,66 € -4.222,34 € https://www.chrono24.de/search/index.htm?countryIds=DE¤cyId=EUR&dosearch=true&maxAgeInDays=0&pageSize=60&query=126603&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&usedOrNew=new&watchTypes=U&year=2023&year=2022
Oyster Perpetual Oyster 124300
€
600,00 € 7.124,00 € 7 %
€
6.955,46 € -168,54 € https://www.chrono24.de/search/index.htm?countryIds=DE¤cyId=EUR&dialColor=708&dosearch=true&maxAgeInDays=0&pageSize=60&query=124300&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&usedOrNew=new&year=2023&year=2022
Datejust 36 Gelbgold 126233
€
600,00 € 13.572,00 € 7 %
€
10.151,85 € -3.420,15 € https://www.chrono24.de/search/index.htm?countryIds=DE¤cyId=EUR&dosearch=true&maxAgeInDays=0&models=2787&pageSize=60&query=126233&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=0&specials=102&usedOrNew=new&watchTypes=U&year=2022&year=2023
Rolex Yachtmastwe 42 gelbgold 226658
€
600,00 € 30.420,00 € 7 %
€
24.617,65 € -5.802,35 € https://www.chrono24.de/search/index.htm?countryIds=DE¤cyId=EUR&dosearch=true&maxAgeInDays=0&pageSize=60&query=226658&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&usedOrNew=new&year=2023&year=2022
OYSTER PERPETUAL 41 blau 124300
€
600,00 € 7.124,00 € 7 %
€
8.440,34 € 1.316,34 € https://www.chrono24.de/search/index.htm?caseDiameter=41&countryIds=DE¤cyId=EUR&dialColor=710&dosearch=true&maxAgeInDays=0&pageSize=60&query=124300&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&watchTypes=U&year=2023&year=2022
Rolex Submariner Schwarz 126610ln
€
600,00 € 11.128,00 € 7 %
€
11.253,78 € 125,78 € https://www.chrono24.de/search/index.htm?countryIds=DE¤cyId=EUR&dosearch=true&maxAgeInDays=0&models=981&pageSize=60&query=126610ln&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&year=2023&year=2022
Rolex GMT Master Rootbeer 126711CHNR
€
600,00 € 17.157,92 € 7 %
€
16.489,92 € -668,00 € https://www.chrono24.de/search/index.htm?countryIds=DE¤cyId=EUR&dosearch=true&maxAgeInDays=0&pageSize=60&query=126711CHNR&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&usedOrNew=new&watchTypes=U&year=2023&year=2022
Rolex Air King 126900
€
600,00 € 8.216,00 € 7 %
€
8.440,34 € 224,34 € https://www.chrono24.de/search/index.htm?countryIds=DE¤cyId=EUR&dosearch=true&maxAgeInDays=0&models=5&pageSize=60&query=126900&redirectToSearchIndex=true&resultview=block&searchexplain=1&sortorder=1&specials=102&usedOrNew=new&year=2023&year=2022
Modellname
Referencenumber
Purchaseprice
Flightprice
Purchaseprice total
Margin Seller
Sellprice w/tax
Sellprice me
Profit
Link
Bag 1
CRV6HN
10000 €
600 €
11024 €
10 %
16800 €
12759,91 €
1735,91 €
Link

Calculation Purchaseprice total:

Purchaseprice + Flightprice = Purchaseprice without duty

Purchaseprice without duty / 100 * 1. duty = Purchaseprice total

Example:

Purchaseprice: 10000 €

Flightprice: 600 €

Duty: 4%

10000 + 600 = 10600 €

10600 € *1.04 = 11024 € 

Sellprice me:

Sellprice with tax / 19 % tax

Sellprice net x 100 – 0.10 margin seller

16800 € / 1.19 = 14177,68 €

14177,68 € x 0,9 = 12759,91 €

Profit:

Sellprice me – Purchaseprice total

12759,91 € – 11024 € = 1735,91 €

Editable Columms

Purchase Price

Sellprice w/tax 

Change for all rows:

Margin Seller 

Flightprice