方案管理器应用市场状况投资项目年限贴现率NPV一般5000.0058%￥1,388方案摘要繁荣可变单元格:年现金流量贴现率结果单元格:NPV2000.0010%1600.008%1200.006%一般不景气年现金流量1600.00模拟运算表贴现率年现金流量￥1,3881000.001200.001400.001600.001800.002000.002%-286.54656.151598.842541.543484.234426.924%-548.18342.191232.552122.923013.283903.646%-787.6454.84897.311739.782582.253424.738%-1007.29-208.75589.791388.342186.882985.4210%-1209.21-451.06307.101065.261823.422581.57单变量求解应用投资项目年限贴现率NPV5000.00510%￥8,000年现金流量3429.37方案管理器方案年现金流量贴现率市场状况C12000.06不景气