JP-200DB Depreciation Calculation
Hi,
Can someone please explain me how depreciation calculation happens for all 5 years with following financial information.
Depreciation Calendar: January to December
Prorate Convention: Monthly
Asset DPIS & Prorate Date: 01-Mar-2013
Depreciation Method: JP-200DB 5 (Japan 200 Declining Balance 5 years)
Formula: "DECODE(SIGN(FLOOR(COST*GUARANTEE_RATE)-FLOOR(BEGIN_NBV*ORIGINAL_RATE)),1, REVISED_RATE, ORIGINAL_RATE)"
"DECODE(SIGN(FlOOR(NVL(COST,0)*.108)-FLOOR(NVL(ADJUSTED_COST,0)*.4)),1, .5, .4)"
Cost of Asset:$5000
No Salvage value and no depreciation limit.
Thanks
BM