流動資金估算表

1、流動資金估算表表2單位：萬元序號項目最低周轉天 數(shù)周轉次數(shù)計算期12345678910111流動資產0.04245.911247.114045.314045.314045.314045.314045.34045.3 14045.3 14045.31.1應收賬款30100.01360.03602.04497.04497.04497.04497.04497.04497.04497.04497.01.2存貨0.02180.05783.87224.87224.87224.87224.87224.87224.87224.87224.81.2.1原材料15200.0641.01709.02137.0213

2、7.02137.02137.02137.02137.02137.02137.01.2.2燃料30100.08.020.026.026.026.026.026.026.026.026.01.2.3在產品7430.0308.3816.61019.41019.41019.41019.41019.41019.41019.41019.41.2.4產成品28110.01222.63238.24042.44042.44042.44042.44042.44042.44042.44042.41.3現(xiàn)金30100.064.8151.8186.6186.6186.6186.6186.6186.6186.6186.6

3、1.4預付賬款15200.0641.11709.52136.82136.82136.82136.82136.82136.82136.82136.82流動負債0.01969.75240.46547.66547.66547.66547.66547.66547.66547.66547.62.1應付賬款30100.01289.83439.44299.34299.34299.34299.34299.34299.34299.34299.32.2預收賬款15200.0679.91801.02248.32248.32248.32248.32248.32248.32248.32248.33流動資金2276.16

4、006.77497.77497.77497.77497.77497.77497.77497.77497.74流動資金當期增加額2276373114910000000總成本估算表表-3單位：萬元序號項目名稱建設期建投期投產期達產期1234567891011生產負荷30%80%100%100%100%100%100%100%100%100%1材料費12821.034189.442736.842736.842736.842736.842736.842736.842736.842736.82燃料動力76.8204.8256.1256.1256.1256.1256.1256.1256.1256.13工資

5、及福利費308.3611.1732.3732.3732.3732.3732.3732.3732.3732.35修理費52.5107.8107.8107.8107.8107.8107.8107.8107.8107.86其他費用340.2907.21134.01134.01134.01134.01134.01134.01134.01134.06.1管理費用190.2507.2634.0634.0634.0634.0634.0634.0634.0634.06.2銷售費用150.0400.0500.0500.0500.0500.0500.0500.0500.0500.07經營成本13598.83602

6、0.444966.944966.944966.944966.944966.944966.944966.944966.98折舊費用104.9215.6215.6215.6215.6215.6215.6215.6215.6215.69攤銷費用117.5117.5117.5117.5117.5117.5117.5117.5117.5117.510利息支出11總成本費用13821.236353.545300.045300.045300.045300.045300.045300.045300.045300.0其中:固定成本333.4444.1444.1444.1444.1444.1444.1444.14

7、44.1444.1可變成本13487.835909.444855.944855.944855.944855.944855.944855.944855.944855.9外購材料費估算表表-3基1單位：萬元序號項目名稱合計建設期建投期投產期達產期1234567891011生產負荷0%30%80%100%100%100%100%100%100%100%100%1鋁塑復合板_174720.005760153601920019200192001920019200192001920019200單價（元/平方米）160.00160.00160.00160.00160.00160.00160.00160.00

8、160.00160.00160.00數(shù)量（萬平方米）109236_96_120-120-120-120_120_120_120_120_進項稅29702.40979.202611.203264.003264.003264.003264.003264.003264.003264.003264.002泡沫塑料139776.004608122881536015360153601536015360153601536015360單價（元/公斤）12 0012-12-12-12-12-12-12-12-12-12-數(shù)量（萬公斤）116483810241280128012801280128012801280

9、1280進項稅23761.92783.362088.962611.202611.202611.202611.202611.202611.202611.202611.203肋齊U26208.0086230428802880288028802880288028802880單價（元/公斤）8.008_8-8-8_8-8_8-8_8-8-數(shù)量（萬公斤）3276108-288-360_360_360_360-360-30-30-360_進項稅4455.36146.88391.68489.60489.60489.60489.60489.60489.60489.60489.604黏接劑樹脂8736.0028

