工程經(jīng)濟(jì)學(xué)課程設(shè)計(jì)excel示例

財(cái)務(wù)現(xiàn)金流量表（全部投資）,,,,,,,,,,,,,,,,,,,單位：萬(wàn)元,

序號(hào),項(xiàng)目,建設(shè)期/年,,,投產(chǎn)期/年,,達(dá)到設(shè)計(jì)能力生產(chǎn)期/年,,,,,,,,,,,,,合計(jì)

,,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,

,生產(chǎn)負(fù)荷/%,,,,80,100,100,100,100,100,100,100,100,100,100,100,100,100,100,

1,現(xiàn)金流入,,,,58680,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,82576,1094806

1.1,產(chǎn)品銷售收入,,,,58680,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,1085580

1.2,"回收固定

資產(chǎn)余值",,,,,,,,,,,,,,,,,,4169,4169

1.3,回收流動(dòng)資金,,,,,,,,,,,,,,,,,,5057,5057

2,現(xiàn)金流出,15000,19950,14050,37139,40563,39552,39552,49539,49591,49591,49591,49591,49591,49651,49651,49651,49651,49651,751551

2.1,建設(shè)投資,15000,19950,14050,,,,,,,,,,,,,,,,

2.2,流動(dòng)資金,,,,4046,1011,,,,,,,,,,,,,,5057

2.3,經(jīng)營(yíng)成本,,,,27180,32160,32160,32160,32160,32160,32160,32160,32160,32160,32160,32160,32160,32160,32160,477420

2.4,"銷售稅金

及附加",,,,5913,7392,7392,7392,7392,7392,7392,7392,7392,7392,7392,7392,7392,7392,7392,109401

2.5,所得稅,,,,,,,,9987,10039,10039,10039,10039,10039,10099,10099,10099,10099,10099,110673

3,凈現(xiàn)金流量(1-2),-15000,-19950,-14050,21541,32787,33798,33798,23811,23759,23759,23759,23759,23759,23699,23699,23699,23699,32925,343255

4,"累計(jì)凈現(xiàn)金

流量",-15000,-34950,-49000,-27459,5328,39126,72924,96735,120495,144254,168014,191773,215532,239232,262931,286630,310330,343255,2370149

5,"所得稅前凈

現(xiàn)金流量",-15000,-19950,-14050,21541,32787,33798,33798,33798,33798,33798,33798,33798,33798,33798,33798,33798,33798,43024,453928

6,"所得稅前累計(jì)凈

現(xiàn)金流量",-15000,-34950,-49000,-27459,5328,39126,72924,106722,140520,174318,208116,241914,275712,309510,343308,377106,410904,453928,

,,,,,,,,,,,,,,,,,,,,,

"計(jì)算指標(biāo)：所得稅后所得稅前

財(cái)務(wù)內(nèi)部收益率

財(cái)務(wù)凈現(xiàn)值

投資回收期

",,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

流動(dòng)資金估算表單位：萬(wàn)元,,,,,,,,,,,,,,,,,,,,

序號(hào),項(xiàng)目,"最低

周轉(zhuǎn)天數(shù)","周轉(zhuǎn)

次數(shù)",投產(chǎn)期/年,達(dá)到設(shè)計(jì)能力生產(chǎn)期/年,,,,,,,,,,,,,,合計(jì),

,,,,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,,

1,流動(dòng)資產(chǎn),,,5374,6717,6717,6717,6717,6717,6717,6717,6717,6717,6717,6717,6717,6717,6717,,

1.1,應(yīng)收賬款,26,14,1620,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,2024,,

1.2,存貨,,,3720,4650,4650,4650,4650,4650,4650,4650,4650,4650,4650,4650,4650,4650,4650,,

1.3,現(xiàn)金,11,31,34,43,43,43,43,43,43,43,43,43,43,43,43,43,43,,

