=A1-(A1*(1-0.1)^5)
where A1 houses 250,000 and 5 is the number of years from 1998 thru 2002


"Luqman" wrote in message
...
I have an asset which was purchased in 1998 worth 250,000/=
I sold this Asset in 2003. The Depreciation Rate is 10% p.a. for Declining
Balance Method.
How much depreciation is charged from 1998 till 2002.
As per law, depreciation for the year of sale is not calculated.

What excel formula will give me the result.

Cost in 2002 was : 250000
The Accumulated Dep. in 2002 was : 102378 <<<<< This I need to calculate
through Excel Formula
The written down value in 2002 was : 147622

I have given the values so that you can judge what formula will return the
above results.


Best Regards,

Luqman