10、8.00768.00960.00960.00960.00960.00960.00960.00960.00960.00單價（元/公斤）100.0010.0010.0010.0010.0010.0010.0010.0010.0010.0010.00數(shù)量（萬公斤）8728.876.896.096.096.096.096.096.096.096.0進項稅1485.1248.96130.56163.20163.20163.20163.20163.20163.20163.20163.205玻璃纖維網格布9434.88311.04829.441036.801036.801036.801036.801036.

11、801036.801036.801036.80單價（元/米）1.801_8_1_8_1_8_1_8_1_8_1_8_1_8_L_8_L_8_1_8_數(shù)量（萬米）5242173-46L576-576-576-576-576-576-576-576-進項稅1603.9352.88141.00176.26176.26176.26176.26176.26176.26176.26176.266包裝袋8190.00270.00720.00900.00900.00900.00900.00900.00900.00900.00900.00單價（元/平方米）7.5007777777777數(shù)量（萬平方米）10923

12、6-96-120-120-120-120-120-120-120-120-進項稅1392.3045.90122.40153.00153.00153.00153.00153.00153.00153.00153.007其他材料21840.00720.001920.002400.002400.002400.002400.002400.002400.002400.002400.00單價（元/平方米）20.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.00數(shù)量（萬平方米）1092.0036.0096.00120.00120.00120.00120.0

13、0120.00120.00120.00120.00進項稅3712.80122.40326.40408.00408.00408.00408.00408.00408.00408.00408.008外購原材料費合計388904.8812821.0434189.4442736.8042736.8042736.8042736.8042736.8042736.8042736.8042736.809進項稅額合計66113.832179.585812.207265.267265.267265.267265.267265.267265.267265.267265.26外購燃料及動力費估算表表-3基2單位：萬元序

14、號項目名稱合計建設期建投期投產期達產期1234567891011生產負荷0%30%80%100%100%100%100%100%100%100%100%1煤76425.267.284.084.084.084.084.084.084.084.0單價（元/平方米）0.700.70.70.70.70.70.70.70.70.70.7數(shù)量（萬平方米）1092.0036.096.0120.0120.0120.0120.0120.0120.0120.0120.0進項稅額1304.311.414.314.314.314.314.314.314.314.32電1520.0650.1133.6167.0167.

15、0167.0167.0167.0167.0167.0167.0單價（元/平方米）0.870.870.870.870.870.870.870.870.870.870.87數(shù)量（萬度）1747.2057.6153.6192.0192.0192.0192.0192.0192.0192.0192.0進項稅額258.418.522.728.428.428.428.428.428.428.428.43水1.54.05.05.05.05.05.05.05.05.0單價（元）3.03.03.03.03.03.03.03.03.03.0數(shù)量（萬噸）5010.013360.016700.016700.016700

16、.016700.016700.016700.016700.016700.0進項稅額0.30.70.90.90.90.90.90.90.90.94外購費用合計233076.8204.8256.1256.1256.1256.1256.1256.1256.1256.15外購燃料動力39613.134.843.543.543.543.543.543.543.543.5進項稅額合計工資及福利費估算表表-3基3單位：萬元序號項目名稱合計建設期建投期投產期達產期1234567891011生產負荷0%30%80%100%100%100%100%100%100%100%100%1普通工人工資額4835.3761

17、59.4425.1531.4531.4531.4531.4531.4531.4531.4531.4人均年工資1.441.441.441.441.441.441.441.441.441.44人數(shù)110.7295.2369.0369.0369.0369.0369.0369.0369.0369.02技術及管理人員工資額1110111.0111.0111.0111.0111.0111.0111.0111.0111.0111.0人均年工資3.003.003.003.003.003.003.003.003.003.00人數(shù)37.037.037.037.037.037.037.037.037.037.03工

