What does PPP Distortions and Multi-Currency Price Endings conclude, in numbers, about “Tax-Inclusive Display, Fees and Exchange-Rate Drift: How Endings Wear Down Before and After Checkout”?

Answer: Tax, fees and the exchange rate are the three gates a lattice price passes before it reaches the books. Markets with tax-inclusive display should keep the tax-inclusive lattice price as master data: books-first does collect one more slice of tax, but it turns RM99.00 into RM106.92 and ¥5,580 into ¥6,138, and a system whose master data is the pre-tax price leaves some lattice points unreachable under every rounding mode, about one in eleven of the yen points. A fixed fee weighs heavily on cheap price points; the fee burden on a RM9.90 digital report is more than four times that on RM199.00, and a platform commission pushes the lowest sellable lattice point up, in Japan beyond the current price. Against exchange-rate drift, the book's dense lattice leaves every price only a narrow dead zone, and a weekly-recomputed table changes prices more than eighteen times a year. This book's default is two hard triggers, the floor and the band, a drift trigger of 0.03 with a two-week waiting period, and a stress buffer of 0.03. Chapter 7 puts these rules into the matrix engine and writes them out as the specification of the calculator.

Scope of the numbers: Exchange rates and price levels in the book are stated sample assumptions, not live data; taxes, display rules and the law on price discrimination are described only in general terms, not as legal or tax advice. Marked boxes separate published evidence, runnable calculations, sources and the author's hypotheses, each stating what would refute it.

中文版

Data table

The numbers below are printed verbatim by the chapter's Python program and can be reproduced by running it. standard-library Python onlyprinted values that match the answer: 106.92, 5580, 6138, 99.00

A. display-first versus net-first on p70 prices
mkt item display net in it tax in it | digits used as net, shown as extra net
MY report99.00 91.67 7.33 | 106.92 +0.0800
SG deck59.90 54.95 4.95 | 65.29 +0.0901
TW deck1,080 1,029 51 | 1,134 +0.0496
JP deck5,580 5,073 507 | 6,138 +0.0999
B. lattice points that NO tax-exclusive master price can produce when tax is computed on the net
and rounded to the currency unit (MYR, SGD up to 1,000; TWD up to 10,000; JPY up to 100,000)
mkt rate points floor half-up ceil
MY0.08 200 15 15 14
SG0.09 200 18 16 16
TW0.05 400 19 19 19
JP0.10 1,000 91 91 91
JPY floor: unreachable among 980, 1,980, 2,980, 3,980, 4,980, 5,580, 9,9802,980
JPY half : unreachable among 980, 1,980, 2,980, 3,980, 4,980, 5,580, 9,980: none
JPY ceil : unreachable among 980, 1,980, 2,980, 3,980, 4,980, 5,580, 9,980980
JPY 10%: residues mod 11 skipped: floor 10, half-up 5, ceil 1;5,580 mod 11 = 3, 2,980 mod 11 = 10
C. US shelf price 49.00, tax added at checkout (SAMPLE combined rates, assumptions)
rate 0 checkout total49.00
rate 0.045 checkout total51.21
rate 0.0725 checkout total52.55
rate 0.095 checkout total53.66
Show the full program
# Chapter 6. p60: Tax-inclusive versus tax-exclusive display, and which endings survive the tax step.
# Tax rates: standard rates the author is sure of at the time of writing (SG GST 9%, JP consumption
# tax 10%, TW business tax 5%, MY service tax on digital services 8%). They are inputs, not tax
# advice; always check the latest official notice. US combined state + local rates are SAMPLE
# ASSUMPTIONS, not any real jurisdiction. Prices come from the p70 matrix (sample FX, not live).
from fractions import Fraction as F

ROWS = [  # market, currency, quantum, tax rate, display price from p70, item
    ("MY", "MYR", F(1, 100), F("0.08"), F("99.00"), "report"),
    ("SG", "SGD", F(1, 100), F("0.09"), F("59.90"), "deck"),
    ("TW", "TWD", F(1), F("0.05"), F(1080), "deck"),
    ("JP", "JPY", F(1), F("0.10"), F(5580), "deck"),
]
LIMIT = {"MYR": 1000, "SGD": 1000, "TWD": 10000, "JPY": 100000}


def rnd(v, q, mode):
    """Round a non-negative Fraction v to a multiple of q: floor, half-up or ceiling."""
    n, r = divmod(v, q)
    if mode == "floor" or r == 0:
        return n * q
    if mode == "ceil":
        return (n + 1) * q
    return (n + (1 if 2 * r >= q else 0)) * q


