Syntax
=DDB(cost, salvage, life, period, [factor])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 |
factor | Optional | The rate the balance declines at (2 when left out) |
How to use DDB
DDB takes 4 required arguments and 1 optional argument. Type =DDB( 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.
=DDB(2400, 300, 10, 1, 2)Result =DDB(2400, 300, 10, 10)Result =DDB(2400, 300, 3650, 1)Result Related financial functions
- 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.
- DBReturns the depreciation of an asset for a period with the fixed declining balance method.
- 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.
- EFFECTReturns the effective annual interest rate from a nominal rate and the compounding periods per year.