Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- Tom Rettigs Library - depvaldb(<n price>, <n rate>, <n periods>) http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 DEPVALDB(<N price>, <N rate>, <N periods>)
 Computes the depreciated value of an asset using declining-balance method.
 Returns <expN> value of asset after specified time.

 <price> is the original purchase price.
 <rate> is the rate of depreciation per period.
 <periods> is the number of time periods.

 * Value of an item originally purchased for $10,000 after 6 months,
 * assuming 10% per year rate of depreciation.
 *   Months are represented by <n>/12
 m_value = DEPVALDB( 10000, .10, 6/12)

 * Value of the same item after 10 years
 m_value = DEPVALDB( 10000, .10, 10)


             Placed in the Public Domain by Tom Rettig Assoc.

See Also: DEPDB() DEPSL() DEPVALSL()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson