Manuals/calci/db

DB(C, Salvage, L, P, M)

Where

• $C$ is the initial cost of an asset,
• $Salvage$ is the value at the end of depreciation,
• $L$ is life of an asset that indicates the number of periods over which the asset is being depreciated,
• $P$ is the period for which depreciation is to be calculated, and
• $M$ is the number of months in the first year.

DB() calculates the depreciation of an asset for a specified period.

Description

DB(C, Salvage, L, P, M)

• Depreciation is the decrease in value of assets.
• DB() calculates the depreciation using the fixed-declining balance method.
• If $Salvage$ <0 Calci displays #N/A error message.
• If $C$ ,$L$, $P$, $M$ <=0, Calci displays #N/A error message.
• Argument $M$ is optional. If omitted, Calci assumes it to be 12.

Examples

Consider the following example that shows the use of DB function:

200,000	1,000,000
1000	10000
5	2
1	1
6	7

=DB(A1,A2,A3,A4,A5) : Calculates the depreciation for the values in the range A1 to A5. Displays 65300 as a result.
=DB(A1,A2,A3,A4) : Calculates the depreciation for the values in the range A1 to A4. 
M is assumed to be 12.Displays 130600 as a result.
=DB(B1,B2,B3,B4,B5) : Calculates the depreciation for the values in the range B1 to B5. 
Displays 525000 as a result.
=DB(20000,2000,5,4.5,6) : Displays 2396.28818079 as a result.

See Also

• DDB

References

• Depreciation