文件195 投资项目敏感性分析
投资项目敏感性分析原始数据:年份 0 1 2 3 4现金流入: ¥0.00 ¥75,000.00 ¥79,000.00 ¥80,000.00 ¥775,000.00销售收入 ¥75,000.00 ¥79,000.00 ¥80,000.00 ¥775,000.00期末残值 ¥0.00 ¥0.00 ¥0.00 ¥0.00 ¥0.00现金流出 ¥208,000.00 ¥80,000.00 ¥80,000.00 ¥80,000.00 ¥80,000.00投资额 ¥208,000.00 ¥0.00 ¥0.00 ¥0.00 ¥0.00运营费用 ¥0.00 ¥45,000.00 ¥45,000.00 ¥45,000.00 ¥45,000.00税金 ¥35,000.00 ¥35,000.00 ¥35,000.00 ¥35,000.00净现金流量 (¥208,000.00) (¥5,000.00) (¥1,000.00) ¥0.00 ¥695,000.00净现值 ¥249,222.98敏感性分析变化率 新投资额 净现值 新运营费用 净现值 新税金249222.98 249222.98-0.1 187200.00 141920.07 40500.00 119675.63 31500.00-0.08 191360.00 141920.07 40500.00 119675.63 31500.00-0.06 195520.00 141920.07 40500.00 119675.63 31500.00-0.04 199680.00 141920.07 40500.00 119675.63 31500.00-0.02 203840.00 141920.07 40500.00 119675.63 31500.000 208000.00 141920.07 40500.00 119675.63 31500.000.02 212160.00 141920.07 40500.00 119675.63 31500.000.04 216320.00 141920.07 40500.00 119675.63 31500.000.06 220480.00 141920.07 40500.00 119675.63 31500.000.08 224640.00 141920.07 40500.00 119675.63 31500.000.1 228800.00 141920.07 40500.00 119675.63 31500.00贴现率: 8% 单位: 元5 6 7 8 9¥80,000.00 ¥65,000.00 ¥60,000.00 ¥55,000.00 ¥53,000.00¥80,000.00 ¥65,000.00 ¥60,000.00 ¥55,000.00 ¥43,000.00¥0.00 ¥0.00 ¥0.00 ¥0.00 ¥10,000.00¥80,000.00 ¥80,000.00 ¥80,000.00 ¥80,000.00 ¥80,000.00¥0.00 ¥0.00 ¥0.00 ¥0.00 ¥0.00¥45,000.00 ¥45,000.00 ¥45,000.00 ¥45,000.00 ¥45,000.00¥35,000.00 ¥35,000.00 ¥35,000.00 ¥35,000.00 ¥35,000.00¥0.00 (¥15,000.00) (¥20,000.00) (¥25,000.00) (¥27,000.00)净现值249222.98119583.03119583.03119583.03119583.03119583.03119583.03119583.03119583.03119583.03119583.03119583.03投资项目敏感性分析敏感性分析