Excel: depreciation: db function

Self-tutoring about Excel: the tutor mentions another neat function from it, this time about depreciation.

Let’s imagine one wants to calculate declining-balance depreciation for the following case: Purchase price of 10000, salvage of 1000, useful life of ten years: what is the depreciation expense during year 5?

Well, it seems that with Excel’s db function, =db(1000, 1000, 10, 5), one could discover said expense as 818.75.

Neat, eh?

Source:

support.microsoft.com