Syntax
=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])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 |
start_period | Required | The start of the span |
end_period | Required | The end of the span |
factor | Optional | The rate the balance declines at (2 when left out) |
no_switch | Optional | TRUE to never switch to straight line |
How to use VDB
VDB takes 5 required arguments and 2 optional arguments. Type =VDB( 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.
=VDB(2400, 300, 10, 0, 1)Result =VDB(2400, 300, 10*12, 6, 18)Result =VDB(2400, 300, 10, 0, 0.875, 1.5)Result Related financial functions
- SYDReturns the sum of years' digits depreciation of an asset for a period.
- TBILLEQReturns the bond equivalent yield of a Treasury bill.
- TBILLPRICEReturns the price per 100 face value of a Treasury bill.
- TBILLYIELDReturns the yield of a Treasury bill.
- XIRRReturns the internal rate of return of cash flows that happen on given dates.
- XNPVReturns the net present value of cash flows that happen on given dates.
- YIELDReturns the yield of a security that pays periodic interest.
- YIELDDISCReturns the annual yield of a discounted security.
- YIELDMATReturns the annual yield of a security that pays interest at maturity.