SLN - Straight Line Depreciation

[beep_boop]

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?

[José Augusto]

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)

Please Login or Register  to view this content.

In G3 use the formula

Please Login or Register  to view this content.

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

See the file for clarification.

[beep_boop]

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.

[José Augusto]

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)

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

See the file