Lapsing.xlsx

	A	C	D	E	F	G	H
1	Fixed Assets	non current assets
2	Building	50	600
3
4	Machineries	5	60
5	Equipment	5	60
6	Furn and Fix	3	36
7	Vehicle	5	60
8
9	Depreciation Expense		Income Statement Account				Cost/Useful Life
10	Accumulated Depreciation		Balance Sheet Account
11	Book Value		Cost minus Accumulated Depreciation
12	Cost		Purchase
13
14	Equipment 50,000
15
16	Equipment	50,000.00
17	Cash		50,000.00
18
19		1st year	2nd year	3rd year	4th year	5th year
20	Depreciation Exp	10,000.00	10,000.00	10,000.00	10,000.00	9,999.00
21	Cost	50,000.00	50,000.00	50,000.00	50,000.00	50,000.00
22	Accumulated Depreciation	10,000.00	20,000.00	30,000.00	40,000.00	49,999.00
23	Net Book Value	40,000.00	30,000.00	20,000.00	10,000.00	1.00
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100