Hi Balan,

I know nothing of accounting, however, I am sure there is a statistical
relationship in your problem. I'd just like to check something first
before I go further down this line.

Using your example, if I put 1000 in A1 and put =A1-(10/100*A1) in A2
and then drag it down to A70.

This will show that it will be 67 years before the value is less than $1.
It will also show that after 46 years there will be less than $1
depreciation
each year. Is this correct? And which figure are you trying to achieve?

There is a logarithmic relationship to this problem and I think the
end result will be a nice neat formula that will handle different
percentages and different asset values, but I need some
more info as to what you are trying to achieve.

Regards
Martin



"Balan" wrote in message
...
Kindly tell me whether there is any formula or readymade function to find
out
the number of years required to depreciate an asset fully ( minimum value
$
1)using a declining balance method. For example, if my asset is worth $
1000
now and it has to be depreciated at 10% / year i.e., value at the end of
the
1st yr would be $900, second yr $810 and so on. I want the year to be
calculated until the value becomes $1 . The minimum depreciation during
any
year should be $1 i.e., if it happens that in any year the depreciation
will
be less $ 1 , the minimum depreciation to be provided would be $1 so as to
reach balance asset value of $1. I could arrive at the value using a
table.
But I am looking for a short cut.