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

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

,,,,,,,會企01表

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

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

流動資產(chǎn)：,,,,流動負債：,,,

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

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

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

應收股利,4,,,預收帳款,71,,

應收利息,5,,,應付工資,72,"56,238.90","304,085.40"

應收帳款,6,"5,969,863.24","6,258,947.58",應付福利費,73,,

其他應收款,7,,,應付股利,74,,

預付帳款,8,,,應交稅金,75,,

應收補貼款,9,,,其他應交款,80,,

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

待攤費用,11,,,預提費用,82,,

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

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

,,,,其他流動負債,90,,

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

長期投資：,,,,長期負債：,,,

長期股權投資,32,,,長期借款,101,,

長期債權投資,34,,,應付債券,102,,

長期投資合計,38,0.00,0.00,長期應付款,103,,

固定資產(chǎn)：,,,,專項應付款,106,,

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

減：累計折舊,40,"1,051,454.88","1,061,548.99",長期負債合計,110,0.00,0.00

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

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

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

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

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

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

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

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

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

長期待攤費用,52,,,資本公積,118,"1,000,000.00","1,000,000.00"

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

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

遞延稅項：,,,,未分配利潤,121,"4,520,749.09","5,781,230.11"

遞延稅款借項,61,,,所有者權益（或股東權益）合計,122,"6,020,749.09","7,281,230.11"

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