Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
81% OFF online library of tutorials for mastering Google Sheets
DB()
Description
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 featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.