cancel
Showing results for 
Search instead for 
Did you mean: 

Percentage Rate on Ordinary Depreciation

anish_mathew3
Explorer
0 Kudos

Hello All,

I have been trying to figure out how the system come up with the percentage rate number for the depreciation areas?.

I have an asset that is being depreciated with half month setting for 3 out of 24 periods. I also did a depreciation to the day for the same asset for 45 days. The numbers don't match even though the base value is the same. Percentage rate on the depreciation to the day is much less than the half month depreciation. Can someone shed some light where to look at?

Any help is greatly appreciated. Thank you for your help.

AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

Please check Depreciation key and Depreciation methods like multi level method, Decline balance methods , base method and period control method.

if possible plz share sap screens.

Thank you

anish_mathew3
Explorer
0 Kudos

Hi Ravindra,

Thank you for your suggestion. I verified the depreciation methods assigned to the depreciation key, but still not able to figure out how the system calculates the depreciation percentage rate (e.g: 33.578656 and 42.105263 ). Below are the screen shots from the 2 depreciation keys. I copied Z21Q key from Z20Q which is a copy of M20Q (standard SAP) but Z21Q depreciation area has the "depreciation to the day" enabled. I want to calculate the depreciation from mid November, so in the mid month setting it will be 3/24 dep.period and on the day depr it will 47/365 dep.periods. The Amount calculated are way off for the same period based on the percentage rate.

Z21Q

Z20Q

former_member351125
Contributor
0 Kudos


Youa re using 200% declining balance method  mid quarter convention. I assume this depreciation key is for US company codes. The formula in getting the depreciation rate is below.

Period Factor

QuarterPeriodOrd Dep start DatePeriod FactorPeriod Factor
11-316-Feb=(12-1.5)/120.875
24-616-May=(12-4.5)/120.625
37-916-Aug=(12-7.5)/120.375
410-1216-Nov=(12-10.5)/120.125

First year of the asset

Depreciation Rate = Asset Cost*(1/UL)*DecliningFactor*periodFactor

Declining Factor is 2 for double declining balance (on your case)

Declining Factor is 1.5 for 150% declining balance

On the next years

Depreciation Rate =NBV from previous year*(1/UL)*DecliningFactor

When the straight line is greater than the declining balance, your depreciation will change from declining to straight-line. This is called change over year.

Change over year = is the year when you change depreciation calculation from one method to another. Below is the year when depreciation change from declining balance to straight-line.

ULChangeoveryear
32
54
75
157

Hope this helps.

Thanks!

Jhero

anish_mathew3
Explorer
0 Kudos

Thank you very much for your detailed answer.

I was missing the depreciation rate calculation formula and you explained it well.

Answers (0)