|
Sorry, I misunderstood your first post. Having read it more closely, it would be helpful to know what method of depreciation you're using to calculate your values. For example:
The original cost of your asset is $10,000. The salvage value is $5000 after the asset has been fully depreciated. You decide that this asset's useful life is 5 years. The following formula will calculate the depreciation for the fifth year using the sum of years digits depreciation method.
=SYD(cost, salvage, life, period)
=SYD(10000,5000,5,5) returns: $333.33
The conditional method of deriving/assigning values will work for you, however, there may be a superior method when making your initial calculation.
__________________
"The gift of liberty is like that of a horse, handsome, strong, and high-spirited. In some it arouses a wish to ride; in many others, on the contrary, it increases the desire to walk."
-- Massimo d'Azeglio
|