how to calculate depreciation rate under wdv method in excel?
Depreciation for the year is the rate in percentage multiplied by the WDV at the beginning of the year. For example, for Year I – Depreciation = 10,00,000 x 12.95% i.e. 1,29,500. New WDV for subsequent year will be previous WDV minus Depreciation already charged.