Use the DB function to calculate declining balance depreciation

Use the DB function to calculate declining balance depreciation

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

Step 1: Define the initial cost, salvage value, useful life, and depreciation period, and optionally the number of months in the first year.

Step 2: Enter the formula in a cell and press Enter.

For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com