現(xiàn)金流量表模板帶公式自動(dòng)計(jì)算

1、,資 產(chǎn), 行次,期末-期初,資產(chǎn), 行次,期末-期初,現(xiàn)金變動(dòng)：,-1,128,056.42,調(diào)節(jié)表合計(jì),-1,128,056.42 , 貨幣資金,1,-1,128,056.42,短期借款,46,666,666.67 ,一、經(jīng)營(yíng)活動(dòng)產(chǎn)生的現(xiàn)金流量：, 短期投資,2,0.00,應(yīng)付票據(jù),47,0.00 ,銷售商品、提供勞務(wù)收到的現(xiàn)金：,主營(yíng)業(yè)務(wù)收入,122,472,989.87 ,124,999,006.99 , 應(yīng)收票據(jù),3,0.00,應(yīng)付賬款,48,201,058.00 ,應(yīng)收票據(jù),0.00, 應(yīng)收賬款,4,-19,217.12,預(yù)收賬款,49,2,506,800.00 ,應(yīng)收賬款,19,

2、217.12, 預(yù)付賬款,5,2,009,614.22,其他應(yīng)付款,50,3,621,880.97 ,預(yù)收賬款,2,506,800.00, 其他應(yīng)收款,6,9,148,060.57,應(yīng)付工資,51,0.00 , 存貨,7,2,780,440.86,應(yīng)付福利款,52,34,101.49 ,收到的其他與經(jīng)營(yíng)活動(dòng)有關(guān)的現(xiàn)金：,3,621,880.97 , 待轉(zhuǎn)其他業(yè)務(wù)支出,8,0.00,未交稅金,53,-218,366.24 ,其他應(yīng)收款,0.00, 待攤費(fèi)用,9,0.00,未付利潤(rùn),54,0.00 ,其他應(yīng)付款,3,621,880.97, 待處理流動(dòng)資產(chǎn)凈損失,10,0.00,其他未交款,55,-

3、260.47 ,加：其他業(yè)務(wù)利潤(rùn),0.00, 一年內(nèi)到期的長(zhǎng)期債券投資,11,0.00,預(yù)提費(fèi)用,56,0.00 ,營(yíng)業(yè)外收入,0.00 , 其他流動(dòng)資產(chǎn),12,0.00,一年內(nèi)到期的長(zhǎng)期負(fù)債,57,0.00 , 長(zhǎng)期投資,13,0.00,其他流動(dòng)負(fù)債,58,0.00 , 固定資產(chǎn)原價(jià),14,1,818,657.70,長(zhǎng)期借款,66,0.00 ,購(gòu)買商品接受勞務(wù)支付的現(xiàn)金,減：主營(yíng)業(yè)務(wù)成本,-113,789,584.54 ,-118,378,581.62 , 減：累計(jì)折舊,15,-545,855.73,應(yīng)付債卷,67,0.00 ,應(yīng)付賬款,201,058.00 , 固定資產(chǎn)清理,16,0.00

4、,長(zhǎng)期應(yīng)付款,68,0.00 ,應(yīng)付票據(jù),0.00 , 在建工程,17,23,867.20,其他長(zhǎng)期負(fù)債,75,0.00 ,預(yù)付賬款,-2,009,614.22, 待處理固定資產(chǎn)凈損失,18,0.00,實(shí)收資本,78,5,000,000.00 ,存貨,-2,780,440.86, 無(wú)形資產(chǎn),19,0.00,資本公積,79,0.00 , 遞延資產(chǎn),20,-86,805.30,盈余公積,80,50,177.06 , 其他長(zhǎng)期資產(chǎn),21,0.00,未分配利潤(rùn)：,80,-50,177.06,支付給職工以及為職工支付的現(xiàn)金, 應(yīng)付工資,0.00 ,0.00 , 資產(chǎn)總計(jì),45,14,000,705.98

5、,加：產(chǎn)品銷售收入,122,472,989.87 ,減：商品銷售成本,-113,789,584.54 ,減：經(jīng)營(yíng)費(fèi)用,-4,240,300.95 ,支付的各項(xiàng)稅費(fèi),應(yīng)交稅金,-218,366.24 ,-1,379,597.39 ,減：商品銷售稅金及附加,-82,892.42 ,其他應(yīng)交款,-260.47 ,加：其他業(yè)務(wù)利潤(rùn),0.00 ,主營(yíng)業(yè)務(wù)稅金及附加,-82,892.42 ,減：管理費(fèi)用,0.00 ,減:所得稅,-1,078,078.26 ,減：財(cái)務(wù)費(fèi)用,-1,093,308.14 ,加：投資收益,0.00 ,加：營(yíng)業(yè)外收入,0.00 ,支付的其他與經(jīng)營(yíng)活動(dòng)有關(guān)的現(xiàn)金,減：營(yíng)業(yè)費(fèi)用,-4,

6、240,300.95 ,-12,721,599.00 ,減：營(yíng)業(yè)外支出,0.00 ,管理費(fèi)用,0.00 ,減：應(yīng)交所得稅,-1,078,078.26 ,其他應(yīng)收款,-9148060.57,負(fù)債及所有者權(quán)益總計(jì),90,14,000,705.98,其他應(yīng)付款,0,減：營(yíng)業(yè)外支出,0.00 ,待攤費(fèi)用,0.00,應(yīng)付福利費(fèi),34,101.49,減：累計(jì)折舊,545,855.73,預(yù)提費(fèi)用,0.00 ,遞延資產(chǎn),86,805.30,二、投資活動(dòng)現(xiàn)金流量,收回投資所收到的現(xiàn)金,長(zhǎng)期投資,0.00 ,0.00 ,短期投資,0.00 ,取得投資收益所收到的現(xiàn)金,投資收益,0.00 ,0.00 ,處置固定資產(chǎn)

7、、無(wú)形資產(chǎn)和其他長(zhǎng)期資產(chǎn)所收回的現(xiàn)金凈額,固定資產(chǎn)清理,0.00,0.00,待處理固定資產(chǎn)凈損失,0.00,收到的其他與投資活動(dòng)有關(guān)的現(xiàn)金,購(gòu)建固定資產(chǎn)、無(wú)形資產(chǎn)和其他長(zhǎng)期資產(chǎn)所支付的現(xiàn)金,無(wú)形資產(chǎn),0.00,-1,842,524.90,固定資產(chǎn)原值,-1,818,657.70,其他長(zhǎng)期資產(chǎn),0.00,在建工程,-23,867.20,投資所支付的現(xiàn)金,短期投資,0.00 ,0.00 ,長(zhǎng)期投資,0.00 ,支付的其他與投資活動(dòng)有關(guān)的現(xiàn)金,三、籌資活動(dòng)現(xiàn)金流量,吸收投資所收到的現(xiàn)金,實(shí)收資本,5,000,000.00 ,5,000,000.00 ,取得借款所收到的現(xiàn)金,短期借款,666,666.67 ,666,666.6