Equipment inventory list.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	EQUIPMENT INVENTORY LIST
2
3	PHYSICAL CONDITION						FINANCIAL STATUS
4	Asset or serial number	Item description	Location	Condition	Vendor	Years of service left	Initial value	Down payment	Date purchased or leased	Loan term in years	Loan rate	Monthly payment	Monthly operating costs	Total monthly cost	Expected value at end of loan term	Annual straight line depreciation	Monthly straight line depreciation	Current value
5	123	Van	Main branch	Good	local	5	$30,000.00	$5,000.00	1/1/2024	4	10.00%	#ERROR!	$200.00	#ERROR!	$20,000.00	#ERROR!	#ERROR!	#ERROR!
6	456	Pick-up truck	Main branch	Excellent	local	3	$5,000.00	$5,000.00	1/1/2025			#ERROR!	$20.00	#ERROR!		#ERROR!	#ERROR!	#ERROR!
7	789	Box truck	East coast	Fair	local	6	$50,000.00	$20,000.00	6/7/2026	5	5.00%	#ERROR!	$40.00	#ERROR!	$1,500.00	#ERROR!	#ERROR!	#ERROR!
8												#ERROR!		#ERROR!		#ERROR!	#ERROR!	#ERROR!
9												#ERROR!		#ERROR!		#ERROR!	#ERROR!	#ERROR!
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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