How to create Formula type Depreciation Method with different Depreciation Rates for different Perio

Jan 9, 2024 1:17PM

Hi,

I have a

requirement, where in Asset life is 7 years and first 7 years asset should be depreciated 60% and remaining 7 years depreciation should be 40%.

I have created a formula like

Decode ( Sign ( Ceiling ( <Remaining life 2> - 1 ) ) , 1 , .6 , 0 , .4 , - 1 , .4 )

if remaining life is 2-1=1 then depreciation should be .6 else .4

but I also have 4,4,5 calendar so my formula is not working for dec'24, if I acquire an asset in the month of Dec'23.

It calculated depreciation at the rate of .6 till Dec'24 and then on the rate of .4, however Dec'24 onward it should have calculated on .4%.

any idea...where I went wrong.

Also I didn't go for table method because of below reason