{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["汇总表","厂房","土地","收益法"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"汇总表","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,0,0,5],[1,0,1,5],[2,4,2,5],[3,3,3,5],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,4],[4,5,5,5],[8,0,8,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1]]}
["资产评估汇总表"]
["评估基准日：2021年01月08日"]
[]
["被评估单位：盐城大丰天州机械制造有限公司",null,null,"金额单位：人民币元"]
["编号","科目名称","评估方法","评估价值",null,"备注"]
[{"$nulls":3},"原值","净值"]
["1-1","房屋建筑物","成本法",{"$f":"厂房!I12","v":{"v":14561726.67,"d":"14,561,726.67"}},{"$f":"厂房!K12","v":{"v":13105554,"d":"13,105,554.00"}}]
["1-2","土地使用权","比较法",{"$f":"土地!J8","v":{"v":3555200,"d":"3,555,200.00"}},{"$f":"土地!J8","v":{"v":3555200,"d":"3,555,200.00"}}]
["小计",null,null,{"$f":"D7+D8","v":{"v":18116926.67,"d":"18,116,926.67"}},{"$f":"E7+E8","v":{"v":16660754,"d":"16,660,754.00"}}]
["2-1","房屋建筑物","收益法",{"$f":"收益法!I10","v":{"v":16623062,"d":"16,623,062.00"}},{"$f":"收益法!I10","v":{"v":16623062,"d":"16,623,062.00"}},"包含土地价值"]
["小计",null,null,{"$f":"D10","v":{"v":16623062,"d":"16,623,062.00"}},{"$f":"E10","v":{"v":16623062,"d":"16,623,062.00"}}]
["资产合计",null,null,{"$f":"(D9+D11)/2","v":{"v":17369994.335,"d":"17,369,994.34"}},{"$f":"(E9+E11)/2","v":{"v":16641908,"d":"16,641,908.00"}}]
["减：资产减值准备"]
["资产合计",null,null,{"$f":"D12","v":{"v":17369994.335,"d":"17,369,994.34"}},{"$f":"E12","v":{"v":16641908,"d":"16,641,908.00"}}]
[{"$nulls":5},"评估机构：江苏三师土地房地产资产评估测绘咨询有限公司"]
[]
[]
[null," "]

{"sheet":"厂房","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"merged":[[0,0,0,11],[1,0,1,11],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,4,10],[4,11,5,11],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,8,12,11]]}
["房屋建筑物评估明细表"]
["评估基准日：2021年01月08日"]
[{"$nulls":11},"1-1"]
["被评估单位：盐城大丰天州机械制造有限公司",{"$nulls":10},"金额单位：人民币元"]
["序号","建筑物名称","结构","建成\n年月","层次/层数","计量单位","建筑面积（m2)","评估单价(元/m2)","评估价值",null,null,"备注"]
[{"$nulls":8},"原值","成新率%","净值"]
[1,"1#厂房","钢混",2018,"1-1","m2",{"v":3893.4,"d":"3,893.40"},1155,{"$f":"ROUND(K7/J7,2)","v":{"v":4996530,"d":"4,996,530.00"}},{"v":0.9,"d":"90%"},{"$f":"ROUND(H7*G7,2)","v":{"v":4496877,"d":"4,496,877.00"}},"局部二层"]
[2,"2#厂房","钢混",2018,"1-1","m2",{"v":3893.4,"d":"3,893.40"},1155,{"$f":"ROUND(K8/J8,2)","v":{"v":4996530,"d":"4,996,530.00"}},{"v":0.9,"d":"90%"},{"$f":"ROUND(H8*G8,2)","v":{"v":4496877,"d":"4,496,877.00"}},"局部二层"]
[3,"3#厂房","钢混",2018,"1-1","m2",{"v":3560,"d":"3,560.00"},1155,{"$f":"ROUND(K9/J9,2)","v":{"v":4568666.67,"d":"4,568,666.67"}},{"v":0.9,"d":"90%"},{"$f":"ROUND(H9*G9,2)","v":{"v":4111800,"d":"4,111,800.00"}},"局部二层"]
["合     计",{"$nulls":5},{"$f":"SUM(G7:G9)","v":{"v":11346.8,"d":"11,346.80"}},null,{"$f":"SUM(I7:I9)","v":{"v":14561726.67,"d":"14,561,726.67"}},null,{"$f":"SUM(K7:K9)","v":{"v":13105554,"d":"13,105,554.00"}}]
["减：房屋建筑物减值准备"]
["合            计",{"$nulls":7},{"$f":"I10-I11","v":{"v":14561726.67,"d":"14,561,726.67"}},null,{"$f":"K10-K11","v":{"v":13105554,"d":"13,105,554.00"}}]
["填报人："]
["填表日期：2021年01月08日"]

{"sheet":"土地","index":2,"n_rows":8,"n_cols":11,"rows_kept":8,"merged":[[0,0,0,10],[1,0,1,10],[7,0,7,2]]}
["土地使用权评估明细表"]
["评估基准日：2021年01月08日"]
[{"$nulls":10},"1-2"]
["被评估单位：盐城大丰天州机械制造有限公司",{"$nulls":9},"金额单位：人民币元"]
["序号","土地出让合同编号","土地位置","取得日期","用地性质","使用权类型","剩余使用年期 （终止日期）","面积(m2)","评估单价（元/m2)","评估价值","备注"]
[1,"3209822018CR0025","盐城市大丰 区草庙居委会三、四组","2018-03-13","工业用地","出让",47.18,{"v":20200,"d":"20,200.00"},{"v":176,"d":"176.00"},{"$f":"H6*I6","v":{"v":3555200,"d":"3,555,200.00"}}]
[]
["合         计",{"$nulls":8},{"$f":"SUM(J6:J7)","v":{"v":3555200,"d":"3,555,200.00"}}]

{"sheet":"收益法","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"merged":[[0,0,0,9],[1,0,1,9],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,8,12,9]]}
["房屋建筑物评估明细表"]
["评估基准日：2021年01月08日"]
[{"$nulls":9},"2-1"]
["被评估单位：盐城大丰天州机械制造有限公司",{"$nulls":8},"金额单位：人民币元"]
["序号","建筑物名称","结构","建成\n年月","层次/层数","计量单位","建筑面积（m2)","评估单价(元/m2)","评估价值","备注"]
[]
[1,"1#厂房","钢混",2018,"1-1","m2",{"v":3893.4,"d":"3,893.40"},1465,{"$f":"ROUND(H7*G7,2)","v":{"v":5703831,"d":"5,703,831.00"}},"局部二层"]
[2,"2#厂房","钢混",2018,"1-1","m2",{"v":3893.4,"d":"3,893.40"},1465,{"v":5703831,"d":"5,703,831.00"},"局部二层"]
[3,"3#厂房","钢混",2018,"1-1","m2",{"v":3560,"d":"3,560.00"},1465,{"v":5215400,"d":"5,215,400.00"},"局部二层"]
["合     计",{"$nulls":5},{"$f":"SUM(G7:G9)","v":{"v":11346.8,"d":"11,346.80"}},null,{"$f":"SUM(I7:I9)","v":{"v":16623062,"d":"16,623,062.00"}}]
["减：房屋建筑物减值准备"]
["合            计",{"$nulls":7},{"$f":"I10-I11","v":{"v":16623062,"d":"16,623,062.00"}}]
["填报人："]
["填表日期：2021年01月08日"]