Question: how to calculate depreciation rate under wdv method in excel?
Answer: 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.