[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 DEPVALSL(<N price>, <N value>, <N life>, <N time>)
 Computes depreciated value of an asset using straight-line method.
 Returns <expN> value of asset after specified time.

 <price> is the original purchase price.
 <value> is the anticipated resale value.
 <life> is the anticipated service life.
 <time> is the time of possession.

 * Value of an item originally purchased for $10,000 after 6 months.
 * Anticipated resale value is $1,000.  Expected life is 5 years.
 m_value = DEPVALSL( 10000, 1000, 60, 6)
 * <life> and <time> are both months

 * Value of the same item after 4 years.
 m_value = DEPVALSL( 10000, 1000, 5, 4)
 * <life> and <time> are both years


             Placed in the Public Domain by Tom Rettig Assoc.

See Also: DEPDB() DEPSL() DEPVALDB()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson