Description
DB returns a number specifying the depreciation of an asset for a specific time period, using the fixed-declining balance method.
Overloads
DB (cost, salvage, life, period)
DB (cost, salvage, life, period, month)
Arguments
cost is a Number or Currency that specifies the initial cost of the asset. The value is non-negative and greater than or equal to salvage.
salvage is a Number or Currency that specifies the value of the asset at the end of its useful life. The value is non-negative.
life is a positive Number that specifies the length of the useful life of the asset.
period is a Number that specifies the period for which asset depreciation is calculated. The value is positive and less than or equal to life. The arguments life and period must have the same units.
month is an optional, positive Number that specifies the number of months in the first year. The default value is 12 months. Month must be greater than zero and less than or equal to 12.
Action
DB returns a number specifying the depreciation of an asset for a specific time period, using the fixed-declining balance method.
Examples
Suppose a business purchases a car for $25,000 at the beginning of March. The car is to be depreciated using the fixed-declining balance method and is to have a five year lifetime and a resell value, after that time, of $5,000.
DB(25000,5000,5,1,10)
Returns 5729.17. The depreciation on the car over the remaining ten months of the year is $5729.17.
DB(25000,5000,5,5,10)
Returns 2019.52. The depreciation in the last full year is $2019.52.
DB(25000,5000,5,6,10)
Returns 244.02. The depreciation in the last two months is $244.02.
Suppose a database table contains the following fields: {table.cost}, {table.salvage}, {table.purchaseDate}, and {table.lifetime}. The following formula can be used to calculate the depreciation using the fixed-declining balance method for the remainder of the first year for each record in the table.
DB ({table.cost}, {table.salvage}, {table.lifetime},1,12-Month({table.purchaseDate}))
Comments
This function is designed to work like the Excel function of the same name.