现金流量表项目行次一、经营活动产生的现金流量：销售商品、提供劳务收到的现金1收到的税费返还2收到的其他与经营活动有关的现金3现金流入小计4购买商品、接受劳务支付的现金5支付给职工以及为职工支付的现金6支付的各项税费7支付的其他与经营活动有关的现金8现金流出小计9经营活动产生的现金流量净额10二、投资活动产生的现金流量：收回投资所收到的现金11取得投资收益所收到的现金1213收到的其他与投资活动有关的现金15现金流入小计16="单位名称："&SYSINFO("COMPANYNAME","")=RPTDATE("YYYY")&"年"&RPTDATE("MM")&"月"=ACCT("5601","SL","",0,0,0,"")+ACCT("5501","SL","",0,0,0,"")+ACCT("5502","SL","",0,0,0,"")+ACCT("5503","SL","",0,0,0,"")-ACCT("1502","DL","",0,0,0,"")-ACCT("1801","DL","",0,0,0,"")-ACCT("1901","DL","",0,0,0,"")-ACCT("2151","DL","",0,0,0,"")-ACCT("2153","DL","",0,0,0,"")-ACCT("2151","DL","",0,0,0,"")-ACCT("2153","DL","",0,0,0,"")+ACCT("1301","Y","",0,0,0,"")-ACCT("1301","C","",0,1,1,"")-ACCT("2181","Y","",0,0,0,"")+ACCT("2181","C","",0,1,1,"")-ACCT("2191","Y","",0,0,0,"")+ACCT("2191","C","",0,1,1,"")-ACCT("2211","Y","",0,0,0,"")+ACCT("2211","C","",0,1,1,"")=-ACCT("1101","Y","",0,0,0,"")+ACCT("1101","C","",0,1,1,"")-ACCT("1401","Y","",0,0,0,"")+ACCT("1401","C","",0,1,1,"")-ACCT("1402","Y","",0,0,0,"")+ACCT("1402","C","",0,1,1,"")处置固定资产、无形资产和其他长期资产所收回的现金净额17投资所支付的现金18支付的其他与投资活动有关的现金19现金流出小计20投资活动产生的现金流量净额21三、筹资活动产生的现金流量：吸收投资所收到的现金22取得借款收到的现金23收到的其他与筹资活动有关的现金24现金流入小计25偿还债务所支付的现金26分配股利、利润或偿付利息所支付的现金27支付的其他与筹资活动有关的现金28现金流出小计29筹资活动产生的现金流量净额30四、汇率变动对现金的影响31五、现金及现金等价物净增加额32加：期初现金及现金等价物余额33六、期末现金及现金等价物余额34补充资料现金流量表附表项目净利润35加：计提的资产减值准备36固定资产折旧37无形资产摊销38长期待摊费用摊销39待摊费用减少40预提费用增加4142固定资产报废损失43财务费用（减：收入）44购建固定资产、无形资产和其他长期资产所支付的现金=ACCT("1101","Y","",0,0,0,"")-ACCT("1101","C","",0,1,1,"")+ACCT("1401","Y","",0,0,0,"")-ACCT("1401","C","",0,1,1,"")+ACCT("1402","Y","",0,0,0,"")-ACCT("1402","C","",0,1,1,"")=ACCT("2101","Y","",0,0,0,"")-ACCT("2101","C","",0,1,1,"")+ACCT("2301","Y","",0,0,0,"")-ACCT("2301","C","",0,1,1,"")+ACCT("2311","Y","",0,0,0,"")-ACCT("2311","C","",0,1,1,"")+ACCT("2321","Y","",0,0,0,"")-ACCT("2321","C","",0,1,1,"")+ACCT("2331","Y","",0,0,0,"")-ACCT("2331","C","",0,1,1,"")=-ACCT("2101","Y","",0,0,0,"")+ACCT("2101","C","",0,1,1,"")-ACCT("2301","Y","",0,0,0,"")+ACCT("2301","C","",0,1,1,"")-ACCT("2311","Y","",0,0,0,"")+ACCT("2311","C","",0,1,1,"")-ACCT("2321","Y","",0,0,0,"")+ACCT("2321","C","",0,1,1,"")-ACCT("2331","Y","",0,0,0,"")+ACCT("2331","C","",0,1,1,"")1.将净利润调节为经营活动现金流量处理固定资产、无形资产和其他长期资产的损失（减：收益）投资损失（减：收益）45递延税款贷项46存货的减少（减：增加）47经营性应收项目的减少（减：增加）48经营性应付项目的增加（减：减少）49其他50经营活动产生的现金流量净额51债务转为资本52一年内到期的可转换公司债券53融资租入固定资产54现金的期末余额55减：现金的期初余额56加：现金等价物的期末余额57减：现金等价物的期初余额58现金及现金等价物的净增加额592.不涉及现金收支的投资和筹资活动3.现金及现金等价物净增加情况本年累计金额=E70-E6-E7+E14-E26-E36-E37=E6+E7+E8=ACCT("2151","JL","",0,0,0,"")+ACCT("2153","JL","",0,0,0,"")=ACCT("2171","JL","",0,0,0,"")=IF("D13>0",D13,0)=SUM(E10:E13)=E9-E14=IF("D17>0",D17,0)=ACCT("1701","DL","",0,0,0,"")=SUM(E17:E20)=ACCT("5101","SL","",0,0,0,"")*1.17+ACCT("5102","SL","",0,0,0,"")+ACCT("1131","C","",0,1,1,"")-ACCT("1131","Y","",0,0,0,"")+ACCT("1111","C","",0,1,1,"")-ACCT("1111","Y","",0,0,0,"")+ACCT("2131","Y","",0,0,0,"")-ACCT("2131","C","",0,1,1,"")=ACCT("5401","SL","",0,0,0,"")*1.17+ACCT("5405","SL","",0,0,0,"")+ACCT("2171","JF","",0,1,0,"")+ACCT("1201:1271","Y","",0,0,0,"")-ACCT("1201:1271","C","",0,1,1,"")+ACCT("4101","Y","",0,0,0,"")-ACCT("4101","C","",0,1,1,"")+ACCT("1291","Y","",0,0,0,"")-ACCT("1291","C","",0,1,1,"")-ACCT("1281","Y","",0,0,0,"")+ACCT("1281","C","",0,1,1,"")-ACCT("2141","Y","",0,0,0,"")+ACCT("2141","C","",0,1,1,"")+ACCT("4107","Y","",0,0,0,"")-ACCT("4107","C","",0,1,1,"")+ACCT("2111","C","",0,1,1,"")-ACCT("2111","Y","",0,0,0,"")+ACCT("2121","C","",0,1,1,"")-ACCT("2121","Y","",0,0,0,"")+ACCT("1151","Y","",0,0,0,"")-ACCT("1151","C","",0,1,1,"")=ACCT("5201","SL","",0,0,0,"")-ACCT("1121","Y","",0,0,0,"")+ACCT("1121","C","",0,1,1,"")-ACCT("1122","Y","",0,0,0,"")+ACCT("1122","C","",0,1,1,"")=IF("D23>0",D23,0)=SUM(E22:E24)=E21-E25=ACCT("3101","Y","",0,0,0,"")-ACCT("3101","C","",0,1,1,"")=IF("D29>0",D29,0)=SUM(E28:E30)=IF("D32>0",D32,0)=ACCT("2161","C","",0,1,1,"")-ACCT("2161","Y","",0,0,0,"")=SUM(E32:E34)=E31-E35=E15+E26+E36+E37=ACCT("3131","Y","",0,0,0,"")-ACCT("3131","C","",0,1,1,"")=ACCT("1502","DL","",0,0,0,"")=ACCT("1801","DL","",0,0,0,"")=ACCT("1901","DL","",0,0,0,"")=ACCT("1301","C","",0,1,1,"")-ACCT("1301","Y","",0,0,0,"")=ACCT("2191","Y","",0,0,0,"")-ACCT("2191","C","",0,1,1,"")=ACCT("5503","SL","",0,0,0,"")=ACCT("1501","Y","",0,0,0,"")-ACCT("1501","C","",0,1,1,"")+ACCT("1601","Y","",0,0,0,"")-ACCT("1601","C","",0,1,1,"")+ACCT("1603","Y","",0,0,0,"")-ACCT("1603","C","",0,1,1,"")+ACCT("1701","Y","",0,0,0,"")-ACCT("1701","C","",0,1,1,"")+ACCT("1801","Y","",0,0,0,"")-ACCT("1801","C","",0,1,1,"")+ACCT("1901","Y","",0,0,0,"")-ACCT("1901","C","",0,1,1,"")+ACCT("1801","DL","",0,0,0,"")+ACCT("1901","DL","",0,0,0,"")=ACCT("1001","C","",0,1,1,"")+ACCT("1002","C","",0,1,1,"")+ACCT("1009","C","",0,1,1,"")=ACCT("1001","Y","",0,0,0,"")+ACCT("1002","Y","",0,0,0,"")+ACCT("1009","Y","",0,0,0,"")=ACCT("1505","DL","",0,0,0,"")+ACCT("1605","DL","",0,0,0,"")+ACCT("1805","DL","",0,0,0,"")=-ACCT("5201","SL","",0,0,0,"")=ACCT("2341","Y","",0,0,0,"")-ACCT("2341","C","",0,1,1,"")=E15-SUM(E44:E58)=SUM(E44:E59)=E66-E67+E68-E69=-ACCT("1201:1271","Y","",0,0,0,"")+ACCT("1201:1271","C","",0,1,1,"")-ACCT("4101","Y","",0,0,0,"")+ACCT("4101","C","",0,1,1,"")-ACCT("1291","Y","",0,0,0,"")+ACCT("1291","C","",0,1,1,"")-ACCT("1281","Y","",0,0,0,"")+ACCT("1281","C","",0,1,1,"")-ACCT("2141","Y","",0,0,0,"")+ACCT("2141","C","",0,1,1,"")+ACCT("4107","Y","",0,0,0,"")-ACCT("4107","C","",0,1,1,"")=-ACCT("1111","Y","",0,0,0,"")+ACCT("1111","C","",0,1,1,"")-ACCT("1131","Y","",0,0,0,"")+ACCT("1131","C","",0,1,1,"")-ACCT("1133","Y","",0,0,0,"")+ACCT("1133","C","",0,1,1,"")-ACCT("1151","Y","",0,0,0,"")+ACCT("1151","C","",0,1,1,"")-ACCT("1301","Y","",0,0,0,"")-ACCT("1301","C","",0,1,1,"")=ACCT("2111","Y","",0,0,0,"")-ACCT("2111","C","",0,1,1,"")+ACCT("2121","Y","",0,0,0,"")-ACCT("2121","C","",0,1,1,"")+ACCT("2131","Y","",0,0,0,"")-ACCT("2131","C","",0,1,1,"")+ACCT("2151","Y","",0,0,0,"")-ACCT("2151","C","",0,1,1,"")+ACCT("2153","Y","",0,0,0,"")-ACCT("2153","C","",0,1,1,"")+ACCT("2171","Y","",0,0,0,"")-ACCT("2171","C","",0,1,1,"")+ACCT("2176","Y","",0,0,0,"")-ACCT("2176","C","",0,1,1,"")+ACCT("2181","Y","",0,0,0,"")-ACCT("2181","C","",0,1,1,"")=ACCT("1001","Y","",0,0,0,"")+ACCT("1002","Y","",0,0,0,"")+ACCT("1009","Y","",0,0,0,"")=ACCT("1001","C","",0,1,1,"")+ACCT("1002","C","",0,1,1,"")+ACCT("1009","C","",0,1,1,"")单位：元本期金额=F70-F6-F7+F14-F26-F36-F37=F6+F7+F8=ACCT("2151","JF","",0,0,0,"")+ACCT("2153","JF","",0,0,0,"")=ACCT("2171","JF","",0,0,0,"")=IF("G13>0",G13,0)=SUM(F10:F13)=F9-F14=IF("G17>0",G17,0)=ACCT("1701","DF","",0,0,0,"")=SUM(F17:F20)会企03表=ACCT("5101","SY","",0,0,0,"")*1.17+ACCT("5102","SY","",0,0,0,"")+ACCT("1131","C","",0,0,0,"")-ACCT("1131","Y","",0,0,0,"")+ACCT("1111","C","",0,0,0,"")-ACCT("1111","Y","",0,0,0,"")+ACCT("2131","Y","",0,0,0,"")-ACCT("2131","C","",0,0,0,"")=ACCT("5401","SY","",0,0,0,"")*1.17+ACCT("5405","SY","",0,0,0,"")+ACCT("2171","JF","",0,0,0,"")+ACCT("1201:1271","Y","",0,0,0,"")-ACCT("1201:1271","C","",0,0,0,"")+ACCT("4101","Y","",0,0,0,"")-ACCT("4101","C","",0,0,0,"")+ACCT("1291","Y","",0,0,0,"")-ACCT("1291","C","",0,0,0,"")-ACCT("1281","Y","",0,0,0,"")+ACCT("1281","C","",0,0,0,"")-ACCT("2141","Y","",0,0,0,"")+ACCT("2141","C","",0,0,0,"")+ACCT("4107","Y","",0,0,0,"")-ACCT("4107","C","",0,0,0,"")+ACCT("2111","C","",0,0,0,"")-ACCT("2111","Y","",0,0,0,"")+ACCT("2121","C","",0,0,0,"")-ACCT("2121","Y","",0,0,0,"")+ACCT("1151","Y","",0,0,0,"")-ACCT("1151","C","",0,0,0,"")=ACCT("5201","SY","",0,0,0,"")-ACCT("1121","Y","",0,0,0,"")+ACCT("1121","C","",0,0,0,"")-ACCT("1122","Y","",0,0,0,"")+ACCT("1122","C","",0,0,0,"")=IF("G23>0",G23,0)=SUM(F22:F24)=F21-F25=ACCT("3101","Y","",0,0,0,"")-ACCT("3101","C","",0,0,0,"")=IF("G29>0",G29,0)=SUM(F28:F30)=IF("G32>0",G32,0)=ACCT("2161","C","",0,0,0,"")-ACCT("2161","Y","",0,0,0,"")=SUM(F32:F34)=F31-F35=F15+F26+F36+F37=ACCT("3131","Y","",0,0,0,"")-ACCT("3131","C","",0,0,0,"")=ACCT("1502","DF","",0,0,0,"")=ACCT("1801","DF","",0,0,0,"")=ACCT("1901","DF","",0,0,0,"")=ACCT("1301","C","",0,0,0,"")-ACCT("1301","Y","",0,0,0,"")=ACCT("2191","Y","",0,0,0,"")-ACCT("2191","C","",0,0,0,"")=ACCT("5503","SY","",0,0,0,"")=ACCT("1501","Y","",0,0,0,"")-ACCT("1501","C","",0,0,0,"")+ACCT("1601","Y","",0,0,0,"")-ACCT("1601","C","",0,0,0,"")+ACCT("1603","Y","",0,0,0,"")-ACCT("1603","C","",0,0,0,"")+ACCT("1701","Y","",0,0,0,"")-ACCT("1701","C","",0,0,0,"")+ACCT("1801","Y","",0,0,0,"")-ACCT("1801","C","",0,0,0,"")+ACCT("1901","Y","",0,0,0,"")-ACCT("1901","C","",0,0,0,"")+ACCT("1801","DF","",0,0,0,"")+ACCT("1901","DF","",0,0,0,"")=ACCT("1001","C","",0,0,0,"")+ACCT("1002","C","",0,0,0,"")+ACCT("1009","C","",0,0,0,"")=ACCT("1001","Y","",0,0,0,"")+ACCT("1002","Y","",0,0,0,"")+ACCT("1009","Y","",0,0,0,"")=ACCT("1505","DF","",0,0,0,"")+ACCT("1605","DF","",0,0,0,"")+ACCT("1805","DF","",0,0,0,"")=-ACCT("5201","SY","",0,0,0,"")=ACCT("2341","Y","",0,0,0,"")-ACCT("2341","C","",0,0,0,"")=F15-SUM(F44:F58)=SUM(F44:F59)=F66-F67+F68-F69=-ACCT("1201:1271","Y","",0,0,0,"")+ACCT("1201:1271","C","",0,0,0,"")-ACCT("4101","Y","",0,0,0,"")+ACCT("4101","C","",0,0,0,"")-ACCT("1291","Y","",0,0,0,"")+ACCT("1291","C","",0,0,0,"")-ACCT("1281","Y","",0,0,0,"")+ACCT("1281","C","",0,0,0,"")-ACCT("2141","Y","",0,0,0,"")+ACCT("2141","C","",0,0,0,"")+ACCT("4107","Y","",0,0,0,"")-ACCT("4107","C","",0,0,0,"")=-ACCT("1111","Y","",0,0,0,"")+ACCT("1111","C","",0,0,0,"")-ACCT("1131","Y","",0,0,0,"")+ACCT("1131","C","",0,0,0,"")-ACCT("1133","Y","",0,0,0,"")+ACCT("1133","C","",0,0,0,"")-ACCT("1151","Y","",0,0,0,"")+ACCT("1151","C","",0,0,0,"")-ACCT("1301","Y","",0,0,0,"")-ACCT("1301","C","",0,0,0,"")=ACCT("2111","Y","",0,0,0,"")-ACCT("2111","C","",0,0,0,"")+ACCT("2121","Y","",0,0,0,"")-ACCT("2121","C","",0,0,0,"")+ACCT("2131","Y","",0,0,0,"")-ACCT("2131","C","",0,0,0,"")+ACCT("2151","Y","",0,0,0,"")-ACCT("2151","C","",0,0,0,"")+ACCT("2153","Y","",0,0,0,"")-ACCT("2153","C","",0,0,0,"")+ACCT("2171","Y","",0,0,0,"")-ACCT("2171","C","",0,0,0,"")+ACCT("2176","Y","",0,0,0,"")-ACCT("2176","C","",0,0,0,"")+ACCT("2181","Y","",0,0,0,"")-ACCT("2181","C","",0,0,0,"")=ACCT("1001","Y","",0,0,0,"")+ACCT("1002","Y","",0,0,0,"")+ACCT("1009","Y","",0,0,0,"")=ACCT("1001","C","",0,0,0,"")+ACCT("1002","C","",0,0,0,"")+ACCT("1009","C","",0,0,0,"")=ACCT("5601","SY","",0,0,0,"")+ACCT("5501","SY","",0,0,0,"")+ACCT("5502","SY","",0,0,0,"")+ACCT("5503","SY","",0,0,0,"")-ACCT("1502","DF","",0,0,0,"")-ACCT("1801","DF","",0,0,0,"")-ACCT("1901","DF","",0,0,0,"")-ACCT("2151","DF","",0,0,0,"")-ACCT("2153","DF","",0,0,0,"")-ACCT("2151","DF","",0,0,0,"")-ACCT("2153","DF","",0,0,0,"")+ACCT("1301","Y","",0,0,0,"")-ACCT("1301","C","",0,0,0,"")-ACCT("2181","Y","",0,0,0,"")+ACCT("2181","C","",0,0,0,"")-ACCT("2191","Y","",0,0,0,"")+ACCT("2191","C","",0,0,0,"")-ACCT("2211","Y","",0,0,0,"")+ACCT("2211","C","",0,0,0,"")=-ACCT("1101","Y","",0,0,0,"")+ACCT("1101","C","",0,0,0,"")-ACCT("1401","Y","",0,0,0,"")+ACCT("1401","C","",0,0,0,"")-ACCT("1402","Y","",0,0,0,"")+ACCT("1402","C","",0,0,0,"")=ACCT("1101","Y","",0,0,0,"")-ACCT("1101","C","",0,0,0,"")+ACCT("1401","Y","",0,0,0,"")-ACCT("1401","C","",0,0,0,"")+ACCT("1402","Y","",0,0,0,"")-ACCT("1402","C","",0,0,0,"")=ACCT("2101","Y","",0,0,0,"")-ACCT("2101","C","",0,0,0,"")+ACCT("2301","Y","",0,0,0,"")-ACCT("2301","C","",0,0,0,"")+ACCT("2311","Y","",0,0,0,"")-ACCT("2311","C","",0,0,0,"")+ACCT("2321","Y","",0,0,0,"")-ACCT("2321","C","",0,0,0,"")+ACCT("2331","Y","",0,0,0,"")-ACCT("2331","C","",0,0,0,"")=-ACCT("2101","Y","",0,0,0,"")+ACCT("2101","C","",0,0,0,"")-ACCT("2301","Y","",0,0,0,"")+ACCT("2301","C","",0,0,0,"")-ACCT("2311","Y","",0,0,0,"")+ACCT("2311","C","",0,0,0,"")-ACCT("2321","Y","",0,0,0,"")+ACCT("2321","C","",0,0,0,"")-ACCT("2331","Y","",0,0,0,"")+ACCT("2331","C","",0,0,0,"")