18、資總額5945.376270.4536.1642.4642.4642.4642.4642.4642.4642.4642.44福利費832.437.975.189.989.989.989.989.989.989.989.95合計6777.7308.3611.1732.3732.3732.3732.3732.3732.3732.3732.3固定資產折舊估算表表-3基4單位:萬元序號項目名稱折舊年限合計生產期2345678910111房屋及建筑物201.1原值841.5505.53361.2當期折舊費384244040404040404040401.3凈值481.5777.5737.5697.565

19、7.5617.5577.5537.5497.5457.52設備102.1原值1685.5688.59972.2當期折舊費1506.365.4160.1160.1160.1160.1160.1160.1160.1160.1160.12.3凈值623.114601299.91139.8979.7819.6659.5499.4339.3179.23其它固定資產103.1原值1631633.2當期折舊費15515.515.515.515.515.515.515.515.515.515.53.3凈值147.5132116.510185.57054.53923.583固定資產合計3.1原值26901357

20、13333.2當期折舊費2045.3104.9215.6215.6215.6215.6215.6215.6215.6215.6215.63.3凈值148161252.12369.52153.91938.31722.71507.11291.51075.9860.3644.7無形資產及其他資產攤銷估算表表-3基5序號項目名稱攤銷年限合計生產期2345678910111無形資產101.1原值117511751.2當期攤銷費1175117.5117.5117.5117.5117.5117.5117.5117.5117.5117.51.3凈值1057.5940.0822.5705.0587.5470.0

21、352.5235.0117.50.02其他資產1002.1原值02.2當期攤銷費00.00.00.00.00.00.00.00.00.00.02.3凈值00.00.00.00.00.00.00.00.00.00.03合計03.1原值11751175.03.2當期攤銷費1175117.5117.5117.5117.5117.5117.5117.5117.5117.5117.53.3凈值1057.5940.0822.5705.0587.5470.0352.5235.0117.50.0產品銷售收入與稅金及附加表表-4單位：萬元表-4序號項目名稱合計建設期建投期投產期達產期1234567891011生

22、產負荷0%30%80%100%100%100%100%100%100%100%100%1銷售收入458640.0015120.040320.050400.050400.050400.050400.050400.050400.050400.050400.01.1浮雕保溫板313040.0010320.027520.034400.034400.034400.034400.034400.034400.034400.034400.0單價（元/平方米）430.0430.0430.0430.0430.0430.0430.0430.0430.0430.0430.0數(shù)量（萬平方米）72824.064.080.

23、080.080.080.080.080.080.080.0銷項稅額53216.801754.44678.45848.05848.05848.05848.05848.05848.05848.05848.01.2平面保溫板4800.012800.016000.016000.016000.016000.016000.016000.016000.016000.0單價（元/平方米）400.0400.0400.0400.0400.0400.0400.0400.0400.0400.0400.0數(shù)量（萬平方米）12.032.040.040.040.040.040.040.040.040.0銷項稅額816.02

24、176.02720.02720.02720.02720.02720.02720.02720.02720.02稅金及附加126041.5110.8138.5138.5138.5138.5138.5138.5138.5138.52.1營業(yè)稅02.2消費稅02.1城市維護建設稅80226.470.588.188.188.188.188.188.188.188.12.2教育費附加45915.140.350.450.450.450.450.450.450.450.43增值稅11459377.81007.41259.21259.21259.21259.21259.21259.21259.21259.2銷項

25、稅779692570.46854.48568.08568.08568.08568.08568.08568.08568.08568.0進項稅665102192.65847.07308.87308.87308.87308.87308.87308.87308.87308.8利潤與利潤分配表表-5序號項目名稱建設期建投期投產期達產期1234567891011生產負荷0%30%80%100%100%100%100%100%100%100%100%1產品銷售收入15120.040320.050400.050400.050400.050400.050400.050400.050400.050400.02稅金

