template to calculate straight line dep over many years

  • Thread starter Thread starter chances
  • Start date Start date
C

chances

I am looking for a template that will calculate straight line depreciation
over a number of years. I have the historical cost for an inventory and
there are various in-service years - from the 1900 to 2007, various useful
life for different assets etc. Maybe a suggested formula. Need to come up
with a Net Book Value for the year ending 2006
 
107 years of data -- that's pretty impressive.

Regardless, straight line depreciation is a very simply calculation. Every
year, the depreciation is the cost of the asset divided by the useful life.
The remaining book value would be:

=Cost * (1 - (2006 - Year(PurchaseDate))/UsefulLife)

Then just sum these values

Regards,
Fred.
 
Back
Top