template to calculate straight line dep over many years

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
 
F

Fred Smith

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Straight line depreciation 4
Allocate an income payment over a date range (tax years) 7
Table w/straight-line depreciation & annual rate depreciation for. 1
Depreciation Spreadsheet 3
This is a toughie | auto-calculate depreciation | populate unbound 4
MACRS depreciation formula 2
Fourmula help 1
IF Function 2

Top