Declining Balance Formula
We need the system to calculate depre 40% for 4 yrs and remaining balance (100%) for the last year. The Life is 5 yrs.
For year 1-4 , it should multiply with Rate= .4
For Year 5 , It should multiply with Rate =1
Formula:
DECODE(SIGN(<Remaining Life2> – 4), 1, 1, 0, 0.4, –1, 0.4)
Please advice whether the above formula is correct or not.
Regards.
For year 1-4 , it should multiply with Rate= .4
For Year 5 , It should multiply with Rate =1
Formula:
DECODE(SIGN(<Remaining Life2> – 4), 1, 1, 0, 0.4, –1, 0.4)
Please advice whether the above formula is correct or not.
Regards.
0