Easy Explanation Notes with Examples

DB function in Excel

Use

DB function (a Financial function) calculates depreciation of an asset by using the fixed-declining balance method over the useful life of the asset. To calculate depreciation based on the Double Declining (DDB) Method or another specified method, use the DDB function.

Syntax

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

cost is the initial cost to acquire the asset,

salvage is the remaining value of the asset after completing useful life,

life means total useful life of the asset,

period means the period for which depreciation needs to be calculated, and

[month] is an optional argument which specifies the number of month in a year, if omitted, it is assumed to be 12.

Example

Suppose, you purchase a car for $10,000, it is anticipated that the car will have the useful life of 10 years and its salvage value will be around $1,000. The DB function in Excel, calculates the yearly depreciation as under:

Formula:

Results:

Function Errors

Errors Occur if
#NUM! The supplied cost or salvage <0.
The supplied life or period ≤ 0.
The supplied [month]  ≤ 0 or > 12.
The supplied period > life.
#VALUE! The supplied arguments are non-numeric.

Related Functions

DDB function calculates depreciation of an asset by using the Double Declining (DDB) Method or another method specified by the user.

SLN function uses the straight-line depreciation method to find out the depreciation of an asset for one period.

SYD function is a Financial function, which returns the sum-of-years’ digits depreciation of an asset for a specific period.

VDB function calculates the depreciation of an asset, for a specified given period, by using any selected depreciation method, such as the double declining balance method etc.

AMORLINC function calculates depreciation of an asset, on a prorated basis, for a specified accounting period.

AMORDEGRC Function returns the depreciation of an asset for each accounting period till a useful life of an asset.




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved