Menu
EXCEL DB FUNCTION
Excel DB Function Introduction
The Excel DB function computes an asset’s depreciation using the Fixed Declining Balance Method for each period of the asset’s life.
Description of Excel DB Function
Syntax :
=DB( cost, salvage, life, period, [month] )
Parameters :
- The following are the arguments.
Cost :
- The asset’s initial purchase price.
Salvage :
- The asset’s worth at the conclusion of depreciation.
The number of periods over which an asset will be depreciated.
Period :
- The time period for which we wish to compute
Month :
- An optional integer input that defines how many months of the year are utilised in the first period of depreciation computation.
- The number of months depreciated in the previous period is therefore computed as 12 – [month].
If the [month] option is missing, the default value of 12 is used.
Step By Step Guide of DB Function
Example :
The DB function is used in the spreadsheet below to calculate the annual depreciation of an asset that costs $10,000 at the start of year 1 and has a salvage value of $1,000 after 5 years.
Key Points
- #NUM! – Occurs if any of the following conditions are met: the supplied cost or the supplied salvage argument is 0; the supplied life or the supplied period argument is 0; The supplied [month] argument is 0 or greater than 12; the supplied period is greater than life (and the [month] argument is ignored); the supplied period is greater than life+1.
- #VALUE! – This error occurs if any of the supplied parameters is not a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
