Venkatakrishnan
New Member
Hi
Attached the working file of WDV calculation. Request the below help from the team.
1. Based on the start date and end date of the asset life the WDV for each year needs to be generated monthly, to the relevant period (say if a asset start date is 10/01/2020 then the depreciation should be for 21 days for Jan'20 the rest depreciation for balance relevant periods
2. If we change the useful life, the calculation of WDV per year and monthly depreciation value should have been changed to the relevant period.
3. By maintaining 5% residual value the WDV depreciation rate considered, hence final WDV should be maintained for all asset 5% which is coming correctly.
For referring the file : Sheet : Data : working given for yearly depreciation, depreciation calculation is not dynamic, if we change the start date and add the useful life the depreciation calculation should end at end date and accurate depreciation to be calculated for each month. Also marked in blue colour the residual WDV value based on the formula which is right.
Sheet : Dep rates : Calculated the each year WDV depreciation rate
Expecting the positive reply from the team, thanks in advance.
Regards
K Venkatakrishnan
Attached the working file of WDV calculation. Request the below help from the team.
1. Based on the start date and end date of the asset life the WDV for each year needs to be generated monthly, to the relevant period (say if a asset start date is 10/01/2020 then the depreciation should be for 21 days for Jan'20 the rest depreciation for balance relevant periods
2. If we change the useful life, the calculation of WDV per year and monthly depreciation value should have been changed to the relevant period.
3. By maintaining 5% residual value the WDV depreciation rate considered, hence final WDV should be maintained for all asset 5% which is coming correctly.
For referring the file : Sheet : Data : working given for yearly depreciation, depreciation calculation is not dynamic, if we change the start date and add the useful life the depreciation calculation should end at end date and accurate depreciation to be calculated for each month. Also marked in blue colour the residual WDV value based on the formula which is right.
Sheet : Dep rates : Calculated the each year WDV depreciation rate
Expecting the positive reply from the team, thanks in advance.
Regards
K Venkatakrishnan