单位:万元
投产期 | 达产期 | ||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | |
生产负荷(%) | 0 | 70 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
一、现金流入 | 0 | 12306 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 |
(一)产品销售收入 | 0 | 12306 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 |
(二)回收固定资产余值 | |||||||||||
(三)回收流动资金 | |||||||||||
二、现金流出 | 5261.65 | 14114.65 | 15963.78 | 14163.78 | 14163.78 | 14163.78 | 14163.78 | 14163.78 | 14163.78 | 14934.29 | 14934.29 |
(一)固定资产投资 | 5261.65 | ||||||||||
(二)流动资金 | 4200 | 1800 | |||||||||
(三)经营成本 | 8333.77 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | |
(四)销售税金及附加 | 0 | 1580.88 | 2258.4 | 2258.4 | 2258.4 | 2258.4 | 2258.4 | 2258.4 | 2258.4 | 2258.4 | 2258.4 |
(五)所得税 | 0 | 770.51 | 770.51 | ||||||||
三、全部投资净现金流量 | -5261.65 | -1808.65 | 1616.22 | 3416.22 | 3416.22 | 3416.22 | 3416.22 | 3416.22 | 3416.22 | 25.71 | 25.71 |
六、累计增量净现金流量 | -5261.65 | -7070.3 | -5454.08 | -2037.86 | 1378.36 | 4794.58 | 8210.8 | 11627.02 | 15043.24 | 17688.95 | 20334.66 |
内部收益率计算表 | |||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | |
净现金流 | -5261.65 | -1808.65 | 1616.22 | 3416.22 | 3416.22 | 3416.22 | 3416.22 | 3416.22 | 3416.22 | 25.71 | 25.71 |
折现系数=0.10 | 0.909090909 | 0.8246281 | 0.751314801 | 0.683013455 | 0.620921323 | 0.547393 | 0.513158118 | 0.46650738 | 0.424097618 | 0.3855432 | 0.3504939 |
净现值(万元) | -4783.318182 | -1494.752066 | 1214.290008 | 2333.324226 | 2121.203842 | 1928.367129 | 1753.061027 | 1593.691842 | 1448.810766 | 1020.035736 | 927.3052148 |
累计净现值(万元) | -4783.318182 | -6278.070248 | -5063.78024 | -2730.456014 | -609.2521717 | 1319.114958 | 3072.175984 | 4665.867827 | 6114.678593 | 7134.714329 | 8062.019544 |
折现系数 | 0.766995934 | 0.588282762 | 0.451210487 | 0.346076609 | 0.265439352 | 0.203590903 | 0.156153395 | 0.119769019 | 0.091862351 | 0.070458049 | 0.054041037 |
净现值(万元) | -4035.6155 | -1063.997618 | 729.2554128 | 1182.273832 | 906.7992215 | 695.5113156 | 533.4543509 | 409.157318 | 313.8219992 | 186.4115657 | 142.9769129 |
累计净现值(万元) | -4035.6155 | -5099.661773 | -4370.40636 | -3188.132529 | -2281.333307 | -1585.821992 | -1052.3671 | -3.2103227 | -329.3883235 | -142.976758 | 0.000155109 |
内部收益率= | 0.303787877 |
项目财务现金流量表
单位:万元
建设期 | 投产期 | 达产期 | |||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | |
生产负荷(%) | 0 | 70 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
一、现金流入 | 0 | 12306 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 |
(一)产品销售收入 | 0 | 12306 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 | 17580 |
(二)回收固定资产余值 | |||||||||||
(三)回收流动资金 | |||||||||||
二、现金流出 | 5261.65 | 14654.01 | 16734.29 | 14934.29 | 14934.29 | 14934.29 | 14934.29 | 14934.29 | 14934.29 | 14934.29 | 14934.29 |
(一)固定资产投资 | 5261.65 | ||||||||||
(二)流动资金 | 4200 | 1800 | |||||||||
(三)经营成本 | 8333.77 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | 11905.38 | |
(四)销售税金及附加 | 0 | 1580.88 | 2258.4 | 2258.4 | 2258.4 | 2258.4 | 2258.4 | 2258.4 | 2258.4 | 2258.4 | 2258.4 |
(五)所得税 | 0 | 539.36 | 770.51 | 770.51 | 770.51 | 770.51 | 770.51 | 770.51 | 770.51 | 770.51 | 770.51 |
三、全部投资净现金流量 | -5261.65 | -2348.01 | 845.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 |
六、累计增量净现金流量 | 0 | -7070.3 | -5454.08 | -2037.86 | 1378.36 | 4794.58 | 8210.8 | 11627.02 | 15043.24 | 18459.46 | 21875.68 |
内部收益率计算表 | |||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | |
净现金流 | -5261.65 | -2348.01 | 845.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 |
折现系数=0.10 | 0.9090909 | 0.82463 | 0.7513148 | 0.6830135 | 0.6209213 | 0.54739 | 0.5131581 | 0.4665074 | 0.4240976 | 0.3855433 | 0.3504939 |
净现值(万元) | -4783.3182 | -1940.5041 | 635.39444 | 1807.0555 | 12.7778 | 1493.4343 | 1357.6676 | 1234.2432 | 1122.0393 | 1020.0357 | 927.30521 |
累计净现值(万元) | 0.9090909 | -6722.0868 | -6085.941 | -4278.2025 | -2634.8038 | -1140.805 | 217.37571 | 1452.0855 | 2574.54 | 3594.9701 | 4522.6259 |
折现系数 | 0.8239845 | 0.67505 | 0.5594447 | 0.4609738 | 0.3798353 | 0.3129784 | 0.25783 | 0.2124968 | 0.1750941 | 0.1442748 | 0.1188802 |
净现值(万元) | -4335.5182 | -1594.1825 | 473.12797 | 1219.6029 | 1004.9339 | 828.05 | 682.30038 | 562.20496 | 463.24818 | 381.70933 | 314.52258 |
累计净现值(万元) | 0.8239845 | -5928.1978 | -5454.5104 | -4234.4465 | -3229.1327 | -2400.7697 | -1718.2114 | -1155.794 | -692.37072 | -310.51712 | 4.1243443 |
内部收益率= | 0.213615 |