View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chances chances is offline
external usenet poster
 
Posts: 1
Default 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