You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom Depreciation Rate Table

Accepted answer
72
Views
5
Comments
in Assets 5 comments

The Rule of depreciation on vehicles is the following:

5 years 0 months

3% of cost for months 1 – 12

2.5% of cost for months 13-24

1% of cost for remaining months until NBV=0

We use daily prorate convention, so we have 365 pediods per year - over 1800 total

When we try to set up the rates table in Oracle, the system is requiring the sum of all years rates for each period to add up to 1 if it is cost based or if it is NBV based the last year rate should be 1. Neither is satifying the client's requirement.

Do you have a suggestion on how to handle this or if there is a workaround ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!