View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Why does Excel's DDB formula never depreciate the whole amount?

That's what declining balance does. When you're always reducing something
by, say 20%, you will never get to zero. It's got nothing to do with Excel,
it's the mathmatics of declining balance depreciation (or geometric
progressions, if you want to generalize).

Regards,
Fred

"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.