Depreciation calculation is not as per expected change in Asset LIfe
PFB asset portfolio:
Asset Cost = 273,537,017.74
DPIS = 01-JAN-2017
Asset depreciation rate was 10% (10 years)
Monthly depreciation (Straight line) = Asset cost/Total #of periods = 273,537,017.74/120 = 2,279,475.15
Accumulated depreciation at end of FEB-25 = 2,279,475.15 X 98 months (Jan-17 to Feb-25) = 223,388,564.49
Net book value at FEB-25 = 273,537,017.74 - 223,388,564.49 = 50,148,453.25
In Mar-25, asset depreciation was changed to 4% (25 years) with amortized adjustment as Yes & amortization start date as 01-JAN-25.
New monthly depreciation = 273,537,017.74/300 = 911,790.06. Adjustment for 2 months =
(911,790.06 - 2,279,475.15) * 2 = - 2,735,370.18.
Total depreciation in MAR-25 = 911,790.06 + (- 2,735,370.18) = -1,823,580.12
NBV at end of MAR-25 =
50,148,453.25 - (-1,823,580.12) = 51,972,033.37
At this stage, system is calculating depreciation amount as 911,790.06 per month. Now, as per new asset life, remaining life = 300 - 98 = 202 months.
If asset depreciates with this amount for another 202 months (total 184,181,592.12), NBV will go into negative.