Sri Lanka Vehicle Duty Calculator

Built from your spreadsheet logic: VAT-removal → 85% factor → + shipping → CNF (LKR) → CID (30%) → XID (CC Rate × CC) → Total → VAT → L Tax (CNF − Deduction) → Total Tax.

VAT removal: 20% • VAT on Total: 18%

Inputs

Tip: Values are editable • Currency is “foreign” until exchange rate converts to LKR

Vehicle value

Foreign currency

Brand New Vehicle Value e.g., 51000

Value

Shipping e.g., 1200

Ship

Rates

Editable

Exchange Rate LKR per 1 foreign

LKR / unit

VAT removal rate used for “After VAT deduction”

decimal

85% factor 0.85 in your sheet

decimal

CID rate 0.30 in your sheet

decimal

VAT rate (applied on Total) editable (your sample matches 0.18)

decimal

Percentage (display only) used for “L Tax × %”

decimal

Engine & deduction

LKR based

CC Rate LKR per CC

LKR / CC

CC engine capacity

Deduction LKR

LKR

Actions

Note: “L Tax × Percentage” is displayed for reference (like your sheet) and is not included in Total Tax.

Results

Currency: LKR

Total Tax

CID + XID + VAT + L Tax

—

Item	Amount
Total Tax	—

Breakdown uses tabular numbers for easy comparison with your spreadsheet.