建筑工程预算自动速算公式表格（EXCEL带自动计算公式）-单因素敏感分析

1、敏敏感感度度分分析析一一（销销售售收收入入变变化化的的影影响响)销销售售收收入入变变化化率率-15%-15%-10%-10%-5%-5%0 05%5%10%10%销售收入289,812,600306,860,400323,908,200340,956,000358,003,800375,051,600与销售收入变化相对应的指标值及其变化率净现值NPV38,879,92750,084,40161,288,87672,493,35083,697,82594902299.49变变化化率率-46.4%-46.4%-30.9%-30.9%-15.5%-15.5%0.0%0.0%15.5%15.5%30.

2、9%30.9%内部收益率27.6%32.4%37.1%41.4%45.6%49.59%变变化化率率-33.5%-33.5%-21.7%-21.7%-10.6%-10.6%0.0%0.0%10.1%10.1%19.6%19.6%税后利润61,891,51275,143,19488,394,875101,646,556114,898,237128149918.1变变化化率率-39.1%-39.1%-26.1%-26.1%-13.0%-13.0%0.0%0.0%13.0%13.0%26.1%26.1%成本利润率32.2%39.1%46.0%52.9%59.8%0.667016651变变化化率率-39

3、.1%-39.1%-26.1%-26.1%-13.0%-13.0%0.0%0.0%13.0%13.0%26.1%26.1%15%15%结论392,099,400106,106,774销售收入每增减5%,NPV值相应等比增减15.5% ,影响率约为1:346.4%46.4%53.4%28.8%28.8%141,401,599销售收入每增减5%,税后利润相应等比增减约13%,影响率约为1:2.639.1%39.1%73.6%销售收入每增减5%,成本利润率相应等比增减约13.%,影响率约为1:2.639.1%39.1%敏敏感感度度分分析析一一（销销售售收收入入变变化化的的影影响响)敏敏感感度度分分析

4、析二二（工工程程成成本本变变化化的的影影响响)工工程程成成本本变变化化率率-15%-15%-10%-10%-5%-5%0 05%5%工程成本886945489393512199178277104424017109672339与工程成本变化相对应的指标值及其变化率净现值NPV9528221987688082800917927249335064892756变变化化率率31.4%31.4%21.0%21.0%10.5%10.5%0.0%0.0%-10.5%-10.5%内部收益率55.37%50.47%45.84%41.45%37.27%变变化化率率33.6%33.6%21.8%21.8%10.6%1

5、0.6%0.0%0.0%-10.1%-10.1%税后利润12621063011802480210983677710164655693454138变变化化率率24.2%24.2%16.1%16.1%8.1%8.1%0.0%0.0%-8.1%-8.1%成本利润率77.32%68.28%60.19%52.91%46.32%变变化化率率46.1%46.1%29.0%29.0%13.8%13.8%0.0%0.0%-12.4%-12.4%10%10%15%15%结论1149232441201767325729000949685109工程成本每增减5%,NPV值相应等比增减10.5% ,影响率约为1:2-21.0%-21.0%-31.5%-31.5%33.29%29.48%-19.7%-19.7%-28.9%-28.9%8525952377062712工程成本每增减5%,税后利润相应等比增减8.1%,影响率约为1:1.6-16.1%-16.1%-24.2%-24.2