Fixed Assets - EBS (MOSC)

MOSC Banner

Formula Depreciation (Need 6 month life with different rates each MONTH)

edited Jul 5, 2011 8:20AM in Fixed Assets - EBS (MOSC) 5 commentsAnswered
Hi

I am trying to create a depreciation formula that will depreciate an asset over 6 months with a different rate each month.

Can anyone help? I have tried several formulas but no luck.

Example Asset life 6 months, Cost 10,000
Month 1 35.00%  so depreciation = 3,500 (10,000 * .35)
Month 2 25.00% so depreciation = 2,500 (10,000 * .25)
Month 3 10.00% so depreciation = 1,000 (10,000 * .10)
Month 4 10.00% so depreciation = 1,000 (10,000 * .10)
Month 5 10.00%  so depreciation = 1,000 (10,000 * .10)
Month 6 10.00% so depreciation = 1,000 (10,000 * .10)
 

- Terry

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