DB

The DB function in Google Sheets calculates the depreciation of an asset for a specified period using the fixed-declining balance method. It's a staple for accountants and finance teams who need to model how an asset's value decreases over time. Dive into our comprehensive guide to learn how it works.

Parameters

• cost: The initial cost of the asset.
• salvage: The value of the asset at the end of its useful life.
• life: The number of periods over which the asset depreciates.
• period: The period for which you want to calculate depreciation.
• [month]: [Optional] The number of months in the first year of depreciation. Defaults to 12.

Step-by-Step Tutorial

1. Calculating first-year depreciation:

   • Example: =DB(10000, 1000, 5, 1)
   • Result: approximately 3690 (the depreciation amount for period 1)

2. Calculating depreciation for a partial first year:

   • Example: =DB(10000, 1000, 5, 1, 6)
   • Result: adjusts the first-year depreciation based on 6 months instead of a full 12.

Use Cases and Scenarios

1. Fixed Asset Accounting: Track the declining value of equipment, vehicles, or machinery over their useful life.
2. Tax Reporting: Calculate depreciation schedules for tax filings using the declining balance method.
3. Budgeting and Forecasting: Project future book values of company assets.

Related Functions

• DDB: Calculates depreciation using the double-declining balance method.
• SLN: Calculates depreciation using the straight-line method.
• SYD: Calculates depreciation using the sum-of-years-digits method.

Related Articles

No related articles available for the DB function.