The following examples illustrate the effect on your assets and your accounts when you specify different revaluation rules.
Example 1: You place an asset in service in Year 1, Quarter 1. The asset cost is $10,000, the life is 5 years, and you are using straight-line depreciation.
In Year 2, Quarter 1 you revalue the asset using a revaluation rate of 5%. Then in Year 4, Quarter 1 you revalue the asset again using a revaluation rate of -10%.
Revaluation Rules:
Revalue Accumulated Depreciation = Yes
Amortize Revaluation Reserve = No
Retire Revaluation Reserve = No
Oracle Assets bases the new depreciation expense on the revalued remaining net book value.
In Year 5, Quarter 4, at the end of the asset's life, you retire the asset with no proceeds of sale or cost of removal.
The effects of the revaluations are illustrated in the following table:
| Period (Yr, Qtr.) | Asset Cost | Deprn. Expense | Accum. Deprn. | Reval. Reserve |
|---|---|---|---|---|
| Yr1,Q1 | 10,000.00 | 500.00 | 500.00 | 0.00 |
| Yr1,Q2 | 10,000.00 | 500.00 | 1,000.00 | 0.00 |
| Yr1,Q3 | 10,000.00 | 500.00 | 1,500.00 | 0.00 |
| Yr1,Q4 | 10,000.00 | 500.00 | 2,000.00 | 0.00 |
| Reval. 1 5% | 10,500.00 | 0.00 | *2,100.00 | **400.00 |
| Yr2,Q1 | 10,500.00 | 525.00 | 2,625.00 | 400.00 |
| Yr2,Q2 | 10,500.00 | 525.00 | 3,150.00 | 400.00 |
| Yr2,Q3 | 10,500.00 | 525.00 | 3,675.00 | 400.00 |
| Yr2,Q4 | 10,500.00 | 525.00 | 4,200.00 | 400.00 |
| Yr3,Q1 | 10,500.00 | 525.00 | 4,725.00 | 400.00 |
| Yr3,Q2 | 10,500.00 | 525.00 | 5,250.00 | 400.00 |
| Yr3,Q3 | 10,500.00 | 525.00 | 5,775.00 | 400.00 |
| Yr3,Q4 | 10,500.00 | 525.00 | 6,300.00 | 400.00 |
| Reval. 2 -10% | 9,450.00 | 0.00 | *5,670.00 | **-20.00 |
| Yr4,Q1 | 9,450.00 | 472.50 | 6,142.50 | -20.00 |
| Yr4,Q2 | 9,450.00 | 472.50 | 6,615.00 | -20.00 |
| Yr4,Q3 | 9,450.00 | 472.50 | 7,087.50 | -20.00 |
| Yr4,Q4 | 9,450.00 | 472.50 | 7,560.00 | -20.00 |
| Yr5,Q1 | 9,450.00 | 472.50 | 8,032.50 | -20.00 |
| Yr5,Q2 | 9,450.00 | 472.50 | 8,505.00 | -20.00 |
| Yr5,Q3 | 9,450.00 | 472.50 | 8,977.50 | -20.00 |
| Yr5,Q4 | 9,450.00 | 472.50 | 9,450.00 | -20.00 |
| Retire | 0.00 | 0.00 | 0.00 | -20.00 |
REVALUATION 1
Year 2, Quarter 1, 5% revaluation
| *Accumulated Depreciation = Existing Accumulated Depreciation + [Existing Accumulated Depreciation x (Revaluation Rate / 100)] |
|---|
| 2,000 + [2,000 X (5/100)] = 2,100 |
| **Revaluation Reserve = Existing Revaluation Reserve + Change in Net Book Value |
|---|
| 0 + (8,400 - 8,000) = 400 |
| Account Description | Debit | Credit |
|---|---|---|
| Asset Cost | 500.00 | |
| Revaluation Reserve | 400.00 | |
| Accumulated Depreciation | 100.00 |
REVALUATION 2
-10% revaluation in Year 4, Quarter 1:
| Account Description | Debit | Credit |
|---|---|---|
| Revaluation Reserve | 420.00 | |
| Accumulated Depreciation | 630.00 | |
| Asset Cost | 1,050.00 |
Retirement in Year 5, Quarter 4:
| Account Description | Debit | Credit |
|---|---|---|
| Accumulated Depreciation | 9,450.00 | |
| Asset Cost | 9,450.00 |
Example 2: You place an asset in service in Year 1, Quarter 1. The asset cost is $10,000, the life is 5 years, and you are using straight-line depreciation.
In Year 2, Quarter 1 you revalue the asset using a revaluation rate of 5%. Then in Year 4, Quarter 1 you revalue the asset again using a revaluation rate of -10%.
Revaluation Rules:
Revalue Accumulated Depreciation = No
Amortize Revaluation Reserve = No
Retire Revaluation Reserve = Yes
For the first revaluation, the asset's new revalued cost is $10,500. Since you do not revalue the accumulated depreciation, Oracle Assets transfers the balance to the revaluation reserve in addition to the change in cost.
Since you are also not amortizing the revaluation reserve, this amount remains in the revaluation reserve account until you retire the asset, when Oracle Assets transfers it to the appropriate revaluation reserve retired account. Oracle Assets bases the new depreciation expense on the revalued net book value.
For the second revaluation, the asset's revalued cost is $9,450. Again, since you do not revalue the accumulated depreciation, Oracle Assets transfers the balance to the revaluation reserve along with the change in cost.
You retire the asset in Year 5, Quarter 4, with no proceeds of sale or cost of removal.
The effects of the revaluations are illustrated in the following table:
| Period (Yr, Qtr.) | Asset Cost | Deprn. Expense | Accum. Deprn. | Reval. Reserve |
|---|---|---|---|---|
| Yr1,Q1 | 10,000.00 | 500.00 | 500.00 | 0.00 |
| Yr1,Q2 | 10,000.00 | 500.00 | 1,000.00 | 0.00 |
| Yr1,Q3 | 10,000.00 | 500.00 | 1,500.00 | 0.00 |
| Yr1,Q4 | 10,000.00 | 500.00 | 2,000.00 | 0.00 |
| Reval. 1 5% | 10,500.00 | 0.00 | 0.00 | *2,500.00 |
| Yr2,Q1 | 10,500.00 | **656.25 | 6,56.25 | 2,500.00 |
| Yr2,Q2 | 10,500.00 | 656.25 | 1,312.50 | 2,500.00 |
| Yr2,Q3 | 10,500.00 | 656.25 | 1,968.75 | 2,500.00 |
| Yr2,Q4 | 10,500.00 | 656.25 | 2,625.00 | 2,500.00 |
| Yr3,Q1 | 10,500.00 | 656.25 | 3,281.25 | 2,500.00 |
| Yr3,Q2 | 10,500.00 | 656.25 | 3,937.50 | 2,500.00 |
| Yr3,Q3 | 10,500.00 | 656.25 | 4,593.75 | 2,500.00 |
| Yr3,Q4 | 10,500.00 | 656.25 | 5,250.00 | 2,500.00 |
| Reval. 2 -10% | 9,450.00 | 0.00 | 0.00 | *6,700.00 |
| Yr4,Q1 | 9,450.00 | **1,181.25 | 1,181.25 | 6,700.00 |
| Yr4,Q2 | 9,450.00 | 1,181.25 | 2,362.50 | 6,700.00 |
| Yr4,Q3 | 9,450.00 | 1,181.25 | 3,543.75 | 6,700.00 |
| Yr4,Q4 | 9,450.00 | 1,181.25 | 4,725.00 | 6,700.00 |
| Yr5,Q1 | 9,450.00 | 1,181.25 | 5,906.25 | 6,700.00 |
| Yr5,Q2 | 9,450.00 | 1,181.25 | 7,087.50 | 6,700.00 |
| Yr5,Q3 | 9,450.00 | 1,181.25 | 8,268.75 | 6,700.00 |
| Yr5,Q4 | 9,450.00 | 1,181.25 | 9,450.00 | 6,700.00 |
REVALUATION 1
5% revaluation in Year 2, Quarter 1:
| Account Description | Debit | Credit |
|---|---|---|
| Asset Cost | 500.00 | |
| Accumulated Depreciation | 2,000.00 | |
| Revaluation Reserve | 2,500.00 |
REVALUATION 2
-10% revaluation in Year 4, Quarter 1:
| Account Description | Debit | Credit |
|---|---|---|
| Accumulated Depreciation | 5,250.00 | |
| Asset Cost | 1,050.00 | |
| Revaluation Reserve | 4,200.00 |
Retirement in Year 5, Quarter 4:
| Account Description | Debit | Credit |
|---|---|---|
| Accumulated Depreciation | 9,450.00 | |
| Revaluation Reserve | 6,700.00 | |
| Revaluation Reserve Retired Gain | 6,700.00 | |
| Asset Cost | 9,450.00 |
Example 3: You place an asset in service in Year 1, Quarter 1. The asset cost is $10,000, the life is 5 years, and you are using straight-line depreciation.
In Year 2, Quarter 1 you revalue the asset using a rate of 5%. Then in Year 4, Quarter 1 you revalue the asset again using a rate of -10%.
Revaluation Rules:
Revalue Accumulated Depreciation = No
Amortize Revaluation Reserve = Yes
For the first revaluation, the asset's new revalued cost is $10,500. Since you do not revalue the accumulated depreciation, Oracle Assets transfers the entire amount to the revaluation reserve. Since you are amortizing the revaluation reserve, Oracle Assets sets the revaluation amortization basis at the time of revaluation and calculates the revaluation amortization using the asset's revalued net book value to spread the revaluation amortization basis based on the periodic depreciation expense calculated (Oracle Assets also bases the new depreciation expense on the revalued net book value).
For the second revaluation, the asset's revalued cost is $9,450. Again, since you do not revalue the accumulated depreciation, Oracle Assets transfers the entire amount to the revaluation reserve.
The effects of the revaluations are illustrated in the following table:
| Period (Yr,Qtr.) | Asset Cost | Deprn. Expense | Accum. Deprn. | Reval. Amortize | Reval. Reserve |
|---|---|---|---|---|---|
| Yr1,Q1 | 10,000.00 | 500.00 | 500.00 | 0.00 | 0.00 |
| Yr1,Q2 | 10,000.00 | 500.00 | 1,000.00 | 0.00 | 0.00 |
| Yr1,Q3 | 10,000.00 | 500.00 | 1,500.00 | 0.00 | 0.00 |
| Yr1,Q4 | 10,000.00 | 500.00 | 2,000.00 | 0.00 | 0.00 |
| Reval. 1 5% | 10,500.00 | 0.00 | 0.00 | 0.00 | *2,500.00 |
| Yr2,Q1 | 10,500.00 | **656.25 | 656.25 | ***156.25 | 2,343.75 |
| Yr2,Q2 | 10,500.00 | 656.25 | 1,312.50 | 156.25 | 2,187.50 |
| Yr2,Q3 | 10,500.00 | 656.25 | 1,968.75 | 156.25 | 2,031.25 |
| Yr2,Q4 | 10,500.00 | 656.25 | 2,625.00 | 156.25 | 1,875.00 |
| Yr3,Q1 | 10,500.00 | 656.25 | 3,281.25 | 156.25 | 1,718.75 |
| Yr3,Q2 | 10,500.00 | 656.25 | 3,937.50 | 156.25 | 1,562.50 |
| Yr3,Q3 | 10,500.00 | 656.25 | 4,593.75 | 156.25 | 1,406.25 |
| Yr3,Q4 | 10,500.00 | 656.25 | 5,250.00 | 156.25 | 1,250.00 |
| Reval. 2 -10% | 9,450.00 | 0.00 | 0.00 | 0.00 | *5,450.00 |
| Yr4,Q1 | 9,450.00 | **1,181.25 | 1,181.25 | ***681.25 | 4,768.75 |
| Yr4,Q2 | 9,450.00 | 1,181.25 | 2,362.50 | 681.25 | 4,087.50 |
| Yr4,Q3 | 9,450.00 | 1,181.25 | 3,543.75 | 681.25 | 3,406.25 |
| Yr4,Q4 | 9,450.00 | 1,181.25 | 4,725.00 | 681.25 | 2,725.00 |
| Yr5,Q1 | 9,450.00 | 1,181.25 | 5,906.25 | 681.25 | 2,043.75 |
| Yr5,Q2 | 9,450.00 | 1,181.25 | 7,087.50 | 681.25 | 1,362.50 |
| Yr5,Q3 | 9,450.00 | 1,181.25 | 8,268.75 | 681.25 | 681.25 |
| Yr5,Q4 | 9,450.00 | 1,181.25 | 9,450.00 | 681.25 | 0.00 |
REVALUATION 1
Year 2, quarter 1, 5% revaluation
| Account Description | Debit | Credit |
|---|---|---|
| Asset Cost | 500.00 | |
| Accumulated Depreciation | 2,000.00 | |
| Revaluation Reserve | 2,500.00 |
Oracle Assets creates the following journal entries each period to amortize the revaluation reserve:
| Account Description | Debit | Credit |
|---|---|---|
| Revaluation Reserve | 158.25 | |
| Revaluation Amortization | 158.25 |
REVALUATION 2
Year 4, quarter 1, -10% revaluation
| Account Description | Debit | Credit |
|---|---|---|
| Accumulated Depreciation | 5,250.00 | |
| Asset Cost | 1,050.00 | |
| Revaluation Reserve | 4,200.00 |
Oracle Assets creates the following journal entries each period to amortize the revaluation reserve:
| Account Description | Debit | Credit |
|---|---|---|
| Revaluation Reserve | 681.25 | |
| Revaluation Amortization | 681.25 |
Example 4: You place an asset in service in Year 1, Quarter 1. The asset cost is $10,000, the life is 5 years, and you are using straight-line depreciation. The asset's life extension factor is 2 and the maximum fully reserved revaluations allowed for this book is 3.
In year 5, quarter 4 the asset is fully reserved. In Year 9, Quarter 1 you want to revalue the asset with a revaluation rate of 5%.
Revaluation Rules:
Revalue Accumulated Depreciation = Yes
Amortize Revaluation Reserve = No
First, Oracle Assets checks whether this fully reserved asset has been previously revalued as fully reserved, and that the maximum number of times is not exceeded by this revaluation. Since this asset has not been previously revalued as fully reserved, this revaluation is allowed.
The asset's new revalued cost is $10,500. The life extension factor for this asset is 2, so the asset's new life is 2 * 5 years = 10 years. Oracle Assets calculates depreciation expense over its new life of 10 years. Oracle Assets calculates the depreciation adjustment of $2,000 using the new 10 year asset life. It transfers the change in net book value to the revaluation reserve account.
Oracle Assets revalues the accumulated depreciation using the 5% revaluation rate. The change in net book value is transferred to the revaluation reserve account. Since you do not amortize the revaluation reserve, the amount remains in the revaluation reserve account.
The effect of the revaluation is illustrated in the following table:
| Period (Yr, Qtr.) | Asset Cost | Deprn. Expense | Accum. Deprn. | Reval. Reserve |
|---|---|---|---|---|
| Yr1 to Yr4 | ||||
| Yr5,Q1 | 10,000.00 | 500.00 | 8,500.00 | 0.00 |
| Yr5,Q2 | 10,000.00 | 500.00 | 9,000.00 | 0.00 |
| Yr5,Q3 | 10,000.00 | 500.00 | 9,500.00 | 0.00 |
| Yr5,Q4 | 10,000.00 | 500.00 | 10,000.00 | 0.00 |
| Reval. 5% | 10,500.00 | 0.00 | *8,400.00 | **2,100.00 |
| Yr9,Q1 | 10,500.00 | ***262.50 | 8,662.50 | 2,100.00 |
| Yr9,Q2 | 10,500.00 | 262.50 | 8,925.00 | 2,100.00 |
| Yr9,Q3 | 10,500.00 | 262.50 | 9,187.50 | 2,100.00 |
| Yr9,Q4 | 10,500.00 | 262.50 | 9,450.00 | 2,100.00 |
| Yr10,Q1 | 10,500.00 | 262.50 | 9,712.50 | 2,100.00 |
| Yr10,Q2 | 10,500.00 | 262.50 | 9,975.00 | 2,100.00 |
| Yr10,Q3 | 10,500.00 | 262.50 | 10,237.50 | 2,100.00 |
| Yr10,Q4 | 10,500.00 | 262.50 | 10,500.00 | 2,100.00 |
| Account Description | Debit | Credit |
|---|---|---|
| Asset Cost | 500.00 | |
| Accumulated Depreciation | 1,600.00 | |
| Revaluation Reserve | 2,100.00 |
Example 5: You place an asset in service in Year 1, Quarter 1. The asset cost is $10,000, the life is 5 years, and you are using straight-line depreciation. The asset's life extension factor is 3.0 and its life extension ceiling is 2.
In Year 5, Quarter 4 the asset is fully reserved. In year 9, quarter 1 you want to revalue the asset with a revaluation rate of 5%.
Revaluation Rules:
Revalue Accumulated Depreciation = Yes
Amortize Revaluation Reserve = No
To determine the depreciation adjustment, Oracle Assets uses the smaller of the life extension factor and the life extension ceiling. Since the life extension ceiling is smaller than the life extension factor, Oracle Assets uses the ceiling to calculate the depreciation adjustment. The new life used to calculate the depreciation adjustment is 2 * 5 years = 10 years, the life extension ceiling of 2 multiplied by the original 5 year life of the asset.
Oracle Assets calculates the asset's depreciation expense under the new life of 10 years up to the revaluation period, and moves the difference between this value and the existing accumulated depreciation from accumulated depreciation to revaluation reserve.
Oracle Assets then determines the new asset cost using the revaluation rate of 5% and revalues the accumulated depreciation with the same rate. Oracle Assets calculates the asset's new life by multiplying the current life by the life extension factor. The asset's new life is 3 * 5 years = 15 years. Oracle Assets bases the new depreciation expense on the revalued net book value and the new 15 year life.
The effect of the revaluation is illustrated in the following table:
| Period (Yr, Qtr.) | Asset Cost | Deprn. Expense | Accum. Deprn. | Reval. Reserve |
|---|---|---|---|---|
| Yr1 to Yr4 | ||||
| Yr5,Q1 | 10,000.00 | 500.00 | 8500.00 | 0.00 |
| Yr5,Q2 | 10,000.00 | 500.00 | 9000.00 | 0.00 |
| Yr5,Q3 | 10,000.00 | 500.00 | 9,500.00 | 0.00 |
| Yr5,Q4 | 10,000.00 | 500.00 | 10,000.00 | 0.00 |
| Reval. 5% | 10,500.00 | 0.00 | *8,400.00 | **2,100.00 |
| Yr9,Q1 | 10,500.00 | ***75.00 | 8,475.00 | 2,100.00 |
| Yr9,Q2 | 10,500.00 | 75.00 | 8,550.00 | 2,100.00 |
| Yr9,Q3 | 10,500.00 | 75.00 | 8,625.00 | 2,100.00 |
| Yr9,Q4 | 10,500.00 | 75.00 | 8,700.00 | 2,100.00 |
| Yr10 to Yr15 |
Depreciation Adjustment (calculated using life extension ceiling)= 2,000
| Account Description | Debit | Credit |
|---|---|---|
| Asset Cost | 500.00 | |
| Accumulated Depreciation | 1,600.00 | |
| Revaluation Reserve | 2,100.00 |
Example 6: You own an asset which has been damaged during its life. You placed the asset in service in Year 1, quarter 1. The asset cost is $10,000, the life is 5 years, and you are using straight-line depreciation. You entered a revaluation ceiling of $10,300 for the asset.
In year 3, quarter 3 you revalue the asset's category with a revaluation rate of 5%.
Revaluation Rules:
Revalue Accumulated Depreciation = No
Amortize Revaluation Reserve = Yes
If Oracle Assets applied the new revaluation rate of 5%, the asset's new cost would be higher than the revaluation ceiling for this asset, so instead Oracle Assets uses the ceiling as the new cost. The ceiling creates the same effect as revaluing the asset at a rate of 3%. Oracle Assets bases the asset's new depreciation expense on the revalued asset cost.
The effect of the revaluation is illustrated in the following table:
| Period (Yr, Qtr.) | Asset Cost | Deprn. Expense | Accum.Deprn. | Reval. Amortize | Reval. Reserve |
|---|---|---|---|---|---|
| Yr1 to Yr 2 | |||||
| Yr3,Q1 | 10,000.00 | 500.00 | 4,500.00 | 0.00 | 0.00 |
| Yr3,Q2 | 10,000.00 | 500.00 | 5,000.00 | 0.00 | 0.00 |
| Reval. *3% | 10,300.00 | 0.00 | 0.00 | 0.00 | **5,300.00 |
| Yr3,Q3 | 10,300.00 | ***1,030.00 | 1,030.00 | ****530.00 | 4,770.00 |
| Yr3,Q4 | 10,300.00 | 1,030.00 | 2,060.00 | 530.00 | 4,240.00 |
| Yr4,Q1 | 10,300.00 | 1,030.00 | 3,090.00 | 530.00 | 3,710.00 |
| Yr4,Q2 | 10,300.00 | 1,030.00 | 4,120.00 | 530.00 | 3,180.00 |
| Yr4,Q3 | 10,300.00 | 1,030.00 | 5,150.00 | 530.00 | 2,650.00 |
| Yr4,Q4 | 10,300.00 | 1,030.00 | 6,180.00 | 530.00 | 2,120.00 |
| Yr5,Q1 | 10,300.00 | 1,030.00 | 7,210.00 | 530.00 | 1,590.00 |
| Yr5,Q2 | 10,300.00 | 1,030.00 | 8,240.00 | 530.00 | 1,060.00 |
| Yr5,Q3 | 10,300.00 | 1,030.00 | 9,270.00 | 530.00 | 530.00 |
| Yr5,Q4 | 10,300.00 | 1,030.00 | 10,300.00 | 530.00 | 0.00 |
| Account Description | Debit | Credit |
|---|---|---|
| Asset Cost | 300.00 | |
| Accumulated Depreciation | 5,000.00 | |
| Revaluation Reserve | 5,300.00 |
Oracle Assets creates the following journal entries each period to amortize the revaluation reserve:
| Account Description | Debit | Credit |
|---|---|---|
| Revaluation Reserve | 530.00 | |
| Revaluation Amortization | 530.00 |