某商业开发项目财务分析表(共18张)

1、精品资料推荐附表一（1）总成本费用估算表单位：万元序号施分12345678910生产负荷（%）201001001001001001001001001001外购原材料360.001800.001800.001800.001800.001800.001800.001800.001800.001800.002外购燃料动力10.0050.0050.0050.0050.0050.0050.0050.0050.0050.003工资及福利费14.0070.0070.0070.0070.0070.0070.0070.0070.0070.004修理费10.0010.0010.0010.0010.0010.001

2、0.0010.0010.0010.005折旧费205.80205.80205.80205.80205.80205.80205.80205.80205.80205.806摊销费7利息支出-14.00-52.618技术开发研究费9管理费8.0040.0040.0040.0040.0040.0040.0040.0040.0040.0010销售费11土地使用费11总成本费用607.802161.802123.192175.802175.802175.802175.802175.802175.802175.8011.1固定成本223.80255.80255.80255.80255.80255.80255

3、.80255.80255.80255.8011.2可变成本384.001906.001867.391920.001920.001920.001920.001920.001920.001920.0012经营成本402.001970.001970.001970.001970.001970.001970.001970.001970.001970.00序号项才、近份11121314151617181920合计生产负荷()1001001001001001001001001001001外购原材料1800.001800.001800.001800.001800.001800.001800.001800.00

4、1800.001800.0034560.002外购燃料动力50.0050.0050.0050.0050.0050.0050.0050.0050.0050.00960.003工资及福利费70.0070.0070.0070.0070.0070.0070.0070.0070.0070.001344.004修理费10.0010.0010.0010.0010.0010.0010.0010.0010.0010.00200.005折旧费205.80205.80205.80205.80205.80205.80205.80205.80205.80205.804116.006摊销费7利息支出-66.618技术开发

5、研究费9管理费40.0040.0040.0040.0040.0040.0040.0040.0040.0040.00768.0010销售费11土地使用费11总成本费用2175.802175.802175.802175.802175.802175.802175.802175.802175.802175.8041881.3911.1固定成本255.80255.80255.80255.80255.80255.80255.80255.80255.80255.805084.0011.2可变成本1920.001920.001920.001920.001920.001920.001920.001920.001

6、920.001920.0036797.3912经营成本1970.001970.001970.001970.001970.001970.001970.001970.001970.001970.0037832.00单位：万元附表一 (2)总成本费用估算表单位：万元附表二（1）序号年份12345678910生产负荷（）201001001001001001001001001001销售收入643.203216.003216.003216.003216.003216.003216.003216.003216.003216.002销售税金及附加35.38176.88176.88176.88176.88176

7、.88176.88176.88176.88176.883总成本费用607.802161.802123.192175.802175.802175.802175.802175.802175.802175.804利润总额0.02877.32915.93863.32863.32863.32863.32863.32863.32863.325弥补以前年度亏损6应纳所得税额0.02877.32915.93863.32863.32863.32863.32863.32863.32863.327所得税0.01289.51302.26284.90284.90284.90284.90284.90284.90284.9

8、08税后利润0.02587.80613.67578.42578.42578.42578.42578.42578.42578.429可供分配利润0.02587.80613.67578.42578.42578.42578.42578.42578.42578.4210盈余公积金0.0070.5473.6469.4169.4169.4169.4169.4169.4169.4111应付利润12未分配利润0.01517.26540.03509.01509.01509.01509.01509.01509.01509.0113累计未分配利润0.01517.281057.311566.332075.342584

9、.353093.373602.384111.394620.41单位：万元附表二（1）序号项？-一一步份11121314151617181920合计生产负荷（）1001001001001001001001001001001销售收入3216.003216.003216.003216.003216.003216.003216.003216.003216.003216.0061747.202销售税金及附加176.88176.88176.88176.88176.88176.88176.88176.88176.88176.883396.103总成本费用2175.802175.802175.802175.8

