ROW 29 A29:【☆ 现金流量表 D38-D47 按 8 资产并列 + 父项展开 sub-items】->【☆ 现金流量表 D38-D47 按 8 资产并列 + 父项展开 sub-items】 ROW 30 A30:数据源:试算表 / 附注 / 资产明细 / 现金流量表底稿 | 比较基准:现金流量表 D 列 | ★ = 主因不平段->数据源:试算表 / 附注 / 资产明细 / 现金流量表底稿 | 比较基准:现金流量表 D 列 | ★ = 主因不平段 ROW 31 A31:编号->编号 B31:项目->项目 C31:C 固定资产->C 固定资产 D31:D 在建工程->D 在建工程 E31:E 无形->E 无形 F31:F 长摊->F 长摊 G31:G 投房->G 投房 H31:H 使用权->H 使用权 I31:I 开发->I 开发 J31:J 其他/抵消->J 其他/抵消 K31:K 本表合计->K 本表合计 L31:L 现金流D列/底稿->L 现金流D列/底稿 M31:M 差异(K-L)->M 差异(K-L) N31:N ✓/✗->N ✓/✗ ROW 32 A32:D39->D39 B32:年初数->年初数 C32:=试算表!B54->569572016.4000001 D32:=试算表!B57->79870731.86 E32:=试算表!B70->0.0 F32:=试算表!B75->0.0 G32:=试算表!B42->0.0 H32:=试算表!B66->0.0 I32:=试算表!B71->0.0 J32:=N(附注!F364)->0.0 K32:=SUM(C32:J32)->649442748.2600001 L32:=现金流量表!D39->649442748.2600001 M32:=K32-L32->0.0 N32:=IF(ABS(M32)<0.001,"✓","✗")->✓ ROW 33 A33:D40->D40 B33:本年增加 ★->本年增加 ★ C33:=SUM(C34:C44)->40835095.9600007 D33:=SUM(D34:D44)->213727879.04 E33:=SUM(E34:E44)->0.0 F33:=SUM(F34:F44)->0.0 G33:=SUM(G34:G44)->0.0 H33:=SUM(H34:H44)->0.0 I33:=SUM(I34:I44)->0.0 J33:=SUM(J34:J44)->-56238565.0000007 K33:=SUM(C33:J33)->198324410.0 L33:=现金流量表!D40->198324410.0 M33:=K33-L33->0.0 N33:=IF(ABS(M33)<0.001,"✓","✗")->✓ ROW 34 A34: 2.1-> 2.1 B34: 本期购入-> 本期购入 C34:=固定资产!H7->8880530.96 D34:=在建工程情况表!D24-在建工程情况表!Q24->193931679.04 E34:=无形资产变动表!I7->0.0 F34:=长期待摊费用变动明细表!F17->0.0 G34:=投资性房地产!D8->0.0 H34:=0->0.0 I34:=0->0.0 J34:=0->0.0 K34:=SUM(C34:J34)->202812210.0 L34:=K34->202812210.0 M34:=K34-L34->0.0 N34:=IF(ABS(M34)<0.001,"✓","✗")->✓ ROW 35 A35: 2.2-> 2.2 B35: 开发支出-> 开发支出 C35:=0->0.0 D35:=0->0.0 E35:=0->0.0 F35:=0->0.0 G35:=0->0.0 H35:=0->0.0 I35:=附注!C1205->0.0 J35:=-附注!G1205->0.0 K35:=SUM(C35:J35)->0.0 L35:=K35->0.0 M35:=K35-L35->0.0 N35:=IF(ABS(M35)<0.001,"✓","✗")->✓ ROW 36 A36: 2.3-> 2.3 B36: 进项税 ★-> 进项税 ★ C36:=附注!C691->56238565.0000007 D36:=0->0.0 E36:=0->0.0 F36:=0->0.0 G36:=0->0.0 H36:=0->0.0 I36:=0->0.0 J36:=-附注!C691->-56238565.0000007 K36:=SUM(C36:J36)->0.0 L36:=K36->0.0 M36:=K36-L36->0.0 N36:=IF(ABS(M36)<0.001,"✓","✗")->✓ ROW 37 A37: 2.4-> 2.4 B37: 利息资本化-> 利息资本化 C37:=0->0.0 D37:=-在建工程情况表!E24->0.0 E37:=0->0.0 F37:=0->0.0 G37:=0->0.0 H37:=0->0.0 I37:=0->0.0 J37:=在建工程情况表!E24->0.0 K37:=SUM(C37:J37)->0.0 L37:=K37->0.0 M37:=K37-L37->0.0 N37:=IF(ABS(M37)<0.001,"✓","✗")->✓ ROW 38 A38: 2.5-> 2.5 B38: 预付账款变动-> 预付账款变动 C38:=N(附注!E1224)->0.0 D38:=-N(附注!F1224)->0.0 E38:=-N(附注!E1224)->0.0 F38:=N(附注!F1224)->0.0 G38:=0->0.0 H38:=0->0.0 I38:=0->0.0 J38:=0->0.0 K38:=SUM(C38:J38)->0.0 L38:=K38->0.0 M38:=K38-L38->0.0 N38:=IF(ABS(M38)<0.001,"✓","✗")->✓ ROW 39 A39: 2.6-> 2.6 B39: 应付购建变动-> 应付购建变动 C39:=N(附注!C1239)->0.0 D39:=-N(附注!B1239)->0.0 E39:=-N(附注!C1239)->0.0 F39:=N(附注!B1239)->0.0 G39:=0->0.0 H39:=0->0.0 I39:=0->0.0 J39:=0->0.0 K39:=SUM(C39:J39)->0.0 L39:=K39->0.0 M39:=K39-L39->0.0 N39:=IF(ABS(M39)<0.001,"✓","✗")->✓ ROW 40 A40: 2.7-> 2.7 B40: 其他非流动变动-> 其他非流动变动 C40:=0->0.0 D40:=0->0.0 E40:=0->0.0 F40:=0->0.0 G40:=0->0.0 H40:=0->0.0 I40:=N(附注!E364)->0.0 J40:=-N(附注!F364)->0.0 K40:=SUM(C40:J40)->0.0 L40:=K40->0.0 M40:=K40-L40->0.0 N40:=IF(ABS(M40)<0.001,"✓","✗")->✓ ROW 41 A41: 2.8-> 2.8 B41: 长期应付款变动-> 长期应付款变动 C41:=N(附注!D756)->0.0 D41:=-N(附注!C756)->0.0 E41:=0->0.0 F41:=0->0.0 G41:=0->0.0 H41:=0->0.0 I41:=0->0.0 J41:=0->0.0 K41:=SUM(C41:J41)->0.0 L41:=K41->0.0 M41:=K41-L41->0.0 N41:=IF(ABS(M41)<0.001,"✓","✗")->✓ ROW 42 A42: 2.9-> 2.9 B42: 融资租赁-> 融资租赁 C42:=0->0.0 D42:=0->0.0 E42:=0->0.0 F42:=0->0.0 G42:=0->0.0 H42:=-N(长期应付款明细!G23)->0.0 I42:=N(长期应付款明细!H23)->0.0 J42:=0->0.0 K42:=SUM(C42:J42)->0.0 L42:=K42->0.0 M42:=K42-L42->0.0 N42:=IF(ABS(M42)<0.001,"✓","✗")->✓ ROW 43 A43: 2.10-> 2.10 B43: 其他应付变动-> 其他应付变动 C43:=-附注!H1244->-24284000.0 D43:=附注!I1244->19796200.0 E43:=0->0.0 F43:=0->0.0 G43:=0->0.0 H43:=0->0.0 I43:=0->0.0 J43:=0->0.0 K43:=SUM(C43:J43)->-4487800.0 L43:=K43->-4487800.0 M43:=K43-L43->0.0 N43:=IF(ABS(M43)<0.001,"✓","✗")->✓ ROW 44 A44: 2.11-> 2.11 B44: 使用权增加 (不入D40)-> 使用权增加 (不入D40) C44:=0->0.0 D44:=0->0.0 E44:=0->0.0 F44:=0->0.0 G44:=0->0.0 H44:=N(现金流量表底稿!C248)->0.0 I44:=N(现金流量表底稿!C249)->0.0 J44:=N(现金流量表底稿!C250)->0.0 K44:=SUM(C44:J44)->0.0 L44:=K44->0.0 M44:=K44-L44->0.0 N44:=IF(ABS(M44)<0.001,"✓","✗")->✓ ROW 45 A45:D41->D41 B45:其他变动->其他变动 C45:=SUM(C46:C48)->0.0 D45:=SUM(D46:D48)->0.0 E45:=SUM(E46:E48)->0.0 F45:=SUM(F46:F48)->0.0 G45:=SUM(G46:G48)->0.0 H45:=SUM(H46:H48)->0.0 I45:=SUM(I46:I48)->0.0 J45:=SUM(J46:J48)->0.0 K45:=SUM(C45:J45)->0.0 L45:=N(现金流量表!D41)->0.0 M45:=K45-L45->0.0 N45:=IF(ABS(M45)<0.001,"✓","✗")->✓ ROW 46 A46: 3.1-> 3.1 B46: 其他增加-> 其他增加 C46:=固定资产!H53->0.0 D46:—->— E46:=无形资产变动表!I46->0.0 F46:—->— G46:=投资性房地产!D50->0.0 H46:='使用权资产 '!G9-'使用权资产 '!G23-'使用权资产 '!G36->0.0 I46:—->— J46:—->— K46:=SUM(C46:J46)->0.0 L46:=K46->0.0 M46:=K46-L46->0.0 N46:=IF(ABS(M46)<0.001,"✓","✗")->✓ ROW 47 A47: 3.2-> 3.2 B47: 其他减少-> 其他减少 C47:=-固定资产!H57->0.0 D47:—->— E47:=-无形资产变动表!I50->0.0 F47:—->— G47:=-投资性房地产!D54->0.0 H47:—->— I47:—->— J47:—->— K47:=SUM(C47:J47)->0.0 L47:=K47->0.0 M47:=K47-L47->0.0 N47:=IF(ABS(M47)<0.001,"✓","✗")->✓ ROW 48 A48: 3.3-> 3.3 B48: 综合调整(手工)-> 综合调整(手工) C48:=0->0.0 D48:=0->0.0 E48:=0->0.0 F48:=0->0.0 G48:=0->0.0 H48:=0->0.0 I48:=0->0.0 J48:=0->0.0 K48:=SUM(C48:J48)->0.0 L48:=K48->0.0 M48:=K48-L48->0.0 N48:=IF(ABS(M48)<0.001,"✓","✗")->✓ ROW 49 A49:D42->D42 B49:折旧摊销->折旧摊销 C49:=-固定资产!H30->-111393945.36 D49:=0->0.0 E49:=-无形资产变动表!I27->0.0 F49:=-长期待摊费用变动明细表!L17->0.0 G49:=-投资性房地产!D29->0.0 H49:=-'使用权资产 '!G21->0.0 I49:=0->0.0 J49:=0->0.0 K49:=SUM(C49:J49)->-111393945.36 L49:=现金流量表!D42->-111393945.36 M49:=K49-L49->0.0 N49:=IF(ABS(M49)<0.001,"✓","✗")->✓ ROW 50 A50:D43->D43 B50:本年减少 ★->本年减少 ★ C50:=SUM(C51:C55)->-148839667.39000008 D50:=SUM(D51:D55)->31013400.2300001 E50:=SUM(E51:E55)->0.0 F50:=SUM(F51:F55)->0.0 G50:=SUM(G51:G55)->0.0 H50:=SUM(H51:H55)->0.0 I50:=SUM(I51:I55)->-453601.92 J50:=SUM(J51:J55)->-71894501.37 K50:=SUM(C50:J50)->-190174370.45 L50:=现金流量表!D43->-190174370.44999993 M50:=K50-L50->0.0 N50:=IF(ABS(M50)<0.001,"✓","✗")->✓ ROW 51 A51: 5.1-> 5.1 B51: D23净值/其他非抵消项-> D23净值/其他非抵消项 C51:=-(固定资产!H15-固定资产!H37-固定资产!H54)->-189770206.04999998 D51:=-N(现金流量表底稿!C201)->49437.52 E51:=-(无形资产变动表!I15-无形资产变动表!I33-无形资产变动表!I47)->0.0 F51:=-N(现金流量表底稿!C193)->0.0 G51:=-(投资性房地产!D15-投资性房地产!D35-投资性房地产!D51)->0.0 H51:=-('使用权资产 '!G12-'使用权资产 '!G26)->0.0 I51:=-附注!C1051->-453601.92 J51:=-N(现金流量表底稿!C203)->0.0 K51:=SUM(C51:J51)->-190174370.44999996 L51:=K51->-190174370.44999996 M51:=K51-L51->0.0 N51:=IF(ABS(M51)<0.001,"✓","✗")->✓ ROW 52 A52: 5.2-> 5.2 B52: 处置损益/Y22抵消-> 处置损益/Y22抵消 C52:=-N(附注!C1029)->71894501.37 D52:=-N(附注!C1031)->0.0 E52:=-N(附注!C1030)->0.0 F52:=0->0.0 G52:=-N(附注!C1022)->0.0 H52:=0->0.0 I52:=0->0.0 J52:=试算表!Y22->-71894501.37 K52:=SUM(C52:J52)->0.0 L52:=K52->0.0 M52:=K52-L52->0.0 N52:=IF(ABS(M52)<0.001,"✓","✗")->✓ ROW 53 A53: 5.3-> 5.3 B53: 报废毁损/应收预收抵消-> 报废毁损/应收预收抵消 C53:=附注!C1067->147785.36 D53:=-附注!C1067->-147785.36 E53:=-N(现金流量表底稿!C198)->0.0 F53:=N(现金流量表底稿!C198)->0.0 G53:=-N(现金流量表底稿!C199)->0.0 H53:=N(现金流量表底稿!C199)->0.0 I53:=0->0.0 J53:=0->0.0 K53:=SUM(C53:J53)->0.0 L53:=K53->0.0 M53:=K53-L53->0.0 N53:=IF(ABS(M53)<0.001,"✓","✗")->✓ ROW 54 A54: 5.4-> 5.4 B54: 销项税抵消-> 销项税抵消 C54:=-附注!C689->-31111748.0700001 D54:=附注!C689->31111748.0700001 E54:=0->0.0 F54:=0->0.0 G54:=0->0.0 H54:=0->0.0 I54:=0->0.0 J54:=0->0.0 K54:=SUM(C54:J54)->0.0 L54:=K54->0.0 M54:=K54-L54->0.0 N54:=IF(ABS(M54)<0.001,"✓","✗")->✓ ROW 55 A55: 5.5-> 5.5 B55: 资产减值-> 资产减值 C55:=-N(资产减值明细表!C23)->0.0 D55:=-N(资产减值明细表!C24)->0.0 E55:=-N(资产减值明细表!C25)->0.0 F55:=0->0.0 G55:=0->0.0 H55:=0->0.0 I55:=0->0.0 J55:=0->0.0 K55:=SUM(C55:J55)->0.0 L55:=K55->0.0 M55:=K55-L55->0.0 N55:=IF(ABS(M55)<0.001,"✓","✗")->✓ ROW 56 A56:D44->D44 B56:年末数 ★->年末数 ★ C56:=N(C32)+N(C33)+N(C45)+N(C49)+N(C50)->350173499.6100007 D56:=N(D32)+N(D33)+N(D45)+N(D49)+N(D50)->324612011.13000005 E56:=N(E32)+N(E33)+N(E45)+N(E49)+N(E50)->0.0 F56:=N(F32)+N(F33)+N(F45)+N(F49)+N(F50)->0.0 G56:=N(G32)+N(G33)+N(G45)+N(G49)+N(G50)->0.0 H56:=N(H32)+N(H33)+N(H45)+N(H49)+N(H50)->0.0 I56:=N(I32)+N(I33)+N(I45)+N(I49)+N(I50)->-453601.92 J56:=N(J32)+N(J33)+N(J45)+N(J49)+N(J50)->-128133066.3700007 K56:=SUM(C56:J56)->546198842.45 L56:=现金流量表!D44->546198842.4500002 M56:=K56-L56->0.0 N56:=IF(ABS(M56)<0.001,"✓","✗")->✓ ROW 57 A57:D46->D46 B57:账面数->账面数 C57:=试算表!H54->538189517.48 D57:=试算表!H57->12901289.37 E57:=试算表!H70->0.0 F57:=试算表!H75->0.0 G57:=试算表!H42->0.0 H57:=试算表!H66->0.0 I57:=试算表!H71->0.0 J57:=N(附注!E364)->0.0 K57:=SUM(C57:J57)->551090806.85 L57:=现金流量表!D46->551090806.85 M57:=K57-L57->0.0 N57:=IF(ABS(M57)<0.001,"✓","✗")->✓ ROW 58 A58:D47->D47 B58:校验 ★->校验 ★ C58:=N(C56)-N(C57)->-188016017.8699993 D58:=N(D56)-N(D57)->311710721.76000005 E58:=N(E56)-N(E57)->0.0 F58:=N(F56)-N(F57)->0.0 G58:=N(G56)-N(G57)->0.0 H58:=N(H56)-N(H57)->0.0 I58:=N(I56)-N(I57)->-453601.92 J58:=N(J56)-N(J57)->-128133066.3700007 K58:=SUM(C58:J58)->-4891964.399999946 L58:=现金流量表!D47->-4891964.399999857 M58:=K58-L58->0.0 N58:=IF(ABS(M58)<0.001,"✓","✗")->✓