26、及附加41.5110.8138.5138.5138.5138.5138.5138.5138.5138.53總成本費用13821.236353.545300.045300.045300.045300.045300.045300.045300.045300.04補貼收入5利潤總額1257.33855.74961.54961.54961.54961.54961.54961.54961.54961.56彌補以刖的年度虧損7應納稅所得額1257.33855.74961.54961.54961.54961.54961.54961.54961.54961.58所得稅314.0964.01240.01240.

27、01240.01240.01240.01240.01240.01240.09凈利潤943.32891.73721.53721.53721.53721.53721.53721.53721.53721.510期初未分配利潤11可供分配的利潤943.32891.73721.53721.53721.53721.53721.53721.53721.53721.512提取法定盈余公積金(10%)94.0289.0372.0372.0372.0372.0372.0372.0372.0372.013可供投資者分配的利潤849.32602.73349.53349.53349.53349.53349.53349.

28、53349.53349.514應付優(yōu)先股股利15提取任意盈余公積金42.5130.1167.5167.5167.5167.5167.5167.5167.5167.516應付普通股股利806.92472.53182.03182.03182.03182.03182.03182.03182.03182.017各投資方利潤分配：0.00.00.00.00.00.00.00.00.00.0其中：甲方乙方18未分配利潤806.92472.53182.03182.03182.03182.03182.03182.03182.03182.019息稅前利潤1257.33855.74961.54961.54961.

29、54961.54961.54961.54961.54961.520息稅折舊攤銷前利潤1479.74188.85294.65294.65294.65294.65294.65294.65294.65294.6項目投資現(xiàn)金流量表表-6財務內部收益率 財務凈現(xiàn)值(1=12%) 投資回收期稅前財務內部收益率 財務凈現(xiàn)值(1=12%) 投資回收期稅前53.8%16482萬元4.1 年稅后： 40.1%11159萬元4.7 年序號項目名稱建設期建投期投產期達產期1234567891011生產負荷0%30%80%100%100%100%100%100%100%100%100%1現(xiàn)金流入15120.040320

30、.050400.050400.050400.050400.050400.050400.050400.058542.71.1產品銷售收入15120.040320.050400.050400.050400.050400.050400.050400.050400.050400.01.2補貼收入1.3回收固定資產644.71.4回收流動資金7498.02現(xiàn)金流出2532.017249.339862.246596.445105.445105.445105.445105.445105.445105.445105.42.1建設投資2532.01333.02.2流動資金2276.03731.01491.02.

31、3經營成本13598.836020.444966.944966.944966.944966.944966.944966.944966.944966.92.4稅金及附加41.5110.8138.5138.5138.5138.5138.5138.5138.5138.52.5維持運營投資3稅前凈現(xiàn)金流量-2532.0-2129.3457.83803.65294.65294.65294.65294.65294.65294.613437.34稅前累計凈現(xiàn)金流量-2532-4661-4203-40048951018915484207782607331367448055調整所得稅03149641240124

32、01240124012401240124012406稅后凈現(xiàn)金流量-2532-2444-5062563405440544054405440544054121977稅后累計凈現(xiàn)金流量-2532-4976-5482-291911365190924413298173522140733604資產負債表表-7單位：萬元序號項目名稱建設期建設期投產期經營期12345678910111資產2532.09054.118947.525467.129188.632910.036631.540352.944074.447795.951517.31.1流動資產0.05411.515638.022490.726545.330599.834654.438708.942763.546818.150872.61.1.1貨幣資金0.064.8151.8186.6186.6186.6186.6186.6186.6186.6186.61.1.2應收帳款0.01360.03602.04497.04497.04497.04497.04497.04497.04497.04497.01.1.3預付帳款0.0641.11709.52136.82136.82136