DEPDB(<N current value>, <N rate>, <N periods>)
Computes depreciation of an item as a percentage of its current value.
Returns <expN> total depreciation over number of <periods>.
<rate> is the rate of depreciation per time period as a decimal fraction.
<periods> is the number of time periods.
* Depreciation over 6 months of item valued at
* $10,000 with annual depreciation of 10%
* Months are represented by <n>/12
m_deprec = DEPDB( 10000, .10, 6/12 )
* Depreciation of same item over ten years
m_deprec = DEPDB( 10000, .10, 10 )
Placed in the Public Domain by Tom Rettig Assoc.