Depreciation Period

[dodokh]

Hello,
If I have the following information:
Asset purchase date: 22-Nov-17
Yearly depreciation percentage: (15%)

Can we calculate the last date of depreciation ?

 

[SanjayGMusafir]

You can draw some idea here - Though, generally, it is assumed that every asset has a life and scrap value and rate of depreciation is ascertained on that basis only.

Book1
	A	B	C
1	Year	WDV	100
2	1	85.00
3	2	72.25
4	3	61.41
5	4	52.20
6	5	44.37
7	6	37.71
8	7	32.05
9	8	27.24
10	9	23.15
11	10	19.68
12	11	16.73
13	12	14.22
14	13	12.09
15	14	10.28
16	15	8.74
17	16	7.43
18	17	6.32
19	18	5.37
20	19	4.56
21	20	3.88
22	21	3.30
23	22	2.81
24	23	2.39
25	24	2.03
26	25	1.73
27	26	1.47
28	27	1.25
29	28	1.06
30	29	0.90
31	30	0.77
Sheet1

Cell Formulas
Range	Formula
B2	B2	=ROUND(C1*0.85,2)
B3:B31	B3	=ROUND(B2*0.85,2)

 

[KRice]

Based on the information provided, no, the last period of depreciation cannot be determined. Do you have more information about the depreciation method to be used (there are many)? Since you've expressed the yearly depreciation in terms of a percentage, I'm assuming it is some type of declining balance method. As @SanjayGMusafir points out, you'll also need some additional information...normally the asset's initial cost, useful life, and salvage value are used in conjunction with the depreciation method to establish the depreciation amount and schedule.