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 depreciation on

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