10、02175.802175.802175.802175.802175.802175.8041881.394利润总额863.32863.32863.32863.32863.32863.32863.32863.32863.32863.3216469.715弥补以前年度亏损6应纳所得税额863.32863.32863.32863.32863.32863.32863.32863.32863.32863.3216469.717所得税284.90284.90284.90284.90284.90284.90284.90284.90284.90284.905435.008税后利润578.42578.42578.

11、42578.42578.42578.42578.42578.42578.42578.4211034.719可供分配利润578.42578.42578.42578.42578.42578.42578.42578.42578.42578.4211034.7110盈余公积金69.4169.4169.4169.4169.4169.4169.4169.4169.4169.411324.1611应付利润12未分配利润509.01509.01509.01509.01509.01509.01509.01509.01509.01509.019710.5413累计未分配利润5129.425638.436147.4

12、56656.467165.477674.498183.508692.519201.539710.549710.54附表三（1）借款还本付息计算表单位：万元序号项、-壬分1234567891020合计生产负荷（）201001001001001001001001001001借款及还本付息1.1年初借款本息累计-205.81-773.70-979.511.1.1本金-205.81-773.70-979.511.1.2建设期利息1.2本年借款1.3本年应计利息-14.00-52.61-66.611.4本年还本205.81567.89-773.701.5本年付息-14.00-52.61-66.612偿还

13、能力205.81567.89583.82562.11562.11562.11562.11562.11562.116183.2010913.382.1未分配利润0.01362.09378.02356.31356.31356.31356.31356.31356.313919.404116.002.2折旧205.80205.80205.80205.80205.80205.80205.80205.80205.802263.804116.003本年节余资金1357.52562.11562.11562.11562.11562.11562.116183.2010913.384累计节余资金1357.52191

14、9.632481.743043.853605.964168.074730.1810913.3810913.38附表四（1）财务现金流量表（全部投资部分）单位:万元序号项m小份12345678910生产负荷（%）20100100100100100100100100100现金流入643.203216.003216.003216.003216.003216.003216.003216.003216.003216.001产品销售收入643.203216.003216.003216.003216.003216.003216.003216.003216.003216.002回收固定资产余值3回收流动资金现

15、金流出5721.062979.182449.142431.782431.782431.782431.782431.782431.782431.784固定资产投资5145.005流动资金138.68542.796经营成本402.001970.001970.001970.001970.001970.001970.001970.001970.001970.007销售税金及附加35.38176.88176.88176.88176.88176.88176.88176.88176.88176.888所得税0.01289.51302.26284.90284.90284.90284.90284.90284.9

16、0284.909所得税后净现金流量-5077.86236.82766.86784.22784.22784.22784.22784.22784.22784.2210所得税后累计净现金流量-5077.86-4841.05-4074.18-3289.96-2505.74-1721.51-937.29-153.06631.161415.3911所得税前净现金流量-5077.86526.331069.121069.121069.121069.121069.121069.121069.121069.1212所得税前累计净现金流量-5077.86-4551.53-3482.41-2413.29-1344.1

17、7-275.05794.071863.192932.314001.43附表四（2）财务现金流量表（全部投资部分）单位：万元序号项广一11121314151617181920合计生产负荷（）100100100100100100100100100100现金流入3216.003216.003216.003216.003216.003216.003216.003216.003216.004926.4763457.671产品销售收入3216.003216.003216.003216.003216.003216.003216.003216.003216.003216.0061747.202回收固定资产余值

18、1029.001029.003回收流动资金681.47681.47现金流出2431.782431.782431.782431.782431.782431.782431.782431.782431.782431.7852489.574固定资产投资5145.005流动资金681.476经营成本1970.001970.001970.001970.001970.001970.001970.001970.001970.001970.0037832.007销售税金及附加176.88176.88176.88176.88176.88176.88176.88176.88176.88176.883396.108所

