Year-by-year compounding
The tool applies the annual depreciation rate to the previous year's value, not to the original price, so each year's loss is computed against a shrinking base. That produces a running table: the same percentage every year, with dollar losses that decline steadily. Reading the row for the year you expect to sell gives the estimated resale value at that age.