2,流動(dòng)負(fù)債,,,1328,1660,1660,1660,1660,1660,1660,1660,1660,1660,1660,1660,1660,1660,1660,,

2.1,應(yīng)付賬款,24,15,1328,1660,1660,1660,1660,1660,1660,1660,1660,1660,1660,1660,1660,1660,1660,,

3,"流動(dòng)資金

（1-2）",30,12,4046,5057,5057,5057,5057,5057,5057,5057,5057,5057,5057,5057,5057,5057,5057,,

4,"流動(dòng)資金

本年增加額",,,4046,1011,,,,,,,,,,,,,,,

外購(gòu)原材料及燃料動(dòng)力費(fèi)用估算表單位：元,,,,,,,,,,,,,,,,,,,,

序號(hào),名稱,規(guī)格,年消耗量,單位,單價(jià),"第2年

消耗金額",,"第5-18年

消耗金額",,,,,,,,,,,,

1,外購(gòu)原材料,,,,,,,,,,,,,,,,,,,

,甲,,81000,噸,1205,78084000,,97605000,,,,,,,,,,,,

,乙,,31500,噸,871,21949200,,27436500,,,,,,,,,,,,

,丙,,72000,噸,1002,57715200,,72144000,,,,,,,,,,,,

,丁,,19800,噸,1094,17328960,,21661200,,,,,,,,,,,,

,小計(jì),,,,,175077360,,218846700,,,,,,,,,,,,

2,外購(gòu)燃料動(dòng)力,,,,,,,,,,,,,,,,,,,

,水,,540000,m3,1.25,540000,,675000,,,,,,,,,,,,

,電,,2475000,度,1,1980000,,2475000,,,,,,,,,,,,

,煤,,90000,噸,300,21600000,,27000000,,,,,,,,,,,,

,小計(jì),,,,,24120000,,30150000,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

固定資產(chǎn)折舊估算表單位：萬(wàn)元,,,,,,,,,,,,,,,,,,,,

序號(hào),項(xiàng)目,合計(jì),折舊率,,達(dá)到設(shè)計(jì)能力生產(chǎn)期/年,,,,,,,,,,,,,,,

,,,,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,,

1,固定資產(chǎn)合計(jì),,,,,,,,,,,,,,,,,,,

1.1,原值,52111,6.13%,,,,,,,,,,,,,,,,,

1.2,折舊費(fèi),,,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,,

,凈值,,,48915,45719,42523,39327,36131,32935,29739,26543,23347,20151,16955,13759,10563,7367,4169,,

,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

無(wú)形及遞延資產(chǎn)攤銷估算表單位：萬(wàn)元,,,,,,,,,,,,,,,,,,,,

序號(hào),項(xiàng)目,原值,攤銷年限/年,達(dá)到設(shè)計(jì)能力生產(chǎn)期/年,,,,,,,,,,,,,,,,

,,,,4,5,6,7,8,9,10,11,12,13,,,,,,,

1,無(wú)形資產(chǎn),1820,10,,,,,,,,,,,,,,,,,

1.1,攤銷,,,182,182,182,182,182,182,182,182,182,182,,,,,,,

1.2,凈值,,,1638,1456,1274,1092,910,728,546,364,182,,,,,,,,

2,遞延資產(chǎn),780,5,,,,,,,,,,,,,,,,,

2.1,攤銷,,,156,156,156,156,156,,,,,,,,,,,,

2.2,凈值,,,624,468,312,156,,,,,,,,,,,,,

3,"無(wú)形及遞延

資產(chǎn)合計(jì)",2600,,,,,,,,,,,,,,,,,,

3.1,攤銷,,,338,338,338,338,338,182,182,182,182,182,,,,,,,

3.2,凈值,,,2262,1924,1586,1248,910,728,546,364,182,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

借款還本付息計(jì)算表,,,,,,,,,,,,,單位：萬(wàn)元,,,,,,,