19、得税284.90284.90284.90284.90284.90284.90284.90284.90284.90284.905435.009所得税后净现金流量784.22784.22784.22784.22784.22784.22784.22784.22784.222494.6910968.1010所得税后累计净现金流量2199.612983.843768.064552.285336.516120.736904.967689.188473.4110968.1010968.1011所得税前净现金流量1069.121069.121069.121069.121069.121069.121069.12

20、1069.121069.122779.5916403.1012所得税前累计净现金流量指标计算5070.556139.677208.79所得税后8277.919347.0310416.1511485.27所得税前12554.3913623.5116403.1016403.10FIRR13.10%18.81%FNPV（万元）1136.183319.53N（年）（静态）8.206.26附表五（1）资金来源与运用表单位：万元序号项一年份12345678910生产负荷（%）201001001001001001001001001001资金来源5489.501625.901121.731069.121069

21、.121069.121069.121069.121069.121069.121.1利润总额0.02877.32915.93863.32863.32863.32863.32863.32863.32863.321.2折旧费205.80205.80205.80205.80205.80205.80205.80205.80205.80205.801.4长期借款-14.00-52.611.5流动资金借款9.4336.911.7自有资金5274.25519.8752.611.9回收固定资产余值1.10回收流动资金2资金运用5489.501400.19-471.44284.90284.90284.90284.

22、90284.90284.90284.902.1固定资产投资5145.002.2建设期利息2.3流动资金138.68542.792.4所得税0.01289.51302.26284.90284.90284.90284.90284.90284.90284.902.5应付利润2.6长期借款本金偿还205.81567.89-773.702.7流动资金借款本金偿还2.8其他短期借款本金偿还3盈余资金0.01225.721593.17784.22784.22784.22784.22784.22784.22784.224累计盈余资金0.01225.721818.892603.123387.344171.564

23、955.795740.016524.247308.46序号城一目一.年份11121314151617181920合计生产负荷（）1001001001001001001001001001001资金来源1069.121069.121069.121069.121069.121069.121069.121069.121069.122779.5928122.651.1利润总额863.32863.32863.32863.32863.32863.32863.32863.32863.32863.3216469.711.2折旧费205.80205.80205.80205.80205.80205.80205.80

24、205.80205.80205.804116.001.4长期借款-66.611.5流动资金借款46.341.6其他短期借款1.7自有资金5846.741.9回收固定资产余值1029.001029.001.10回收流动资金681.47681.472资金运用284.90284.90284.90284.90284.90284.90284.90284.90284.90331.245481.342.1固定资产投资2.2建设期利息2.3流动资金2.4所得税284.90284.90284.90284.90284.90284.90284.90284.90284.90284.905435.002.5应付利润2.

25、6长期借款本金偿还2.7流动资金借款本金偿还46.3446.342.8其他短期借款本金偿还3盈余资金784.22784.22784.22784.22784.22784.22784.22784.22784.222448.3516814.844累计盈余资金8092.698876.919661.1410445.3611229.5812013.8112798.0313582.2614366.4816814.8416814.84单位：万元附表五（2）资金来源与运用表附表六投资计划与资金筹措表单位：万元序号项-年份1234567891020合计生产负荷（）2010010010010010010010010

26、01001总投资5283.68542.795826.471.1固定资产投资5145.005145.001.2建设期利息1.3流动资金138.68542.79681.472资金筹措5283.68542.795826.472.1自有资金5274.25519.8752.615846.742.1.1用于流动资金129.25505.88635.132.2借款9.4322.91-52.61-20.272.2.1长期借款（本金及建设期利息）-14.00-52.61-66.612.2.2流动资金借款9.4336.9146.342.2.3其他短期借款2.3其他序号项营一份周转次数1234567891020合计生

27、产负荷（）201001001001001001001001001001流动资产169.51835.64835.64835.64835.64835.64835.64835.64835.649192.0016046.601.1应收帐款7.652.89259.21259.21259.21259.21259.21259.21259.21259.212851.324977.891.2存货114.79567.26567.26567.26567.26567.26567.26567.26567.266239.8510892.701.2.1原材料7.647.37236.84236.84236.84236.842

