金蝶K3现金流量表公式模板.xls
- 文档编号:904954
- 上传时间:2023-04-30
- 格式:XLS
- 页数:3
- 大小:30KB
金蝶K3现金流量表公式模板.xls
《金蝶K3现金流量表公式模板.xls》由会员分享,可在线阅读,更多相关《金蝶K3现金流量表公式模板.xls(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(CI4.02,S,0,0,0,)五五、现现金金及及现现金金等等价价物物净净增增加加额额=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,)-ACCTCASH(CI4.02,S,0,-1,-1,)=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=ACCTCASH(CI4.01,S,0,-1,-1,)-ACCTCASH(CI4.02,S,0,1,0,)
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 金蝶 K3 现金流 量表 公式 模板