View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Why does Excel's DDB formula never depreciate the whole amount?

Conceptually, depreciate 100 by 10%, you get 90, depreciate that by 10% and
you get 81, depreciate that by 10% and you get 72.9 and depreciate that by
10% and you get 65.61, etc. It never gets to zero.

Tyro

"brandi7862" wrote in message
...
Why does Excel's DDB formula never depreciate the whole amount when the
salvage value = 0? It always leaves a few hundred dollars left to
depreciate
-- I've tried tons of examples and they all do this.