0
Former Member
Oct 31, 2011 at 02:36 PM

# 100% depreciation when Net Value is less than 10%

34 Views

HI,

I have the below requirements in order to create an appropriate depreciation key:

1. calculate a fix percentage of 45% depreciation with base value the NET AMOUNT and not the acquisition value.

2. when the NET AMOUNT is going to fall under the 10% of the acquisition value then the asset has to be depreciated full 100%.

For the 1rst requirement I went to afams and I made a multilev.meth z45 where the BaseVal is 24 (Net book value) and the rate 45%.

For the 2nd, I made a depreciation key with two phases.

In the first phase I assigned the multilev.meth z45 and I use the changeover method 2 (Changeover when net book value percentage reached) and Changeover rate: 10.

In the second phase I have assign a multilev method with 100% depreciation percentage.

The problem is that the system go to the phase 2 (100% depreciation) when already the net book value is under 10% of acquisition value (from the previous depreciation run ) and not when is going to fall under 10%.

What system do for an asset with Acquisition value 1000 (01.01.2011):

Year Acq.Val. Ord.Depr. NetBook V % of NetBook Val

2011 1.000,00 450,00- 550,00 EUR 55%

2012 1.000,00 247,50- 302,50 EUR 30%

2013 1.000,00 136,13- 166,37 EUR 17%

2014 1.000,00 74,87- 91,50 EUR 09%

2015 1.000,00 91,49- 0,01 EUR 100%

What is the required:

Year Acq.Val. Ord.Depr. NetBook V % of NetBook Val

2011 1.000,00 450,00- 550,00 EUR 55%

2012 1.000,00 247,50- 302,50 EUR 30%

2013 1.000,00 136,13- 166,37 EUR 17%

2014 1.000,00 166,36 0,01 EUR 100%

Any idea?