Re: $$Excel-Macros$$ WDV Method

2014-08-16 Thread Vaibhav Joshi
The formula gives you annual rate hence in last year it gives 12 months dep & not for remaining period. Cheers!! On Sat, Aug 16, 2014 at 11:01 AM, Kanwaljit Singh Dhunna < kanwal...@gmail.com> wrote: > Dear All, > > I am trying to calculate Written Down Value Rate for calculating > depreciatio

$$Excel-Macros$$ WDV Method

2014-08-15 Thread Kanwaljit Singh Dhunna
Dear All, I am trying to calculate Written Down Value Rate for calculating depreciation on the basis of WDV method by using the following formula. Rate = [1 - (Scrap Value / Total Cost ) ^ (1/Life) ] * 100 If the life is in Number of Exact years, the rate derived is accurate, but if the life of