The Adventurous Meal

The Adventurous Meal

Friday 31 March 2017

How to maintain proper asset depreciation schedule




Every company has its own policy on how to record its fixed assets face value during the books of accounts closing. Most of the accountants maintain the assets schedule in an excel worksheet showing the allocation of depreciation value for its fixed asset items. But first the following criteria, has to be considered in which the particular fixed assets is being depreciated based on the useful life of the asset.  Policy has to be defined as per the useful life of the particular assets. 

Particular asset could be estimated as in workable condition for the next 5 years (i.e., Vehicle, Equipments etc.,) The estimated useful life of the assets can also be re-assessed whether the useful life of it can be extended for another year or so on.

Below is the basic way of calculating a particular asset and depreciation schedule preparation:

Ex:

Assuming company ABC purchased a Motor Vehicle on 15/1/17 at a value of 100,000.00 and has an estimated useful life for 5 years. The best method of calculating is accelerated depreciation method or evenly over the useful life of the asset.



Calculation Formula
Jan (31 days)
     1,698.63
(100000÷5yrs÷365Days)x31days
Feb(28 days)
     1,534.25
(100000÷5yrs÷365Days)x28days
Mar (31 days)
     1,643.84
(100000÷5yrs÷365Days)x31days
Apr (30 days)
     1,698.63
(100000÷5yrs÷365Days)x30days
May (31 days)
     1,698.63
(100000÷5yrs÷365Days)x31days
June (30 days)
     1,643.84
(100000÷5yrs÷365Days)x31days
July (31 days)
     1,698.63
(100000÷5yrs÷365Days)x31days
Aug (31 days)
     1,698.63
(100000÷5yrs÷365Days)x31days
Sept (30 days)
     1,643.84
(100000÷5yrs÷365Days)x31days
Oct (31 days)
     1,698.63
(100000÷5yrs÷365Days)x31days
Nov (30 days)
     1,643.84
(100000÷5yrs÷365Days)x31days
Dec (31 days)
     1,698.63
(100000÷5yrs÷365Days)x31days
Accumulated Depreciation as on
31-Dec-2017
   20,000.00

Acquisition Cost
100,000.00

Book Value as on December 31, 2017
80,000.00



           

No comments:

Post a Comment