净现值的计算公式.xlsVIP

Sheet3 Sheet2 Sheet1 项目计算期（第T年） 所得税前净现金流量 折现率 NPV IRR 所得税后净现金流量 .00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 -100.00 -300.00 -83.00 97.62 97.62 97.62 97.62 97.62 156.43 156.43 156.43 156.43 156.43 156.43 156.43 156.43 156.43 156.43 156.43 156.43 156.43 156.43 216.43 .10 ￥482.45 .20 .00 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 -100.00 -300.00 -83.00 78.96 79.46 79.46 79.46 79.46 122.32 122.32 122.32 122.32 122.32 122.32 122.32 122.32 122.32 122.32 122.32 122.32 122.32 122.32 182.32 .10 ￥292.04 .17