现金流量表模板带公式自动计算

1、,资 产, 行次,期末-期初,资产, 行次,期末-期初,现金变动：,-1,128,056.42,调节表合计,-1,128,056.42 , 货币资金,1,-1,128,056.42,短期借款,46,666,666.67 ,一、经营活动产生的现金流量：, 短期投资,2,0.00,应付票据,47,0.00 ,销售商品、提供劳务收到的现金：,主营业务收入,122,472,989.87 ,124,999,006.99 , 应收票据,3,0.00,应付账款,48,201,058.00 ,应收票据,0.00, 应收账款,4,-19,217.12,预收账款,49,2,506,800.00 ,应收账款,19,

2、217.12, 预付账款,5,2,009,614.22,其他应付款,50,3,621,880.97 ,预收账款,2,506,800.00, 其他应收款,6,9,148,060.57,应付工资,51,0.00 , 存货,7,2,780,440.86,应付福利款,52,34,101.49 ,收到的其他与经营活动有关的现金：,3,621,880.97 , 待转其他业务支出,8,0.00,未交税金,53,-218,366.24 ,其他应收款,0.00, 待摊费用,9,0.00,未付利润,54,0.00 ,其他应付款,3,621,880.97, 待处理流动资产净损失,10,0.00,其他未交款,55,-

3、260.47 ,加：其他业务利润,0.00, 一年内到期的长期债券投资,11,0.00,预提费用,56,0.00 ,营业外收入,0.00 , 其他流动资产,12,0.00,一年内到期的长期负债,57,0.00 , 长期投资,13,0.00,其他流动负债,58,0.00 , 固定资产原价,14,1,818,657.70,长期借款,66,0.00 ,购买商品接受劳务支付的现金,减：主营业务成本,-113,789,584.54 ,-118,378,581.62 , 减：累计折旧,15,-545,855.73,应付债卷,67,0.00 ,应付账款,201,058.00 , 固定资产清理,16,0.00

4、,长期应付款,68,0.00 ,应付票据,0.00 , 在建工程,17,23,867.20,其他长期负债,75,0.00 ,预付账款,-2,009,614.22, 待处理固定资产净损失,18,0.00,实收资本,78,5,000,000.00 ,存货,-2,780,440.86, 无形资产,19,0.00,资本公积,79,0.00 , 递延资产,20,-86,805.30,盈余公积,80,50,177.06 , 其他长期资产,21,0.00,未分配利润：,80,-50,177.06,支付给职工以及为职工支付的现金, 应付工资,0.00 ,0.00 , 资产总计,45,14,000,705.98

5、,加：产品销售收入,122,472,989.87 ,减：商品销售成本,-113,789,584.54 ,减：经营费用,-4,240,300.95 ,支付的各项税费,应交税金,-218,366.24 ,-1,379,597.39 ,减：商品销售税金及附加,-82,892.42 ,其他应交款,-260.47 ,加：其他业务利润,0.00 ,主营业务税金及附加,-82,892.42 ,减：管理费用,0.00 ,减:所得税,-1,078,078.26 ,减：财务费用,-1,093,308.14 ,加：投资收益,0.00 ,加：营业外收入,0.00 ,支付的其他与经营活动有关的现金,减：营业费用,-4,

6、240,300.95 ,-12,721,599.00 ,减：营业外支出,0.00 ,管理费用,0.00 ,减：应交所得税,-1,078,078.26 ,其他应收款,-9148060.57,负债及所有者权益总计,90,14,000,705.98,其他应付款,0,减：营业外支出,0.00 ,待摊费用,0.00,应付福利费,34,101.49,减：累计折旧,545,855.73,预提费用,0.00 ,递延资产,86,805.30,二、投资活动现金流量,收回投资所收到的现金,长期投资,0.00 ,0.00 ,短期投资,0.00 ,取得投资收益所收到的现金,投资收益,0.00 ,0.00 ,处置固定资产

7、、无形资产和其他长期资产所收回的现金净额,固定资产清理,0.00,0.00,待处理固定资产净损失,0.00,收到的其他与投资活动有关的现金,购建固定资产、无形资产和其他长期资产所支付的现金,无形资产,0.00,-1,842,524.90,固定资产原值,-1,818,657.70,其他长期资产,0.00,在建工程,-23,867.20,投资所支付的现金,短期投资,0.00 ,0.00 ,长期投资,0.00 ,支付的其他与投资活动有关的现金,三、筹资活动现金流量,吸收投资所收到的现金,实收资本,5,000,000.00 ,5,000,000.00 ,取得借款所收到的现金,短期借款,666,666.67 ,666,666.6