28、36.84236.84236.84236.842605.264547.371.2.2燃料240.422.082.082.082.082.082.082.082.0822.9240.001.2.3在产品1233.50164.17164.17164.17164.17164.17164.17164.17164.171805.833152.671.2.4产成品1233.50164.17164.17164.17164.17164.17164.17164.17164.171805.833152.671.3现金121.839.179.179.179.179.179.179.179.17100.83176.0

29、02流动负债30.83154.17154.17154.17154.17154.17154.17154.17154.171695.832960.002.1应付帐款1230.83154.17154.17154.17154.17154.17154.17154.17154.171695.832960.003流动资金138.68681.47681.47681.47681.47681.47681.47681.47681.477496.1613086.604自有流动资金129.25505.88635.135流动资金本年度增加额138.68542.79681.476流动资金偿还7利息3.15单位：万元流动资金

30、估算表附表七附表八（1）资产负债表单位：万元序号3'廿一狼一份12345678910生产负荷（）201001001001001001001001001001资产9361.575299.386143.966722.387300.817879.238457.669036.089614.5110192.931.11.1.1流动资产总额167.691052.192645.363429.584213.814998.035782.266566.487350.718134.93应收帐款52.89259.21259.21259.21259.21259.21259.21259.21259.21259.2

31、11.1.2存货114.79567.26567.26567.26567.26567.26567.26567.26567.26567.261.1.3现金1.839.179.179.179.179.179.179.179.179.171.1.4累计盈余资金0.01225.721818.892603.123387.344171.564955.795740.016524.247308.461.2在建工程5283.68542.791.3固定资产净值3910.203704.403498.603292.803087.002881.202675.402469.602263.802058.002负债及所有者权益

32、2.1流动负债总额40.26191.08191.08191.08191.08191.08191.08191.08191.08191.082.1.1应付帐款30.83154.17154.17154.17154.17154.17154.17154.17154.17154.172.1.2流动资金借款9.4336.9136.9136.9136.9136.9136.9136.9136.9136.91负债小计40.26177.08138.47191.08191.08191.08191.08191.08191.08191.082.3所有者权益5274.276381.947048.221779.912358.

33、342936.763515.194093.614672.045250.462.3.1资本金5274.255794.125846.742.3.2资本公积金2.3.3累计盈余公积金0.0070.54144.18213.59283.00352.41421.82491.23560.64630.052.3.4累计未分配利润0.01517.281057.311566.332075.342584.353093.373602.384111.394620.41资产负债率（）0.433.342.252.842.622.432.262.111.991.87计算指标流动比率（）416.47550.671384.451

34、794.882205.302615.733026.153436.583847.004257.42速动比率（）131.39253.791087.581498.001908.432318.852729.283139.703550.123960.55序号3'L一_年份一11121314151617181920生产负荷（）1001001001001001001001001001001.00资产10771.3611349.7811928.2012506.6313085.0513663.4814241.9014820.3315398.7517641.301.101.1.1流动资产总额8919.16

35、9703.3810487.6011271.8312056.0512840.2813624.5014408.7315192.9517641.30应收帐款259.21259.21259.21259.21259.21259.21259.21259.21259.21259.211.1.2存货567.26567.26567.26567.26567.26567.26567.26567.26567.26567.261.1.3现金9.179.179.179.179.179.179.179.179.179.171.1.4累计盈余资金8092.698876.919661.1410445.3611229.58120

36、13.8112798.0313582.2614366.4816814.841.20在建工程1.30固定资产净值1852.201646.401440.601234.801029.00823.20617.40411.60205.800.002.00负债及所有者权益2.10流动负债总额191.08191.08191.08191.08191.08191.08191.08191.08191.08191.082.1.1应付帐款154.17154.17154.17154.17154.17154.17154.17154.17154.17154.172.1.2流动资金借款36.9136.9136.9136.9136.9136.9136.9136.9136.9136.91负债小计191.08191.08191.08191.08191.08191.08191.08191.08191.08191.