IC-Google-Sheets-Equipment-Inventory-Template_Google_Sheets

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1

2	GOOGLE SHEETS EQUIPMENT INVENTORY TEMPLATE							https://www.smartsheet.com/try-it?trp=12363&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Equipment+Inventory+Tracking+Spreadsheet-google-sheet-12363&lpa=Equipment+Inventory+Tracking+Spreadsheet+google-sheet+12363
3	TOTAL EQUIPMENT INVENTORY VALUE
4	$41,508.65			*Based upon CURRENT VALUE fields below
5
6	EQUIPMENT STATUS						FINANCIAL STATUS
7	ITEM NO.	ITEM NAME	DESCRIPTION	MANUFACTURER	LOCATION	CONDITION	DATE ACQUIRED	ESTIMATED YEARS LEFT IN SERVICE	INITIAL VALUE	DOWNPAYMENT	LOAN TERMS IN YEARS	RATE OF LOAN	MONTHLY PAYMENT	MONTHLY COST OF OPERATION	TOTAL MONTHLY COST	EXPECTED VALUE AT LOAN-TERM END	ANNUAL STRAIGHT LINE DEPRECIATION	MONTHLY STRAIGHT LINE DEPRECIATION	CURRENT VALUE
8	123	Item A	General description	Vendor 36	Main Branch	Fair	02/02/28	2	$11,000.00	$3,000.00	5	8%	$128.00	$22.00	$150.00	$7,000.00	$2,000.00	$166.67	$15,328.77
9	345	Item B	General description	Vendor 2	Main Branch	Damaged	02/03/28	5	$6,000.00	$2,500.00	6	7%	$40.83	$35.00	$75.83	$2,000.00	$800.00	$66.67	$7,733.70
10	456	Item C	General description	Vendor 122	East Coast	Excellent	02/04/28	7	$15,000.00	$10,000.00	7	7%	$50.00	$20.00	$70.00	$9,000.00	$857.14	$71.43	$16,859.88
11							02/05/28	1	$500.00	$25.00	8	4%	$2.38	$0.00	$2.38		$500.00	$41.67	$1,586.30
12													–		$0.00		–	–	–
13													–		$0.00		–	–	–
14													–		$0.00		–	–	–
15													–		$0.00		–	–	–
16													–		$0.00		–	–	–
17													–		$0.00		–	–	–
18													–		$0.00		–	–	–
19													–		$0.00		–	–	–
20													–		$0.00		–	–	–
21													–		$0.00		–	–	–
22													–		$0.00		–	–	–
23													–		$0.00		–	–	–
24													–		$0.00		–	–	–
25													–		$0.00		–	–	–
26													–		$0.00		–	–	–
27													–		$0.00		–	–	–
28													–		$0.00		–	–	–
29													–		$0.00		–	–	–
30													–		$0.00		–	–	–
31													–		$0.00		–	–	–
32													–		$0.00		–	–	–
33													–		$0.00		–	–	–
34													–		$0.00		–	–	–
35													–		$0.00		–	–	–
36													–		$0.00		–	–	–
37													–		$0.00		–	–	–
38													–		$0.00		–	–	–
39													–		$0.00		–	–	–
40													–		$0.00		–	–	–
41													–		$0.00		–	–	–
42
43	CLICK HERE TO CREATE WITH SMARTSHEET
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