Functions
DB
Fixed-declining balance depreciation
Try it
When to use it
When should I use DB instead of SLN or DDB?
Use DB (fixed-declining balance) when an asset loses value faster early in its life but you want a fixed-rate method that is less aggressive than double-declining balance.
Used in
Syntax
DB(cost, salvage, life, period, [month])Examples
=DB(100,50,10,2) // => 6.2511
=DB(100,50,10,2,10) // => 6.325916666666667