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

年)