SLN - Straight Line Depreciation

In A i have start date (ex: 12-jan-2017)
In B I have end date (ex: 19 -dec-2020)
In C i have Cost
In D i have salvage value
In E i have Life

I want to find depreciation of every month ( ex: Jan 31 days, feb 28 days) from starting date (12-jan-2017)
How do i do this?

Hi

You can use the function VDB to get the depreciation and DATEDIF to get the life time.
So if your data is in A3:E3 use in E3 (month as unit)

Formula:

=DATEDIF(A3,B3,"m")

In G3 use the formula

Formula:

=VDB($C$3,$D$3,$E$3,0,F3)

to obtain the accumulated depreciation at the end of F3 months after the start date.

See the file for clarification.

I am trying to calculate the depreciation for 365 days, as in 31 days for Jan, 28 for feb, 30 days for april etc. using a straight line method.

Hi

I added a new column where I put the month end date.
For the normal depreciation method I used the same method as in the previous post.
In column K I used the following formulas to calculate linear depreciations:
(formula for first value K3)

Formula:

=($C$3-$D$3)/$E$3*(F3-$A$3)

(formula for the other values K4:...)

Formula:

=($C$3-$D$3)/$E$3*(F4-F3)

See the file