{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Equipment inventory list"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Equipment inventory list","index":0,"n_rows":9,"n_cols":19,"rows_kept":9,"merged":[[0,13,0,14],[0,15,0,16],[0,17,0,18],[2,1,2,6],[2,7,2,18]]}
[null,"EQUIPMENT INVENTORY LIST"]
[]
[null,"PHYSICAL CONDITION",{"$nulls":5},"FINANCIAL STATUS"]
[null,"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"]
[null,123,"Van","Main branch","Good","local",5,{"v":30000,"d":"$30,000.00"},{"v":5000,"d":"$5,000.00"},{"$f":"DATE(YEAR(TODAY())-2, 1,1)","v":"2021-01-01"},4,{"v":0.1,"d":"10.00%"},{"$f":"IFERROR(IF(AND(Data[[#This Row],[Initial value]]>0,Data[[#This Row],[Initial value]]<>Data[[#This Row],[Down payment]]),-1*PMT(Data[[#This Row],[Loan rate]]/12,Data[[#This Row],[Loan term in years]]*12,Data[[#This Row],[Initial value]]-Data[[#This Row],[Down payment]]),0),0)","v":{"v":634.0645858686797,"d":"$634.06"}},{"v":200,"d":"$200.00"},{"$f":"IFERROR(Data[[#This Row],[Monthly operating costs]]+Data[[#This Row],[Monthly payment]],\"\")","v":{"v":834.0645858686797,"d":"$834.06"}},{"v":20000,"d":"$20,000.00"},{"$f":"IFERROR(IF(Data[[#This Row],[Initial value]]>0,SLN(Data[[#This Row],[Initial value]],Data[[#This Row],[Expected value at end of loan term]],Data[[#This Row],[Years of service left ]]),0),0)","v":{"v":2000,"d":"$2,000.00"}},{"$f":"IFERROR(Data[[#This Row],[Annual straight line depreciation]]/12,0)","v":{"v":166.66666666666666,"d":"$166.67"}},{"$f":"IFERROR(Data[[#This Row],[Initial value]]-(Data[[#This Row],[Annual straight line depreciation]]*((TODAY()-Data[[#This Row],[Date purchased or leased]])/365)),0)","v":{"v":25221.91780821918,"d":"$25,221.92"}}]
[null,456,"Pick-up truck","Main branch","Excellent","local",3,{"v":5000,"d":"$5,000.00"},{"v":5000,"d":"$5,000.00"},{"$f":"DATE(YEAR(TODAY())-1, 1,1)","v":"2022-01-01"},null,null,{"$f":"IFERROR(IF(AND(Data[[#This Row],[Initial value]]>0,Data[[#This Row],[Initial value]]<>Data[[#This Row],[Down payment]]),-1*PMT(Data[[#This Row],[Loan rate]]/12,Data[[#This Row],[Loan term in years]]*12,Data[[#This Row],[Initial value]]-Data[[#This Row],[Down payment]]),0),0)","v":{"v":0,"d":"$0.00"}},{"v":20,"d":"$20.00"},{"$f":"IFERROR(Data[[#This Row],[Monthly operating costs]]+Data[[#This Row],[Monthly payment]],\"\")","v":{"v":20,"d":"$20.00"}},null,{"$f":"IFERROR(IF(Data[[#This Row],[Initial value]]>0,SLN(Data[[#This Row],[Initial value]],Data[[#This Row],[Expected value at end of loan term]],Data[[#This Row],[Years of service left ]]),0),0)","v":{"v":1666.6666666666667,"d":"$1,666.67"}},{"$f":"IFERROR(Data[[#This Row],[Annual straight line depreciation]]/12,0)","v":{"v":138.88888888888889,"d":"$138.89"}},{"$f":"IFERROR(Data[[#This Row],[Initial value]]-(Data[[#This Row],[Annual straight line depreciation]]*((TODAY()-Data[[#This Row],[Date purchased or leased]])/365)),0)","v":{"v":2684.931506849315,"d":"$2,684.93"}}]
[null,789,"Box truck","East coast","Fair","local",6,{"v":50000,"d":"$50,000.00"},{"v":20000,"d":"$20,000.00"},{"$f":"TODAY()","v":"2023-05-23"},5,{"v":0.05,"d":"5.00%"},{"$f":"IFERROR(IF(AND(Data[[#This Row],[Initial value]]>0,Data[[#This Row],[Initial value]]<>Data[[#This Row],[Down payment]]),-1*PMT(Data[[#This Row],[Loan rate]]/12,Data[[#This Row],[Loan term in years]]*12,Data[[#This Row],[Initial value]]-Data[[#This Row],[Down payment]]),0),0)","v":{"v":566.137009320328,"d":"$566.14"}},{"v":40,"d":"$40.00"},{"$f":"IFERROR(Data[[#This Row],[Monthly operating costs]]+Data[[#This Row],[Monthly payment]],\"\")","v":{"v":606.137009320328,"d":"$606.14"}},{"v":1500,"d":"$1,500.00"},{"$f":"IFERROR(IF(Data[[#This Row],[Initial value]]>0,SLN(Data[[#This Row],[Initial value]],Data[[#This Row],[Expected value at end of loan term]],Data[[#This Row],[Years of service left ]]),0),0)","v":{"v":8083.333333333333,"d":"$8,083.33"}},{"$f":"IFERROR(Data[[#This Row],[Annual straight line depreciation]]/12,0)","v":{"v":673.6111111111111,"d":"$673.61"}},{"$f":"IFERROR(Data[[#This Row],[Initial value]]-(Data[[#This Row],[Annual straight line depreciation]]*((TODAY()-Data[[#This Row],[Date purchased or leased]])/365)),0)","v":{"v":50000,"d":"$50,000.00"}}]
[{"$nulls":12},{"$f":"IFERROR(IF(AND(Data[[#This Row],[Initial value]]>0,Data[[#This Row],[Initial value]]<>Data[[#This Row],[Down payment]]),-1*PMT(Data[[#This Row],[Loan rate]]/12,Data[[#This Row],[Loan term in years]]*12,Data[[#This Row],[Initial value]]-Data[[#This Row],[Down payment]]),0),0)","v":{"v":0,"d":"$0.00"}},null,{"$f":"IFERROR(Data[[#This Row],[Monthly operating costs]]+Data[[#This Row],[Monthly payment]],\"\")","v":{"v":0,"d":"$0.00"}},null,{"$f":"IFERROR(IF(Data[[#This Row],[Initial value]]>0,SLN(Data[[#This Row],[Initial value]],Data[[#This Row],[Expected value at end of loan term]],Data[[#This Row],[Years of service left ]]),0),0)","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(Data[[#This Row],[Annual straight line depreciation]]/12,0)","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(Data[[#This Row],[Initial value]]-(Data[[#This Row],[Annual straight line depreciation]]*((TODAY()-Data[[#This Row],[Date purchased or leased]])/365)),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":12},{"$f":"IFERROR(IF(AND(Data[[#This Row],[Initial value]]>0,Data[[#This Row],[Initial value]]<>Data[[#This Row],[Down payment]]),-1*PMT(Data[[#This Row],[Loan rate]]/12,Data[[#This Row],[Loan term in years]]*12,Data[[#This Row],[Initial value]]-Data[[#This Row],[Down payment]]),0),0)","v":{"v":0,"d":"$0.00"}},null,{"$f":"IFERROR(Data[[#This Row],[Monthly operating costs]]+Data[[#This Row],[Monthly payment]],\"\")","v":{"v":0,"d":"$0.00"}},null,{"$f":"IFERROR(IF(Data[[#This Row],[Initial value]]>0,SLN(Data[[#This Row],[Initial value]],Data[[#This Row],[Expected value at end of loan term]],Data[[#This Row],[Years of service left ]]),0),0)","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(Data[[#This Row],[Annual straight line depreciation]]/12,0)","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(Data[[#This Row],[Initial value]]-(Data[[#This Row],[Annual straight line depreciation]]*((TODAY()-Data[[#This Row],[Date purchased or leased]])/365)),0)","v":{"v":0,"d":"$0.00"}}]