"I am facing problem in Calculation WDV method by a single formula in Excel. I also want to know if an asset ( Furniture and fxiture) is purchased on 1-08-1992 for Rs. 10 crore, which depreciated @ 18.10%. How to know its WDV as on 31.03.2011. As per my calculation, Rs. 10 crore multiplied by (100-98.16) = Rs. 18, 43, 648.12.
(**98.16 is multiplying factor of 18.10% after 20 years) Is my interpretaion is correct. Need early reply as to finish audit ASAP.
Whether in WVD method daywise calculation required if an asset is purchased in any time mid of year (As we do in SLM Basis). If yes, then how to calculate WDV in EXCEL