VAT Rate Calculation Exercise

Extract

[...] 60 % MARKET SHARE RATE COEF MARGIN PA VAT AMOUNT MARGIN RATE PV TTC PV HT 2.20 25? 40 % 84? 73 ? 60 % 13 ? 38 ? 45 % 71 ? 2.30 58 ? 17 ? 63 ? 120 Correction PA COEF AMOUNT MARK-UP RATE PV TTC PV HT MARGIN RATE MARGIN VAT 20 ? 1,50 5 ? 20% 30 ? 25 ? 25% 5 ? 48 ? 2,00 16 ? 40% 96 ? 80 ? 67% 32 ? 54 ? 1,68 15 ? 29% 91 ? 76 ? 40% 22 ? [...]

[...] Explanations HT = tax-free TTC = all taxes included PA = purchase price (in ? and HT) PV = sale price (in can be given in HT or TTC) TVA = value-added tax (so applied on the sale price PV HT) (in Here are the formulas to use, to know and to transform : PV TTC = PV HT + VAT AMOUNT (in MARGIN = PV HT - PA (in MARKUP RATE = MARGIN / PV HT (in MARKUP RATE = MARGIN / PA (in COEF = PV TTC / PA Method : We focus on a single row of the table. [...]

[...] 92% 58 ? 50 ? 1,61 13 ? 25% 80 ? 67 ? 34% 17 ? 58 ? 2,30 22 ? 48% 133 ? 111 ? 92% 53 ? 56 ? 1,92 18 ? 38% 108 ? 90 ? 60% 34 ? MARKET SHARE RATE COEF" MARGIN PA VAT AMOUNT MARGIN RATE PV TTC PV HT 45% 2,20 21 ? 25 ? 9 ? 83% 55 ? 46 ? 40% 2,00 34 ? 50 ? 17 ? 67% 101 ? [...]