序號(hào),項(xiàng)目,利率%,建設(shè)期/年,,,投產(chǎn)期/年,達(dá)到設(shè)計(jì)能力生產(chǎn)期/年,,,,,,,,,,,,,

,,,1,2,3,4,5,6,7,8,9,10,11,12,,,,,,

1,建行借款,6,,,,,,,,,,,,,,,,,,

1.1,"年初借款

本息累計(jì)",,,15450,21527,22818.62,24188,25639,9773,,,,,,,,,,,

1.1.1,本金,,,15000,20000,20000,20000,20000,9773,,,,,,,,,,,

1.1.2,建設(shè)期利息,,,450,1527,2819,,,,,,,,,,,,,,

1.2,本年借款,,15000,5000,,,,,,,,,,,,,,,,

1.3,本年應(yīng)計(jì)利息,,450,1077,1291.62,1369,1451,1538,586,,,,,,,,,,,

1.4,本年償還本金,,,,,,,15866,9773,,,,,,,,,,,

1.5,本年支付利息,,,,,,,1538,586,,,,,,,,,,,

2,工行借款,10,,,,,,,,,,,,,,,,,,

2.1,"年初借款

本息累計(jì)",,,,10500,17850,19635,3020,,,,,,,,,,,,

2.1.1,本金,,,,10000,16000,16000,3020,,,,,,,,,,,,

2.1.2,建設(shè)期利息,,,,500,1850,,,,,,,,,,,,,,

2.2,本年借款,,,10000,6000,,,,,,,,,,,,,,,

2.3,本年應(yīng)計(jì)利息,,,500,1350,1785,1964,302,,,,,,,,,,,,

2.4,本年償還本金,,,,,,16615,3020,,,,,,,,,,,,

2.5,本年支付利息,,,,,,1964,302,,,,,,,,,,,,

3,中行借款,8,,,,,,,,,,,,,,,,,,

3.1,"年初借款

本息累計(jì)",,,,5148,13932,1023,,,,,,,,,,,,,

3.1.1,本金,,,,4950,13000,1023,,,,,,,,,,,,,

3.1.2,建設(shè)期利息,,,,198,932,,,,,,,,,,,,,,

3.2,本年借款,,,4950,8050,,,,,,,,,,,,,,,

3.3,本年應(yīng)計(jì)利息,,,198,734,1115,82,,,,,,,,,,,,,

3.4,本年償還本金,,,,,12909,1023,,,,,,,,,,,,,

3.5,本年支付利息,,,,,1115,82,,,,,,,,,,,,,

4,"償還借款本金

的資金來(lái)源",,,,,,,,,,,,,,,,,,,

4.1,利潤(rùn),,,,,11129,16789,17832,18622,,,,,,,,,,,

4.2,折舊費(fèi)*80%,,,,,2556.8,2556.8,2556.8,2556.8,,,,,,,,,,,

4.3,攤銷費(fèi),,,,,338,338,338,338,,,,,,,,,,,

4.4,"償還本金

來(lái)源合計(jì)",,,,,14024,19683,20727,21517,,,,,,,,,,,

,"建設(shè)期利息

累計(jì)",5600,,,,,,,,,,,,,,,,,,

,借款累計(jì),49000,,,,,,,,,,,,,,,,,,

成本費(fèi)用估算表單位：萬(wàn)元,,,,,,,,,,,,,,,,,,,,

序號(hào),項(xiàng)目,合計(jì),投產(chǎn)期/年,達(dá)到設(shè)計(jì)能力生產(chǎn)期/年,,,,,,,,,,,,,,,,

,,,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,,,

,生產(chǎn)負(fù)荷%,,80,100,100,100,100,100,100,100,100,100,100,100,100,100,100,,,

1,外購(gòu)原材料,323898,17508,21885,21885,21885,21885,21885,21885,21885,21885,21885,21885,21885,21885,21885,21885,,,

2,"外購(gòu)燃料

動(dòng)力",44622,2412,3015,3015,3015,3015,3015,3015,3015,3015,3015,3015,3015,3015,3015,3015,,,

