Re: template to calculate straight line dep over many years

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <chances@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:90D05CF8-7297-43FC-9890-B22DD6FCA9AD@xxxxxxxxxxxxxxxx
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

.

Relevant Pages

  • Re: Calculating Depreciation
    ... years accounts that had a Cost of 4498 (NBV ... just two separate rates for two separate classes of asset. ... then he wouldn't need separate cost and depreciation accounts ...
    (uk.business.accountancy)
  • Re: Calculating Depreciation
    ... the depreciation has been calculated. ... I don't think he could have been calculating it ... per asset. ... 25% of cost each year but from now on keep a register of assets. ...
    (uk.business.accountancy)
  • Re: Calculating Depreciation
    ... the depreciation has been calculated. ... He should then have separate cost ... and depreciation accounts for each of the two asset classes, ... years accounts that had a Cost of 4498 (NBV ...
    (uk.business.accountancy)
  • Re: Rental Property Depreciation / Home Office Depreciation
    ... deduction), I moved in January of 07 to a new home. ... My question relates to taking the depreciation on the home. ... take in account the depreciation portion of the home office deduction ... The home office asset would be taken out of service and ...
    (misc.taxes)
  • Re: Description Conceptual Classes
    ... Unfortunately terms like 'domain model' and 'analysis phase' mean ... asset depreciation can be described as a GoF Strategy pattern: ... A more elegant solution employing parametric polymorphism is: ...
    (comp.object)