[<<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