# Manuals/calci/db

Jump to navigation
Jump to search

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

Where

- is the initial cost of an asset,
- is the value at the end of depreciation,
- is life of an asset that indicates the number of periods over which the asset is being depreciated,
- is the period for which depreciation is to be calculated, and
- 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 <0 Calci displays #N/A error message.
- If ,, , <=0, Calci displays #N/A error message.
- Argument 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. Displays65300as 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.Displays130600as a result. =DB(B1,B2,B3,B4,B5) : Calculates the depreciation for the values in the range B1 to B5.

Displays525000as a result. =DB(20000,2000,5,4.5,6) : Displays2396.28818079as a result.