Straight Line Depreciation Calculation

**andrew8008** · 05-25-2007, 01:48 PM

I am trying to develop a formula that would calcluate depreciation by year. I an attached file, person would input Purchase Date (month/yr), Cost, and useful life. I am assuming salvage value =0. I want a formula in cells E5 - Q5 that will calculate deprecication depending on the inputted purchase date. So if purchase date is Feb 1, 2007, the depr amt in 2007 would be (11/12 )* (100,000/12). I also want the folrmula to not exceed accumulated Depr over the cost like in cell Q5.

Can anyone help? Thanks

**WinteE** · 05-26-2007, 07:15 AM

Hi Andrew,

See the attached file.
The formula is based on depreciation starting in the month of purchase.

Succes,
Erik

**andrew8008** · 05-30-2007, 02:03 PM

WinteE,

This is great... I now need to break out 2007 & 2008 by Quarter.

I included in attached.

Any suggestions on how to modify your formula?

I really appreciate your help.

**WinteE** · 05-31-2007, 03:55 AM

Andrew,

Take a look at it, let me know if it's OK.

Erik

**cawinkel** · 11-07-2012, 04:29 PM

Let's say you wanted to get so specific that the caluclation went by days, i.e purchased on 2/13/2007. How would you calculate based on the exact purchase date?STL Depr.xls