輸入資產(chǎn)負(fù)債表和利潤表可自動(dòng)生成現(xiàn)金流量表xls

資產(chǎn)負(fù)債表,,,,,,,

,,,,,,,會(huì)企01表

編制單位：萊蕪市鋼城區(qū)宏達(dá)機(jī)械廠,,,2011年12月,,,,單位：元

資產(chǎn),行次,年初數(shù),期末數(shù),負(fù)債及所有者權(quán)益,行次,年初數(shù),期末數(shù)

流動(dòng)資產(chǎn)：,,,,流動(dòng)負(fù)債：,,,

貨幣資金,1,"398,675.20","499,745.20",短期借款,68,,

短期投資,2,,,應(yīng)付票據(jù),69,,

應(yīng)收票據(jù),3,,,應(yīng)付帳款,70,"2,969,286.36","6,105,874.35"

應(yīng)收股利,4,,,預(yù)收帳款,71,,

應(yīng)收利息,5,,,應(yīng)付工資,72,"56,238.90","304,085.40"

應(yīng)收帳款,6,"5,969,863.24","6,258,947.58",應(yīng)付福利費(fèi),73,,

其他應(yīng)收款,7,,,應(yīng)付股利,74,,

預(yù)付帳款,8,,,應(yīng)交稅金,75,,

應(yīng)收補(bǔ)貼款,9,,,其他應(yīng)交款,80,,

存貨,10,"317,685.56","418,259.77",其他應(yīng)付款,81,"4,741,625.92","5,105,874.32"

待攤費(fèi)用,11,,,預(yù)提費(fèi)用,82,,

一年內(nèi)到期的長期債券投資,21,,,預(yù)計(jì)負(fù)債,83,,

其他流動(dòng)資產(chǎn),24,,,一年內(nèi)到期的長期負(fù)債,86,,

,,,,其他流動(dòng)負(fù)債,90,,

流動(dòng)資產(chǎn)合計(jì),31,"6,686,224.00","7,176,952.55",流動(dòng)負(fù)債合計(jì),100,"7,767,151.18","11,515,834.07"

長期投資：,,,,長期負(fù)債：,,,

長期股權(quán)投資,32,,,長期借款,101,,

長期債權(quán)投資,34,,,應(yīng)付債券,102,,

長期投資合計(jì),38,0.00,0.00,長期應(yīng)付款,103,,

固定資產(chǎn)：,,,,專項(xiàng)應(yīng)付款,106,,

固定資產(chǎn)原價(jià),39,"8,153,131.15","12,681,660.62",其他長期負(fù)債,108,,

減：累計(jì)折舊,40,"1,051,454.88","1,061,548.99",長期負(fù)債合計(jì),110,0.00,0.00

固定資產(chǎn)凈值,41,"7,101,676.27","11,620,111.63",遞延稅項(xiàng)：,,,

減：固定資產(chǎn)減值準(zhǔn)備,42,,,遞延稅項(xiàng)貸項(xiàng),111,,

固定資產(chǎn)凈額,43,"7,101,676.27","11,620,111.63",負(fù)債總計(jì),114,"7,767,151.18","11,515,834.07"

工程物資,44,,,少數(shù)股東權(quán)益,,,

在建工程,45,,,,,,

固定資產(chǎn)清理,46,,,所有者權(quán)益（或股東權(quán)益）：,,,

固定資產(chǎn)合計(jì),50,"7,101,676.27","11,620,111.63",實(shí)收資本（或股本）,115,"500,000.00","500,000.00"

無形資產(chǎn)及其他資產(chǎn)：,,,,減：已歸還投資,116,,

無形資產(chǎn),51,,,實(shí)收資本（或股本）凈額,117,"500,000.00","500,000.00"

長期待攤費(fèi)用,52,,,資本公積,118,"1,000,000.00","1,000,000.00"

其他長期資產(chǎn),53,,,盈余公積,119,,

無形資產(chǎn)及其他資產(chǎn)合計(jì),60,0.00,0.00,其中：法定公益金,120,,

遞延稅項(xiàng)：,,,,未分配利潤,121,"4,520,749.09","5,781,230.11"

遞延稅款借項(xiàng),61,,,所有者權(quán)益（或股東權(quán)益）合計(jì),122,"6,020,749.09","7,281,230.11"

資產(chǎn)總計(jì),67,"13,787,900.27","18,797,064.18",負(fù)債和所有者權(quán)益（或股東權(quán)益）總計(jì),135