《(1)投资回收期决策模型.xls》由会员分享，可在线阅读，更多相关《(1)投资回收期决策模型.xls（3页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
投投资资回回收收期期法法分分析析模模型型投投资资期期数数净净现现金金流流量量现现值值现现值值累累计计0 0-100-100-100.00-100.00-100.00-100.001 1-80-80-74.07-74.07-174.07-174.072 2303025.7225.72-148.35-148.353 3505039.6939.69-108.66-108.664 4909066.1566.15-42.51-42.515 510010068.0668.0625.5525.556 611011069.3269.3294.8794.877 712012070.0270.02164.89164.898 813013070.2370.23235.12235.129 914014070.0370.03305.16305.16101015015069.4869.48374.64374.64年年贴贴现现率率8%8%注注：COUNTIFCOUNTIF和和VLOOKUPVLOOKUP函函数数应应用用投投资资回回收收期期数数5 5投投资资回回收收期期（年年）4.624.62注注：COUNTIFCOUNTIF和和VLOOKUPVLOOKUP函函数数应应用用