Syntax
=DB(cost, salvage, life, period, [month])Arguments
| Argument | Required | Description |
|---|---|---|
cost | Required | The initial cost |
salvage | Required | The value at the end of its life |
life | Required | The number of periods of its life |
period | Required | The period |
month | Optional | Months in the first year (12 when left out) |
How to use DB
DB takes 4 required arguments and 1 optional argument. Type =DB( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=DB(1000000, 100000, 6, 1, 7)Result =DB(1000000, 100000, 6, 2, 7)Result =DB(1000000, 100000, 6, 7, 7)Result Related financial functions
- COUPNUMReturns the number of coupons payable between the settlement date and maturity.
- COUPPCDReturns the coupon date on or before the settlement date.
- CUMIPMTReturns the total interest paid on a loan between two periods.
- CUMPRINCReturns the total principal paid on a loan between two periods.
- DDBReturns the depreciation of an asset for a period with the double declining balance method or another factor.
- DISCReturns the discount rate of a security.
- DOLLARDEConverts a price written as a whole number and a fraction (like 1.02 meaning 1 and 2/16) to a decimal number.
- DOLLARFRConverts a decimal price to a whole number and a fraction written after the decimal point.
- DURATIONReturns the Macaulay duration in years of a security that pays periodic interest, for 100 face value.