100万吨陶粒生产线项目可行性报告
- 格式:xls
- 大小:272.00 KB
- 文档页数:3
敏感性分析表
项目 年份1234
现金流入082501650016500
现金流出36984.585686.2047168547.3862587775.52551收入减少07012.51402514025
投资增加42532.2675686.2047168547.3862587775.52551
经营费用增加36984.586539.1354239829.4941968941.854337
收入减少比例15%
费用增加比例15%
净现金流量
正常情况-36984.582563.7952847952.6137428724.47449
收入减少-36984.581326.2952845477.6137426249.47449
投资增加-42532.2672563.7952847952.6137428724.47449
经营费用增加-36984.581710.8645776670.5058047558.145663
收入费用同时变化-42532.267473.3645774195.5058045083.145663
效益评价指标IRRNPVN
正常情况14.45%3595.326.03
收入减少6.55%-7399.548.39
投资增加11.17%-1357.986.83
经营费用增加10.66%-1906.956.67
收入费用同时变化-0.40%-17855.094.12
注:以上所得税后
注:以下所得税前
净现金流量-36984.582660.3806049474.5336510285.51634
(正常情况)-36984.58-34324.1994-24849.66575-14564.14941
IRRNPVN
18.82%10633.405.42
-36984.58-34420.78472-26468.17097-17743.69648
-36984.58-35658.28472-30180.67097-23931.19648
-42532.267-39968.47172-32015.85797-23291.38348
-36984.58-35273.71542-28603.20962-21045.06396
-42532.267-42058.90242-37863.39662-32780.25096敏感性分析表(附表十)
变化因素内部收益率累计净现值(万元)投资回收期(年)
基本方案14.45%3595.326.03
投资费用增加5%11.17%-1357.986.83
经营费用增加5%10.66%-1906.956.67
收入减少5%6.55%-7399.548.39
注:五年FNPV(万元)
基本方案0.00投资费用增加10%0.00
经营费用增加10%0.00
收入减少10%0.00 注:五年FIRR(%)
基本方案0.00%
投资费用增加10%0.00%
经营费用增加10%0.00%
收入减少10%0.00%5678910
165001650016500165001650020784.00907
7869.1664987964.3038998117.6480688220.0062428250.0285718250.028571
140251402514025140251402517666.40771
7869.1664987964.3038998117.6480688220.0062428250.0285718250.028571
9049.5414729158.9494849335.2952789453.0071799487.5328579487.532857
8630.8335028535.6961018382.3519328279.9937588249.97142912533.9805
6155.8335026060.6961015907.3519325804.9937585774.9714299416.379137
8630.8335028535.6961018382.3519328279.9937588249.97142912533.9805
7450.4585287341.0505167164.7047227046.9928217012.46714311296.47621
4975.4585284866.0505164689.7047224571.9928214537.4671438178.874851
5NPV5IRR
-14875.66-9.34%
-20601.14-19.67%
-19828.96-13.53%
-17879.19-14.37%
-28557.96-0.40%
10285.5163410285.5163410285.5163410285.5163410285.5163414569.5254
-4278.633076006.88326216292.399626577.9159336863.4322751432.95767
-9112.86298-577.166887805.18505216085.1788124335.1502436869.13074
-17775.363-11714.6669-5807.31495-2.321190225772.65023815189.02938
-14660.55-6124.853882257.49805210537.4918118787.4632431321.44374
-13594.6054-6253.55491911.14980997958.14263114970.6097726267.08599
-27804.7924-22938.7419-18249.0372-13677.0444-9139.57723-960.702375
年)