Table: Oracle Assets gets the annual depreciation rate from a rate table.
Calculated: For straight-line depreciation, the depreciation program calculates the annual depreciation rate by dividing the life (in years) into one. Calculated methods spread the asset value evenly over the life.
You can accommodate new depreciation methods using rate tables instead of formulas. Add the appropriate rates to create a new method at any time.
Oracle Assets uses asset recoverable cost or net book value, salvage value, date placed in service, prorate convention, depreciation method, and life to calculate depreciation for life-based methods. Oracle Assets, using rates from a table or calculated rates, depreciates assets with life-based depreciation methods to be fully reserved at the end of a fixed lifetime.
For example, some reporting authorities require that you prorate depreciation according to the number of months you hold an asset in its first fiscal year of life. In this case, your prorate calendar has 12 prorate periods and your rate table has 12 rates (one for each month of the year) per year of life. Other governments require that you prorate depreciation according to the number of days that you hold an asset in its first fiscal year of life. This means that there is a different depreciation rate for each day of the year. Thus, the number of rates in your rate table is a factor of 365. For example, the rate table would have 1825 rates for an asset with a 4 year life (365 x 5). This means that your prorate calendar must contain 365 prorate periods and correspondingly, your rate table must have 365 rates (one for each day of the year) for each year of life.
To determine the rates, calculate an annual depreciation rate for each fiscal year of an asset's life, for each period in your prorate calendar. This rate is the annual rate for the year for an asset where the prorate date falls into this prorate period. You do not need to calculate the depreciation rate for each depreciation period in each year of the asset life. You only enter annual depreciation rates in the Annual Rate field of the Rates window. The depreciation program uses this annual depreciation rate to determine the fraction of an asset cost or net book value to allocate to this fiscal year. It then uses the depreciation calendar and divide depreciation flag to spread the annual depreciation over the depreciation periods of the fiscal year.
Annual Depreciation Amount = Depreciation Rate x Depreciation Calculation Basis x Fraction of Year Held
Oracle Assets standard rate tables contain 12 rates per year of life. If your government requires daily rates, set up the appropriate rates using the Depreciation Methods window.
For assets that have a prorate period of 7, the rate table in Table 1 - 13 shows a 20% annual depreciation rate for the first year of life. If, however, you had used a prorate convention that resulted in a prorate period at the beginning of your fiscal year, Oracle Assets would have used the full rate for the year (40%).
For the asset in this example, Oracle Assets uses a rate of 20%, so the depreciation for fiscal 1996 is $2,000 (20% of $10,000).
You can specify whether to start taking depreciation in the period of the date placed in service or the prorate date using the Depreciate When Placed In Service flag for the prorate convention. If you elect to start depreciation in the period corresponding to the date placed in service, Oracle Assets starts to depreciate the asset in AUG-95, and the depreciation for each period is $200 ($2,000 divided by 10--the number of periods from August to May).
If you elect to start depreciation in the period corresponding to the prorate date, Oracle Assets does not start to depreciate the asset until DEC-95, and the depreciation for each period from DEC-95 to MAY-96 is $333.33 ($2,000 divided by 6--the number of periods from December to May).
Similarly, the rates for 1995, 1996, and 1997 are 19.20%, 11.52%, and 11.52% respectively. Oracle Assets calculates annual depreciation for these years as $1,920, $1,152, and $1,152 and divides these amounts evenly across all the accounting periods in the appropriate fiscal years.