投资项目敏感性分析.xlsx

投资项目敏感性分析原原始始数数据据：年年份份0 01 12 23 34 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.98249222.98-0.1-0.1187200.00141920.0740500.00119675.6331500.00-0.08-0.08191360.00141920.0740500.00119675.6331500.00-0.06-0.06195520.00141920.0740500.00119675.6331500.00-0.04-0.04199680.00141920.0740500.00119675.6331500.00-0.02-0.02203840.00141920.0740500.00119675.6331500.000 0208000.00141920.0740500.00119675.6331500.000.020.02212160.00141920.0740500.00119675.6331500.000.040.04216320.00141920.0740500.00119675.6331500.000.060.06220480.00141920.0740500.00119675.6331500.000.080.08224640.00141920.0740500.00119675.6331500.000.10.1228800.00141920.0740500.00119675.6331500.00贴现率：8%单位：元5 56 67 78 89 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#净净现现值值249222.98119583.03119583.03119583.03119583.03119583.03119583.03119583.03119583.03119583.03119583.03119583.03投资项目敏感性分析