template to calculate straight line dep over many years
 

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

template to calculate straight line dep over many years
 

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.

"chances" wrote in message
...
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