Skip to Content
author's profile photo Former Member
Former Member

100% depreciation when Net Value is less than 10%

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 31, 2011 at 04:37 PM

    Hi,

    You can use the following change over method:

    3 Changeover when net book value less than changeover amount

    best regards Bernhard

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.