| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Straight Line is not straight | Excel Discussion (Misc queries) | |||
| straight line graph, really straight line.. | Excel Discussion (Misc queries) | |||
| best fit straight line | Charts and Charting in Excel | |||
| Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel | |||
| best straight line in Excel | Charts and Charting in Excel | |||
Linear Mode
