Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Depreciation is a method of allocating the cost of a fixed asset over its estimated useful life.  Governmental and proprietary fund types need to be depreciated. 

...

So if an item has an original cost of $10,000 with an estimated useful life of 5 years and a salvage value of $1,000, it would have an annual (FTD) depreciation of $1800 computed as follows:

End of YearOriginal CostLTD DepreciationBook Value at Beginning of FYYearly (FTD) DepreciationBook Value at End of the Fiscal Year
110,000-10,0001,8008,200
210,0001,8008,2001,8006,400
310,0003,6006,4001,8004,600
410,0005,4004,6001,8002,800
510,0007,2002,8001,8001,000
Result10,0009,0001,00001,000


However the Inventory application uses a slightly different calculation from the straight-line method.The total depreciation as of the end of the last fiscal year (called Life-to-date Depreciation) is stored for each item. The system uses the following calculation for annual depreciation. The depreciation for a part of a year will be the annual depreciation pro-rated for the number of months involved.

 

This formula protects the calculation from being sensitive to changes in original cost, life expectancy, etc. Thus, if an improvement (additional acquisition) is done to an item, the amount of depreciation taken from that point on will reflect the increase or decrease to the original cost. Depreciation already taken in prior years will not be affected.  Listed below are two examples of calculating depreciation for the life of the items. 

Tag #1: $10,000 original cost depreciated over 5 years acquired 01/01/2015 (FY15) with a salvage value of 1000.00.  The item should be completely depreciated in five years.

...

Tag A's original cost is $5000 depreciated over 5 years.  The yearly depreciation is $1000.  If in year 4, I create an additional acquisition thus updating the original cost to $7000, my yearly depreciation for the remaining life of the asset is now $2000.   It will not disturb prior year depreciation.

YearOriginal CostLifeYearly Depreciation
1$50005 years$1000
2$50005 years$1000
3$50005 years$1000
4$70005 years$2000
5$70005 years$2000

Running Deprecation Option

If in year 4,  I run depreciate on Tag A, it will recalculate LTD depreciation from scratch using the current original cost of $7000

YearOriginal CostLifeYearly Depreciation
1$70005 years$1400
2$70005 years$1400
3$70005 years$1400
4$70005 years$1400
5$70005 years$1400

As you can see, the original tracking of depreciation on the life of the asset is altered.  It is recommended that you contact your ITC or discuss with your auditors before using the Depreciate option.