3,工資及福利,7500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,,,

4,修理費(fèi),23970,1598,1598,1598,1598,1598,1598,1598,1598,1598,1598,1598,1598,1598,1598,1598,,,

5,折舊費(fèi),47940,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,3196,,,

6,攤銷費(fèi),2600,338,338,338,338,338,182,182,182,182,182,,,,,,,,

7,制造費(fèi)用,60750,4050,4050,4050,4050,4050,4050,4050,4050,4050,4050,4050,4050,4050,4050,4050,,,

7,"財(cái)務(wù)費(fèi)用

（利息支出）",,4269,3497,1840,586,,,,,,,,,,,,,,

8,其他費(fèi)用,16680,1112,1112,1112,1112,1112,1112,1112,1112,1112,1112,1112,1112,1112,1112,1112,,,

9,總成本費(fèi)用,,34983,39191,37534,36280,35694,35538,35538,35538,35538,35538,35356,35356,35356,35356,35356,,,

,"其中：

固定成本",,6491,6740,6740,6740,6740,6584,6584,6584,6584,6584,6402,6402,6402,6402,6402,,,

,可變成本,,28492,32451,30794,29540,28954,28954,28954,28954,28954,28954,28954,28954,28954,28954,28954,,,

10,經(jīng)營(yíng)成本,,27180,32160,32160,32160,32160,32160,32160,32160,32160,32160,32160,32160,32160,32160,32160,,,

,,,,,,,,,,,,,,,,,,,,,

銷售收入和銷售稅金及附加估算表單位:萬(wàn)元,,,,,,,,,,,,,,,,,,,,

序號(hào),項(xiàng)目,單價(jià),生產(chǎn)負(fù)荷80%,,生產(chǎn)負(fù)荷100%,,,,,,,,,,,,,,,

,,,銷售量,金額,銷售量,金額,,,,,,,,,,,,,,

1,"產(chǎn)品銷售

收入",16300,36000,58680,45000,73350,,,,,,,,,,,,,,

2,"銷售稅金

及附加",,,5913,,7392,,,,,,,,,,,,,,

2.1,"產(chǎn)品

增值稅17%",,,5632,,7040,,,,,,,,,,,,,,

2.2,"城鄉(xiāng)維護(hù)

建設(shè)稅4%",,,225,,282,,,,,,,,,,,,,,

2.3,"教育

附加稅1%",,,56,,70,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

損益表單位：萬(wàn)元,,,,,,,,,,,,,,,,,,,,

序號(hào),項(xiàng)目,投產(chǎn)期/年,達(dá)到設(shè)計(jì)能力生產(chǎn)期/年,,,,,,,,,,,,,,,,,

,,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,,,,

,生產(chǎn)負(fù)荷/%,80,100,100,100,100,100,100,100,100,100,100,100,100,100,100,,,,

1,產(chǎn)品銷售收入,58680,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,73350,,,,

2,銷售稅金及附加,5913,7392,7392,7392,7392,7392,7392,7392,7392,7392,7392,7392,7392,7392,7392,,,,

3,總成本費(fèi)用,34983,39191,37534,36280,35694,35538,35538,35538,35538,35538,35356,35356,35356,35356,35356,,,,

4,利潤(rùn)總額,17784,26768,28424,29678,30264,30420,30420,30420,30420,30420,30602,30602,30602,30602,30602,,,,

5,"彌補(bǔ)前年度

虧損",,,,,,,,,,,,,,,,,,,

6,應(yīng)納所得稅額,,,,,30264,30420,30420,30420,30420,30420,30602,30602,30602,30602,30602,,,,

7,所得稅,,,,,9987,10039,10039,10039,10039,10039,10099,10099,10099,10099,10099,,,,

8,稅后利潤(rùn),17784,26768,28424,29678,20277,20381,20381,20381,20381,20381,20503,20503,2