WDV Depreciation

[spycein]

Dear All,

I want a formula which gives me the return value of depreciation as per WDV method for a particular period.

For example,

Asset Value Rs.4160/-

Scrap Value Rs.525/-

Remaining life (in days) 420 days.

Depreciation Value for 365 days Rs.3558/-.

The formula should return the value Rs.3558/- as depreciation for 365 days.



Thanks