Fixed Assets - EBS (MOSC)

MOSC Banner

JP-200DB Depreciation Calculation

edited Nov 29, 2019 4:05AM in Fixed Assets - EBS (MOSC) 8 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center