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