Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.

How To Use in Sheets

DB(cost, salvage, life, period, [month])

External Links

Google Sheets | Depreciation Functions - SLN, SYD, DB and DDB

Use Google Sheets to calculate straight-line or accelerated depreciation using the four depreciation functions. SLN - Straight Line, SYD - Sum of the Year's Digits, DB - Declining Balance, and DDB - Double Declining Balance.

0Better Sheets Tutorials

No videos yet. Stay tuned!