WORKBOOK /Users/neo/.hermes/audits/cashflow-asset-hook-20260512-083049/wanchuan_anhui_v9_v2_1_long_asset_R29_R58_asset_class_atomic_SAFE_20260513-085849.xlsx SHEET 长期资产循环_全量穿透校验 max_row 180 max_col 14 COLS ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q'] === TARGET ROWS 64:169 A:Q (non-empty cells; formula/value) === ROW 64 LABEL=编号 / 项目 A64:T=编号 | V=编号 B64:T=项目 | V=项目 C64:T=C 固定资产 | V=C 固定资产 D64:T=D 在建工程 | V=D 在建工程 E64:T=E 无形资产 | V=E 无形资产 F64:T=F 长期待摊费用 | V=F 长期待摊费用 G64:T=G 投资性房地产 | V=G 投资性房地产 H64:T=H 使用权资产 | V=H 使用权资产 I64:T=I 开发支出 | V=I 开发支出 J64:T=J 生物资产 | V=J 生物资产 K64:T=K 8资产合计 | V=K 8资产合计 L64:T=L 现金流D列 | V=L 现金流D列 M64:T=M 差额 | V=M 差额 N64:T=N ✓/✗ | V=N ✓/✗ ROW 65 LABEL=【大类 1 / D39 年初数 — 主行 + 3 sub (原值/累折/减值年初, 镜像 R29-R58 年初列)】 A65:T=【大类 1 / D39 年初数 — 主行 + 3 sub (原值/累折/减值年初, 镜像 R29-R58 年初列)】 | V=【大类 1 / D39 年初数 — 主行 + 3 sub (原值/累折/减值年初, 镜像 R29-R58 年初列)】 ROW 66 LABEL=D39 / 年初数 ★ (净额年初 = 原值 - 累折 - 减值) A66:T=D39 | V=D39 B66:T=年初数 ★ (净额年初 = 原值 - 累折 - 减值) | V=年初数 ★ (净额年初 = 原值 - 累折 - 减值) C66:F==N(C67)+N(C68)+N(C69) | V=569572016.3999999 D66:F==N(D67)+N(D68)+N(D69) | V=79870731.86 E66:F==N(E67)+N(E68)+N(E69) | V=0 F66:F==N(F67)+N(F68)+N(F69) | V=0 G66:F==N(G67)+N(G68)+N(G69) | V=0 H66:F==N(H67)+N(H68)+N(H69) | V=0 I66:F==N(I67)+N(I68)+N(I69) | V=0 J66:F==N(J67)+N(J68)+N(J69) | V=0 K66:F==N(C66)+N(D66)+N(E66)+N(F66)+N(G66)+N(H66)+N(I66)+N(J66) | V=649442748.2599999 L66:F==N(现金流量表!D39) | V=649442748.2600001 M66:F==K66-L66 | V=0 N66:F==IF(ABS(M66)<0.001,"✓","✗") | V=✓ ROW 67 LABEL= 1.1 / 原值-年初 A67:T= 1.1 | V= 1.1 B67:T= 原值-年初 | V= 原值-年初 C67:F==固定资产!H4 | V=688113038.6899999 D67:F==在建工程情况表!B24 | V=79870731.86 E67:F==无形资产变动表!I4 | V=0 F67:F==长期待摊费用变动明细表!B17 | V=0 G67:F==投资性房地产!D5 | V=0 H67:F=='使用权资产 '!G4 | V=0 I67:T=— | V=— J67:T=— | V=— K67:F==N(C67)+N(D67)+N(E67)+N(F67)+N(G67)+N(H67)+N(I67)+N(J67) | V=767983770.55 L67:T=— | V=— M67:T=— | V=— N67:T=— | V=— ROW 68 LABEL= 1.2 / 累折-年初 (负, snapshot) A68:T= 1.2 | V= 1.2 B68:T= 累折-年初 (负, snapshot) | V= 累折-年初 (负, snapshot) C68:F==-固定资产!H27 | V=-111038508.82000001 D68:T=— | V=— E68:F==-无形资产变动表!I24 | V=0 F68:T=— | V=— G68:F==-投资性房地产!D26 | V=0 H68:F==-'使用权资产 '!G18 | V=0 I68:T=— | V=— J68:T=— | V=— K68:F==N(C68)+N(D68)+N(E68)+N(F68)+N(G68)+N(H68)+N(I68)+N(J68) | V=-111038508.82000001 L68:T=— | V=— M68:T=— | V=— N68:T=— | V=— ROW 69 LABEL= 1.3 / 减值-年初 (负, snapshot) A69:T= 1.3 | V= 1.3 B69:T= 减值-年初 (负, snapshot) | V= 减值-年初 (负, snapshot) C69:F==-固定资产!H49 | V=-7502513.47 D69:T=— | V=— E69:F==-无形资产变动表!I42 | V=0 F69:T=— | V=— G69:F==-投资性房地产!D46 | V=0 H69:F==-'使用权资产 '!G32 | V=0 I69:T=— | V=— J69:T=— | V=— K69:F==N(C69)+N(D69)+N(E69)+N(F69)+N(G69)+N(H69)+N(I69)+N(J69) | V=-7502513.47 L69:T=— | V=— M69:T=— | V=— N69:T=— | V=— ROW 70 LABEL=【大类 2 / D40 本年增加 — 主行 + 30 sub (19 CF自然拆 + 11 资产sheet打底)】 A70:T=【大类 2 / D40 本年增加 — 主行 + 30 sub (19 CF自然拆 + 11 资产sheet打底)】 | V=【大类 2 / D40 本年增加 — 主行 + 30 sub (19 CF自然拆 + 11 资产sheet打底)】 ROW 71 LABEL=D40 / 本年增加 ★ (主行 = SUM 30 sub - 进项税 - 底稿调整) A71:T=D40 | V=D40 B71:T=本年增加 ★ (主行 = SUM 30 sub - 进项税 - 底稿调整) | V=本年增加 ★ (主行 = SUM 30 sub - 进项税 - 底稿调整) C71:F==N(C73)+N(C74)+N(C75)+N(C76)+N(C77)+N(C78)+N(C79)+N(C80)+N(C81)+N(C82)+N(C83)+N(C84)+N(C85)+N(C86)+N(C87)+N(C88)+N(C89)+N(C90)+N(C91)+N(C93)+N(C94)+N(C95)+N(C96)+N(C97)+N(C98)+N(C99)+N(C100)+N(C101)+N(C102)+N(C103) | V=321532417.4900007 D71:F==N(D73)+N(D74)+N(D75)+N(D76)+N(D77)+N(D78)+N(D79)+N(D80)+N(D81)+N(D82)+N(D83)+N(D84)+N(D85)+N(D86)+N(D87)+N(D88)+N(D89)+N(D90)+N(D91)+N(D93)+N(D94)+N(D95)+N(D96)+N(D97)+N(D98)+N(D99)+N(D100)+N(D101)+N(D102)+N(D103) | V=193931679.04 E71:F==N(E73)+N(E74)+N(E75)+N(E76)+N(E77)+N(E78)+N(E79)+N(E80)+N(E81)+N(E82)+N(E83)+N(E84)+N(E85)+N(E86)+N(E87)+N(E88)+N(E89)+N(E90)+N(E91)+N(E93)+N(E94)+N(E95)+N(E96)+N(E97)+N(E98)+N(E99)+N(E100)+N(E101)+N(E102)+N(E103) | V=0 F71:F==N(F73)+N(F74)+N(F75)+N(F76)+N(F77)+N(F78)+N(F79)+N(F80)+N(F81)+N(F82)+N(F83)+N(F84)+N(F85)+N(F86)+N(F87)+N(F88)+N(F89)+N(F90)+N(F91)+N(F93)+N(F94)+N(F95)+N(F96)+N(F97)+N(F98)+N(F99)+N(F100)+N(F101)+N(F102)+N(F103) | V=0 G71:F==N(G73)+N(G74)+N(G75)+N(G76)+N(G77)+N(G78)+N(G79)+N(G80)+N(G81)+N(G82)+N(G83)+N(G84)+N(G85)+N(G86)+N(G87)+N(G88)+N(G89)+N(G90)+N(G91)+N(G93)+N(G94)+N(G95)+N(G96)+N(G97)+N(G98)+N(G99)+N(G100)+N(G101)+N(G102)+N(G103) | V=0 H71:F==N(H73)+N(H74)+N(H75)+N(H76)+N(H77)+N(H78)+N(H79)+N(H80)+N(H81)+N(H82)+N(H83)+N(H84)+N(H85)+N(H86)+N(H87)+N(H88)+N(H89)+N(H90)+N(H91)+N(H93)+N(H94)+N(H95)+N(H96)+N(H97)+N(H98)+N(H99)+N(H100)+N(H101)+N(H102)+N(H103) | V=0 I71:F==N(I73)+N(I74)+N(I75)+N(I76)+N(I77)+N(I78)+N(I79)+N(I80)+N(I81)+N(I82)+N(I83)+N(I84)+N(I85)+N(I86)+N(I87)+N(I88)+N(I89)+N(I90)+N(I91)+N(I93)+N(I94)+N(I95)+N(I96)+N(I97)+N(I98)+N(I99)+N(I100)+N(I101)+N(I102)+N(I103) | V=0 J71:F==N(J73)+N(J74)+N(J75)+N(J76)+N(J77)+N(J78)+N(J79)+N(J80)+N(J81)+N(J82)+N(J83)+N(J84)+N(J85)+N(J86)+N(J87)+N(J88)+N(J89)+N(J90)+N(J91)+N(J93)+N(J94)+N(J95)+N(J96)+N(J97)+N(J98)+N(J99)+N(J100)+N(J101)+N(J102)+N(J103) | V=0 K71:F==N(C71)+N(D71)+N(E71)+N(F71)+N(G71)+N(H71)+N(I71)+N(J71)-N(附注!C691)-N(现金流量表底稿!C241)-N(现金流量表底稿!C242)-N(现金流量表底稿!C243) | V=459225531.53 L71:F==N(现金流量表!D40) | V=198324410 M71:F==K71-L71 | V=260901121.52999997 N71:F==IF(ABS(M71)<0.001,"✓","✗") | V=✗ ROW 72 LABEL=▎▎ 现金流公式自然拆 (19 sub, 多-cell 钩稽全拆开) ▎▎ A72:T=▎▎ 现金流公式自然拆 (19 sub, 多-cell 钩稽全拆开) ▎▎ | V=▎▎ 现金流公式自然拆 (19 sub, 多-cell 钩稽全拆开) ▎▎ ROW 73 LABEL= 2.1.a / 本期购入毛额 A73:T= 2.1.a | V= 2.1.a B73:T= 本期购入毛额 | V= 本期购入毛额 C73:F==固定资产!H7 | V=8880530.96 D73:F==在建工程情况表!D24 | V=208724052.16 E73:F==无形资产变动表!I7 | V=0 F73:F==长期待摊费用变动明细表!F17 | V=0 G73:F==投资性房地产!D8 | V=0 H73:F=='使用权资产 '!G7 | V=0 I73:T=— | V=— J73:T=— | V=— K73:F==N(C73)+N(D73)+N(E73)+N(F73)+N(G73)+N(H73)+N(I73)+N(J73) | V=217604583.12 L73:F==现金流量表底稿!C238 | V=202812210 M73:F==K73-L73 | V=14792373.120000005 N73:F==IF(ABS(M73)<0.001,"✓","✗") | V=✗ ROW 74 LABEL= 2.1.b / 本期处置抵减 (在建工程, 负) A74:T= 2.1.b | V= 2.1.b B74:T= 本期处置抵减 (在建工程, 负) | V= 本期处置抵减 (在建工程, 负) C74:T=— | V=— D74:F==-在建工程情况表!Q24 | V=-14792373.12 E74:T=— | V=— F74:T=— | V=— G74:T=— | V=— H74:T=— | V=— I74:T=— | V=— J74:T=— | V=— K74:F==N(C74)+N(D74)+N(E74)+N(F74)+N(G74)+N(H74)+N(I74)+N(J74) | V=-14792373.12 L74:T=— | V=— M74:T=— | V=— N74:T=— | V=— ROW 75 LABEL= 2.2.a / 开发支出本期发生 A75:T= 2.2.a | V= 2.2.a B75:T= 开发支出本期发生 | V= 开发支出本期发生 C75:T=— | V=— D75:T=— | V=— E75:F==附注!C1205 | V=0 F75:F==长期待摊费用变动明细表!E17 | V=0 G75:T=— | V=— H75:T=— | V=— I75:T=— | V=— J75:T=— | V=— K75:F==N(C75)+N(D75)+N(E75)+N(F75)+N(G75)+N(H75)+N(I75)+N(J75) | V=0 L75:F==现金流量表底稿!C239 | V=0 M75:F==K75-L75 | V=0 N75:F==IF(ABS(M75)<0.001,"✓","✗") | V=✓ ROW 76 LABEL= 2.2.b / 开发支出资本化转出 (负) A76:T= 2.2.b | V= 2.2.b B76:T= 开发支出资本化转出 (负) | V= 开发支出资本化转出 (负) C76:T=— | V=— D76:T=— | V=— E76:F==-附注!G1205 | V=0 F76:T=— | V=— G76:T=— | V=— H76:T=— | V=— I76:T=— | V=— J76:T=— | V=— K76:F==N(C76)+N(D76)+N(E76)+N(F76)+N(G76)+N(H76)+N(I76)+N(J76) | V=0 L76:T=— | V=— M76:T=— | V=— N76:T=— | V=— ROW 77 LABEL= 2.3 / 进项税 ★ (CF专属) A77:T= 2.3 | V= 2.3 B77:T= 进项税 ★ (CF专属) | V= 进项税 ★ (CF专属) C77:F==附注!C691 | V=56238565.0000007 D77:T=— | V=— E77:T=— | V=— F77:T=— | V=— G77:T=— | V=— H77:T=— | V=— I77:T=— | V=— J77:T=— | V=— K77:F==N(C77)+N(D77)+N(E77)+N(F77)+N(G77)+N(H77)+N(I77)+N(J77) | V=56238565.0000007 L77:F==现金流量表底稿!C240 | V=56238565.0000007 M77:F==K77-L77 | V=0 N77:F==IF(ABS(M77)<0.001,"✓","✗") | V=✓ ROW 78 LABEL= 2.4 / 利息资本化 (在建特有, 负) A78:T= 2.4 | V= 2.4 B78:T= 利息资本化 (在建特有, 负) | V= 利息资本化 (在建特有, 负) C78:T=— | V=— D78:F==-在建工程情况表!E24 | V=0 E78:T=— | V=— F78:T=— | V=— G78:T=— | V=— H78:T=— | V=— I78:T=— | V=— J78:T=— | V=— K78:F==N(C78)+N(D78)+N(E78)+N(F78)+N(G78)+N(H78)+N(I78)+N(J78) | V=0 L78:F==现金流量表底稿!C241 | V=0 M78:F==K78-L78 | V=0 N78:F==IF(ABS(M78)<0.001,"✓","✗") | V=✓ ROW 79 LABEL= 2.5.a / 预付账款期末 A79:T= 2.5.a | V= 2.5.a B79:T= 预付账款期末 | V= 预付账款期末 C79:F==附注!E1224 | V=0 D79:T=— | V=— E79:T=— | V=— F79:T=— | V=— G79:T=— | V=— H79:T=— | V=— I79:T=— | V=— J79:T=— | V=— K79:F==N(C79)+N(D79)+N(E79)+N(F79)+N(G79)+N(H79)+N(I79)+N(J79) | V=0 L79:F==现金流量表底稿!C242 | V=0 M79:F==K79-L79 | V=0 N79:F==IF(ABS(M79)<0.001,"✓","✗") | V=✓ ROW 80 LABEL= 2.5.b / 预付账款期初 (负) A80:T= 2.5.b | V= 2.5.b B80:T= 预付账款期初 (负) | V= 预付账款期初 (负) C80:F==-附注!F1224 | V=0 D80:T=— | V=— E80:T=— | V=— F80:T=— | V=— G80:T=— | V=— H80:T=— | V=— I80:T=— | V=— J80:T=— | V=— K80:F==N(C80)+N(D80)+N(E80)+N(F80)+N(G80)+N(H80)+N(I80)+N(J80) | V=0 L80:T=— | V=— M80:T=— | V=— N80:T=— | V=— ROW 81 LABEL= 2.6.a / 应付购建期末 A81:T= 2.6.a | V= 2.6.a B81:T= 应付购建期末 | V= 应付购建期末 C81:F==附注!C1239 | V=0 D81:T=— | V=— E81:T=— | V=— F81:T=— | V=— G81:T=— | V=— H81:T=— | V=— I81:T=— | V=— J81:T=— | V=— K81:F==N(C81)+N(D81)+N(E81)+N(F81)+N(G81)+N(H81)+N(I81)+N(J81) | V=0 L81:F==现金流量表底稿!C243 | V=0 M81:F==K81-L81 | V=0 N81:F==IF(ABS(M81)<0.001,"✓","✗") | V=✓ ROW 82 LABEL= 2.6.b / 应付购建期初 (负) A82:T= 2.6.b | V= 2.6.b B82:T= 应付购建期初 (负) | V= 应付购建期初 (负) C82:F==-附注!B1239 | V=0 D82:T=— | V=— E82:T=— | V=— F82:T=— | V=— G82:T=— | V=— H82:T=— | V=— I82:T=— | V=— J82:T=— | V=— K82:F==N(C82)+N(D82)+N(E82)+N(F82)+N(G82)+N(H82)+N(I82)+N(J82) | V=0 L82:T=— | V=— M82:T=— | V=— N82:T=— | V=— ROW 83 LABEL= 2.7.a / 其他非流动期末 A83:T= 2.7.a | V= 2.7.a B83:T= 其他非流动期末 | V= 其他非流动期末 C83:T=— | V=— D83:T=— | V=— E83:F==附注!E364 | V=0 F83:T=— | V=— G83:T=— | V=— H83:T=— | V=— I83:T=— | V=— J83:T=— | V=— K83:F==N(C83)+N(D83)+N(E83)+N(F83)+N(G83)+N(H83)+N(I83)+N(J83) | V=0 L83:F==现金流量表底稿!C244 | V=0 M83:F==K83-L83 | V=0 N83:F==IF(ABS(M83)<0.001,"✓","✗") | V=✓ ROW 84 LABEL= 2.7.b / 其他非流动期初 (负) A84:T= 2.7.b | V= 2.7.b B84:T= 其他非流动期初 (负) | V= 其他非流动期初 (负) C84:T=— | V=— D84:T=— | V=— E84:F==-附注!F364 | V=0 F84:T=— | V=— G84:T=— | V=— H84:T=— | V=— I84:T=— | V=— J84:T=— | V=— K84:F==N(C84)+N(D84)+N(E84)+N(F84)+N(G84)+N(H84)+N(I84)+N(J84) | V=0 L84:T=— | V=— M84:T=— | V=— N84:T=— | V=— ROW 85 LABEL= 2.8.a / 长期应付款期末 A85:T= 2.8.a | V= 2.8.a B85:T= 长期应付款期末 | V= 长期应付款期末 C85:F==附注!D756 | V=0 D85:T=— | V=— E85:T=— | V=— F85:T=— | V=— G85:T=— | V=— H85:T=— | V=— I85:T=— | V=— J85:T=— | V=— K85:F==N(C85)+N(D85)+N(E85)+N(F85)+N(G85)+N(H85)+N(I85)+N(J85) | V=0 L85:F==现金流量表底稿!C245 | V=0 M85:F==K85-L85 | V=0 N85:F==IF(ABS(M85)<0.001,"✓","✗") | V=✓ ROW 86 LABEL= 2.8.b / 长期应付款期初 (负) A86:T= 2.8.b | V= 2.8.b B86:T= 长期应付款期初 (负) | V= 长期应付款期初 (负) C86:F==-附注!C756 | V=0 D86:T=— | V=— E86:T=— | V=— F86:T=— | V=— G86:T=— | V=— H86:T=— | V=— I86:T=— | V=— J86:T=— | V=— K86:F==N(C86)+N(D86)+N(E86)+N(F86)+N(G86)+N(H86)+N(I86)+N(J86) | V=0 L86:T=— | V=— M86:T=— | V=— N86:T=— | V=— ROW 87 LABEL= 2.9.a / 融资租赁期末 (负) A87:T= 2.9.a | V= 2.9.a B87:T= 融资租赁期末 (负) | V= 融资租赁期末 (负) C87:T=— | V=— D87:T=— | V=— E87:T=— | V=— F87:T=— | V=— G87:T=— | V=— H87:F==-长期应付款明细!G23 | V=0 I87:T=— | V=— J87:T=— | V=— K87:F==N(C87)+N(D87)+N(E87)+N(F87)+N(G87)+N(H87)+N(I87)+N(J87) | V=0 L87:F==现金流量表底稿!C246 | V=0 M87:F==K87-L87 | V=0 N87:F==IF(ABS(M87)<0.001,"✓","✗") | V=✓ ROW 88 LABEL= 2.9.b / 融资租赁期初 A88:T= 2.9.b | V= 2.9.b B88:T= 融资租赁期初 | V= 融资租赁期初 C88:T=— | V=— D88:T=— | V=— E88:T=— | V=— F88:T=— | V=— G88:T=— | V=— H88:F==长期应付款明细!H23 | V=0 I88:T=— | V=— J88:T=— | V=— K88:F==N(C88)+N(D88)+N(E88)+N(F88)+N(G88)+N(H88)+N(I88)+N(J88) | V=0 L88:T=— | V=— M88:T=— | V=— N88:T=— | V=— ROW 89 LABEL= 2.10.a / 其他应付期末 (负) A89:T= 2.10.a | V= 2.10.a B89:T= 其他应付期末 (负) | V= 其他应付期末 (负) C89:F==-附注!H1244 | V=-24284000 D89:T=— | V=— E89:T=— | V=— F89:T=— | V=— G89:T=— | V=— H89:T=— | V=— I89:T=— | V=— J89:T=— | V=— K89:F==N(C89)+N(D89)+N(E89)+N(F89)+N(G89)+N(H89)+N(I89)+N(J89) | V=-24284000 L89:F==现金流量表底稿!C247 | V=-4487800 M89:F==K89-L89 | V=-19796200 N89:F==IF(ABS(M89)<0.001,"✓","✗") | V=✗ ROW 90 LABEL= 2.10.b / 其他应付期初 A90:T= 2.10.b | V= 2.10.b B90:T= 其他应付期初 | V= 其他应付期初 C90:F==附注!I1244 | V=19796200 D90:T=— | V=— E90:T=— | V=— F90:T=— | V=— G90:T=— | V=— H90:T=— | V=— I90:T=— | V=— J90:T=— | V=— K90:F==N(C90)+N(D90)+N(E90)+N(F90)+N(G90)+N(H90)+N(I90)+N(J90) | V=19796200 L90:T=— | V=— M90:T=— | V=— N90:T=— | V=— ROW 91 LABEL= 2.11 / 使用权增加 (不入D40) A91:T= 2.11 | V= 2.11 B91:T= 使用权增加 (不入D40) | V= 使用权增加 (不入D40) C91:T=— | V=— D91:T=— | V=— E91:T=— | V=— F91:T=— | V=— G91:T=— | V=— H91:F=='使用权资产 '!G7 | V=0 I91:T=— | V=— J91:T=— | V=— K91:F==N(C91)+N(D91)+N(E91)+N(F91)+N(G91)+N(H91)+N(I91)+N(J91) | V=0 L91:T=— | V=— M91:T=— | V=— N91:T=— | V=— ROW 92 LABEL=▎▎ 资产明细段 增加项 (11 sub, 单 cell, 不拆) ▎▎ A92:T=▎▎ 资产明细段 增加项 (11 sub, 单 cell, 不拆) ▎▎ | V=▎▎ 资产明细段 增加项 (11 sub, 单 cell, 不拆) ▎▎ ROW 93 LABEL= 2.12 / 投资方投入 A93:T= 2.12 | V= 2.12 B93:T= 投资方投入 | V= 投资方投入 C93:F==固定资产!H6 | V=0 D93:T=— | V=— E93:F==无形资产变动表!I6 | V=0 F93:T=— | V=— G93:F==投资性房地产!D7 | V=0 H93:F=='使用权资产 '!G6 | V=0 I93:T=— | V=— J93:T=— | V=— K93:F==N(C93)+N(D93)+N(E93)+N(F93)+N(G93)+N(H93)+N(I93)+N(J93) | V=0 L93:T=— | V=— M93:T=— | V=— N93:T=— | V=— ROW 94 LABEL= 2.13 / 因非同一控制下企业合并而增加 A94:T= 2.13 | V= 2.13 B94:T= 因非同一控制下企业合并而增加 | V= 因非同一控制下企业合并而增加 C94:F==固定资产!H5 | V=0 D94:F==在建工程情况表!F24 | V=0 E94:F==无形资产变动表!I5 | V=0 F94:F==长期待摊费用变动明细表!C17 | V=0 G94:F==投资性房地产!D6 | V=0 H94:F=='使用权资产 '!G5 | V=0 I94:T=— | V=— J94:T=— | V=— K94:F==N(C94)+N(D94)+N(E94)+N(F94)+N(G94)+N(H94)+N(I94)+N(J94) | V=0 L94:T=— | V=— M94:T=— | V=— N94:T=— | V=— ROW 95 LABEL= 2.14 / 由在建工程转入 (内部转换) A95:T= 2.14 | V= 2.14 B95:T= 由在建工程转入 (内部转换) | V= 由在建工程转入 (内部转换) C95:F==固定资产!H8 | V=260901121.53 D95:T=— | V=— E95:F==无形资产变动表!I11 | V=0 F95:F==长期待摊费用变动明细表!E17 | V=0 G95:F==投资性房地产!D9 | V=0 H95:T=— | V=— I95:T=— | V=— J95:T=— | V=— K95:F==N(C95)+N(D95)+N(E95)+N(F95)+N(G95)+N(H95)+N(I95)+N(J95) | V=260901121.53 L95:T=— | V=— M95:T=— | V=— N95:T=— | V=— ROW 96 LABEL= 2.15 / 由无形资产转入 (内部转换) A96:T= 2.15 | V= 2.15 B96:T= 由无形资产转入 (内部转换) | V= 由无形资产转入 (内部转换) C96:F==固定资产!H9 | V=0 D96:T=— | V=— E96:T=— | V=— F96:T=— | V=— G96:F==投资性房地产!D10 | V=0 H96:T=— | V=— I96:T=— | V=— J96:T=— | V=— K96:F==N(C96)+N(D96)+N(E96)+N(F96)+N(G96)+N(H96)+N(I96)+N(J96) | V=0 L96:T=— | V=— M96:T=— | V=— N96:T=— | V=— ROW 97 LABEL= 2.16 / 由投资性房地产转入 (内部转换) A97:T= 2.16 | V= 2.16 B97:T= 由投资性房地产转入 (内部转换) | V= 由投资性房地产转入 (内部转换) C97:F==固定资产!H10 | V=0 D97:T=— | V=— E97:F==无形资产变动表!I9 | V=0 F97:T=— | V=— G97:T=— | V=— H97:T=— | V=— I97:T=— | V=— J97:T=— | V=— K97:F==N(C97)+N(D97)+N(E97)+N(F97)+N(G97)+N(H97)+N(I97)+N(J97) | V=0 L97:T=— | V=— M97:T=— | V=— N97:T=— | V=— ROW 98 LABEL= 2.17 / 由长期待摊费用转入 (内部转换) A98:T= 2.17 | V= 2.17 B98:T= 由长期待摊费用转入 (内部转换) | V= 由长期待摊费用转入 (内部转换) C98:F==固定资产!H11 | V=0 D98:T=— | V=— E98:T=— | V=— F98:T=— | V=— G98:T=— | V=— H98:T=— | V=— I98:T=— | V=— J98:T=— | V=— K98:F==N(C98)+N(D98)+N(E98)+N(F98)+N(G98)+N(H98)+N(I98)+N(J98) | V=0 L98:T=— | V=— M98:T=— | V=— N98:T=— | V=— ROW 99 LABEL= 2.18 / 由开发支出转入 (内部转换) A99:T= 2.18 | V= 2.18 B99:T= 由开发支出转入 (内部转换) | V= 由开发支出转入 (内部转换) C99:T=— | V=— D99:T=— | V=— E99:F==无形资产变动表!I10 | V=0 F99:T=— | V=— G99:T=— | V=— H99:T=— | V=— I99:T=— | V=— J99:T=— | V=— K99:F==N(C99)+N(D99)+N(E99)+N(F99)+N(G99)+N(H99)+N(I99)+N(J99) | V=0 L99:T=— | V=— M99:T=— | V=— N99:T=— | V=— ROW 100 LABEL= 2.19 / 由其他转入 A100:T= 2.19 | V= 2.19 B100:T= 由其他转入 | V= 由其他转入 C100:F==固定资产!H12 | V=0 D100:T=— | V=— E100:F==无形资产变动表!I12 | V=0 F100:T=— | V=— G100:F==投资性房地产!D12 | V=0 H100:T=— | V=— I100:T=— | V=— J100:T=— | V=— K100:F==N(C100)+N(D100)+N(E100)+N(F100)+N(G100)+N(H100)+N(I100)+N(J100) | V=0 L100:T=— | V=— M100:T=— | V=— N100:T=— | V=— ROW 101 LABEL= 2.20 / 因汇率变动而增加 A101:T= 2.20 | V= 2.20 B101:T= 因汇率变动而增加 | V= 因汇率变动而增加 C101:F==固定资产!H13 | V=0 D101:F==在建工程情况表!J24 | V=0 E101:F==无形资产变动表!I13 | V=0 F101:T=— | V=— G101:F==投资性房地产!D13 | V=0 H101:T=— | V=— I101:T=— | V=— J101:T=— | V=— K101:F==N(C101)+N(D101)+N(E101)+N(F101)+N(G101)+N(H101)+N(I101)+N(J101) | V=0 L101:T=— | V=— M101:T=— | V=— N101:T=— | V=— ROW 102 LABEL= 2.21 / 使权 修改租赁条款变动 (原值) A102:T= 2.21 | V= 2.21 B102:T= 使权 修改租赁条款变动 (原值) | V= 使权 修改租赁条款变动 (原值) C102:T=— | V=— D102:T=— | V=— E102:T=— | V=— F102:T=— | V=— G102:T=— | V=— H102:F=='使用权资产 '!G8 | V=0 I102:T=— | V=— J102:T=— | V=— K102:F==N(C102)+N(D102)+N(E102)+N(F102)+N(G102)+N(H102)+N(I102)+N(J102) | V=0 L102:T=— | V=— M102:T=— | V=— N102:T=— | V=— ROW 103 LABEL= 2.22 / 使权 其他变动 (原值) A103:T= 2.22 | V= 2.22 B103:T= 使权 其他变动 (原值) | V= 使权 其他变动 (原值) C103:T=— | V=— D103:T=— | V=— E103:T=— | V=— F103:T=— | V=— G103:T=— | V=— H103:F=='使用权资产 '!G9 | V=0 I103:T=— | V=— J103:T=— | V=— K103:F==N(C103)+N(D103)+N(E103)+N(F103)+N(G103)+N(H103)+N(I103)+N(J103) | V=0 L103:T=— | V=— M103:T=— | V=— N103:T=— | V=— ROW 104 LABEL=【大类 3 / D41 其他变动 — 主行 + 5 sub (其他增加拆 3 行)】 A104:T=【大类 3 / D41 其他变动 — 主行 + 5 sub (其他增加拆 3 行)】 | V=【大类 3 / D41 其他变动 — 主行 + 5 sub (其他增加拆 3 行)】 ROW 105 LABEL=D41 / 其他变动 (主行 = SUM 5 sub) A105:T=D41 | V=D41 B105:T=其他变动 (主行 = SUM 5 sub) | V=其他变动 (主行 = SUM 5 sub) C105:F==N(C106)+N(C107)+N(C108)+N(C109)+N(C110) | V=1022863.3799999999 D105:F==N(D106)+N(D107)+N(D108)+N(D109)+N(D110) | V=-5810901.95 E105:F==N(E106)+N(E107)+N(E108)+N(E109)+N(E110) | V=4738601.05 F105:F==N(F106)+N(F107)+N(F108)+N(F109)+N(F110) | V=0 G105:F==N(G106)+N(G107)+N(G108)+N(G109)+N(G110) | V=0 H105:F==N(H106)+N(H107)+N(H108)+N(H109)+N(H110) | V=6737283.33 I105:F==N(I106)+N(I107)+N(I108)+N(I109)+N(I110) | V=0 J105:F==N(J106)+N(J107)+N(J108)+N(J109)+N(J110) | V=0 K105:F==N(C105)+N(D105)+N(E105)+N(F105)+N(G105)+N(H105)+N(I105)+N(J105) | V=6687845.81 L105:F==N(现金流量表!D41) | V=0 M105:F==K105-L105 | V=6687845.81 N105:F==IF(ABS(M105)<0.001,"✓","✗") | V=✗ ROW 106 LABEL= 3.1.a / 其他增加 (含使权-其他变动原值) A106:T= 3.1.a | V= 3.1.a B106:T= 其他增加 (含使权-其他变动原值) | V= 其他增加 (含使权-其他变动原值) C106:F==固定资产!H53 | V=0 D106:T=— | V=— E106:F==无形资产变动表!I46 | V=0 F106:T=— | V=— G106:F==投资性房地产!D50 | V=0 H106:F=='使用权资产 '!G9 | V=0 I106:T=— | V=— J106:T=— | V=— K106:F==N(C106)+N(D106)+N(E106)+N(F106)+N(G106)+N(H106)+N(I106)+N(J106) | V=0 L106:T=— | V=— M106:T=— | V=— N106:T=— | V=— ROW 107 LABEL= 3.1.b / 使权-其他变动累折 (负) A107:T= 3.1.b | V= 3.1.b B107:T= 使权-其他变动累折 (负) | V= 使权-其他变动累折 (负) C107:T=— | V=— D107:T=— | V=— E107:T=— | V=— F107:T=— | V=— G107:T=— | V=— H107:F==-'使用权资产 '!G23 | V=0 I107:T=— | V=— J107:T=— | V=— K107:F==N(C107)+N(D107)+N(E107)+N(F107)+N(G107)+N(H107)+N(I107)+N(J107) | V=0 L107:T=— | V=— M107:T=— | V=— N107:T=— | V=— ROW 108 LABEL= 3.1.c / 使权-其他变动减值 (负) A108:T= 3.1.c | V= 3.1.c B108:T= 使权-其他变动减值 (负) | V= 使权-其他变动减值 (负) C108:T=— | V=— D108:T=— | V=— E108:T=— | V=— F108:T=— | V=— G108:T=— | V=— H108:F==-'使用权资产 '!G36 | V=0 I108:T=— | V=— J108:T=— | V=— K108:F==N(C108)+N(D108)+N(E108)+N(F108)+N(G108)+N(H108)+N(I108)+N(J108) | V=0 L108:T=— | V=— M108:T=— | V=— N108:T=— | V=— ROW 109 LABEL= 3.2 / 其他减少 A109:T= 3.2 | V= 3.2 B109:T= 其他减少 | V= 其他减少 C109:F==-固定资产!H57 | V=0 D109:T=— | V=— E109:F==-无形资产变动表!I50 | V=0 F109:T=— | V=— G109:F==-投资性房地产!D54 | V=0 H109:T=— | V=— I109:T=— | V=— J109:T=— | V=— K109:F==N(C109)+N(D109)+N(E109)+N(F109)+N(G109)+N(H109)+N(I109)+N(J109) | V=0 L109:T=— | V=— M109:T=— | V=— N109:T=— | V=— ROW 110 LABEL= 3.3 / 综合调整 (手工) A110:T= 3.3 | V= 3.3 B110:T= 综合调整 (手工) | V= 综合调整 (手工) C110:F==6687845.81-5664982.43 | V=1022863.3799999999 D110:F==-5810901.95 | V=-5810901.95 E110:F==4738601.05 | V=4738601.05 F110:T=— | V=— G110:T=— | V=— H110:F==6737283.33 | V=6737283.33 I110:T=— | V=— J110:T=— | V=— K110:F==N(C110)+N(D110)+N(E110)+N(F110)+N(G110)+N(H110)+N(I110)+N(J110) | V=6687845.81 L110:T=— | V=— M110:T=— | V=— N110:T=— | V=— ROW 111 LABEL=【大类 4 / D42 折旧摊销 — 主行 + 21 sub (累折段所有变动, 不变)】 A111:T=【大类 4 / D42 折旧摊销 — 主行 + 21 sub (累折段所有变动, 不变)】 | V=【大类 4 / D42 折旧摊销 — 主行 + 21 sub (累折段所有变动, 不变)】 ROW 112 LABEL=D42 / 折旧摊销 ★ (主行 = -SUM(累折增加 12 sub) + SUM(累折减少 9 sub)) A112:T=D42 | V=D42 B112:T=折旧摊销 ★ (主行 = -SUM(累折增加 12 sub) + SUM(累折减少 9 sub)) | V=折旧摊销 ★ (主行 = -SUM(累折增加 12 sub) + SUM(累折减少 9 sub)) C112:F==-(N(C114)+N(C115)+N(C116)+N(C117)+N(C118)+N(C119)+N(C120)+N(C121)+N(C122)+N(C123)+N(C124)+N(C125))+(N(C127)+N(C128)+N(C129)+N(C130)+N(C131)+N(C132)+N(C133)+N(C134)+N(C135)) | V=-49944091.46 D112:F==-(N(D114)+N(D115)+N(D116)+N(D117)+N(D118)+N(D119)+N(D120)+N(D121)+N(D122)+N(D123)+N(D124)+N(D125))+(N(D127)+N(D128)+N(D129)+N(D130)+N(D131)+N(D132)+N(D133)+N(D134)+N(D135)) | V=0 E112:F==-(N(E114)+N(E115)+N(E116)+N(E117)+N(E118)+N(E119)+N(E120)+N(E121)+N(E122)+N(E123)+N(E124)+N(E125))+(N(E127)+N(E128)+N(E129)+N(E130)+N(E131)+N(E132)+N(E133)+N(E134)+N(E135)) | V=0 F112:F==-(N(F114)+N(F115)+N(F116)+N(F117)+N(F118)+N(F119)+N(F120)+N(F121)+N(F122)+N(F123)+N(F124)+N(F125))+(N(F127)+N(F128)+N(F129)+N(F130)+N(F131)+N(F132)+N(F133)+N(F134)+N(F135)) | V=0 G112:F==-(N(G114)+N(G115)+N(G116)+N(G117)+N(G118)+N(G119)+N(G120)+N(G121)+N(G122)+N(G123)+N(G124)+N(G125))+(N(G127)+N(G128)+N(G129)+N(G130)+N(G131)+N(G132)+N(G133)+N(G134)+N(G135)) | V=0 H112:F==-(N(H114)+N(H115)+N(H116)+N(H117)+N(H118)+N(H119)+N(H120)+N(H121)+N(H122)+N(H123)+N(H124)+N(H125))+(N(H127)+N(H128)+N(H129)+N(H130)+N(H131)+N(H132)+N(H133)+N(H134)+N(H135)) | V=0 I112:F==-(N(I114)+N(I115)+N(I116)+N(I117)+N(I118)+N(I119)+N(I120)+N(I121)+N(I122)+N(I123)+N(I124)+N(I125))+(N(I127)+N(I128)+N(I129)+N(I130)+N(I131)+N(I132)+N(I133)+N(I134)+N(I135)) | V=0 J112:F==-(N(J114)+N(J115)+N(J116)+N(J117)+N(J118)+N(J119)+N(J120)+N(J121)+N(J122)+N(J123)+N(J124)+N(J125))+(N(J127)+N(J128)+N(J129)+N(J130)+N(J131)+N(J132)+N(J133)+N(J134)+N(J135)) | V=0 K112:F==N(C112)+N(D112)+N(E112)+N(F112)+N(G112)+N(H112)+N(I112)+N(J112) | V=-49944091.46 L112:F==N(现金流量表!D42) | V=-111393945.36 M112:F==K112-L112 | V=61449853.9 N112:F==IF(ABS(M112)<0.001,"✓","✗") | V=✗ ROW 113 LABEL=▎▎ 累折段增加项 (12 sub, 单 cell, 不变) ▎▎ A113:T=▎▎ 累折段增加项 (12 sub, 单 cell, 不变) ▎▎ | V=▎▎ 累折段增加项 (12 sub, 单 cell, 不变) ▎▎ ROW 114 LABEL= 4.1 / 累折-合并增加 A114:T= 4.1 | V= 4.1 B114:T= 累折-合并增加 | V= 累折-合并增加 C114:F==固定资产!H28 | V=0 D114:T=— | V=— E114:F==无形资产变动表!I25 | V=0 F114:T=— | V=— G114:F==投资性房地产!D27 | V=0 H114:F=='使用权资产 '!G19 | V=0 I114:T=— | V=— J114:T=— | V=— K114:F==N(C114)+N(D114)+N(E114)+N(F114)+N(G114)+N(H114)+N(I114)+N(J114) | V=0 L114:T=— | V=— M114:T=— | V=— N114:T=— | V=— ROW 115 LABEL= 4.2 / 累折-投资方投入 A115:T= 4.2 | V= 4.2 B115:T= 累折-投资方投入 | V= 累折-投资方投入 C115:F==固定资产!H29 | V=0 D115:T=— | V=— E115:F==无形资产变动表!I26 | V=0 F115:T=— | V=— G115:F==投资性房地产!D28 | V=0 H115:F=='使用权资产 '!G20 | V=0 I115:T=— | V=— J115:T=— | V=— K115:F==N(C115)+N(D115)+N(E115)+N(F115)+N(G115)+N(H115)+N(I115)+N(J115) | V=0 L115:T=— | V=— M115:T=— | V=— N115:T=— | V=— ROW 116 LABEL= 4.3 / 本期计提 ★ (折旧/摊销) A116:T= 4.3 | V= 4.3 B116:T= 本期计提 ★ (折旧/摊销) | V= 本期计提 ★ (折旧/摊销) C116:F==固定资产!H30 | V=111393945.36 D116:T=— | V=— E116:F==无形资产变动表!I27 | V=0 F116:F==长期待摊费用变动明细表!L17 | V=0 G116:F==投资性房地产!D29 | V=0 H116:F=='使用权资产 '!G21 | V=0 I116:T=— | V=— J116:T=— | V=— K116:F==N(C116)+N(D116)+N(E116)+N(F116)+N(G116)+N(H116)+N(I116)+N(J116) | V=111393945.36 L116:T=— | V=— M116:T=— | V=— N116:T=— | V=— ROW 117 LABEL= 4.4 / 累折-由固定资产转入 A117:T= 4.4 | V= 4.4 B117:T= 累折-由固定资产转入 | V= 累折-由固定资产转入 C117:T=— | V=— D117:T=— | V=— E117:F==无形资产变动表!I28 | V=0 F117:T=— | V=— G117:T=— | V=— H117:T=— | V=— I117:T=— | V=— J117:T=— | V=— K117:F==N(C117)+N(D117)+N(E117)+N(F117)+N(G117)+N(H117)+N(I117)+N(J117) | V=0 L117:T=— | V=— M117:T=— | V=— N117:T=— | V=— ROW 118 LABEL= 4.5 / 累折-由无形资产转入 A118:T= 4.5 | V= 4.5 B118:T= 累折-由无形资产转入 | V= 累折-由无形资产转入 C118:F==固定资产!H31 | V=0 D118:T=— | V=— E118:T=— | V=— F118:T=— | V=— G118:T=— | V=— H118:T=— | V=— I118:T=— | V=— J118:T=— | V=— K118:F==N(C118)+N(D118)+N(E118)+N(F118)+N(G118)+N(H118)+N(I118)+N(J118) | V=0 L118:T=— | V=— M118:T=— | V=— N118:T=— | V=— ROW 119 LABEL= 4.6 / 累折-由投资性房地产转入 A119:T= 4.6 | V= 4.6 B119:T= 累折-由投资性房地产转入 | V= 累折-由投资性房地产转入 C119:F==固定资产!H32 | V=0 D119:T=— | V=— E119:F==无形资产变动表!I29 | V=0 F119:T=— | V=— G119:T=— | V=— H119:T=— | V=— I119:T=— | V=— J119:T=— | V=— K119:F==N(C119)+N(D119)+N(E119)+N(F119)+N(G119)+N(H119)+N(I119)+N(J119) | V=0 L119:T=— | V=— M119:T=— | V=— N119:T=— | V=— ROW 120 LABEL= 4.7 / 累折-由长期待摊费用转入 A120:T= 4.7 | V= 4.7 B120:T= 累折-由长期待摊费用转入 | V= 累折-由长期待摊费用转入 C120:F==固定资产!H33 | V=0 D120:T=— | V=— E120:T=— | V=— F120:T=— | V=— G120:T=— | V=— H120:T=— | V=— I120:T=— | V=— J120:T=— | V=— K120:F==N(C120)+N(D120)+N(E120)+N(F120)+N(G120)+N(H120)+N(I120)+N(J120) | V=0 L120:T=— | V=— M120:T=— | V=— N120:T=— | V=— ROW 121 LABEL= 4.8 / 累折-修改租赁条款变动 (使权) A121:T= 4.8 | V= 4.8 B121:T= 累折-修改租赁条款变动 (使权) | V= 累折-修改租赁条款变动 (使权) C121:T=— | V=— D121:T=— | V=— E121:T=— | V=— F121:T=— | V=— G121:T=— | V=— H121:F=='使用权资产 '!G22 | V=0 I121:T=— | V=— J121:T=— | V=— K121:F==N(C121)+N(D121)+N(E121)+N(F121)+N(G121)+N(H121)+N(I121)+N(J121) | V=0 L121:T=— | V=— M121:T=— | V=— N121:T=— | V=— ROW 122 LABEL= 4.9 / 累折-其他变动 (使权) A122:T= 4.9 | V= 4.9 B122:T= 累折-其他变动 (使权) | V= 累折-其他变动 (使权) C122:T=— | V=— D122:T=— | V=— E122:T=— | V=— F122:T=— | V=— G122:T=— | V=— H122:F=='使用权资产 '!G23 | V=0 I122:T=— | V=— J122:T=— | V=— K122:F==N(C122)+N(D122)+N(E122)+N(F122)+N(G122)+N(H122)+N(I122)+N(J122) | V=0 L122:T=— | V=— M122:T=— | V=— N122:T=— | V=— ROW 123 LABEL= 4.10 / 累折-汇率变动 (使权) A123:T= 4.10 | V= 4.10 B123:T= 累折-汇率变动 (使权) | V= 累折-汇率变动 (使权) C123:T=— | V=— D123:T=— | V=— E123:T=— | V=— F123:T=— | V=— G123:T=— | V=— H123:F=='使用权资产 '!G24 | V=0 I123:T=— | V=— J123:T=— | V=— K123:F==N(C123)+N(D123)+N(E123)+N(F123)+N(G123)+N(H123)+N(I123)+N(J123) | V=0 L123:T=— | V=— M123:T=— | V=— N123:T=— | V=— ROW 124 LABEL= 4.11 / 累折-由其他转入 A124:T= 4.11 | V= 4.11 B124:T= 累折-由其他转入 | V= 累折-由其他转入 C124:F==固定资产!H34 | V=0 D124:T=— | V=— E124:F==无形资产变动表!I30 | V=0 F124:T=— | V=— G124:F==投资性房地产!D32 | V=0 H124:T=— | V=— I124:T=— | V=— J124:T=— | V=— K124:F==N(C124)+N(D124)+N(E124)+N(F124)+N(G124)+N(H124)+N(I124)+N(J124) | V=0 L124:T=— | V=— M124:T=— | V=— N124:T=— | V=— ROW 125 LABEL= 4.12 / 累折-因汇率变动而增加 A125:T= 4.12 | V= 4.12 B125:T= 累折-因汇率变动而增加 | V= 累折-因汇率变动而增加 C125:F==固定资产!H35 | V=0 D125:T=— | V=— E125:F==无形资产变动表!I31 | V=0 F125:T=— | V=— G125:F==投资性房地产!D33 | V=0 H125:T=— | V=— I125:T=— | V=— J125:T=— | V=— K125:F==N(C125)+N(D125)+N(E125)+N(F125)+N(G125)+N(H125)+N(I125)+N(J125) | V=0 L125:T=— | V=— M125:T=— | V=— N125:T=— | V=— ROW 126 LABEL=▎▎ 累折段减少项 (9 sub, 单 cell, 不变) ▎▎ A126:T=▎▎ 累折段减少项 (9 sub, 单 cell, 不变) ▎▎ | V=▎▎ 累折段减少项 (9 sub, 单 cell, 不变) ▎▎ ROW 127 LABEL= 4.13 / 累折-本期对外投资转出 A127:T= 4.13 | V= 4.13 B127:T= 累折-本期对外投资转出 | V= 累折-本期对外投资转出 C127:F==固定资产!H36 | V=0 D127:T=— | V=— E127:F==无形资产变动表!I32 | V=0 F127:T=— | V=— G127:F==投资性房地产!D34 | V=0 H127:F=='使用权资产 '!G25 | V=0 I127:T=— | V=— J127:T=— | V=— K127:F==N(C127)+N(D127)+N(E127)+N(F127)+N(G127)+N(H127)+N(I127)+N(J127) | V=0 L127:T=— | V=— M127:T=— | V=— N127:T=— | V=— ROW 128 LABEL= 4.14 / 累折-本期处置及出售 (回转) A128:T= 4.14 | V= 4.14 B128:T= 累折-本期处置及出售 (回转) | V= 累折-本期处置及出售 (回转) C128:F==固定资产!H37 | V=61449853.9 D128:T=— | V=— E128:F==无形资产变动表!I33 | V=0 F128:T=— | V=— G128:F==投资性房地产!D35 | V=0 H128:F=='使用权资产 '!G26 | V=0 I128:T=— | V=— J128:T=— | V=— K128:F==N(C128)+N(D128)+N(E128)+N(F128)+N(G128)+N(H128)+N(I128)+N(J128) | V=61449853.9 L128:T=— | V=— M128:T=— | V=— N128:T=— | V=— ROW 129 LABEL= 4.15 / 累折-转出至在建工程 A129:T= 4.15 | V= 4.15 B129:T= 累折-转出至在建工程 | V= 累折-转出至在建工程 C129:F==固定资产!H38 | V=0 D129:T=— | V=— E129:T=— | V=— F129:T=— | V=— G129:F==投资性房地产!D36 | V=0 H129:T=— | V=— I129:T=— | V=— J129:T=— | V=— K129:F==N(C129)+N(D129)+N(E129)+N(F129)+N(G129)+N(H129)+N(I129)+N(J129) | V=0 L129:T=— | V=— M129:T=— | V=— N129:T=— | V=— ROW 130 LABEL= 4.16 / 累折-转出至无形资产 A130:T= 4.16 | V= 4.16 B130:T= 累折-转出至无形资产 | V= 累折-转出至无形资产 C130:F==固定资产!H39 | V=0 D130:T=— | V=— E130:T=— | V=— F130:T=— | V=— G130:F==投资性房地产!D37 | V=0 H130:T=— | V=— I130:T=— | V=— J130:T=— | V=— K130:F==N(C130)+N(D130)+N(E130)+N(F130)+N(G130)+N(H130)+N(I130)+N(J130) | V=0 L130:T=— | V=— M130:T=— | V=— N130:T=— | V=— ROW 131 LABEL= 4.17 / 累折-转出至投资性房地产 A131:T= 4.17 | V= 4.17 B131:T= 累折-转出至投资性房地产 | V= 累折-转出至投资性房地产 C131:F==固定资产!H40 | V=0 D131:T=— | V=— E131:F==无形资产变动表!I35 | V=0 F131:T=— | V=— G131:T=— | V=— H131:T=— | V=— I131:T=— | V=— J131:T=— | V=— K131:F==N(C131)+N(D131)+N(E131)+N(F131)+N(G131)+N(H131)+N(I131)+N(J131) | V=0 L131:T=— | V=— M131:T=— | V=— N131:T=— | V=— ROW 132 LABEL= 4.18 / 累折-转出至长期待摊费用 A132:T= 4.18 | V= 4.18 B132:T= 累折-转出至长期待摊费用 | V= 累折-转出至长期待摊费用 C132:F==固定资产!H41 | V=0 D132:T=— | V=— E132:T=— | V=— F132:T=— | V=— G132:T=— | V=— H132:T=— | V=— I132:T=— | V=— J132:T=— | V=— K132:F==N(C132)+N(D132)+N(E132)+N(F132)+N(G132)+N(H132)+N(I132)+N(J132) | V=0 L132:T=— | V=— M132:T=— | V=— N132:T=— | V=— ROW 133 LABEL= 4.19 / 累折-转出至其他 A133:T= 4.19 | V= 4.19 B133:T= 累折-转出至其他 | V= 累折-转出至其他 C133:F==固定资产!H42 | V=0 D133:T=— | V=— E133:F==无形资产变动表!I36 | V=0 F133:T=— | V=— G133:F==投资性房地产!D39 | V=0 H133:T=— | V=— I133:T=— | V=— J133:T=— | V=— K133:F==N(C133)+N(D133)+N(E133)+N(F133)+N(G133)+N(H133)+N(I133)+N(J133) | V=0 L133:T=— | V=— M133:T=— | V=— N133:T=— | V=— ROW 134 LABEL= 4.20 / 累折-因合并范围变更而减少 A134:T= 4.20 | V= 4.20 B134:T= 累折-因合并范围变更而减少 | V= 累折-因合并范围变更而减少 C134:F==固定资产!H43 | V=0 D134:T=— | V=— E134:F==无形资产变动表!I37 | V=0 F134:T=— | V=— G134:F==投资性房地产!D40 | V=0 H134:F=='使用权资产 '!G27 | V=0 I134:T=— | V=— J134:T=— | V=— K134:F==N(C134)+N(D134)+N(E134)+N(F134)+N(G134)+N(H134)+N(I134)+N(J134) | V=0 L134:T=— | V=— M134:T=— | V=— N134:T=— | V=— ROW 135 LABEL= 4.21 / 累折-因汇率变动而减少 A135:T= 4.21 | V= 4.21 B135:T= 累折-因汇率变动而减少 | V= 累折-因汇率变动而减少 C135:F==固定资产!H44 | V=0 D135:T=— | V=— E135:F==无形资产变动表!I38 | V=0 F135:T=— | V=— G135:F==投资性房地产!D41 | V=0 H135:T=— | V=— I135:T=— | V=— J135:T=— | V=— K135:F==N(C135)+N(D135)+N(E135)+N(F135)+N(G135)+N(H135)+N(I135)+N(J135) | V=0 L135:T=— | V=— M135:T=— | V=— N135:T=— | V=— ROW 136 LABEL=【大类 5 / D43 本年减少 — 主行 + 27 sub (CF段 8 + 资产段 11 + 减值段 8) ★ 减值全归大类5】 A136:T=【大类 5 / D43 本年减少 — 主行 + 27 sub (CF段 8 + 资产段 11 + 减值段 8) ★ 减值全归大类5】 | V=【大类 5 / D43 本年减少 — 主行 + 27 sub (CF段 8 + 资产段 11 + 减值段 8) ★ 减值全归大类5】 ROW 137 LABEL=D43 / 本年减少 ★ (主行 = 现金流量表 D43 直接引用) A137:T=D43 | V=D43 B137:T=本年减少 ★ (主行 = 现金流量表 D43 直接引用) | V=本年减少 ★ (主行 = 现金流量表 D43 直接引用) C137:F==N(C139)+N(C140)+N(C141)+N(C142)+N(C143)+N(C144)+N(C145)+N(C146) | V=-302595246.07999986 D137:F==N(D139)+N(D140)+N(D141)+N(D142)+N(D143)+N(D144)+N(D145)+N(D146) | V=-14792373.12 E137:F==N(E139)+N(E140)+N(E141)+N(E142)+N(E143)+N(E144)+N(E145)+N(E146) | V=0 F137:F==N(F139)+N(F140)+N(F141)+N(F142)+N(F143)+N(F144)+N(F145)+N(F146) | V=0 G137:F==N(G139)+N(G140)+N(G141)+N(G142)+N(G143)+N(G144)+N(G145)+N(G146) | V=0 H137:F==N(H139)+N(H140)+N(H141)+N(H142)+N(H143)+N(H144)+N(H145)+N(H146) | V=0 I137:F==N(I139)+N(I140)+N(I141)+N(I142)+N(I143)+N(I144)+N(I145)+N(I146) | V=0 J137:F==N(J139)+N(J140)+N(J141)+N(J142)+N(J143)+N(J144)+N(J145)+N(J146) | V=0 K137:F==N(现金流量表!D43) | V=-190174370.44999993 L137:F==N(现金流量表!D43) | V=-190174370.44999993 M137:F==K137-L137 | V=0 N137:F==IF(ABS(M137)<0.001,"✓","✗") | V=✓ ROW 138 LABEL=▎▎ 现金流公式自然拆 (8 sub, 处置净值拆 3 + 报废拆 2) ▎▎ A138:T=▎▎ 现金流公式自然拆 (8 sub, 处置净值拆 3 + 报废拆 2) ▎▎ | V=▎▎ 现金流公式自然拆 (8 sub, 处置净值拆 3 + 报废拆 2) ▎▎ ROW 139 LABEL= 5.1.1 / 处置-原值减少 (负) A139:T= 5.1.1 | V= 5.1.1 B139:T= 处置-原值减少 (负) | V= 处置-原值减少 (负) C139:F==-固定资产!H15 | V=-251220059.95 D139:F==-在建工程情况表!Q24 | V=-14792373.12 E139:F==-无形资产变动表!I15 | V=0 F139:T=— | V=— G139:F==-投资性房地产!D15 | V=0 H139:F==-'使用权资产 '!G12 | V=0 I139:T=— | V=— J139:T=— | V=— K139:F==N(C139)+N(D139)+N(E139)+N(F139)+N(G139)+N(H139)+N(I139)+N(J139) | V=-266012433.07 L139:F==-N(现金流量表底稿!C202) | V=-453601.92 M139:F==K139-L139 | V=-265558831.15 N139:F==IF(ABS(M139)<0.001,"✓","✗") | V=✗ ROW 140 LABEL= 5.1.2 / 处置-累折回转 (正) A140:T= 5.1.2 | V= 5.1.2 B140:T= 处置-累折回转 (正) | V= 处置-累折回转 (正) C140:F==固定资产!H37 | V=61449853.9 D140:T=— | V=— E140:F==无形资产变动表!I33 | V=0 F140:T=— | V=— G140:F==投资性房地产!D35 | V=0 H140:F=='使用权资产 '!G26 | V=0 I140:T=— | V=— J140:T=— | V=— K140:F==N(C140)+N(D140)+N(E140)+N(F140)+N(G140)+N(H140)+N(I140)+N(J140) | V=61449853.9 L140:T=— | V=— M140:T=— | V=— N140:T=— | V=— ROW 141 LABEL= 5.1.3 / 处置-减值回转 (正) A141:T= 5.1.3 | V= 5.1.3 B141:T= 处置-减值回转 (正) | V= 处置-减值回转 (正) C141:F==固定资产!H54 | V=0 D141:T=— | V=— E141:F==无形资产变动表!I47 | V=0 F141:T=— | V=— G141:F==投资性房地产!D51 | V=0 H141:T=— | V=— I141:T=— | V=— J141:T=— | V=— K141:F==N(C141)+N(D141)+N(E141)+N(F141)+N(G141)+N(H141)+N(I141)+N(J141) | V=0 L141:T=— | V=— M141:T=— | V=— N141:T=— | V=— ROW 142 LABEL= 5.2 / 处置损益 A142:T= 5.2 | V= 5.2 B142:T= 处置损益 | V= 处置损益 C142:F==附注!C1029 | V=-71894501.37 D142:F==附注!C1031 | V=0 E142:F==附注!C1030 | V=0 F142:T=— | V=— G142:F==附注!C1022 | V=0 H142:T=— | V=— I142:T=— | V=— J142:T=— | V=— K142:F==N(C142)+N(D142)+N(E142)+N(F142)+N(G142)+N(H142)+N(I142)+N(J142) | V=-71894501.37 L142:F==-N(现金流量表底稿!C203) | V=0 M142:F==K142-L142 | V=-71894501.37 N142:F==IF(ABS(M142)<0.001,"✓","✗") | V=✗ ROW 143 LABEL= 5.3.a / 报废毁损-试算表余额 A143:T= 5.3.a | V= 5.3.a B143:T= 报废毁损-试算表余额 | V= 报废毁损-试算表余额 C143:F==试算表!Y22 | V=-71894501.37 D143:T=— | V=— E143:T=— | V=— F143:T=— | V=— G143:T=— | V=— H143:T=— | V=— I143:T=— | V=— J143:T=— | V=— K143:F==N(C143)+N(D143)+N(E143)+N(F143)+N(G143)+N(H143)+N(I143)+N(J143) | V=-71894501.37 L143:F==-N(现金流量表!L13) | V=-72042286.73 M143:F==K143-L143 | V=147785.3599999994 N143:F==IF(ABS(M143)<0.001,"✓","✗") | V=✗ ROW 144 LABEL= 5.3.b / 报废毁损-已计提减值冲回 (负) A144:T= 5.3.b | V= 5.3.b B144:T= 报废毁损-已计提减值冲回 (负) | V= 报废毁损-已计提减值冲回 (负) C144:F==-附注!C1067 | V=-147785.36 D144:T=— | V=— E144:T=— | V=— F144:T=— | V=— G144:T=— | V=— H144:T=— | V=— I144:T=— | V=— J144:T=— | V=— K144:F==N(C144)+N(D144)+N(E144)+N(F144)+N(G144)+N(H144)+N(I144)+N(J144) | V=-147785.36 L144:T=— | V=— M144:T=— | V=— N144:T=— | V=— ROW 145 LABEL= 5.4 / 销项税 ★ (CF专属) A145:T= 5.4 | V= 5.4 B145:T= 销项税 ★ (CF专属) | V= 销项税 ★ (CF专属) C145:F==附注!C689 | V=31111748.0700001 D145:T=— | V=— E145:T=— | V=— F145:T=— | V=— G145:T=— | V=— H145:T=— | V=— I145:T=— | V=— J145:T=— | V=— K145:F==N(C145)+N(D145)+N(E145)+N(F145)+N(G145)+N(H145)+N(I145)+N(J145) | V=31111748.0700001 L145:F==N(附注!C689) | V=31111748.0700001 M145:F==K145-L145 | V=0 N145:F==IF(ABS(M145)<0.001,"✓","✗") | V=✓ ROW 146 LABEL= 5.5 / (减值-本期回转, 见 5.20 占位) A146:T= 5.5 | V= 5.5 B146:T= (减值-本期回转, 见 5.20 占位) | V= (减值-本期回转, 见 5.20 占位) C146:T=— | V=— D146:T=— | V=— E146:T=— | V=— F146:T=— | V=— G146:T=— | V=— H146:T=— | V=— I146:T=— | V=— J146:T=— | V=— K146:F==N(C146)+N(D146)+N(E146)+N(F146)+N(G146)+N(H146)+N(I146)+N(J146) | V=0 L146:T=— | V=— M146:T=— | V=— N146:T=— | V=— ROW 147 LABEL=▎▎ 资产明细段 减少项 (11 sub, 含使权拆 2) ▎▎ A147:T=▎▎ 资产明细段 减少项 (11 sub, 含使权拆 2) ▎▎ | V=▎▎ 资产明细段 减少项 (11 sub, 含使权拆 2) ▎▎ ROW 148 LABEL= 5.6 / 本期对外投资转出 A148:T= 5.6 | V= 5.6 B148:T= 本期对外投资转出 | V= 本期对外投资转出 C148:F==-固定资产!H14 | V=0 D148:T=— | V=— E148:F==-无形资产变动表!I14 | V=0 F148:T=— | V=— G148:F==-投资性房地产!D14 | V=0 H148:F==-'使用权资产 '!G11 | V=0 I148:T=— | V=— J148:T=— | V=— K148:F==N(C148)+N(D148)+N(E148)+N(F148)+N(G148)+N(H148)+N(I148)+N(J148) | V=0 L148:T=— | V=— M148:T=— | V=— N148:T=— | V=— ROW 149 LABEL= 5.7 / 转出至在建工程 (内部转换) A149:T= 5.7 | V= 5.7 B149:T= 转出至在建工程 (内部转换) | V= 转出至在建工程 (内部转换) C149:F==-固定资产!H16 | V=0 D149:T=— | V=— E149:T=— | V=— F149:T=— | V=— G149:F==-投资性房地产!D16 | V=0 H149:T=— | V=— I149:T=— | V=— J149:T=— | V=— K149:F==N(C149)+N(D149)+N(E149)+N(F149)+N(G149)+N(H149)+N(I149)+N(J149) | V=0 L149:T=— | V=— M149:T=— | V=— N149:T=— | V=— ROW 150 LABEL= 5.8 / 转出至无形资产 (内部转换) A150:T= 5.8 | V= 5.8 B150:T= 转出至无形资产 (内部转换) | V= 转出至无形资产 (内部转换) C150:F==-固定资产!H17 | V=0 D150:T=— | V=— E150:T=— | V=— F150:T=— | V=— G150:F==-投资性房地产!D17 | V=0 H150:T=— | V=— I150:T=— | V=— J150:T=— | V=— K150:F==N(C150)+N(D150)+N(E150)+N(F150)+N(G150)+N(H150)+N(I150)+N(J150) | V=0 L150:T=— | V=— M150:T=— | V=— N150:T=— | V=— ROW 151 LABEL= 5.9 / 转出至投资性房地产 (内部转换) A151:T= 5.9 | V= 5.9 B151:T= 转出至投资性房地产 (内部转换) | V= 转出至投资性房地产 (内部转换) C151:F==-固定资产!H18 | V=0 D151:T=— | V=— E151:F==-无形资产变动表!I17 | V=0 F151:T=— | V=— G151:T=— | V=— H151:T=— | V=— I151:T=— | V=— J151:T=— | V=— K151:F==N(C151)+N(D151)+N(E151)+N(F151)+N(G151)+N(H151)+N(I151)+N(J151) | V=0 L151:T=— | V=— M151:T=— | V=— N151:T=— | V=— ROW 152 LABEL= 5.10 / 转出至长期待摊费用 (内部转换) A152:T= 5.10 | V= 5.10 B152:T= 转出至长期待摊费用 (内部转换) | V= 转出至长期待摊费用 (内部转换) C152:F==-固定资产!H19 | V=0 D152:T=— | V=— E152:T=— | V=— F152:T=— | V=— G152:T=— | V=— H152:T=— | V=— I152:T=— | V=— J152:T=— | V=— K152:F==N(C152)+N(D152)+N(E152)+N(F152)+N(G152)+N(H152)+N(I152)+N(J152) | V=0 L152:T=— | V=— M152:T=— | V=— N152:T=— | V=— ROW 153 LABEL= 5.11 / 转出至固定资产 (CIP→FA, 内部) A153:T= 5.11 | V= 5.11 B153:T= 转出至固定资产 (CIP→FA, 内部) | V= 转出至固定资产 (CIP→FA, 内部) C153:T=— | V=— D153:F==-在建工程情况表!M24 | V=-260901121.53 E153:F==-无形资产变动表!I16 | V=0 F153:T=— | V=— G153:T=— | V=— H153:T=— | V=— I153:T=— | V=— J153:T=— | V=— K153:F==N(C153)+N(D153)+N(E153)+N(F153)+N(G153)+N(H153)+N(I153)+N(J153) | V=-260901121.53 L153:T=— | V=— M153:T=— | V=— N153:T=— | V=— ROW 154 LABEL= 5.12 / 转出至其他 A154:T= 5.12 | V= 5.12 B154:T= 转出至其他 | V= 转出至其他 C154:F==-固定资产!H20 | V=0 D154:T=— | V=— E154:F==-无形资产变动表!I18 | V=0 F154:T=— | V=— G154:F==-投资性房地产!D19 | V=0 H154:T=— | V=— I154:T=— | V=— J154:T=— | V=— K154:F==N(C154)+N(D154)+N(E154)+N(F154)+N(G154)+N(H154)+N(I154)+N(J154) | V=0 L154:T=— | V=— M154:T=— | V=— N154:T=— | V=— ROW 155 LABEL= 5.13 / 因合并范围变更而减少 A155:T= 5.13 | V= 5.13 B155:T= 因合并范围变更而减少 | V= 因合并范围变更而减少 C155:F==-固定资产!H21 | V=0 D155:F==-在建工程情况表!L24 | V=0 E155:F==-无形资产变动表!I19 | V=0 F155:F==-长期待摊费用变动明细表!G17 | V=0 G155:F==-投资性房地产!D20 | V=0 H155:F==-'使用权资产 '!G13 | V=0 I155:T=— | V=— J155:T=— | V=— K155:F==N(C155)+N(D155)+N(E155)+N(F155)+N(G155)+N(H155)+N(I155)+N(J155) | V=0 L155:T=— | V=— M155:T=— | V=— N155:T=— | V=— ROW 156 LABEL= 5.14 / 因汇率变动而减少 A156:T= 5.14 | V= 5.14 B156:T= 因汇率变动而减少 | V= 因汇率变动而减少 C156:F==-固定资产!H22 | V=0 D156:T=— | V=— E156:F==-无形资产变动表!I20 | V=0 F156:T=— | V=— G156:F==-投资性房地产!D21 | V=0 H156:T=— | V=— I156:T=— | V=— J156:T=— | V=— K156:F==N(C156)+N(D156)+N(E156)+N(F156)+N(G156)+N(H156)+N(I156)+N(J156) | V=0 L156:T=— | V=— M156:T=— | V=— N156:T=— | V=— ROW 157 LABEL= 5.15.a / 使权-处置累折回转 (G26) A157:T= 5.15.a | V= 5.15.a B157:T= 使权-处置累折回转 (G26) | V= 使权-处置累折回转 (G26) C157:T=— | V=— D157:T=— | V=— E157:T=— | V=— F157:T=— | V=— G157:T=— | V=— H157:F=='使用权资产 '!G26 | V=0 I157:T=— | V=— J157:T=— | V=— K157:F==N(C157)+N(D157)+N(E157)+N(F157)+N(G157)+N(H157)+N(I157)+N(J157) | V=0 L157:T=— | V=— M157:T=— | V=— N157:T=— | V=— ROW 158 LABEL= 5.15.b / 使权-合并范围累折回转 (G27) A158:T= 5.15.b | V= 5.15.b B158:T= 使权-合并范围累折回转 (G27) | V= 使权-合并范围累折回转 (G27) C158:T=— | V=— D158:T=— | V=— E158:T=— | V=— F158:T=— | V=— G158:T=— | V=— H158:F=='使用权资产 '!G27 | V=0 I158:T=— | V=— J158:T=— | V=— K158:F==N(C158)+N(D158)+N(E158)+N(F158)+N(G158)+N(H158)+N(I158)+N(J158) | V=0 L158:T=— | V=— M158:T=— | V=— N158:T=— | V=— ROW 159 LABEL=▎▎ 减值段所有变动 (8 sub, 单 cell, 不变) ▎▎ A159:T=▎▎ 减值段所有变动 (8 sub, 单 cell, 不变) ▎▎ | V=▎▎ 减值段所有变动 (8 sub, 单 cell, 不变) ▎▎ ROW 160 LABEL= 5.16 / 减值-本期计提 ★ A160:T= 5.16 | V= 5.16 B160:T= 减值-本期计提 ★ | V= 减值-本期计提 ★ C160:F==固定资产!H50 | V=0 D160:T=— | V=— E160:F==无形资产变动表!I43 | V=0 F160:T=— | V=— G160:F==投资性房地产!D47 | V=0 H160:F=='使用权资产 '!G33 | V=0 I160:T=— | V=— J160:T=— | V=— K160:F==N(C160)+N(D160)+N(E160)+N(F160)+N(G160)+N(H160)+N(I160)+N(J160) | V=0 L160:T=— | V=— M160:T=— | V=— N160:T=— | V=— ROW 161 LABEL= 5.17 / 减值-合并增加 A161:T= 5.17 | V= 5.17 B161:T= 减值-合并增加 | V= 减值-合并增加 C161:F==固定资产!H51 | V=0 D161:T=— | V=— E161:F==无形资产变动表!I44 | V=0 F161:T=— | V=— G161:F==投资性房地产!D48 | V=0 H161:F=='使用权资产 '!G34 | V=0 I161:T=— | V=— J161:T=— | V=— K161:F==N(C161)+N(D161)+N(E161)+N(F161)+N(G161)+N(H161)+N(I161)+N(J161) | V=0 L161:T=— | V=— M161:T=— | V=— N161:T=— | V=— ROW 162 LABEL= 5.18 / 减值-汇率增加 A162:T= 5.18 | V= 5.18 B162:T= 减值-汇率增加 | V= 减值-汇率增加 C162:F==固定资产!H52 | V=0 D162:T=— | V=— E162:F==无形资产变动表!I45 | V=0 F162:T=— | V=— G162:F==投资性房地产!D49 | V=0 H162:F=='使用权资产 '!G35 | V=0 I162:T=— | V=— J162:T=— | V=— K162:F==N(C162)+N(D162)+N(E162)+N(F162)+N(G162)+N(H162)+N(I162)+N(J162) | V=0 L162:T=— | V=— M162:T=— | V=— N162:T=— | V=— ROW 163 LABEL= 5.19 / 减值-其他增加 A163:T= 5.19 | V= 5.19 B163:T= 减值-其他增加 | V= 减值-其他增加 C163:F==固定资产!H53 | V=0 D163:T=— | V=— E163:F==无形资产变动表!I46 | V=0 F163:T=— | V=— G163:F==投资性房地产!D50 | V=0 H163:F=='使用权资产 '!G36 | V=0 I163:T=— | V=— J163:T=— | V=— K163:F==N(C163)+N(D163)+N(E163)+N(F163)+N(G163)+N(H163)+N(I163)+N(J163) | V=0 L163:T=— | V=— M163:T=— | V=— N163:T=— | V=— ROW 164 LABEL= 5.20 / 减值-处置回转 A164:T= 5.20 | V= 5.20 B164:T= 减值-处置回转 | V= 减值-处置回转 C164:F==固定资产!H54 | V=0 D164:T=— | V=— E164:F==无形资产变动表!I47 | V=0 F164:T=— | V=— G164:F==投资性房地产!D51 | V=0 H164:F=='使用权资产 '!G37 | V=0 I164:T=— | V=— J164:T=— | V=— K164:F==N(C164)+N(D164)+N(E164)+N(F164)+N(G164)+N(H164)+N(I164)+N(J164) | V=0 L164:T=— | V=— M164:T=— | V=— N164:T=— | V=— ROW 165 LABEL= 5.21 / 减值-合并范围变更而减少 A165:T= 5.21 | V= 5.21 B165:T= 减值-合并范围变更而减少 | V= 减值-合并范围变更而减少 C165:F==固定资产!H55 | V=0 D165:T=— | V=— E165:F==无形资产变动表!I48 | V=0 F165:T=— | V=— G165:F==投资性房地产!D52 | V=0 H165:F=='使用权资产 '!G38 | V=0 I165:T=— | V=— J165:T=— | V=— K165:F==N(C165)+N(D165)+N(E165)+N(F165)+N(G165)+N(H165)+N(I165)+N(J165) | V=0 L165:T=— | V=— M165:T=— | V=— N165:T=— | V=— ROW 166 LABEL= 5.22 / 减值-汇率变动而减少 A166:T= 5.22 | V= 5.22 B166:T= 减值-汇率变动而减少 | V= 减值-汇率变动而减少 C166:F==固定资产!H56 | V=0 D166:T=— | V=— E166:F==无形资产变动表!I49 | V=0 F166:T=— | V=— G166:F==投资性房地产!D53 | V=0 H166:T=— | V=— I166:T=— | V=— J166:T=— | V=— K166:F==N(C166)+N(D166)+N(E166)+N(F166)+N(G166)+N(H166)+N(I166)+N(J166) | V=0 L166:T=— | V=— M166:T=— | V=— N166:T=— | V=— ROW 167 LABEL= 5.23 / 减值-其他减少 A167:T= 5.23 | V= 5.23 B167:T= 减值-其他减少 | V= 减值-其他减少 C167:F==固定资产!H57 | V=0 D167:T=— | V=— E167:F==无形资产变动表!I50 | V=0 F167:T=— | V=— G167:F==投资性房地产!D54 | V=0 H167:T=— | V=— I167:T=— | V=— J167:T=— | V=— K167:F==N(C167)+N(D167)+N(E167)+N(F167)+N(G167)+N(H167)+N(I167)+N(J167) | V=0 L167:T=— | V=— M167:T=— | V=— N167:T=— | V=— ROW 168 LABEL=【大类 6 / D44 年末数 (净额年末) — snapshot, 无 sub】 A168:T=【大类 6 / D44 年末数 (净额年末) — snapshot, 无 sub】 | V=【大类 6 / D44 年末数 (净额年末) — snapshot, 无 sub】 ROW 169 LABEL=D44 / 年末数 ★ (净额年末) A169:T=D44 | V=D44 B169:T=年末数 ★ (净额年末) | V=年末数 ★ (净额年末) C169:F==固定资产!H63 | V=538189517.4799999 D169:F==在建工程情况表!R24-在建工程情况表!V24-在建工程情况表!W24 | V=12901289.36999998 E169:F==无形资产变动表!I55 | V=0 F169:F==长期待摊费用变动明细表!O17 | V=0 G169:F==投资性房地产!D60 | V=0 H169:F=='使用权资产 '!G44 | V=0 I169:F==附注!F364 | V=0 J169:F==试算表!H61 | V=0 K169:F==N(C169)+N(D169)+N(E169)+N(F169)+N(G169)+N(H169)+N(I169)+N(J169) | V=551090806.8499999 L169:F==N(现金流量表!D44) | V=546198842.4500002 M169:F==K169-L169 | V=4891964.399999738 N169:F==IF(ABS(M169)<0.001,"✓","✗") | V=✗ === RELEVANT SHEETS === 附注 固定资产 在建工程情况表 无形资产变动表 试算表 数据源_CF小合并 现金流量表底稿 使用权资产 资产减值明细表 长期应付款明细 投资性房地产 长期待摊费用变动明细表 数据源_CF_Lead 数据源_CF_VAT 数据源_CF销项税额 数据源_CF增值税缴纳 数据源_CF_PPE 数据源_CF_CIP 数据源_CF_ROU 数据源_CF借款 数据源_CF一年内到期 数据源_CF长期应付款 数据源_CF_OP 数据源_CF_OR 数据源_CF成本 数据源_CF费用 数据源_CF管理费用 数据源_CF销售费用 数据源_CF研发费用 数据源_CF销管 数据源_CF利润表补充 数据源_CF_Payroll 数据源_CF_Prepayment 数据源_CF_NR本集团 数据源_CF_NR本公司 数据源_CF_AP_OP 数据源_CF其他应收mov 数据源_CF其他应付mov 数据源_CF_OR票据mov 数据源_CF_OP票据mov 数据源_CF_JE 数据源_CF注销子公司 数据源_CF资金调拨 数据源_CF_OP_mov 数据源_CF固定资产清理 数据源_CF母公司 === ASSET SHEET 固定资产 dimension 73x11 === ROW 1 A1=附注042-固定资产变动表 | B1=返回目录 ROW 2 B2==基本信息及要求!$I$11=>房屋建筑物 | C2==基本信息及要求!$I$12=>生产机器及设备 | D2==基本信息及要求!$I$13=>模具 | E2==基本信息及要求!$I$14=>运输设备 | F2==基本信息及要求!$I$15=>电子及办公设备 | G2==基本信息及要求!$I$16=>其他 | H2=合计(Total) ROW 3 A3=固定资产原值(Original value of fixed assets) ROW 4 A4=本年年初余额 | B4==[1]PPE!C5=>688111649.55 | E4=1389.14 | H4==SUM(B4:G4)=>688113038.6899999 ROW 5 A5=因非同一控制下企业合并而增加 | H5==SUM(B5:G5)=>0 ROW 6 A6=投资方投入 | H6==SUM(B6:G6)=>0 ROW 7 A7=本期购置 | B7=8880530.96 | H7==SUM(B7:G7)=>8880530.96 ROW 8 A8=由在建工程转入 | B8=260901121.53 | H8==SUM(B8:G8)=>260901121.53 | I8==H8-在建工程情况表!M24=>0 ROW 9 A9=由无形资产转入 | H9==SUM(B9:G9)=>0 | I9==H9-无形资产变动表!I16=>0 ROW 10 A10=由投资性房地产转入 | H10==SUM(B10:G10)=>0 | I10==H10-投资性房地产!D18=>0 ROW 11 A11=由长期待摊费用转入 | H11==SUM(B11:G11)=>0 ROW 12 A12=由其他转入 | H12==SUM(B12:G12)=>0 ROW 13 A13=因汇率变动而增加 | H13==SUM(B13:G13)=>0 ROW 14 A14=本期对外投资转出 | H14==SUM(B14:G14)=>0 ROW 15 A15=本期处置及出售 | B15=251220059.95 | H15==SUM(B15:G15)=>251220059.95 ROW 16 A16=转出至在建工程 | H16==SUM(B16:G16)=>0 | I16==H16-H38-在建工程情况表!H24=>0 ROW 17 A17=转出至无形资产 | H17==SUM(B17:G17)=>0 | I17==H17-无形资产变动表!I8=>0 ROW 18 A18=转出至投资性房地产 | H18==SUM(B18:G18)=>0 | I18==H18-投资性房地产!D11=>0 ROW 19 A19=转出至长期待摊费用 | H19==SUM(B19:G19)=>0 ROW 20 A20=转出至其他 | H20==SUM(B20:G20)=>0 ROW 21 A21=因合并范围变更而减少 | H21==SUM(B21:G21)=>0 ROW 22 A22=因汇率变动而减少 | H22==SUM(B22:G22)=>0 ROW 23 A23=期末数(Closing balance) | B23==B4+SUM(B5:B13)-SUM(B14:B22)=>706673242.0899999 | C23==C4+SUM(C5:C13)-SUM(C14:C22)=>0 | D23==D4+SUM(D5:D13)-SUM(D14:D22)=>0 | E23==E4+SUM(E5:E13)-SUM(E14:E22)=>1389.14 | F23==F4+SUM(F5:F13)-SUM(F14:F22)=>0 | G23==G4+SUM(G5:G13)-SUM(G14:G22)=>0 | H23==SUM(B23:G23)=>706674631.2299999 ROW 24 A24=参考值(Reference) ROW 25 A25=校验(Validation) | B25==H4-试算表!B51=>0 | H25==H23-试算表!H51=>0 ROW 26 A26=固定资产累计折旧(Accumulated depreciation of fixed assets) ROW 27 A27=本年年初余额 | B27==-[1]PPE!C13=>111037189.14 | E27=1319.68 | H27==SUM(B27:G27)=>111038508.82000001 ROW 28 A28=因非同一控制下企业合并而增加 | H28==SUM(B28:G28)=>0 ROW 29 A29=投资方投入 | H29==SUM(B29:G29)=>0 ROW 30 A30=本期计提 | B30=111393945.36 | H30==SUM(B30:G30)=>111393945.36 ROW 31 A31=由无形资产转入 | H31==SUM(B31:G31)=>0 | I31==H31-无形资产变动表!I34=>0 ROW 32 A32=由投资性房地产转入 | H32==SUM(B32:G32)=>0 | I32==H32-投资性房地产!D38=>0 ROW 33 A33=由长期待摊费用转入 | H33==SUM(B33:G33)=>0 ROW 34 A34=由其他转入 | H34==SUM(B34:G34)=>0 ROW 35 A35=因汇率变动而增加 | H35==SUM(B35:G35)=>0 ROW 36 A36=本期对外投资转出 | H36==SUM(B36:G36)=>0 ROW 37 A37=本期处置及出售 | B37=61449853.9 | H37==SUM(B37:G37)=>61449853.9 ROW 38 A38=转出至在建工程 | H38==SUM(B38:G38)=>0 ROW 39 A39=转出至无形资产 | H39==SUM(B39:G39)=>0 | I39==H39-无形资产变动表!I28=>0 ROW 40 A40=转出至投资性房地产 | H40==SUM(B40:G40)=>0 | I40==H40-投资性房地产!D31=>0 ROW 41 A41=转出至长期待摊费用 | H41==SUM(B41:G41)=>0 ROW 42 A42=转出至其他 | H42==SUM(B42:G42)=>0 ROW 43 A43=因合并范围变更而减少 | H43==SUM(B43:G43)=>0 ROW 44 A44=因汇率变动而减少 | H44==SUM(B44:G44)=>0 ROW 45 A45=期末数(Closing balance) | B45==B27+SUM(B28:B35)-SUM(B36:B44)=>160981280.6 | C45==C27+SUM(C28:C35)-SUM(C36:C44)=>0 | D45==D27+SUM(D28:D35)-SUM(D36:D44)=>0 | E45==E27+SUM(E28:E35)-SUM(E36:E44)=>1319.68 | F45==F27+SUM(F28:F35)-SUM(F36:F44)=>0 | G45==G27+SUM(G28:G35)-SUM(G36:G44)=>0 | H45==SUM(B45:G45)=>160982600.28 ROW 46 A46=参考值(Reference) ROW 47 A47=校验(Validation) | B47==H27-试算表!B52=>0 | H47==H45-试算表!H52=>0 ROW 48 A48=固定资产减值准备(Impairement of fixed assets) ROW 49 A49=本年年初余额 | B49=7502513.47 | H49==SUM(B49:G49)=>7502513.47 ROW 50 A50=本期计提 | H50==SUM(B50:G50)=>0 | I50==H50+附注!C971=>0 ROW 51 A51=因非同一控制下企业合并而增加 | H51==SUM(B51:G51)=>0 ROW 52 A52=因汇率变动而增加 | H52==SUM(B52:G52)=>0 ROW 53 A53=其他增加 | H53==SUM(B53:G53)=>0 ROW 54 A54=因处置及出售转销及核销 | H54==SUM(B54:G54)=>0 ROW 55 A55=因合并范围变更而减少 | H55==SUM(B55:G55)=>0 ROW 56 A56=因汇率变动而减少 | H56==SUM(B56:G56)=>0 ROW 57 A57=其他减少 | H57==SUM(B57:G57)=>0 ROW 58 A58=期末数(Closing balance) | B58==B49+SUM(B50:B53)-SUM(B54:B57)=>7502513.47 | C58==C49+SUM(C50:C53)-SUM(C54:C57)=>0 | D58==D49+SUM(D50:D53)-SUM(D54:D57)=>0 | E58==E49+SUM(E50:E53)-SUM(E54:E57)=>0 | F58==F49+SUM(F50:F53)-SUM(F54:F57)=>0 | G58==G49+SUM(G50:G53)-SUM(G54:G57)=>0 | H58==SUM(B58:G58)=>7502513.47 ROW 59 A59=参考值(Reference) ROW 60 A60=校验(Validation) | B60==H49-试算表!B53=>0 | H60==H58-试算表!H53=>0 ROW 61 A61=固定资产净额(Net value of fixed assets) ROW 62 A62=年初数(Opening balance) | B62==B4-B27-B49=>569571946.9399999 | C62==C4-C27-C49=>0 | D62==D4-D27-D49=>0 | E62==E4-E27-E49=>69.46000000000004 | F62==F4-F27-F49=>0 | G62==G4-G27-G49=>0 | H62==SUM(B62:G62)=>569572016.4 | I62==H62-试算表!B54=>0 ROW 63 A63=年末数(Closing balance) | B63==B23-B45-B58=>538189448.0199999 | C63==C23-C45-C58=>0 | D63==D23-D45-D58=>0 | E63==E23-E45-E58=>69.46000000000004 | F63==F23-F45-F58=>0 | G63==G23-G45-G58=>0 | H63==SUM(B63:G63)=>538189517.4799999 | I63==H63-试算表!H54=>0 ROW 64 A64=其中：已抵押之资产净额(Including:Mortgaged assets) ROW 65 A65=本年年初余额 | H65==SUM(B65:G65)=>0 ROW 66 A66=本期期末余额 | H66==SUM(B66:G66)=>0 ROW 67 A67=其中：融资租入的资产(Including:financially leased in F.A. ) ROW 68 A68=年初原值(Opening original value) | H68==SUM(B68:G68)=>0 ROW 69 A69=期末原值(Closing original value) | H69==SUM(B69:G69)=>0 ROW 70 A70=年初累计折旧(Opening accumulated depreciation) | H70==SUM(B70:G70)=>0 ROW 71 A71=年末累计折旧(Closing accumulated depreciation) | H71==SUM(B71:G71)=>0 ROW 72 A72=年初净值(Opening net value) | B72==B68-B70=>0 | C72==C68-C70=>0 | D72==D68-D70=>0 | E72==E68-E70=>0 | F72==F68-F70=>0 | G72==G68-G70=>0 | H72==SUM(B72:G72)=>0 ROW 73 A73=期末净值(Closing net value) | B73==B69-B71=>0 | C73==C69-C71=>0 | D73==D69-D71=>0 | E73==E69-E71=>0 | F73==F69-F71=>0 | G73==G69-G71=>0 | H73==SUM(B73:G73)=>0 === ASSET SHEET 在建工程情况表 dimension 25x257 === ROW 1 A1=在建工程情况表 Construction In Progress ROW 2 A2==基本信息及要求!$A$4=>万传（安徽）物流有限公司 ROW 3 A3=工程项目名称 Name of project | B3=年初余额 | D3=本期购入 | F3=因合并报表范围增加而增加 | H3=本期从固定资产转入 | J3=本期因汇率变动而变化 | L3=因合并范围变化而减少 | M3=本期转入固定资产 | N3=本期转入投资产性房地产 | O3=本期转入无形资产 | P3=本期转入長期待攤費用 | Q3=本期处置 | R3=期末余额 ROW 4 B4=Opening balance | D4=Purchase | F4=addition due to the change of consolidation scope | H4=Transferred from fixed assets | J4=due to transferred exchange rate movement | L4=deduction due to the change of consolidation scope | M4=Transfer-out to F.A. | N4=Transferred investment property | O4=Transfer out to intangible assets | P4=Transfer out to Long-Term Deferred Expenses | Q4= Disposal | R4=Closing balance ROW 5 B5=金额 Amount | C5=其中：利息资本化数 Capitalized interest | D5=金额 Amount | E5=其中：利息资本化数 Capitalized interest | F5=金额 Amount | G5=其中：利息资本化数 Capitalized interest | H5=金额 Amount | I5=其中：利息资本化数 Capitalized interest | J5=金额 Amount | K5=其中：利息资本化数 Capitalized interest | L5=金额 Amount | M5=金额 Amount | N5=金额 Amount | O5=金额 Amount | P5=金额 Amount | Q5=金额 Amount | R5=金额 Amount ROW 6 A6=在建工程合计 (具体项目待补充) | B6==试算表!B55=>79870731.86 | D6=208724052.16 | M6==固定资产!H8=>260901121.53 | Q6=14792373.12 | R6==B6+D6+F6+H6+J6-L6-M6-N6-O6-Q6-P6=>12901289.36999998 ROW 7 R7==B7+D7+F7+H7+J7-L7-M7-N7-O7-Q7-P7=>0 ROW 8 R8==B8+D8+F8+H8+J8-L8-M8-N8-O8-Q8-P8=>0 ROW 9 R9==B9+D9+F9+H9+J9-L9-M9-N9-O9-Q9-P9=>0 ROW 10 R10==B10+D10+F10+H10+J10-L10-M10-N10-O10-Q10-P10=>0 ROW 11 R11==B11+D11+F11+H11+J11-L11-M11-N11-O11-Q11-P11=>0 ROW 12 R12==B12+D12+F12+H12+J12-L12-M12-N12-O12-Q12-P12=>0 ROW 13 R13==B13+D13+F13+H13+J13-L13-M13-N13-O13-Q13-P13=>0 ROW 14 R14==B14+D14+F14+H14+J14-L14-M14-N14-O14-Q14-P14=>0 ROW 15 R15==B15+D15+F15+H15+J15-L15-M15-N15-O15-Q15-P15=>0 ROW 16 R16==B16+D16+F16+H16+J16-L16-M16-N16-O16-Q16-P16=>0 ROW 17 R17==B17+D17+F17+H17+J17-L17-M17-N17-O17-Q17-P17=>0 ROW 18 R18==B18+D18+F18+H18+J18-L18-M18-N18-O18-Q18-P18=>0 ROW 19 R19==B19+D19+F19+H19+J19-L19-M19-N19-O19-Q19-P19=>0 ROW 20 R20==B20+D20+F20+H20+J20-L20-M20-N20-O20-Q20-P20=>0 ROW 21 R21==B21+D21+F21+H21+J21-L21-M21-N21-O21-Q21-P21=>0 ROW 22 R22==B22+D22+F22+H22+J22-L22-M22-N22-O22-Q22-P22=>0 ROW 23 A23=工程物资 | R23==B23+D23+F23+H23+J23-L23-M23-N23-O23-Q23-P23=>0 ROW 24 A24=合计 | B24==SUM(B6:B23)=>79870731.86 | C24==SUM(C6:C23)=>0 | D24==SUM(D6:D23)=>208724052.16 | E24==SUM(E6:E23)=>0 | F24==SUM(F6:F23)=>0 | G24==SUM(G6:G23)=>0 | H24==SUM(H6:H23)=>0 | I24==SUM(I6:I23)=>0 | J24==SUM(J6:J23)=>0 | K24==SUM(K6:K23)=>0 | L24==SUM(L6:L23)=>0 | M24==SUM(M6:M23)=>260901121.53 | N24==SUM(N6:N23)=>0 | O24==SUM(O6:O23)=>0 | P24==SUM(P6:P23)=>0 | Q24==SUM(Q6:Q23)=>14792373.12 | R24==SUM(R6:R23)=>12901289.36999998 ROW 25 B25==B24-试算表!B55=>0 | E25==E24+附注!C957=>0 | P25==P24-长期待摊费用变动明细表!E17=>0 | R25==R24-试算表!H55=>-1.862645149230957e-08 === ASSET SHEET 无形资产变动表 dimension 58x10 === ROW 1 A1=R043-无形资产变动表 | B1=返回目录 ROW 2 B2=土地使用权(Land use right) | C2=专利权(Patent right) | D2=非专利技术(Non-patent technology) | E2=商标权(Trade mark right) | F2=特许使用权(License) | G2=软件使用权(Software Use Right) | H2=其他(Others) | I2=合计(Total) ROW 3 A3=无形资产原值(Original Value of intangible assets) ROW 4 A4=本年年初余额 | I4==SUM(B4:H4)=>0 ROW 5 A5=因非同一控制下企业合并而增加 | I5==SUM(B5:H5)=>0 ROW 6 A6=投资方投入 | I6==SUM(B6:H6)=>0 ROW 7 A7=本期购置 | I7==SUM(B7:H7)=>0 ROW 8 A8=由固定资产转入 | I8==SUM(B8:H8)=>0 | J8==I8-固定资产!H17=>0 ROW 9 A9=由投资性房地产转入 | I9==SUM(B9:H9)=>0 | J9==I9-投资性房地产!D17=>0 ROW 10 A10=由开发支出转入 | I10==SUM(B10:H10)=>0 | J10==I10-附注!F1213=>0 ROW 11 A11=由在建工程转入 | I11==SUM(B11:H11)=>0 | J11==I11-在建工程情况表!O24=>0 ROW 12 A12=由其他转入 | I12==SUM(B12:H12)=>0 ROW 13 A13=因汇率变动而增加 | I13==SUM(B13:H13)=>0 ROW 14 A14=本期对外投资转出 | I14==SUM(B14:H14)=>0 ROW 15 A15=本期处置及出售 | I15==SUM(B15:H15)=>0 ROW 16 A16=转出至固定资产 | I16==SUM(B16:H16)=>0 | J16==I16-固定资产!H9=>0 ROW 17 A17=转出至投资性房地产 | I17==SUM(B17:H17)=>0 | J17==I17-投资性房地产!D10=>0 ROW 18 A18=转出至其他 | I18==SUM(B18:H18)=>0 ROW 19 A19=因合并范围变更而减少 | I19==SUM(B19:H19)=>0 ROW 20 A20=因汇率变动而减少 | I20==SUM(B20:H20)=>0 ROW 21 A21=期末数(Closing balance) | B21==B4+SUM(B5:B13)-SUM(B14:B20)=>0 | C21==C4+SUM(C5:C13)-SUM(C14:C20)=>0 | D21==D4+SUM(D5:D13)-SUM(D14:D20)=>0 | E21==E4+SUM(E5:E13)-SUM(E14:E20)=>0 | F21==F4+SUM(F5:F13)-SUM(F14:F20)=>0 | G21==G4+SUM(G5:G13)-SUM(G14:G20)=>0 | H21==H4+SUM(H5:H13)-SUM(H14:H20)=>0 | I21==I4+SUM(I5:I13)-SUM(I14:I20)=>0 ROW 22 A22=校验(Validation) | B22==I4-试算表!B67=>0 | I22==I21-试算表!H67=>0 ROW 23 A23=无形资产累计摊销(Accumulated ammortization of intangible assets) ROW 24 A24=本年年初余额 | I24==SUM(B24:H24)=>0 ROW 25 A25=因非同一控制下企业合并而增加 | I25==SUM(B25:H25)=>0 ROW 26 A26=投资方投入 | I26==SUM(B26:H26)=>0 ROW 27 A27=本期计提 | I27==SUM(B27:H27)=>0 ROW 28 A28=由固定资产转入 | I28==SUM(B28:H28)=>0 | J28==I28-固定资产!H39=>0 ROW 29 A29=由投资性房地产转入 | I29==SUM(B29:H29)=>0 | J29==I29-投资性房地产!D37=>0 ROW 30 A30=由其他转入 | I30==SUM(B30:H30)=>0 ROW 31 A31=因汇率变动而增加 | I31==SUM(B31:H31)=>0 ROW 32 A32=本期对外投资转出 | I32==SUM(B32:H32)=>0 ROW 33 A33=本期处置及出售 | I33==SUM(B33:H33)=>0 ROW 34 A34=转出至固定资产 | I34==SUM(B34:H34)=>0 | J34==I34-固定资产!H31=>0 ROW 35 A35=转出至投资性房地产 | I35==SUM(B35:H35)=>0 | J35==I35-投资性房地产!D30=>0 ROW 36 A36=转出至其他 | I36==SUM(B36:H36)=>0 ROW 37 A37=因合并范围变更而减少 | I37==SUM(B37:H37)=>0 ROW 38 A38=因汇率变动而减少 | I38==SUM(B38:H38)=>0 ROW 39 A39=期末数(Closing balance) | B39==B24+SUM(B25:B31)-SUM(B32:B38)=>0 | C39==C24+SUM(C25:C31)-SUM(C32:C38)=>0 | D39==D24+SUM(D25:D31)-SUM(D32:D38)=>0 | E39==E24+SUM(E25:E31)-SUM(E32:E38)=>0 | F39==F24+SUM(F25:F31)-SUM(F32:F38)=>0 | G39==G24+SUM(G25:G31)-SUM(G32:G38)=>0 | H39==H24+SUM(H25:H31)-SUM(H32:H38)=>0 | I39==I24+SUM(I25:I31)-SUM(I32:I38)=>0 ROW 40 A40=校验(Validation) | B40==I24-试算表!B68=>0 | I40==I39-试算表!H68=>0 ROW 41 A41=无形资产减值准备(Impairment of intangible assets) ROW 42 A42=本年年初余额 | I42==SUM(B42:H42)=>0 ROW 43 A43=本期计提 | I43==SUM(B43:H43)=>0 | J43==I43+附注!C973=>0 ROW 44 A44=因非同一控制下企业合并而增加 | I44==SUM(B44:H44)=>0 ROW 45 A45=因汇率变动而增加 | I45==SUM(B45:H45)=>0 ROW 46 A46=其他增加 | I46==SUM(B46:H46)=>0 ROW 47 A47=因处置及出售转销及核销 | I47==SUM(B47:H47)=>0 ROW 48 A48=因合并范围变更而减少 | I48==SUM(B48:H48)=>0 ROW 49 A49=因汇率变动而减少 | I49==SUM(B49:H49)=>0 ROW 50 A50=其他减少 | I50==SUM(B50:H50)=>0 ROW 51 A51=期末数(Closing balance) | B51==B42+SUM(B43:B46)-SUM(B47:B50)=>0 | C51==C42+SUM(C43:C46)-SUM(C47:C50)=>0 | D51==D42+SUM(D43:D46)-SUM(D47:D50)=>0 | E51==E42+SUM(E43:E46)-SUM(E47:E50)=>0 | F51==F42+SUM(F43:F46)-SUM(F47:F50)=>0 | G51==G42+SUM(G43:G46)-SUM(G47:G50)=>0 | H51==H42+SUM(H43:H46)-SUM(H47:H50)=>0 | I51==SUM(B51:H51)=>0 ROW 52 A52=校验(Validation) | B52==I42-试算表!B69=>0 | I52==I51-试算表!H69=>0 ROW 53 A53=无形资产净额(Net value of intangible assets) ROW 54 A54=年初数(Opening balance) | B54==B4-B24-B42=>0 | C54==C4-C24-C42=>0 | D54==D4-D24-D42=>0 | E54==E4-E24-E42=>0 | F54==F4-F24-F42=>0 | G54==G4-G24-G42=>0 | H54==H4-H24-H42=>0 | I54==SUM(B54:H54)=>0 | J54==I54-试算表!B70=>0 ROW 55 A55=年末数(Closing balance) | B55==B21-B39-B51=>0 | C55==C21-C39-C51=>0 | D55==D21-D39-D51=>0 | E55==E21-E39-E51=>0 | F55==F21-F39-F51=>0 | G55==G21-G39-G51=>0 | H55==H21-H39-H51=>0 | I55==SUM(B55:H55)=>0 | J55==I55-试算表!H70=>0 ROW 56 A56=其中：已抵押之资产净额(Including:Mortgaged assets) ROW 57 A57=年初数(Opening amount) | I57==SUM(B57:H57)=>0 ROW 58 A58=年末数(Closing amount) | I58==SUM(B58:H58)=>0 === ASSET SHEET 长期待摊费用变动明细表 dimension 25x256 === ROW 1 A1=长期待摊费用变动明细表 Long-Term Deferred Expenses ROW 2 A2==基本信息及要求!$A$4=>万传（安徽）物流有限公司 ROW 3 A3=项目 Item | B3=年初原始发生金额 Opening balance of original cost | C3=因合并范围变更而增加 Acquisition due to consolidation scope changes | D3=因购买子公司而增加 Addition due to purchasing subsidiaries | E3=本年在建工程转入 Transfer in from C.I.P. | F3=本年购置 Purchase | G3=因合并范围变更而减少 Deduction due to consolidation scope changes | H3=因处置子公司而减少 Deduction due to disposal of subsidiaries | I3=其他转出 Other transfer-out | J3=年末原始发生金额 Closing balance | K3=年初累计摊销 Opening accumulated depreciation | L3=本年摊销 Depreciation | M3=年末累计摊销 Closing balance | N3=年初余额 2010年1月1日 | O3=年末余额 2010年12月31日 | P3=剩余摊销年限 Remaining amortization period ROW 4 A4=固定资产改良支出 Expenditure for fixed assets improved | J4==SUM(B4:F4)-SUM(G4:I4)=>0 | M4==SUM(K4:L4)=>0 | N4==B4-K4=>0 | O4==J4-M4=>0 ROW 5 A5=模具 Mould | J5==SUM(B5:F5)-SUM(G5:I5)=>0 | M5==SUM(K5:L5)=>0 | N5==B5-K5=>0 | O5==J5-M5=>0 ROW 6 A6=开办费 Opening expenses | J6==SUM(B6:F6)-SUM(G6:I6)=>0 | M6==SUM(K6:L6)=>0 | N6==B6-K6=>0 | O6==J6-M6=>0 ROW 7 A7=其他（1）Other(1) | J7==SUM(B7:F7)-SUM(G7:I7)=>0 | M7==SUM(K7:L7)=>0 | N7==B7-K7=>0 | O7==J7-M7=>0 ROW 8 A8=其他（2）Other(2) | J8==SUM(B8:F8)-SUM(G8:I8)=>0 | M8==SUM(K8:L8)=>0 | N8==B8-K8=>0 | O8==J8-M8=>0 ROW 9 A9=其他（3）Other(3) | J9==SUM(B9:F9)-SUM(G9:I9)=>0 | M9==SUM(K9:L9)=>0 | N9==B9-K9=>0 | O9==J9-M9=>0 ROW 10 A10=其他（4）Other(4) | J10==SUM(B10:F10)-SUM(G10:I10)=>0 | M10==SUM(K10:L10)=>0 | N10==B10-K10=>0 | O10==J10-M10=>0 ROW 11 A11=其他（5）Other(5) | J11==SUM(B11:F11)-SUM(G11:I11)=>0 | M11==SUM(K11:L11)=>0 | N11==B11-K11=>0 | O11==J11-M11=>0 ROW 12 A12=其他（6）Other(6) | J12==SUM(B12:F12)-SUM(G12:I12)=>0 | M12==SUM(K12:L12)=>0 | N12==B12-K12=>0 | O12==J12-M12=>0 ROW 13 A13=其他（7）Other(7) | J13==SUM(B13:F13)-SUM(G13:I13)=>0 | M13==SUM(K13:L13)=>0 | N13==B13-K13=>0 | O13==J13-M13=>0 ROW 14 A14=其他（8）Other(8) | J14==SUM(B14:F14)-SUM(G14:I14)=>0 | M14==SUM(K14:L14)=>0 | N14==B14-K14=>0 | O14==J14-M14=>0 ROW 15 A15=其他（9）Other(9) | J15==SUM(B15:F15)-SUM(G15:I15)=>0 | M15==SUM(K15:L15)=>0 | N15==B15-K15=>0 | O15==J15-M15=>0 ROW 16 A16=其他（10）Other(10) | J16==SUM(B16:F16)-SUM(G16:I16)=>0 | M16==SUM(K16:L16)=>0 | N16==B16-K16=>0 | O16==J16-M16=>0 ROW 17 A17=合计Total | B17==SUM(B4:B16)=>0 | C17==SUM(C4:C16)=>0 | D17==SUM(D4:D16)=>0 | E17==SUM(E4:E16)=>0 | F17==SUM(F4:F16)=>0 | G17==SUM(G4:G16)=>0 | H17==SUM(H4:H16)=>0 | I17==SUM(I4:I16)=>0 | J17==SUM(J4:J16)=>0 | K17==SUM(K4:K16)=>0 | L17==SUM(L4:L16)=>0 | M17==SUM(M4:M16)=>0 | N17==SUM(N4:N16)=>0 | O17==SUM(O4:O16)=>0 ROW 18 A18=校验 | E18==E17-在建工程情况表!P24=>0 | N18==N17-试算表!B75=>0 | O18==O17-试算表!H75=>0 ROW 19 A19=注1:年初原始发生金额即该项长年待摊费用发生时的原值 ROW 20 A20=Note 1：Opening balance of original cost should be the original value of long-term prepaid expenses when occurred. ROW 21 A21=注2:年初累积摊销即该项长年待摊费用从发生到年初为止已经累积摊销的金额 ROW 22 A22=Note 2：Opening balance of accumulated amortization should be the accumulated amortization from occurrence till the beginning of the year. ROW 23 A23=注3:请全部用正数填写 Please fill in all the data with positive number ROW 25 A25=返回目录 === ASSET SHEET 投资性房地产 dimension 63x5 === ROW 1 A1=R041-投资性房地产明细 | B1=返回目录 ROW 3 B3=房屋建筑物(Buildings) | C3=土地使用权(Land use right) | D3=合计(Total) ROW 4 A4=原值(Original value) ROW 5 A5=本年年初余额 | D5==SUM(B5:C5)=>0 ROW 6 A6=因非同一控制下企业合并而增加 | D6==SUM(B6:C6)=>0 ROW 7 A7=投资方投入 | D7==SUM(B7:C7)=>0 ROW 8 A8=本期购置 | D8==SUM(B8:C8)=>0 ROW 9 A9=由在建工程转入 | D9==SUM(B9:C9)=>0 | E9==D9-在建工程情况表!N24=>0 ROW 10 A10=由无形资产转入 | D10==SUM(B10:C10)=>0 | E10==D10-无形资产变动表!I17=>0 ROW 11 A11=由自用房地产转换为投资性房地产 | D11==SUM(B11:C11)=>0 | E11==D11-固定资产!H18=>0 ROW 12 A12=由其他转入 | D12==SUM(B12:C12)=>0 ROW 13 A13=因汇率变动而增加 | D13==SUM(B13:C13)=>0 ROW 14 A14=本期对外投资转出 | D14==SUM(B14:C14)=>0 ROW 15 A15=本期处置及出售 | D15==SUM(B15:C15)=>0 ROW 16 A16=转出至在建工程 | D16==SUM(B16:C16)=>0 ROW 17 A17=转出至无形资产 | D17==SUM(B17:C17)=>0 | E17==D17-无形资产变动表!I9=>0 ROW 18 A18=由投资性房地产转换为自用房地产 | D18==SUM(B18:C18)=>0 | E18==D18-固定资产!H10=>0 ROW 19 A19=转出至其他 | D19==SUM(B19:C19)=>0 ROW 20 A20=因合并范围变更而减少 | D20==SUM(B20:C20)=>0 ROW 21 A21=因汇率变动而减少 | D21==SUM(B21:C21)=>0 ROW 22 A22=期末余额(Closing balance) | B22==B5+SUM(B6:B13)-SUM(B14:B21)=>0 | C22==C5+SUM(C6:C13)-SUM(C14:C21)=>0 | D22==D5+SUM(D6:D13)-SUM(D14:D21)=>0 ROW 23 A23=参考值(Reference) ROW 24 A24=校验(Validation) | B24==D5-试算表!B38=>0 | D24==D22-试算表!H38=>0 ROW 25 A25=累计折旧及累计摊销(Accumulated depreciation and amortization) ROW 26 A26=本年年初余额 | D26==C26+B26=>0 ROW 27 A27=因非同一控制下企业合并而增加 | D27==C27+B27=>0 ROW 28 A28=投资方投入 | D28==C28+B28=>0 ROW 29 A29=本期计提 | D29==C29+B29=>0 ROW 30 A30=由无形资产转入 | D30==C30+B30=>0 | E30==D30-无形资产变动表!I35=>0 ROW 31 A31=由自用房地产转换为投资性房地产 | D31==C31+B31=>0 | E31==D31-固定资产!H40=>0 ROW 32 A32=由其他转入 | D32==C32+B32=>0 ROW 33 A33=因汇率变动而增加 | D33==C33+B33=>0 ROW 34 A34=本期对外投资转出 | D34==C34+B34=>0 ROW 35 A35=本期处置及出售 | D35==C35+B35=>0 ROW 36 A36=转出至在建工程 | D36==C36+B36=>0 ROW 37 A37=转出至无形资产 | D37==C37+B37=>0 | E37==D37-无形资产变动表!I29=>0 ROW 38 A38=由投资性房地产转换为自用房地产 | D38==C38+B38=>0 | E38==D38-固定资产!H32=>0 ROW 39 A39=转出至其他 | D39==C39+B39=>0 ROW 40 A40=因合并范围变更而减少 | D40==C40+B40=>0 ROW 41 A41=因汇率变动而减少 | D41==C41+B41=>0 ROW 42 A42=期末余额(Closing balance) | B42==B26+SUM(B27:B33)-SUM(B34:B41)=>0 | C42==C26+SUM(C27:C33)-SUM(C34:C41)=>0 | D42==D26+SUM(D27:D33)-SUM(D34:D41)=>0 ROW 43 A43=参考值(Reference) ROW 44 A44=校验(Validation) | B44==D26-试算表!B40=>0 | D44==D42-试算表!H40=>0 ROW 45 A45=减值准备(Impairment) ROW 46 A46=本年年初余额 | D46==C46+B46=>0 ROW 47 A47=本期计提 | D47==C47+B47=>0 | E47==D47-附注!C970=>0 ROW 48 A48=因非同一控制下企业合并而增加 | D48==C48+B48=>0 ROW 49 A49=因汇率变动而增加 | D49==C49+B49=>0 ROW 50 A50=其他增加 | D50==C50+B50=>0 ROW 51 A51=因处置及出售转销及核销 | D51==C51+B51=>0 ROW 52 A52=因合并范围变更而减少 | D52==C52+B52=>0 ROW 53 A53=因汇率变动而减少 | D53==C53+B53=>0 ROW 54 A54=其他减少 | D54==C54+B54=>0 ROW 55 A55=期末余额(Closing balance) | B55==B46+SUM(B47:B50)-SUM(B51:B54)=>0 | C55==C46+SUM(C47:C50)-SUM(C51:C54)=>0 | D55==C55+B55=>0 ROW 56 A56=参考值(Reference) ROW 57 A57=校验(Validation) | B57==D46-试算表!B41=>0 | D57==D55-试算表!H41=>0 ROW 58 A58=投资性房地产净额(Net value of investment property) ROW 59 A59=年初数(Opening balance) | B59==B5-B26-B46=>0 | C59==C5-C26-C46=>0 | D59==C59+B59=>0 | E59==D59-试算表!B42=>0 ROW 60 A60=年末数(Closing balance) | B60==B22-B42-B55=>0 | C60==C22-C42-C55=>0 | D60==C60+B60=>0 | E60==D60-试算表!H42=>0 ROW 61 A61=其中:已抵押的投资性房地产净额(Including:Mortgaged assets) ROW 62 A62=本年年初余额 | D62==C62+B62=>0 ROW 63 A63=本期期末余额 | D63==C63+B63=>0 === ASSET SHEET 使用权资产 dimension 44x8 === ROW 1 A1=附注042-使用权资产变动表 | B1=返回目录 ROW 2 B2=场地使用权 | C2=房屋建筑物 | D2=生产设备 | E2=运输工具 | F2=其他 | G2=合计(Total) ROW 3 A3=使用权资产原值 ROW 4 A4=本年年初余额 | G4==SUM(B4:F4)=>0 ROW 5 A5=因非同一控制下企业合并而增加 | G5==SUM(B5:F5)=>0 ROW 6 A6=投资方投入 | G6==SUM(B6:F6)=>0 ROW 7 A7=本期租入 | G7==SUM(B7:F7)=>0 ROW 8 A8=修改租赁条款变动 | G8==SUM(B8:F8)=>0 ROW 9 A9=其他变动 | G9==SUM(B9:F9)=>0 ROW 10 A10=汇率变动 | G10==SUM(B10:F10)=>0 ROW 11 A11=本期对外投资转出 | G11==SUM(B11:F11)=>0 ROW 12 A12=本期处置及出售 | G12==SUM(B12:F12)=>0 ROW 13 A13=因合并范围变更而减少 | G13==SUM(B13:F13)=>0 ROW 14 A14=期末数(Closing balance) | B14==B4+SUM(B5:B10)-SUM(B11:B13)=>0 | C14==C4+SUM(C5:C10)-SUM(C11:C13)=>0 | D14==D4+SUM(D5:D10)-SUM(D11:D13)=>0 | E14==E4+SUM(E5:E10)-SUM(E11:E13)=>0 | F14==F4+SUM(F5:F10)-SUM(F11:F13)=>0 | G14==SUM(B14:F14)=>0 ROW 15 A15=参考值(Reference) ROW 16 A16=校验(Validation) | B16==G4-试算表!B63=>0 | G16==G14-试算表!H63=>0 ROW 17 A17=使用权资产累计折旧 ROW 18 A18=本年年初余额 | G18==SUM(B18:F18)=>0 ROW 19 A19=因非同一控制下企业合并而增加 | G19==SUM(B19:F19)=>0 ROW 20 A20=投资方投入 | G20==SUM(B20:F20)=>0 ROW 21 A21=本期计提 | G21==SUM(B21:F21)=>0 ROW 22 A22=修改租赁条款变动 | G22==SUM(B22:F22)=>0 ROW 23 A23=其他变动 | G23==SUM(B23:F23)=>0 ROW 24 A24=汇率变动 | G24==SUM(B24:F24)=>0 ROW 25 A25=本期对外投资转出 | G25==SUM(B25:F25)=>0 ROW 26 A26=本期处置及出售 | G26==SUM(B26:F26)=>0 ROW 27 A27=因合并范围变更而减少 | D27=’ | G27==SUM(B27:F27)=>0 ROW 28 A28=期末数(Closing balance) | B28==B18+SUM(B19:B24)-SUM(B25:B27)=>0 | C28==C18+SUM(C19:C24)-SUM(C25:C27)=>0 | D28==D18+SUM(D19:D24)-SUM(D25:D27)=>0 | E28==E18+SUM(E19:E24)-SUM(E25:E27)=>0 | F28==F18+SUM(F19:F24)-SUM(F25:F27)=>0 | G28==SUM(B28:F28)=>0 ROW 29 A29=参考值(Reference) ROW 30 A30=校验(Validation) | B30==G18-试算表!B64=>0 | G30==G28-试算表!H64=>0 ROW 31 A31=使用权资产减值准备 ROW 32 A32=本年年初余额 | G32==SUM(B32:F32)=>0 ROW 33 A33=本期计提 | G33==SUM(B33:F33)=>0 | H33==G33+附注!C974=>0 ROW 34 A34=因非同一控制下企业合并而增加 | G34==SUM(B34:F34)=>0 ROW 35 A35=汇率变动 | G35==SUM(B35:F35)=>0 ROW 36 A36=其他变动 | G36==SUM(B36:F36)=>0 ROW 37 A37=因处置及出售转销及核销 | G37==SUM(B37:F37)=>0 ROW 38 A38=因合并范围变更而减少 | G38==SUM(B38:F38)=>0 ROW 39 A39=期末数(Closing balance) | B39==B32+SUM(B33:B36)-SUM(B37:B38)=>0 | C39==C32+SUM(C33:C36)-SUM(C37:C38)=>0 | D39==D32+SUM(D33:D36)-SUM(D37:D38)=>0 | E39==E32+SUM(E33:E36)-SUM(E37:E38)=>0 | F39==F32+SUM(F33:F36)-SUM(F37:F38)=>0 | G39==SUM(B39:F39)=>0 ROW 40 A40=参考值(Reference) ROW 41 A41=校验(Validation) | B41==G32-试算表!B65=>0 | G41==G39-试算表!H65=>0 ROW 42 A42=使用权资产净额 ROW 43 A43=年初数(Opening balance) | B43==B4-B18-B32=>0 | C43==C4-C18-C32=>0 | D43==D4-D18-D32=>0 | E43==E4-E18-E32=>0 | F43==F4-F18-F32=>0 | G43==SUM(B43:F43)=>0 | H43==G43-试算表!B66=>0 ROW 44 A44=年末数(Closing balance) | B44==B14-B28-B39=>0 | C44==C14-C28-C39=>0 | D44==D14-D28-D39=>0 | E44==E14-E28-E39=>0 | F44==F14-F28-F39=>0 | G44==SUM(B44:F44)=>0 | H44==G44-试算表!H66=>0 === ASSET SHEET 资产减值明细表 dimension 33x16 === ROW 1 A1=R9009资产减值明细表 | B1=返回目录 ROW 2 A2=项目 | B2=本年年初余额 | C2=本期计提 | D2=因非同一控制下企业合并而增加 | E2=因汇率变动而增加 | F2=其他增加 | G2=因价值回升转回 | H2=因处置及出售转销及核销 | I2=因合并范围变更而减少 | J2=因汇率变动而减少 | K2=其他减少 | L2=本期期末余额(Closing Balance) | M2=校验 | N2=校验 ROW 3 A3=坏账准备-应收票据 | B3==附注!E93+附注!F93=>0 | L3==B3+SUM(C3:F3)-SUM(G3:K3)=>0 | M3==L3-附注!C93-附注!D93=>0 ROW 4 A4=坏账准备-应收账款 | B4==试算表!B13=>238229.1531 | C4==-附注!C982=>1562330.56 | L4==B4+SUM(C4:F4)-SUM(G4:K4)=>1800559.7131 | M4==L4-试算表!H13=>0.0071000000461936 ROW 5 A5=坏账准备-预付账款 | B5==附注!G186=>0 | L5==B5+SUM(C5:F5)-SUM(G5:K5)=>0 | M5==L5-附注!D186=>0 ROW 6 A6=坏账准备-其他应收款 | B6==试算表!B18=>0 | L6==B6+SUM(C6:F6)-SUM(G6:K6)=>0 | M6==L6-试算表!H18=>0 ROW 7 A7=坏账准备-长期应收款 | B7==试算表!B47=>0 | L7==B7+SUM(C7:F7)-SUM(G7:K7)=>0 | M7==L7-试算表!H47=>0 ROW 8 A8=坏账准备合计(Total bad debt p附注ovision) | B8==SUM(B3:B7)=>238229.1531 | C8==SUM(C3:C7)=>1562330.56 | D8==SUM(D3:D7)=>0 | E8==SUM(E3:E7)=>0 | F8==SUM(F3:F7)=>0 | G8==SUM(G3:G7)=>0 | H8==SUM(H3:H7)=>0 | I8==SUM(I3:I7)=>0 | J8==SUM(J3:J7)=>0 | K8==SUM(K3:K7)=>0 | L8==SUM(L3:L7)=>1800559.7131 ROW 9 A9=存货跌价准备-原材料 | B9==附注!G260=>0 | L9==B9+SUM(C9:F9)-SUM(G9:K9)=>0 | M9==L9-附注!D260=>0 ROW 10 A10=存货跌价准备-产成品 | B10==附注!G265+附注!G264=>0 | L10==B10+SUM(C10:F10)-SUM(G10:K10)=>0 | M10==L10-附注!D265-附注!D264=>0 ROW 11 A11=存货跌价准备-在产品 | B11==附注!G266+附注!G267=>0 | L11==B11+SUM(C11:F11)-SUM(G11:K11)=>0 | M11==L11-附注!D267-附注!D266=>0 ROW 12 A12=存货跌价准备-委托加工物资 | B12==附注!G262=>0 | L12==B12+SUM(C12:F12)-SUM(G12:K12)=>0 | M12==L12-附注!D262=>0 ROW 13 A13=存货跌价准备-周转材料 | B13==附注!G261=>0 | L13==B13+SUM(C13:F13)-SUM(G13:K13)=>0 | M13==L13-附注!D261=>0 ROW 14 A14=存货跌价准备-合同履约成本 | B14==附注!G268=>0 | L14==B14+SUM(C14:F14)-SUM(G14:K14)=>0 | M14==L14-附注!D268=>0 ROW 15 A15=存货跌价准备合计(total invento附注y p附注ovision) | B15==SUM(B9:B14)=>0 | C15==SUM(C9:C14)=>0 | D15==SUM(D9:D14)=>0 | E15==SUM(E9:E14)=>0 | F15==SUM(F9:F14)=>0 | G15==SUM(G9:G14)=>0 | H15==SUM(H9:H14)=>0 | I15==SUM(I9:I14)=>0 | J15==SUM(J9:J14)=>0 | K15==SUM(K9:K14)=>0 | L15==SUM(L9:L14)=>0 | M15==L15-试算表!H24=>0 | N15==B15-试算表!B24=>0 ROW 16 A16=合同资产减值准备 | B16==试算表!B21=>0 | L16==B16+SUM(C16:F16)-SUM(G16:K16)=>0 | M16==L16-试算表!H21=>0 ROW 17 A17=长期股权投资减值准备-子公司 | L17==B17+SUM(C17:F17)-SUM(G17:K17)=>0 ROW 18 A18=长期股权投资减值准备-合营公司 | L18==B18+SUM(C18:F18)-SUM(G18:K18)=>0 ROW 19 A19=长期股权投资减值准备-联营公司 | L19==B19+SUM(C19:F19)-SUM(G19:K19)=>0 ROW 20 A20=长期股权投资减值准备-其他 | L20==B20+SUM(C20:F20)-SUM(G20:K20)=>0 ROW 21 A21=长期股权投资减值准备合计（total long te附注m investment impai附注ment) | B21==SUM(B17:B20)=>0 | C21==SUM(C17:C20)=>0 | D21==SUM(D17:D20)=>0 | E21==SUM(E17:E20)=>0 | F21==SUM(F17:F20)=>0 | G21==SUM(G17:G20)=>0 | H21==SUM(H17:H20)=>0 | I21==SUM(I17:I20)=>0 | J21==SUM(J17:J20)=>0 | K21==SUM(K17:K20)=>0 | L21==SUM(L17:L20)=>0 | M21==L21-试算表!H44=>0 | N21==B21-试算表!B44=>0 ROW 22 A22=投资性房地产减值准备 | B22==试算表!B41=>0 | L22==B22+SUM(C22:F22)-SUM(G22:K22)=>0 | M22==L22-试算表!H41=>0 ROW 23 A23=固定资产减值准备 | B23==试算表!B53=>7502513.47 | L23==B23+SUM(C23:F23)-SUM(G23:K23)=>7502513.47 | M23==L23-试算表!H53=>0 ROW 24 A24=在建工程减值准备 | B24==试算表!B56=>0 | L24==B24+SUM(C24:F24)-SUM(G24:K24)=>0 | M24==L24-试算表!H56=>0 ROW 25 A25=无形资产减值准备 | B25==试算表!B69=>0 | L25==B25+SUM(C25:F25)-SUM(G25:K25)=>0 | M25==L25-试算表!H69=>0 ROW 26 A26=使用权资产减值准备 | B26==试算表!B65=>0 | L26==B26+SUM(C26:F26)-SUM(G26:K26)=>0 | M26==L26-试算表!H65=>0 ROW 27 A27=商誉减值准备 | B27==试算表!B73=>0 | L27==B27+SUM(C27:F27)-SUM(G27:K27)=>0 | M27==L27-试算表!H73=>0 ROW 28 A28=债权投资减值准备 | B28==试算表!B33=>0 | L28==B28+SUM(C28:F28)-SUM(G28:K28)=>0 | M28==L28-试算表!H33=>0 ROW 29 A29=其他债权投资减值准备 | B29==试算表!B36=>0 | L29==B29+SUM(C29:F29)-SUM(G29:K29)=>0 | M29==L29-试算表!H36=>0 ROW 30 A30=贷款损失准备（金融企业） | L30==B30+SUM(C30:F30)-SUM(G30:K30)=>0 ROW 31 A31=委托贷款损失准备 | B31==附注!F379+附注!D379=>0 | L31==B31+SUM(C31:F31)-SUM(G31:K31)=>0 | M31==L31-附注!C379-附注!E379=>0 ROW 32 A32=其他资产减值准备 | B32==附注!D380+附注!F380=>0 | L32==B32+SUM(C32:F32)-SUM(G32:K32)=>0 | M32==L32-附注!C380-附注!E380=>0 ROW 33 A33=合计（total） | B33==SUM(B21,B15,B8,B16)+SUM(B22:B32)=>7740742.6230999995 | C33==SUM(C21,C15,C8,C16)+SUM(C22:C32)=>1562330.56 | D33==SUM(D21,D15,D8,D16)+SUM(D22:D32)=>0 | E33==SUM(E21,E15,E8,E16)+SUM(E22:E32)=>0 | F33==SUM(F21,F15,F8,F16)+SUM(F22:F32)=>0 | G33==SUM(G21,G15,G8,G16)+SUM(G22:G32)=>0 | H33==SUM(H21,H15,H8,H16)+SUM(H22:H32)=>0 | I33==SUM(I21,I15,I8,I16)+SUM(I22:I32)=>0 | J33==SUM(J21,J15,J8,J16)+SUM(J22:J32)=>0 | K33==SUM(K21,K15,K8,K16)+SUM(K22:K32)=>0 | L33==SUM(L21,L15,L8,L16)+SUM(L22:L32)=>9303073.1831 === ASSET SHEET 长期应付款明细 dimension 64x17 === ROW 1 A1=长期应付款明细表 LONG-TERM PAYABLES ROW 2 A2==基本信息及要求!$A$4=>万传（安徽）物流有限公司 ROW 3 B3=期末数 | D3=期初数 ROW 4 B4=一年以内到期 Due within one year | C4=一年以后到期 Due after one year | D4=一年以内到期 Due within one year | E4=一年以后到期 Due after one year ROW 5 A5=应付融资租赁款 Capital lease payables | B5==附注!C714=>4893071.47 | C5==附注!C760=>3180722.37 | D5==附注!D714=>10803184.9 | E5==附注!D760=>40954940.76 | F5==B5+C5-附注!C755=>0 | G5==D5+E5-附注!D755=>0 ROW 6 A6=分期付款购入固定资产采购款 | F6==B6+C6-附注!C756=>0 | G6==D6+E6-附注!D756=>0 ROW 7 A7=其他 Others | C7==数据源_CF小合并!E99=>0 | E7==数据源_CF小合并!F99=>0 | F7==B7+C7-附注!C757=>0 | G7==D7+E7-附注!D757=>0 ROW 8 A8=合计 Total | B8==SUM(B5:B7)=>4893071.47 | C8==SUM(C5:C7)=>3180722.37 | D8==SUM(D5:D7)=>10803184.9 | E8==SUM(E5:E7)=>40954940.76 ROW 9 B9==B8-附注!C714=>0 | C9==C8-附注!C760=>0 | D9==D8-附注!D714=>0 | E9==E8-附注!D760=>0 ROW 11 A11=应付融资租赁款 Capital lease payable ROW 12 B12=期初数 | G12=本年增加 Addition in the period | I12=本年减少 Payment in the period | K12=期末数 ROW 13 A13=债权人名称 Name of creditors | B13=最低租赁付款额 Minimum lease payments | C13=未确认融资费用 Unrealized financial expense | D13=应付融资租赁款 Capital lease payables | E13=其中一年内到期 Maturity within one year | F13=一年以上到期 Maturity after one year | G13=最低租赁付款额 Minimum lease payments | H13=未确认融资费用 unrealized financial expense | I13=最低租赁付款额 Minimum lease payments | J13=未确认融资费用 Unrealized financial expense | K13=最低租赁付款额 Minimum lease payments | L13=未确认融资费用 Unrealized financial expense | M13=应付融资租赁款 Capital lease payables | N13=其中一年内到期 Maturity within one year | O13=一年以上到期 Maturity after one year ROW 14 A14=应付融资租赁款合计 (具体债权人待补充) | B14=51758125.66 | C14=0 | D14==B14-C14=>51758125.66 | E14==[2]合并资产负债表!E55=>10803184.9 | F14==D14-E14=>40954940.76 | G14=0 | H14=0 | I14=43684331.82 | J14=0 | K14==B14+G14-I14=>8073793.839999996 | L14==C14+H14-J14=>0 | M14==K14-L14=>8073793.839999996 | N14==[2]合并资产负债表!C55=>4893071.47 | O14==M14-N14=>3180722.3699999964 ROW 15 D15==B15-C15=>0 | F15==D15-E15=>0 | K15==B15+G15-I15=>0 | L15==C15+H15-J15=>0 | M15==K15-L15=>0 | O15==M15-N15=>0 ROW 16 D16==B16-C16=>0 | F16==D16-E16=>0 | K16==B16+G16-I16=>0 | L16==C16+H16-J16=>0 | M16==K16-L16=>0 | O16==M16-N16=>0 ROW 17 D17==B17-C17=>0 | F17==D17-E17=>0 | K17==B17+G17-I17=>0 | L17==C17+H17-J17=>0 | M17==K17-L17=>0 | O17==M17-N17=>0 ROW 18 D18==B18-C18=>0 | F18==D18-E18=>0 | K18==B18+G18-I18=>0 | L18==C18+H18-J18=>0 | M18==K18-L18=>0 | O18==M18-N18=>0 ROW 19 D19==B19-C19=>0 | F19==D19-E19=>0 | K19==B19+G19-I19=>0 | L19==C19+H19-J19=>0 | M19==K19-L19=>0 | O19==M19-N19=>0 ROW 20 D20==B20-C20=>0 | F20==D20-E20=>0 | K20==B20+G20-I20=>0 | L20==C20+H20-J20=>0 | M20==K20-L20=>0 | O20==M20-N20=>0 ROW 21 D21==B21-C21=>0 | F21==D21-E21=>0 | K21==B21+G21-I21=>0 | L21==C21+H21-J21=>0 | M21==K21-L21=>0 | O21==M21-N21=>0 ROW 22 D22==B22-C22=>0 | F22==D22-E22=>0 | K22==B22+G22-I22=>0 | L22==C22+H22-J22=>0 | M22==K22-L22=>0 | O22==M22-N22=>0 ROW 23 A23=合计 Total | B23==SUM(B14:B22)=>51758125.66 | C23==SUM(C14:C22)=>0 | D23==SUM(D14:D22)=>51758125.66 | E23==SUM(E14:E22)=>10803184.9 | F23==SUM(F14:F22)=>40954940.76 | G23==SUM(G14:G22)=>0 | H23==SUM(H14:H22)=>0 | I23==SUM(I14:I22)=>43684331.82 | J23==SUM(J14:J22)=>0 | K23==SUM(K14:K22)=>8073793.839999996 | L23==SUM(L14:L22)=>0 | M23==SUM(M14:M22)=>8073793.839999996 | N23==SUM(N14:N22)=>4893071.47 | O23==SUM(O14:O22)=>3180722.3699999964 ROW 24 E24==E23-D5=>0 | F24==F23-E5=>0 | N24==N23-B5=>0 | O24==O23-C5=>-3.725290298461914e-09 ROW 25 A25=应付融资租赁款还需填写以下信息：Further information ROW 26 B26=期末数 | C26=年初数 ROW 27 A27=资产负债表后第1年 The first year after B/S ROW 28 A28=资产负债表后第2年 The second year after B/S ROW 29 A29=资产负债表后第3年 The third year after B/S ROW 30 A30=以后年度 Later | B30=8073793.84 | C30=51758125.66 ROW 31 A31=最低租赁付款额合计 Total of minimum lease payment | B31==SUM(B27:B30)=>8073793.84 | C31==SUM(C27:C30)=>51758125.66 ROW 32 A32=未确认融资费用 Unrealized financial expense ROW 33 A33=应付融资租赁款 Capital lease payment | B33==B31-B32=>8073793.84 | C33==C31-C32=>51758125.66 ROW 34 A34=其中：1年内到期的应付融资租赁款 Maturity within one year ROW 35 A35=1年后到期的应付融资租赁款 Maturity after one year | B35==B33-B34=>8073793.84 | C35==C33-C34=>51758125.66 ROW 36 A36=构稽检查 Check | B36==IF(B31=K23,"OK","与最低租赁付款额不符")=>OK | C36==IF(C31=B23,"OK","与最低租赁付款额不符")=>OK ROW 37 B37==IF(B33=M23,"OK","与最低租赁付款额不符")=>OK | C37==IF(C33=D23,"OK","与最低租赁付款额不符")=>OK ROW 38 B38==IF(B36="OK",0,1)=>0 | C38==IF(C36="OK",0,1)=>0 ROW 39 B39==IF(B37="OK",0,1)=>0 | C39==IF(C37="OK",0,1)=>0 ROW 41 A41=其他长期应付款 Other long-term payables ROW 42 A42=债权人名称 Name of creditors | B42=性质及内容 Nature and content | C42=初始金额 Original amount | D42=起止年限 Period | E42=折现率 | F42=年初数 | H42=本年增加 Addition in the period | I42=本年支付 Repayment in the period | J42=利息摊销 | K42=本年其他变动 | L42=期末数 | M42=期末数 | O42=期末数 ROW 43 F43=一年以内到期 Maturity within one year | G43=一年以后到期 Maturity after one year | M43=一年以内到期 Maturity within one year | N43=一年以后到期 Maturity after one year | O43=长期应付款原值 | P43=未确认融资费用 ROW 44 L44==F44+G44+H44-I44+K44+J44=>0 | N44==L44-M44=>0 | Q44==O44+P44-L44=>0 ROW 45 L45==F45+G45+H45-I45+K45+J45=>0 | N45==L45-M45=>0 | Q45==O45+P45-L45=>0 ROW 46 L46==F46+G46+H46-I46+K46+J46=>0 | N46==L46-M46=>0 | Q46==O46+P46-L46=>0 ROW 47 L47==F47+G47+H47-I47+K47+J47=>0 | N47==L47-M47=>0 | Q47==O47+P47-L47=>0 ROW 48 L48==F48+G48+H48-I48+K48+J48=>0 | N48==L48-M48=>0 | Q48==O48+P48-L48=>0 ROW 49 L49==F49+G49+H49-I49+K49+J49=>0 | N49==L49-M49=>0 | Q49==O49+P49-L49=>0 ROW 50 L50==F50+G50+H50-I50+K50+J50=>0 | N50==L50-M50=>0 | Q50==O50+P50-L50=>0 ROW 51 L51==F51+G51+H51-I51+K51+J51=>0 | N51==L51-M51=>0 | Q51==O51+P51-L51=>0 ROW 52 L52==F52+G52+H52-I52+K52+J52=>0 | N52==L52-M52=>0 | Q52==O52+P52-L52=>0 ROW 53 L53==F53+G53+H53-I53+K53+J53=>0 | N53==L53-M53=>0 | Q53==O53+P53-L53=>0 ROW 54 L54==F54+G54+H54-I54+K54+J54=>0 | N54==L54-M54=>0 | Q54==O54+P54-L54=>0 ROW 55 L55==F55+G55+H55-I55+K55+J55=>0 | N55==L55-M55=>0 | Q55==O55+P55-L55=>0 ROW 56 L56==F56+G56+H56-I56+K56+J56=>0 | N56==L56-M56=>0 | Q56==O56+P56-L56=>0 ROW 57 L57==F57+G57+H57-I57+K57+J57=>0 | N57==L57-M57=>0 | Q57==O57+P57-L57=>0 ROW 58 L58==F58+G58+H58-I58+K58+J58=>0 | N58==L58-M58=>0 | Q58==O58+P58-L58=>0 ROW 59 L59==F59+G59+H59-I59+K59+J59=>0 | N59==L59-M59=>0 | Q59==O59+P59-L59=>0 ROW 60 A60=合计 Total | C60==ROUND(SUM(C44:C59),2)=>0 | D60==SUM(D44:D59)=>0 | F60==ROUND(SUM(F44:F59),2)=>0 | G60==ROUND(SUM(G44:G59),2)=>0 | H60==ROUND(SUM(H44:H59),2)=>0 | I60==ROUND(SUM(I44:I59),2)=>0 | J60==ROUND(SUM(J44:J59),2)=>0 | K60==ROUND(SUM(K44:K59),2)=>0 | L60==ROUND(SUM(L44:L59),2)=>0 | M60==ROUND(SUM(M44:M59),2)=>0 | N60==ROUND(SUM(N44:N59),2)=>0 | O60==ROUND(SUM(O44:O59),2)=>0 | P60==ROUND(SUM(P44:P59),2)=>0 | Q60==O60+P60-L60=>0 ROW 61 F61==F60-D7=>0 | G61==G60-E7=>0 | M61==M60-B7=>0 | N61==N60-C7=>0 === ASSET SHEET 试算表 dimension 242x73 === ROW 2 A2=试 算 平 衡 表 （资 产） | J2=试 算 平 衡 表 （负 债） ROW 3 H3=索引号： EB-1-1 | Q3=索引号： EB-1-2 ROW 4 A4==基本信息及要求!A4=>万传（安徽）物流有限公司 | D4==基本信息及要求!A5=>2025-12-31 | H4=="币种："&基本信息及要求!$B$7=>币种：人民币 | J4==A4=>万传（安徽）物流有限公司 | M4==D4=>2025-12-31 | Q4=="币种："&基本信息及要求!$B$7=>币种：人民币 ROW 5 A5=资 产 | B5= 调 整 前 余 额 | D5=增(减) | E5=占总资产比例 | F5= 调 整 分 录 | H5=调整后余额 | J5=负债及股东权益 | K5= 调 整 前 余 额 | M5=增(减) | N5=占总资产比例 | O5= 调 整 分 录 | Q5=调整后余额 ROW 20 A20= 合同资产 | B20==数据源_CF小合并!F33=>0 | C20==数据源_CF小合并!E33=>0 | D20==IF(B20=0,0,(C20-B20)/B20)=>0 | F20==SUMIF(AD:AD,dm!A13,AG:AG)=>0 | G20==SUMIF(AD:AD,dm!A13,AH:AH)=>0 | H20==C20+F20-G20=>0 | J20= 其他流动负债 | K20==-数据源_CF小合并!F92=>2167037.79 | L20==-数据源_CF小合并!E92=>164188.16 | M20==IF(K20=0,0,(L20-K20)/K20)=>-0.92423382704369 | N20==IF(L20=0,0,L20/$L$46)=>0.0002180099259532707 | O20==SUMIF(AD:AD,dm!A66,AG:AG)=>0 | P20==SUMIF(AD:AD,dm!A66,AH:AH)=>0 | Q20==L20-O20+P20=>164188.16 ROW 21 A21= 减：合同资产减值准备 | B21==数据源_CF小合并!F34=>0 | C21==数据源_CF小合并!E34=>0 | D21==IF(B21=0,0,(C21-B21)/B21)=>0 | F21==SUMIF(AD:AD,dm!A14,AG:AG)=>0 | G21==SUMIF(AD:AD,dm!A14,AH:AH)=>0 | H21==C21+G21-F21=>0 | J21= 内部往来（负债） | M21==IF(K21=0,0,(L21-K21)/K21)=>0 | N21==IF(L21=0,0,L21/$L$46)=>0 | O21==SUMIF(AD:AD,dm!A67,AG:AG)=>0 | P21==SUMIF(AD:AD,dm!A67,AH:AH)=>0 | Q21==L21-O21+P21=>0 ROW 22 A22= 合同资产净额 | B22==B20-B21=>0 | C22==C20-C21=>0 | D22==IF(B22=0,0,(C22-B22)/B22)=>0 | E22==IF(C22=0,0,C22/$C$79)=>0 | F22==F20+F21=>0 | G22==G20+G21=>0 | H22==H20-H21=>0 | J22=流动负债合计 | K22==SUM(K8:K21)=>820885152.56 | L22==SUM(L8:L21)=>916131277.592832 | M22==IF(K22=0,0,(L22-K22)/K22)=>0.11602856347906758 | N22==IF(L22=0,0,L22/$L$46)=>1.2164440602263196 | O22==SUM(O8:O21)=>0 | P22==SUM(P8:P21)=>14150.94 | Q22==SUM(Q8:Q21)=>916145428.532832 ROW 23 A23= 存货 | B23==数据源_CF小合并!F30=>0 | C23==数据源_CF小合并!E30=>0 | D23==IF(B23=0,0,(C23-B23)/B23)=>0 | F23==SUMIF(AD:AD,dm!A11,AG:AG)=>0 | G23==SUMIF(AD:AD,dm!A11,AH:AH)=>0 | H23==C23+F23-G23=>0 | J23=非流动负债 ROW 24 A24= 减：存货跌价准备 | B24==数据源_CF小合并!F31=>0 | C24==数据源_CF小合并!E31=>0 | D24==IF(B24=0,0,(C24-B24)/B24)=>0 | F24==SUMIF(AD:AD,dm!A12,AG:AG)=>0 | G24==SUMIF(AD:AD,dm!A12,AH:AH)=>0 | H24==C24+G24-F24=>0 | J24= 长期借款 | K24==数据源_CF小合并!F97=>0 | L24==数据源_CF小合并!E97=>0 | M24==IF(K24=0,0,(L24-K24)/K24)=>0 | N24==IF(L24=0,0,L24/$L$46)=>0 | O24==SUMIF(AD:AD,dm!A68,AG:AG)=>0 | P24==SUMIF(AD:AD,dm!A68,AH:AH)=>0 | Q24==L24-O24+P24=>0 ROW 25 A25= 存货净值 | B25==B23-B24=>0 | C25==C23-C24=>0 | D25==IF(B25=0,0,(C25-B25)/B25)=>0 | E25==IF(C25=0,0,C25/$C$79)=>0 | F25==F23+F24=>0 | G25==G23+G24=>0 | H25==H23-H24=>0 | J25= 应付债券 | K25==数据源_CF小合并!F98=>0 | L25==数据源_CF小合并!E98=>0 | M25==IF(K25=0,0,(L25-K25)/K25)=>0 | N25==IF(L25=0,0,L25/$L$46)=>0 | O25==SUMIF(AD:AD,dm!A69,AG:AG)=>0 | P25==SUMIF(AD:AD,dm!A69,AH:AH)=>0 | Q25==L25-O25+P25=>0 ROW 35 A35= 其他债权投资 | D35==IF(B35=0,0,(C35-B35)/B35)=>0 | F35==SUMIF(AD:AD,dm!A21,AG:AG)=>0 | G35==SUMIF(AD:AD,dm!A21,AH:AH)=>0 | H35==C35+F35-G35=>0 | J35=所有者权益 ROW 36 A36= 减：其他债权投资减值准备 | D36==IF(B36=0,0,(C36-B36)/B36)=>0 | F36==SUMIF(AD:AD,dm!A22,AG:AG)=>0 | G36==SUMIF(AD:AD,dm!A22,AH:AH)=>0 | H36==C36+G36-F36=>0 | J36= 实收资本（股本） | K36==-数据源_CF小合并!F111=>20000000 | L36==-数据源_CF小合并!E111=>20000000 | M36==IF(K36=0,0,(L36-K36)/K36)=>0 | N36==IF(L36=0,0,L36/$L$46)=>0.026556108059590983 | O36==SUMIF(AD:AD,dm!A77,AG:AG)=>0 | P36==SUMIF(AD:AD,dm!A77,AH:AH)=>0 | Q36==L36-O36+P36=>20000000 ROW 37 A37= 其他债权投资净值 | B37==B35-B36=>0 | C37==C35-C36=>0 | D37==IF(B37=0,0,(C37-B37)/B37)=>0 | E37==IF(C37=0,0,C37/$C$79)=>0 | F37==F35+F36=>0 | G37==G35+G36=>0 | H37==H35-H36=>0 | J37= 其他权益工具 | M37==IF(K37=0,0,(L37-K37)/K37)=>0 | N37==IF(L37=0,0,L37/$L$46)=>0 | O37==SUMIF(AD:AD,dm!A78,AG:AG)=>0 | P37==SUMIF(AD:AD,dm!A78,AH:AH)=>0 | Q37==L37-O37+P37=>0 ROW 38 A38= 投资性房地产 | D38==IF(B38=0,0,(C38-B38)/B38)=>0 | F38==SUMIF(AD:AD,dm!A25,AG:AG)=>0 | G38==SUMIF(AD:AD,dm!A25,AH:AH)=>0 | H38==C38+F38-G38=>0 | J38= 资本公积 | K38==数据源_CF小合并!F112=>0 | L38==数据源_CF小合并!E112=>0 | M38==IF(K38=0,0,(L38-K38)/K38)=>0 | N38==IF(L38=0,0,L38/$L$46)=>0 | O38==SUMIF(AD:AD,dm!A79,AG:AG)=>0 | P38==SUMIF(AD:AD,dm!A79,AH:AH)=>0 | Q38==L38-O38+P38=>0 ROW 39 A39= 加：投资性房地产（公允价值变动） | D39==IF(B39=0,0,(C39-B39)/B39)=>0 | F39==SUMIF(AD:AD,dm!A26,AG:AG)=>0 | G39==SUMIF(AD:AD,dm!A26,AH:AH)=>0 | H39==C39+F39-G39=>0 | J39= 减：库存股 | M39==IF(K39=0,0,(L39-K39)/K39)=>0 | N39==IF(L39=0,0,-L39/$L$46)=>0 | O39==SUMIF(AD:AD,dm!A80,AG:AG)=>0 | P39==SUMIF(AD:AD,dm!A80,AH:AH)=>0 | Q39==L39+O39-P39=>0 ROW 40 A40= 减：投资性房地产累计摊销 | D40==IF(B40=0,0,(C40-B40)/B40)=>0 | F40==SUMIF(AD:AD,dm!A27,AG:AG)=>0 | G40==SUMIF(AD:AD,dm!A27,AH:AH)=>0 | H40==C40+G40-F40=>0 | J40= 其他综合收益 | K40==数据源_CF小合并!F114=>0 | L40==数据源_CF小合并!E114=>0 | M40==IF(K40=0,0,(L40-K40)/K40)=>0 | N40==IF(L40=0,0,L40/$L$46)=>0 | O40==W31+W33+SUMIF(AD:AD,dm!A81,AG:AG)=>0 | P40==X31+X33+SUMIF(AD:AD,dm!A81,AH:AH)=>0 | Q40==L40-O40+P40=>0 ROW 41 A41= 减：投资性房地产减值准备 | D41==IF(B41=0,0,(C41-B41)/B41)=>0 | F41==SUMIF(AD:AD,dm!A28,AG:AG)=>0 | G41==SUMIF(AD:AD,dm!A28,AH:AH)=>0 | H41==C41+G41-F41=>0 | J41= 专项储备 | K41==数据源_CF小合并!F115=>0 | L41==数据源_CF小合并!E115=>0 | M41==IF(K41=0,0,(L41-K41)/K41)=>0 | N41==IF(L41=0,0,L41/$L$46)=>0 | O41==SUMIF(AD:AD,dm!A83,AG:AG)=>0 | P41==SUMIF(AD:AD,dm!A83,AH:AH)=>0 | Q41==L41-O41+P41=>0 ROW 42 A42= 投资性房地产净值 | B42==B38+B39-B40-B41=>0 | C42==C38+C39-C40-C41=>0 | D42==IF(B42=0,0,(C42-B42)/B42)=>0 | E42==IF(C42=0,0,C42/$C$79)=>0 | F42==SUM(F38:F41)=>0 | G42==SUM(G38:G41)=>0 | H42==H38+H39-H40-H41=>0 | J42= 盈余公积 | K42==数据源_CF小合并!F116=>0 | L42==数据源_CF小合并!E116=>0 | M42==IF(K42=0,0,(L42-K42)/K42)=>0 | N42==IF(L42=0,0,L42/$L$46)=>0 | O42==SUMIF(AD:AD,dm!A82,AG:AG)=>0 | P42==SUMIF(AD:AD,dm!A82,AH:AH)=>0 | Q42==L42-O42+P42=>0 ROW 43 A43= 长期股权投资 | B43==数据源_CF小合并!F46=>0 | C43==数据源_CF小合并!E46=>0 | D43==IF(B43=0,0,(C43-B43)/B43)=>0 | F43==SUMIF(AD:AD,dm!A29,AG:AG)=>0 | G43==SUMIF(AD:AD,dm!A29,AH:AH)=>0 | H43==C43+F43-G43=>0 | J43= 未分配利润 | K43==-数据源_CF小合并!F117=>-77242763.5430999 | L43==-数据源_CF小合并!E117=>-186189593.806 | M43==IF(K43=0,0,(L43-K43)/K43)=>1.410447079642742 | N43==IF(L43=0,0,L43/$L$46)=>-0.2472235486341744 | O43==W41+W30=>0 | P43==X41+X30=>-14150.94 | Q43==L43-O43+P43=>-186203744.746 ROW 44 A44= 减：长期股权投资减值准备 | B44==数据源_CF小合并!F47=>0 | C44==数据源_CF小合并!E47=>0 | D44==IF(B44=0,0,(C44-B44)/B44)=>0 | F44==SUMIF(AD:AD,dm!A30,AG:AG)=>0 | G44==SUMIF(AD:AD,dm!A30,AH:AH)=>0 | H44==C44+G44-F44=>0 | J44= 少数股东权益 | K44==数据源_CF小合并!F120=>0 | L44==数据源_CF小合并!E120=>0 | M44==IF(K44=0,0,(L44-K44)/K44)=>0 | N44==IF(L44=0,0,L44/$L$46)=>0 | O44==SUMIF(AD:AD,dm!A85,AG:AG)=>0 | P44==SUMIF(AD:AD,dm!A85,AH:AH)=>0 | Q44==L44-O44+P44=>0 ROW 45 A45= 长期股权投资净额 | B45==B43-B44=>0 | C45==C43-C44=>0 | D45==IF(B45=0,0,(C45-B45)/B45)=>0 | E45==IF(C45=0,0,C45/$C$79)=>0 | F45==F43+F44=>0 | G45==G43+G44=>0 | H45==H43-H44=>0 | J45=所有者权益合计 | K45==K36+K38-K39+K40+K41+K42+K43+K44+K37=>-57242763.543099895 | L45==L36+L38-L39+L40+L41+L42+L43+L44+L37=>-166189593.806 | M45==IF(K45=0,0,(L45-K45)/K45)=>1.9032419736491333 | N45==IF(L45=0,0,L45/$L$46)=>-0.2206674405745834 | O45==SUM(O36:O44)=>0 | P45==SUM(P36:P44)=>-14150.94 | Q45==Q36+Q38-Q39+Q40+Q41+Q42+Q43+Q44+Q37=>-166203744.746 ROW 46 A46= 长期应收款 | B46==数据源_CF小合并!F42=>0 | C46==数据源_CF小合并!E42=>0 | D46==IF(B46=0,0,(C46-B46)/B46)=>0 | F46==SUMIF(AD:AD,dm!A31,AG:AG)=>0 | G46==SUMIF(AD:AD,dm!A31,AH:AH)=>0 | H46==C46+F46-G46=>0 | J46=负债和所有者权益合计 | K46==K34+K45=>804597329.7769 | L46==L34+L45=>753122406.156832 | M46==IF(K46=0,0,(L46-K46)/K46)=>-0.06397600602818446 | N46==IF(L46=0,0,L46/$L$46)=>1 | O46==O34+O45=>0 | P46==P34+P45=>0 | Q46==Q34+Q45=>753122406.156832 ROW 47 A47= 减：坏帐准备（长期应收款） | D47==IF(B47=0,0,(C47-B47)/B47)=>0 | F47==SUMIF(AD:AD,dm!A32,AG:AG)=>0 | G47==SUMIF(AD:AD,dm!A32,AH:AH)=>0 | H47==C47+G47-F47=>0 | K47==K46-B79=>-0.009999990463256836 | L47==L46-C79=>-0.0071680545806884766 | Q47==Q46-H79=>-0.0071680545806884766 ROW 48 A48= 长期应收款净额 | B48==B46-B47=>0 | C48==C46-C47=>0 | D48==IF(B48=0,0,(C48-B48)/B48)=>0 | E48==IF(C48=0,0,C48/$C$79)=>0 | F48==F46+F47=>0 | G48==G46+G47=>0 | H48==H46-H47=>0 | K48==K15-B28=>-15340362.85 | L48==L15-C28=>-16210340.100000001 ROW 49 A49= 其他权益工具投资 | D49==IF(B49=0,0,(C49-B49)/B49)=>0 | E49==IF(C49=0,0,C49/$C$79)=>0 | F49==SUMIF(AD:AD,dm!A23,AG:AG)=>0 | G49==SUMIF(AD:AD,dm!A23,AH:AH)=>0 | H49==C49+F49-G49=>0 ROW 50 A50= 其他非流动金融资产 | D50==IF(B50=0,0,(C50-B50)/B50)=>0 | E50==IF(C50=0,0,C50/$C$79)=>0 | F50==SUMIF(AD:AD,dm!A24,AG:AG)=>0 | G50==SUMIF(AD:AD,dm!A24,AH:AH)=>0 | H50==C50+F50-G50=>0 ROW 51 A51= 固定资产原值 | B51==数据源_CF小合并!F49=>688113038.69 | C51==数据源_CF小合并!E49=>706674631.23 | D51==IF(B51=0,0,(C51-B51)/B51)=>0.026974626981835313 | F51==SUMIF(AD:AD,dm!A33,AG:AG)=>0 | G51==SUMIF(AD:AD,dm!A33,AH:AH)=>0 | H51==C51+F51-G51=>706674631.23 ROW 52 A52= 减：累计折旧 | B52==数据源_CF小合并!F50=>111038508.82 | C52==数据源_CF小合并!E50=>160982600.28 | D52==IF(B52=0,0,(C52-B52)/B52)=>0.4497907256748408 | F52==SUMIF(AD:AD,dm!A34,AG:AG)=>0 | G52==SUMIF(AD:AD,dm!A34,AH:AH)=>0 | H52==C52+G52-F52=>160982600.28 ROW 53 A53= 减：固定资产减值准备 | B53==数据源_CF小合并!F51=>7502513.47 | C53==数据源_CF小合并!E51=>7502513.47 | D53==IF(B53=0,0,(C53-B53)/B53)=>0 | F53==SUMIF(AD:AD,dm!A35,AG:AG)=>0 | G53==SUMIF(AD:AD,dm!A35,AH:AH)=>0 | H53==C53+G53-F53=>7502513.47 ROW 54 A54= 固定资产净额 | B54==B51-B52-B53=>569572016.4000001 | C54==C51-C52-C53=>538189517.48 | D54==IF(B54=0,0,(C54-B54)/B54)=>-0.055098386185392784 | E54==IF(C54=0,0,C54/$C$79)=>0.714610949130099 | F54==F51+F52+F53=>0 | G54==G51+G52+G53=>0 | H54==H51-H52-H53=>538189517.48 ROW 55 A55= 在建工程 | B55==数据源_CF小合并!F54=>79870731.86 | C55==数据源_CF小合并!E54=>12901289.37 | D55==IF(B55=0,0,(C55-B55)/B55)=>-0.8384728789938498 | F55==SUMIF(AD:AD,dm!A36,AG:AG)=>0 | G55==SUMIF(AD:AD,dm!A36,AH:AH)=>0 | H55==C55+F55-G55=>12901289.37 ROW 56 A56= 减：在建工程减值准备 | B56==数据源_CF小合并!F55=>0 | C56==数据源_CF小合并!E55=>0 | D56==IF(B56=0,0,(C56-B56)/B56)=>0 | F56==SUMIF(AD:AD,dm!A37,AG:AG)=>0 | G56==SUMIF(AD:AD,dm!A37,AH:AH)=>0 | H56==C56+G56-F56=>0 ROW 57 A57= 在建工程净额 | B57==B55-B56=>79870731.86 | C57==C55-C56=>12901289.37 | D57==IF(B57=0,0,(C57-B57)/B57)=>-0.8384728789938498 | E57==IF(C57=0,0,C57/$C$79)=>0.01713040173072558 | F57==F55+F56=>0 | G57==G55+G56=>0 | H57==H55-H56=>12901289.37 ROW 58 A58= 生产性生物资产原值 | D58==IF(B58=0,0,(C58-B58)/B58)=>0 | F58==SUMIF(AD:AD,dm!A38,AG:AG)=>0 | G58==SUMIF(AD:AD,dm!A38,AH:AH)=>0 | H58==C58+F58-G58=>0 ROW 59 A59= 减：生产性生物资产累计折旧 | D59==IF(B59=0,0,(C59-B59)/B59)=>0 | F59==SUMIF(AD:AD,dm!A39,AG:AG)=>0 | G59==SUMIF(AD:AD,dm!A39,AH:AH)=>0 | H59==C59+G59-F59=>0 ROW 60 A60= 减：生产性生物资产减值准备 | D60==IF(B60=0,0,(C60-B60)/B60)=>0 | F60==SUMIF(AD:AD,dm!A40,AG:AG)=>0 | G60==SUMIF(AD:AD,dm!A40,AH:AH)=>0 | H60==C60+G60-F60=>0 ROW 61 A61= 生产性生物资产净值 | B61==B58-B59-B60=>0 | C61==C58-C59-C60=>0 | D61==IF(B61=0,0,(C61-B61)/B61)=>0 | E61==IF(C61=0,0,C61/$C$79)=>0 | F61==F58+F59+F60=>0 | G61==G58+G59+G60=>0 | H61==H58-H59-H60=>0 ROW 62 A62= 油气资产 | D62==IF(B62=0,0,(C62-B62)/B62)=>0 | E62==IF(C62=0,0,C62/$C$79)=>0 | F62==SUMIF(AD:AD,dm!A41,AG:AG)=>0 | G62==SUMIF(AD:AD,dm!A41,AH:AH)=>0 | H62==C62+F62-G62=>0 ROW 63 A63= 使用权资产原值 | B63==数据源_CF小合并!F57=>0 | C63==数据源_CF小合并!E57=>0 | D63==IF(B63=0,0,(C63-B63)/B63)=>0 | F63==SUMIF(AD:AD,dm!A42,AG:AG)=>0 | G63==SUMIF(AD:AD,dm!A42,AH:AH)=>0 | H63==C63+F63-G63=>0 ROW 64 A64= 减：使用权资产累计折旧 | B64==数据源_CF小合并!F58=>0 | C64==数据源_CF小合并!E58=>0 | D64==IF(B64=0,0,(C64-B64)/B64)=>0 | F64==SUMIF(AD:AD,dm!A43,AG:AG)=>0 | G64==SUMIF(AD:AD,dm!A43,AH:AH)=>0 | H64==C64+G64-F64=>0 ROW 65 A65= 减：使用权资产减值准备 | D65==IF(B65=0,0,(C65-B65)/B65)=>0 | F65==SUMIF(AD:AD,dm!A44,AG:AG)=>0 | G65==SUMIF(AD:AD,dm!A44,AH:AH)=>0 | H65==C65+G65-F65=>0 ROW 66 A66= 使用权资产净额 | B66==B63-B65-B64=>0 | C66==C63-C65-C64=>0 | D66==IF(B66=0,0,(C66-B66)/B66)=>0 | E66==IF(C66=0,0,C66/$C$79)=>0 | F66==F63+F65+F64=>0 | G66==G63+G65=>0 | H66==H63-H65-H64=>0 ROW 67 A67= 无形资产原值 | B67==数据源_CF小合并!F60=>0 | C67==数据源_CF小合并!E60=>0 | D67==IF(B67=0,0,(C67-B67)/B67)=>0 | F67==SUMIF(AD:AD,dm!A45,AG:AG)=>0 | G67==SUMIF(AD:AD,dm!A45,AH:AH)=>0 | H67==C67+F67-G67=>0 ROW 68 A68= 减：无形资产累计摊销 | B68==数据源_CF小合并!F61=>0 | C68==数据源_CF小合并!E61=>0 | D68==IF(B68=0,0,(C68-B68)/B68)=>0 | F68==SUMIF(AD:AD,dm!A46,AG:AG)=>0 | G68==SUMIF(AD:AD,dm!A46,AH:AH)=>0 | H68==C68+G68-F68=>0 ROW 69 A69= 减：无形资产减值准备 | D69==IF(B69=0,0,(C69-B69)/B69)=>0 | F69==SUMIF(AD:AD,dm!A47,AG:AG)=>0 | G69==SUMIF(AD:AD,dm!A47,AH:AH)=>0 | H69==C69+G69-F69=>0 ROW 70 A70= 无形资产净额 | B70==B67-B69-B68=>0 | C70==C67-C69-C68=>0 | D70==IF(B70=0,0,(C70-B70)/B70)=>0 | E70==IF(C70=0,0,C70/$C$79)=>0 | F70==F67+F69+F68=>0 | G70==G67+G69=>0 | H70==H67-H69-H68=>0 ROW 71 A71= 开发支出 | B71==数据源_CF小合并!F64=>0 | C71==数据源_CF小合并!E64=>0 | D71==IF(B71=0,0,(C71-B71)/B71)=>0 | E71==IF(C71=0,0,C71/$C$79)=>0 | F71==SUMIF(AD:AD,dm!A48,AG:AG)=>0 | G71==SUMIF(AD:AD,dm!A48,AH:AH)=>0 | H71==C71+F71-G71=>0 ROW 72 A72= 商誉 | B72==数据源_CF小合并!F65=>0 | C72==数据源_CF小合并!E65=>0 | D72==IF(B72=0,0,(C72-B72)/B72)=>0 | F72==SUMIF(AD:AD,dm!A49,AG:AG)=>0 | G72==SUMIF(AD:AD,dm!A49,AH:AH)=>0 | H72==C72+F72-G72=>0 ROW 73 A73= 减：商誉减值准备 | D73==IF(B73=0,0,(C73-B73)/B73)=>0 | F73==SUMIF(AD:AD,dm!A50,AG:AG)=>0 | G73==SUMIF(AD:AD,dm!A50,AH:AH)=>0 | H73==C73+G73-F73=>0 ROW 74 A74= 商誉净值 | B74==B72-B73=>0 | C74==C72-C73=>0 | D74==IF(B74=0,0,(C74-B74)/B74)=>0 | E74==IF(C74=0,0,C74/$C$79)=>0 | F74==F72+F73=>0 | G74==G72+G73=>0 | H74==H72-H73=>0 ROW 75 A75= 长期待摊费用 | B75==数据源_CF小合并!F68=>0 | C75==数据源_CF小合并!E68=>0 | D75==IF(B75=0,0,(C75-B75)/B75)=>0 | E75==IF(C75=0,0,C75/$C$79)=>0 | F75==SUMIF(AD:AD,dm!A51,AG:AG)=>0 | G75==SUMIF(AD:AD,dm!A51,AH:AH)=>0 | H75==C75+F75-G75=>0 ROW 76 A76= 递延所得税资产 | B76==数据源_CF小合并!F69=>0 | C76==数据源_CF小合并!E69=>0 | D76==IF(B76=0,0,(C76-B76)/B76)=>0 | E76==IF(C76=0,0,C76/$C$79)=>0 | F76==SUMIF(AD:AD,dm!A52,AG:AG)=>0 | G76==SUMIF(AD:AD,dm!A52,AH:AH)=>0 | H76==C76+F76-G76=>0 ROW 77 A77= 其他非流动资产 | B77==数据源_CF小合并!F70=>54001897.78 | C77==数据源_CF小合并!E70=>57208471.29 | D77==IF(B77=0,0,(C77-B77)/B77)=>0.05937890410932143 | E77==IF(C77=0,0,C77/$C$79)=>0.07596171727433944 | F77==SUMIF(AD:AD,dm!A53,AG:AG)=>0 | G77==SUMIF(AD:AD,dm!A53,AH:AH)=>0 | H77==C77+F77-G77=>57208471.29 ROW 78 A78=非流动资产合计 | B78==B34+B37+B42+B45+B48+B49+B50+B54+B57+B61+B62+B66+B70+B71+B74+B75+B76+B77=>703444646.0400001 | C78==C34+C37+C42+C45+C48+C49+C50+C54+C57+C61+C62+C66+C70+C71+C74+C75+C76+C77=>608299278.14 | D78==IF(B78=0,0,(C78-B78)/B78)=>-0.13525636798234986 | E78==IF(C78=0,0,C78/$C$79)=>0.807703068135164 | F78==F34+F37+F42+F45+F48+F49+F50+F54+F57+F61+F62+F70+F71+F74+F75+F76+F77=>0 | G78==G34+G37+G42+G45+G48+G49+G50+G54+G57+G61+G62+G70+G71+G74+G75+G76+G77=>0 | H78==H34+H37+H42+H45+H48+H49+H50+H54+H57+H61+H62+H66+H70+H71+H74+H75+H76+H77=>608299278.14 ROW 79 A79=资产总计 | B79==B30+B78=>804597329.7869 | C79==C30+C78=>753122406.164 | D79==IF(B79=0,0,(C79-B79)/B79)=>-0.06397600603090901 | E79==IF(C79=0,0,C79/$C$79)=>1 | F79==F30+F78=>0 | G79==G30+G78=>0 | H79==H30+H78=>753122406.164 === ASSET SHEET 附注 dimension 1255x14 === ROW 97 B97=坏账准备 | C97=第一阶段：信用风险未显著增加 | D97=第二阶段：信用风险显著增加 | E97=第三阶段：已发生信用减值 | F97=合计 ROW 98 C98=未来12个月预期信用损失 | D98=整个存续期预期信用损失(未发生信用减值) | E98=整个存续期预期信用损失(已发生信用减值) ROW 177 A177=12、预付账款分账龄 ROW 189 A189=13、预付账款余额第三方前五名 ROW 220 B220=第二阶段：信用风险显著增加 | C220==SUM(C221:C227)=>0 | D220==SUM(D221:D227)=>0 | E220==C220-D220=>0 | F220==SUM(F221:F227)=>0 | G220==SUM(G221:G227)=>0 | H220==F220-G220=>0 | I220=整个存续期预期信用损失(未发生信用减值) ROW 228 B228=第三阶段：已发生信用减值 | E228==C228-D228=>0 | H228==F228-G228=>0 | I228=整个存续期预期信用损失(已发生信用减值) ROW 233 B233=坏账准备 | C233=第一阶段：信用风险未显著增加 | D233=第二阶段：信用风险显著增加 | E233=第三阶段：已发生信用减值 | F233=合计 ROW 234 C234=未来12个月预期信用损失 | D234=整个存续期预期信用损失(未发生信用减值) | E234=整个存续期预期信用损失(已发生信用减值) ROW 241 B241=本期计提 | F241==SUM(C241:E241)=>0 | G241==F241-资产减值明细表!C6=>0 ROW 242 B242=本期转回 | F242==SUM(C242:E242)=>0 | G242==F242+资产减值明细表!G6=>0 ROW 243 B243=本期转销或核销 | F243==SUM(C243:E243)=>0 | G243==F243+资产减值明细表!H6=>0 === ASSET SHEET 现金流量表底稿 dimension 492x12 === ROW 180 B180=加：应收投资收益款（期初-期末） | D180=*经营性应收调整 | E180=2-2-6 | G180=请附明细构成 | H180==IF(D180="*经营性应收调整",C180,0)=>0 | I180==IF(D180="*经营性应付调整",C180,0)=>0 ROW 181 B181=加：预收投资收益款（期末-期初） | D181=*经营性应付调整 | E181=2-2-7 | G181=请附明细构成 | H181==IF(D181="*经营性应收调整",C181,0)=>0 | I181==IF(D181="*经营性应付调整",C181,0)=>0 ROW 182 H182==IF(D182="*经营性应收调整",C182,0)=>0 | I182==IF(D182="*经营性应付调整",C182,0)=>0 ROW 183 H183==IF(D183="*经营性应收调整",C183,0)=>0 | I183==IF(D183="*经营性应付调整",C183,0)=>0 ROW 184 H184==IF(D184="*经营性应收调整",C184,0)=>0 | I184==IF(D184="*经营性应付调整",C184,0)=>0 ROW 185 H185==IF(D185="*经营性应收调整",C185,0)=>0 | I185==IF(D185="*经营性应付调整",C185,0)=>0 ROW 186 B186=取得投资收益所收到的现金 | C186==SUM(C175:C185)=>0 | H186==IF(D186="*经营性应收调整",C186,0)=>0 | I186==IF(D186="*经营性应付调整",C186,0)=>0 | J186=原币试算折算参考值： ROW 187 H187==IF(D187="*经营性应收调整",C187,0)=>0 | I187==IF(D187="*经营性应付调整",C187,0)=>0 ROW 188 A188=2-3 | B188=固定资产处置净值 | C188==+固定资产!H15-固定资产!H37-固定资产!H54=>189770206.04999998 | E188=2-3-1 | H188==IF(D188="*经营性应收调整",C188,0)=>0 | I188==IF(D188="*经营性应付调整",C188,0)=>0 ROW 189 B189=投资性房地产处置净值 | C189==投资性房地产!D15-投资性房地产!D35-投资性房地产!D51=>0 | E189=2-3-2 | H189==IF(D189="*经营性应收调整",C189,0)=>0 | I189==IF(D189="*经营性应付调整",C189,0)=>0 ROW 190 B190=无形资产处置净值 | C190==+无形资产变动表!I15-无形资产变动表!I33-无形资产变动表!I47=>0 | E190=2-3-3 | H190==IF(D190="*经营性应收调整",C190,0)=>0 | I190==IF(D190="*经营性应付调整",C190,0)=>0 ROW 191 B191=固定资产处置损益 | C191==附注!C1029=>-71894501.37 | E191=2-3-4 | H191==IF(D191="*经营性应收调整",C191,0)=>0 | I191==IF(D191="*经营性应付调整",C191,0)=>0 ROW 192 B192=无形资产处置损益 | C192==附注!C1030=>0 | E192=2-3-5 | H192==IF(D192="*经营性应收调整",C192,0)=>0 | I192==IF(D192="*经营性应付调整",C192,0)=>0 ROW 193 B193=加：固定资产清理（期初-期末） | E193=2-3-6 | H193==IF(D193="*经营性应收调整",C193,0)=>0 | I193==IF(D193="*经营性应付调整",C193,0)=>0 ROW 194 B194=在建工程处置损益 | C194==附注!C1031=>0 | E194=2-3-7 | H194==IF(D194="*经营性应收调整",C194,0)=>0 | I194==IF(D194="*经营性应付调整",C194,0)=>0 ROW 195 B195=投资性房地产处置损益 | C195==附注!C1022=>0 | E195=2-3-8 | H195==IF(D195="*经营性应收调整",C195,0)=>0 | I195==IF(D195="*经营性应付调整",C195,0)=>0 ROW 196 B196=非流动资产报废毁损损失 | C196==-附注!C1067=>-147785.36 | E196=2-3-9 | H196==IF(D196="*经营性应收调整",C196,0)=>0 | I196==IF(D196="*经营性应付调整",C196,0)=>0 ROW 197 B197=加：应交增值税-销项税（销售设备税金） | C197==附注!C689=>31111748.0700001 | E197=2-3-10 | H197==IF(D197="*经营性应收调整",C197,0)=>0 | I197==IF(D197="*经营性应付调整",C197,0)=>0 ROW 198 B198=加：应收资产处置款（期初-期末） | D198=*经营性应收调整 | E198=2-3-11 | G198=请附明细构成 | H198==IF(D198="*经营性应收调整",C198,0)=>0 | I198==IF(D198="*经营性应付调整",C198,0)=>0 ROW 199 B199=加：预收资产处置款（期末-期初） | D199=*经营性应付调整ok | E199=2-3-12 | G199=请附明细构成 | H199==IF(D199="*经营性应收调整",C199,0)=>0 | I199==IF(D199="*经营性应付调整",C199,0)=>0 ROW 200 B200=使用权资产的处置 | C200=='使用权资产 '!G12-'使用权资产 '!G26=>0 | H200==IF(D200="*经营性应收调整",C200,0)=>0 | I200==IF(D200="*经营性应付调整",C200,0)=>0 ROW 201 C201=-49437.52 | H201==IF(D201="*经营性应收调整",C201,0)=>0 | I201==IF(D201="*经营性应付调整",C201,0)=>0 ROW 202 C202==附注!C1051=>453601.92 | H202==IF(D202="*经营性应收调整",C202,0)=>0 | I202==IF(D202="*经营性应付调整",C202,0)=>0 ROW 203 H203==IF(D203="*经营性应收调整",C203,0)=>0 | I203==IF(D203="*经营性应付调整",C203,0)=>0 ROW 204 B204=处置固定资产、无形资产和其他长期资产而收回的现金净额 | C204==SUM(C188:C203)=>149243831.79000005 | H204==IF(D204="*经营性应收调整",C204,0)=>0 | I204==IF(D204="*经营性应付调整",C204,0)=>0 | J204=原币试算折算参考值： ROW 205 H205==IF(D205="*经营性应收调整",C205,0)=>0 | I205==IF(D205="*经营性应付调整",C205,0)=>0 ROW 238 A238=2-6 | B238=固定资产、在建工程、投资性房地产、长期待摊费用本年购入 | C238==投资性房地产!D8+固定资产!H7+无形资产变动表!I7+在建工程情况表!D24+长期待摊费用变动明细表!F17-在建工程情况表!Q24=>202812210 | E238=2-6-1 | H238==-IF(D238="*经营性应收调整",C238,0)=>0 | I238==-IF(D238="*经营性应付调整",C238,0)=>0 ROW 239 B239=加：开发支出 | C239==附注!C1205-附注!G1205=>0 | E239=2-6-2 | H239==-IF(D239="*经营性应收调整",C239,0)=>0 | I239==-IF(D239="*经营性应付调整",C239,0)=>0 ROW 240 B240=加：与长期资产采购相关的进项税 | C240==附注!C691=>56238565.0000007 | E240=2-6-3 | H240==-IF(D240="*经营性应收调整",C240,0)=>0 | I240==-IF(D240="*经营性应付调整",C240,0)=>0 ROW 241 B241=减：本期利息资本化 | C241==-在建工程情况表!E24=>0 | E241=2-6-4 | H241==-IF(D241="*经营性应收调整",C241,0)=>0 | I241==-IF(D241="*经营性应付调整",C241,0)=>0 ROW 242 B242=加：预付账款购建长期资产款（期末-期初） | C242==+附注!E1224-附注!F1224=>0 | D242=*经营性应收调整 | E242=2-6-5 | G242=预付账款中与长期资产相关款项，须填列附表 | H242==-IF(D242="*经营性应收调整",C242,0)=>0 | I242==-IF(D242="*经营性应付调整",C242,0)=>0 ROW 243 B243=加：应付购建长期资产款（期初-期末） | C243==+附注!C1239-附注!B1239=>0 | D243=*经营性应付调整 | E243=2-6-6 | G243=应付账款中与长期资产相关款项，须填列附表 | H243==-IF(D243="*经营性应收调整",C243,0)=>0 | I243==-IF(D243="*经营性应付调整",C243,0)=>0 ROW 244 B244=加：其他非流动资产中预付长期资产款项（期末-期初） | C244==+附注!E364-附注!F364=>0 | E244=2-6-7 | H244==-IF(D244="*经营性应收调整",C244,0)=>0 | I244==-IF(D244="*经营性应付调整",C244,0)=>0 ROW 245 B245=加：长期应付款-分期付款（期末-期初） | C245==附注!D756-附注!C756=>0 | E245=2-6-8 | H245==-IF(D245="*经营性应收调整",C245,0)=>0 | I245==-IF(D245="*经营性应付调整",C245,0)=>0 ROW 246 B246=减：融资租赁租入长期资产 | C246==-(长期应付款明细!G23-长期应付款明细!H23)=>0 | E246=2-6-9 | H246==-IF(D246="*经营性应收调整",C246,0)=>0 | I246==-IF(D246="*经营性应付调整",C246,0)=>0 ROW 247 B247=加：其他应付款中设备及工程款变动 | C247==-(附注!$H$1244-附注!$I$1244)=>-4487800 | D247=*经营性应付调整 | E247=2-6-10 | H247==-IF(D247="*经营性应收调整",C247,0)=>0 | I247==-IF(D247="*经营性应付调整",C247,0)=>4487800 ROW 248 B248=使用权资产增加 | H248==-IF(D248="*经营性应收调整",C248,0)=>0 | I248==-IF(D248="*经营性应付调整",C248,0)=>0 ROW 249 H249==-IF(D249="*经营性应收调整",C249,0)=>0 | I249==-IF(D249="*经营性应付调整",C249,0)=>0 ROW 250 H250==-IF(D250="*经营性应收调整",C250,0)=>0 | I250==-IF(D250="*经营性应付调整",C250,0)=>0 ROW 251 B251=购建固定资产、无形资产和其他长期资产所支付的现金 | C251==SUM(C238:C250)=>254562975.00000072 | H251==-IF(D251="*经营性应收调整",C251,0)=>0 | I251==-IF(D251="*经营性应付调整",C251,0)=>0 | J251=原币试算折算参考值： === ASSET SHEET 数据源_CF小合并 dimension 172x15 === ROW 35 C35=合同资产-净额 | H35=0 ROW 36 B36=/ | C36=一年内到期的非流动资产 | E36=0 | G36=0 | H36=0 ROW 37 B37=BS0111 | C37=其他流动资产 | E37==[2]合并资产负债表!C10=>16483353.64 | F37==[2]合并资产负债表!E10=>15541263.57 | G37=942090.076400012 | H37=0 ROW 38 H38=0 ROW 39 C39=流动资产合计 | E39==[1]小合并!E39=>144823128.0264 | F39==[2]合并资产负债表!E12=>101152683.74 | H39=0 ROW 40 H40=0 ROW 41 C41=非流动资产 | H41=0 ROW 42 B42=/ | C42=长期应收款 | E42=0 | G42=0 | H42=0 ROW 43 B43=/ | C43=未确认融资收益 | E43=0 | G43=0 | H43=0 ROW 44 B44=/ | C44=长期应收款-减值准备 | E44=0 | G44=0 | H44=0 ROW 45 C45=长期应收款-净额 | E45=0 | F45=0 | H45=0 ROW 46 B46=BS0204 | C46=长期股权投资 | E46=0 | G46=0 | H46=0 ROW 47 B47=/ | C47=长期股权投资-减值准备 | E47=0 | G47=0 | H47=0 ROW 48 C48=长期股权投资-净额 | E48=0 | F48=0 | H48=0 ROW 49 B49=1601 | C49=固定资产 | E49=706674631.23 | F49=688113038.69 | G49==[1]小合并!G49=>18561592.5400001 | H49=6.70552253723145e-08 ROW 50 B50=1602 | C50=固定资产-累计折旧 | E50=160982600.28 | F50=111038508.82 | G50==[1]小合并!G50=>-49944091.46 | H50=0 ROW 51 B51=1603 | C51=固定资产减值准备 | E51=7502513.47 | F51=7502513.47 | G51=0 | H51=0 ROW 52 C52=固定资产净额 | E52==[2]合并资产负债表!C15=>538189517.48 | F52==[2]合并资产负债表!E15=>569572016.4 | H52=0 ROW 53 B53=1606 | C53=固定资产清理 | E53=0 | G53=0 | H53=0 ROW 54 B54=BS1604 | C54=在建工程 | E54==[2]合并资产负债表!C16=>12901289.37 | F54==[2]合并资产负债表!E16=>79870731.86 | G54==-[1]小合并!G54=>66969442.49 | H54=0 ROW 55 B55=/ | C55=在建工程-减值准备 | E55=0 | G55=0 | H55=0 ROW 56 C56=在建工程-净额 | E56==[2]合并资产负债表!C16=>12901289.37 | F56==[2]合并资产负债表!E16=>79870731.86 | H56=0 ROW 57 B57=1651 | C57=使用权资产 | E57=0 | G57=0 | H57=0 ROW 58 B58=1652 | C58=使用权资产累计折旧 | E58=0 | G58=0 | H58=0 ROW 59 C59=使用权资产-净额 | E59=0 | F59=0 | H59=0 ROW 60 B60=1701 | C60=无形资产 | E60=0 | G60=0 | H60=0 ROW 61 B61=1702 | C61=无形资产-累计摊销 | E61=0 | G61=0 | H61=0 ROW 62 B62=/ | C62=无形资产-减值准备 | E62=0 | G62=0 | H62=0 ROW 63 C63=无形资产-净额 | E63=0 | F63=0 | H63=0 ROW 64 B64=BS0213 | C64=开发支出 | E64=0 | G64=0 | H64=0 ROW 65 B65=/ | C65=商誉 | E65=0 | G65=0 | H65=0 ROW 66 B66=/ | C66=商誉-减值准备 | E66=0 | G66=0 | H66=0 ROW 67 C67=商誉-净额 | E67=0 | F67=0 | H67=0 ROW 68 B68=BS0215 | C68=长期待摊费用 | E68=0 | G68=0 | H68=0 ROW 69 B69=BS0216 | C69=递延所得税资产 | E69=0 | G69=0 | H69=0 ROW 70 B70=BS0217 | C70=其他非流动资产 | E70==[2]合并资产负债表!C17=>57208471.29 | F70==[2]合并资产负债表!E17=>54001897.78 | G70==[1]小合并!G70=>3206573.5036 | H70=-0.0063999961130321 ROW 71 H71=0 ROW 72 C72=非流动资产合计 | E72==[2]合并资产负债表!C19=>608299278.14 | F72==[2]合并资产负债表!E19=>703444646.04 | H72=0 ROW 73 H73=0 ROW 74 C74=资产合计 | E74==[2]合并资产负债表!C22=>753122406.16 | F74=804597329.7869 | H74=0 ROW 75 B75=Check | H75=0