18.1.7-计算固定资产投资项目的动态回收期

计算动态回收期计算验证7.2%现金流现值现金流现值现金流现值累计-200（普通公式）（现值函数）120￥18.66￥18.66￥-181.34235￥30.46￥30.46￥-150.89350￥40.59￥40.59￥-110.30460￥45.43￥45.43￥-64.87580￥56.51￥56.51￥-8.36670￥46.12￥46.12￥37.77760￥36.88￥36.88￥74.658100￥57.34￥57.34￥131.985.185.18定义名称：TPV=MMULT(N(ROW($1:$8)=COLUMN($A:$H)),PV($C$2,$B$4:$B$11,,-$C$4:$C$11,))+$C$31－8年各年产生的净现金流量（万元）动态投资回收期设备投资（万元）年利率动态投资回收期（方法二）=MMULT(N(ROW($1:$8)=COLUMN($A:$H)),PV($C$2,$B$4:$B$11,,-$C$4:$C$11,))+$C$3