电脑桌面
添加蚂蚁七词文库到电脑桌面
安装后可以在桌面快捷访问

金蝶EAS Cloud 现金流量表-表页_公式.xls

金蝶EAS Cloud 现金流量表-表页_公式.xls_第1页
1/3
金蝶EAS Cloud 现金流量表-表页_公式.xls_第2页
2/3
金蝶EAS Cloud 现金流量表-表页_公式.xls_第3页
3/3
项目本期金额一、经营活动产生的现金流量:销售商品、提供劳务收到的现金=ACCTCASH("CI1.01.01","S","",0,0,0,"")收到的税费返还=ACCTCASH("CI1.01.02","S","",0,0,0,"")收到其他与经营活动有关的现金=ACCTCASH("CI1.01.03","S","",0,0,0,"")经营活动现金流入小计=SUM(B3:B5)购买商品、接受劳务支付的现金=ACCTCASH("CI1.02.01","S","",0,0,0,"")支付给职工以及为职工支付的现金=ACCTCASH("CI1.02.02","S","",0,0,0,"")支付的各项税费=ACCTCASH("CI1.02.03","S","",0,0,0,"")支付其他与经营活动有关的现金=ACCTCASH("CI1.02.04","S","",0,0,0,"")经营活动现金流出小计=SUM(B7:B10)经营活动产生的现金流量净额=B6-B11二、投资活动产生的现金流量:收回投资收到的现金=ACCTCASH("CI2.01.01","S","",0,0,0,"")取得投资收益收到的现金=ACCTCASH("CI2.01.02","S","",0,0,0,"")处置固定资产、无形资产和其他长期资产收回的现金=ACCTCASH("CI2.01.03","S","",0,0,0,"")处置子公司及其他营业单位收到的现金净额=ACCTCASH("CI2.01.04","S","",0,0,0,"")收到其他与投资活动有关的现金=ACCTCASH("CI2.01.05","S","",0,0,0,"")投资活动现金流入小计=SUM(B14:B18)购建固定资产、无形资产和其他长期资产支付的现金=ACCTCASH("CI2.02.01","S","",0,0,0,"")投资支付的现金=ACCTCASH("CI2.02.02","S","",0,0,0,"")取得子公司及其他营业单位支付的现金净额=ACCTCASH("CI2.02.03","S","",0,0,0,"")支付其他与投资活动有关的现金=ACCTCASH("CI2.02.04","S","",0,0,0,"")投资活动现金流出小计=SUM(B20:B23)投资活动产生的现金流量净额=B19-B24三、筹资活动产生的现金流量:吸收投资收到的现金=ACCTCASH("CI3.01.01","S","",0,0,0,"")取得借款收到的现金=ACCTCASH("CI3.01.02","S","",0,0,0,"")收到其他与筹资活动有关的现金=ACCTCASH("CI3.01.03","S","",0,0,0,"")筹资活动现金流入小计=SUM(B27:B29)偿还债务支付的现金=ACCTCASH("CI3.02.01","S","",0,0,0,"")分配股利、利润或偿付利息支付的现金=ACCTCASH("CI3.02.02","S","",0,0,0,"")支付其他与筹资活动有关的现金=ACCTCASH("CI3.02.03","S","",0,0,0,"")筹资活动现金流出小计=SUM(B31:B33)筹资活动产生的现金流量净额=B30-B34四、汇率变动对现金及现金等价物的影响=ACCTCASH("CI4.01","S","",0,0,0,"")-ACCTCASH("C五、现金及现金等价物净增加额=B12+B25+B35+B36加:期初现金及现金等价物余额=ACCT("1001:1002","C","",0,0,0,"")六、期末现金及现金等价物余额=B37+B38上期金额本年累计=ACCTCASH("CI1.01.01","S","",0,-1,-1,"")=ACCTCASH("CI1.01.01","S","",0,1,0,"")=ACCTCASH("CI1.01.02","S","",0,-1,-1,"")=ACCTCASH("CI1.01.02","S","",0,1,0,"")=ACCTCASH("CI1.01.03","S","",0,-1,-1,"")=ACCTCASH("CI1.01.03","S","",0,1,0,"")=SUM(C3:C5)=SUM(D3:D5)=ACCTCASH("CI1.02.01","S","",0,-1,-1,"")=ACCTCASH("CI1.02.01","S","",0,1,0,"")=ACCTCASH("CI1.02.02","S","",0,-1,-1,"")=ACCTCASH("CI1.02.02","S","",0,1,0,"")=ACCTCASH("CI1.02.03","S","",0,-1,-1,"")=ACCTCASH("CI1.02.03","S","",0,1,0,"")=ACCTCASH("CI1.02.04","S","",0,-1,-1,"")=ACCTCASH("CI1.02.04","S","",0,1,0,"")=SUM(C7:C10)=SUM(D7:D10)=C6-C11=D6-D11=ACCTCASH("CI2.01.01","S","",0,-1,-1,"")=ACCTCASH("CI2.01.01","S","",0,1,0,"")=ACCTCASH("CI2.01.02","S","",0,-1,-1,"")=ACCTCASH("CI2.01.02","S","",0,1,0,"")=ACCTCASH("CI2.01.03","S","",0,-1,-1,"")=ACCTCASH("CI2.01.03","S","",0,1,0,"")=ACCTCASH("CI2.01.04","S","",0,-1,-1,"")=ACCTCASH("CI2.01.04","S","",0,1,0,"")=ACCTCASH("CI2.01.05","S","",0,-1,-1,"")=ACCTCASH("CI2.01.05","S","",0,1,0,"")=SUM(C14:C18)=SUM(D14:D18)=ACCTCASH("CI2.02.01","S","",0,-1,-1,"")=ACCTCASH("CI2.02.01","S","",0,1,0,"")=ACCTCASH("CI2.02.02","S","",0,-1,-1,"")=ACCTCASH("CI2.02.02","S","",0,1,0,"")=ACCTCASH("CI2.02.03","S","",0,-1,-1,"")=ACCTCASH("CI2.02.03","S","",0,1,0,"")=ACCTCASH("CI2.02.04","S","",0,-1,-1,"")=ACCTCASH("CI2.02.04","S","",0,1,0,"")=SUM(C20:C23)=SUM(D20:D23)=C19-C24=D19-D24=ACCTCASH("CI3.01.01","S","",0,-1,-1,"")=ACCTCASH("CI3.01.01","S","",0,1,0,"")=ACCTCASH("CI3.01.02","S","",0,-1,-1,"")=ACCTCASH("CI3.01.02","S","",0,1,0,"")=ACCTCASH("CI3.01.03","S","",0,-1,-1,"")=ACCTCASH("CI3.01.03","S","",0,1,0,"")=SUM(C27:C29)=SUM(D27:D29)=ACCTCASH("CI3.02.01","S","",0,-1,-1,"")=ACCTCASH("CI3.02.01","S","",0,1,0,"")=ACCTCASH("CI3.02.02","S","",0,-1,-1,"")=ACCTCASH("CI3.02.02","S","",0,1,0,"")=ACCTCASH("CI3.02.03","S","",0,-1,-1,"")=ACCTCASH("CI3.02.03","S","",0,1,0,"")=SUM(C31:C33)=SUM(D31:D33)=C30-C34=D30-D34=ACCTCASH("CI4.01","S","",0,-1,-1,"")-ACCTC=ACCTCASH("CI4.01","S","",0,-1,-1,"")-ACCTCASH("CI4.02","S","",0,1,0,"")=C12+C25+C35+C36=D12+D25+D35+D36=ACCT("1001:1002","C","",0,-1,-1,"")=ACCT("1001:1002","C","",0,1,1,"")=C37+C38=D37+D38.02","S","",0,1,0,"")

1、当您付费下载文档后,您只拥有了使用权限,并不意味着购买了版权,文档只能用于自身使用,不得用于其他商业用途(如 [转卖]进行直接盈利或[编辑后售卖]进行间接盈利)。
2、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。
3、如文档内容存在违规,或者侵犯商业秘密、侵犯著作权等,请点击“违规举报”。

碎片内容

金蝶EAS Cloud 现金流量表-表页_公式.xls

确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息
QQ群
  • 答案:my7c点击这里加入QQ群
支持邮箱
微信
  • 微信