template to calculate straight line dep over many years

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chances - 22 May 2008 00:02 GMT

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

Reply to this Message

Fred Smith - 22 May 2008 02:58 GMT

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.

>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

Reply to this Message