🧮 Loan calculator
HideAdmin only
Enter the admin passcode to upload a new pricelist or edit prices.
Upload updated pricelist
Upload the latest pricelist PDF — the same file you already export each month, no need to reformat anything. It should keep the same layout as your current list: columns for Type, A/M, Reg. No., Colour, Year, CC, S. Price (or Selling Price), Code, Location, S/Key, read straight off the page by position, so extra sections like "HELP SELL" are picked up automatically too. Interest / Yr. Loan / Monthly columns are ignored; monthly installments are always recalculated fresh using the formula below, so they stay accurate even for cars you never filled those in for. (Excel/CSV still works too, if that's ever easier.)
Edit car prices
For a car that doesn't have a price yet — or one whose price just changed — type it in here and save. No need to wait for the next pricelist upload; it goes live immediately, and shows up as a price change on the Search screen just like an upload would.
How monthly installment is calculated
0% deposit. Bank: 3.5% flat p.a. (3.25% for cars within a 5-year age gap, e.g. 2021 model year onward),
tenure = 15 − (current year − year made), capped at 9 years max.
Chailease: 7.5% flat p.a. (5.5% for cars within a 5-year age gap), tenure = 17 − (current year − year made), capped at 9 years max.
Aeon: 7.5% flat p.a. (5.5% for cars within a 5-year age gap), same as Chailease — except for Perodua and Toyota, where Aeon's current
promo extends eligibility using 19 years instead of 17 (so older Perodua/Toyota cars still qualify).
The actual tenure is still capped at 9 years max for every financier, always.
If the car is too old for a positive tenure, that financier is marked "not eligible" for it.
Year made, not year registered: a car listed as 2014/2015 (made 2014, registered 2015) is counted from 2014.
monthly = (price × (1 + rate × tenure)) / (tenure × 12)
Recovery
If something goes wrong, restore the pricelist as it stood on 28 Aug 2026 (the list this app first launched with, 80 cars).