财务管理财务分析财务表格与估算管理知识分析.docx

1、财务管理财务分析财务表格与估算管理知识分析 财务管理财务分析财务表格与估算管理知识分析投资分析专用！流动资金估算表表2单位：万元序号项目最低周转天数周转次数计算期12345678910111流动资产0.04245.911247.114045.314045.314045.314045.314045.314045.314045.314045.31.1应收账款30100.01360.03602.04497.04497.04497.04497.04497.04497.04497.04497.01.2存货0.02180.05783.87224.87224.87224.87224.87224.87224.

2、87224.87224.81.2.1原材料15200.0641.01709.02137.02137.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现金30100.06

3、4.8151.8186.6186.6186.6186.6186.6186.6186.6186.61.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.3

4、2248.32248.32248.32248.32248.32248.33流动资金2276.16006.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.8

5、204.8256.1256.1256.1256.1256.1256.1256.1256.13工资及福利费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

6、.0500.0500.0500.0500.0500.0500.07经营成本13598.836020.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

7、其中:固定成本333.4444.1444.1444.1444.1444.1444.1444.1444.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单价（元/平方米）1

8、60.00160.00160.00160.00160.00160.00160.00160.00160.00160.00160.00数量（万平方米）10923696120120120120120120120120进项税29702.40979.202611.203264.003264.003264.003264.003264.003264.003264.003264.002泡沫塑料139776.004608122881536015360153601536015360153601536015360单价（元/公斤）12.0012121212121212121212数量（万公斤）116483841024

9、12801280128012801280128012801280进项税23761.92783.362088.962611.202611.202611.202611.202611.202611.202611.202611.203助剂26208.00864230428802880288028802880288028802880单价（元/公斤）8.008888888888数量（万公斤）3276108288360360360360360360360360进项税4455.36146.88391.68489.60489.60489.60489.60489.60489.60489.60489.604黏接剂树

10、脂8736.00288.00768.00960.00960.00960.00960.00960.00960.00960.00960.00单价（元/公斤）100.0010.0010.0010.0010.0010.0010.0010.0010.0010.0010.00数量（万公斤）87428.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.801

11、036.801036.801036.801036.801036.80单价（元/米）1.801.81.81.81.81.81.81.81.81.81.8数量（万米）5242173461576576576576576576576576进项税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.5007.57.57.57.57.57.57.57.57.57.5数

12、量（万平方米）10923696120120120120120120120120进项税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数量（万平方米）1092.0036.0096.00120.00120.00120.00120

13、.00120.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数量(万平方米）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.016

15、7.0167.0167.0167.0167.0167.0167.0单价（元/平方米）0.870.870.870.870.870.870.870.870.870.870.87数量(万度）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数量(万吨）5010.013360.016700.016700.0167

16、00.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.37

17、6159.4425.1531.4531.4531.4531.4531.4531.4531.4531.4人均年工资1.441.441.441.441.441.441.441.441.441.44人数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人数37.037.037.037.037.037.037.037.037.037.0

18、3工资总额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.5

19、657.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原值269013

20、5713333.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.0352.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净值