def lattice(cur, hi):
    """Everyday lattice of the book: MYR, SGD x9.00 x9.90; TWD x80 x88 x90 x99; JPY x80."""
    pts = set()
    if cur in ("MYR", "SGD"):
        for t in range(0, hi // 10):
            pts |= {F(10 * t + 9), F(10 * t + 9) + F("0.90")}
    elif cur == "TWD":
        for h in range(0, hi // 100):
            pts |= {F(100 * h + e) for e in (80, 88, 90, 99)}
    else:
        for h in range(0, hi // 100):
            pts.add(F(100 * h + 80))
    return sorted(pts)


def reachable(d, t, q, mode):
    """Is there a tax-exclusive price n (a multiple of q) with n + round(t n) == d?"""
    n0 = rnd(d / (1 + t), q, "floor")
    return any(n + rnd(t * n, q, mode) == d for n in (n0 + i * q for i in range(-3, 4)) if n > 0)


def fm(v, q):
    return "{:,.2f}".format(float(v)) if q < 1 else "{:,}".format(int(v))


if __name__ == "__main__":
    print("A. display-first versus net-first on p70 prices")
    print("   mkt item     display   net in it   tax in it | digits used as net, shown as   extra net")
    for mkt, cur, q, t, d, item in ROWS:
        net = rnd(d / (1 + t), q, "half")
        shown = d + rnd(d * t, q, "half")
        print("   {}  {:<6} {:>9} {:>11} {:>10} | {:>28} {:>11}".format(
            mkt, item, fm(d, q), fm(net, q), fm(d - net, q), fm(shown, q),
            "{:+.4f}".format(float(d / net - 1))))
    print("B. lattice points that NO tax-exclusive master price can produce when tax is computed on the net")
    print("   and rounded to the currency unit (MYR, SGD up to 1,000; TWD up to 10,000; JPY up to 100,000)")
    print("   mkt  rate  points   floor   half-up   ceil")
    for mkt, cur, q, t, d, item in ROWS:
        pts = lattice(cur, LIMIT[cur])
        row = [sum(1 for v in pts if not reachable(v, t, q, mode)) for mode in ("floor", "half", "ceil")]
        print("   {}  {:<5} {:>6,} {:>7} {:>9} {:>6}".format(mkt, "{:.2f}".format(float(t)), len(pts), *row))
    jp = [F(v) for v in (980, 1980, 2980, 3980, 4980, 5580, 9980)]
    for mode in ("floor", "half", "ceil"):
        bad = [fm(v, 1) for v in jp if not reachable(v, F("0.10"), F(1), mode)]
        print("   JPY {:<5}: unreachable among 980, 1,980, 2,980, 3,980, 4,980, 5,580, 9,980: {}".format(
            mode, ", ".join(bad) or "none"))
    print("   JPY 10%: residues mod 11 skipped: floor 10, half-up 5, ceil 1;  5,580 mod 11 = {}, "
          "2,980 mod 11 = {}".format(5580 % 11, 2980 % 11))
    print("C. US shelf price 49.00, tax added at checkout (SAMPLE combined rates, assumptions)")
    for r in ("0", "0.045", "0.0725", "0.095"):
        tot = F("49.00") + rnd(F("49.00") * F(r), F(1, 100), "half")
        print("   rate {:<6} checkout total {:>6}".format(r, fm(tot, F(1, 100))))

Single source and citation

Fan, Y. (2026). Purchasing-Power-Parity Distortions, Multi-Currency Psychological Price Endings and the Southeast Asia–Taiwan–Japan Pricing Matrix (Version 0.1.0), Chapter 6: Tax-Inclusive Display, Fees and Exchange-Rate Drift: How Endings Wear Down Before and After Checkout. 5D Library. DOI pending

DOI pending · monograph page goes live after publication · 5DL-B-134 · v0.1.0 · CC-BY-NC-ND-4.0

BibTeX
@book{fan2026134,
  author    = {Fan, Yafu},
  title     = {Purchasing-Power-Parity Distortions, Multi-Currency Psychological Price Endings and the Southeast Asia–Taiwan–Japan Pricing Matrix},
  year      = {2026},
  publisher = {5D Library},
  edition   = {0.1.0},
  note      = {DOI pending}
}

Other chapter answers in this book