内部收益率IRR计算(内嵌公式)

1、项目23投资额项目412345生产负荷（%）501001001006一、现金流入59201184011840118407（一）产品销售收入59201184011840118408（二）回收固定资产余值9（三）回收流动资金10二、现金流出784211451114511145111（一）固定资产投资76912（二）流动资金50013（三）经营成本476395259525952514（四）销售税金及附加169616971697169715（五）所得税11422922922916三、全部投资净现金流量-192238938938917六、累计增量净现金流量-1922-1533-1144-75518192

2、0投资额项目21123422净现金流-1921.81738938938923折现系数=0.120.8930.7970.7120.63624净现值（万元）-1716.183310.108276.883247.21725累计净现值（万元）-1716.183-1406.074-1129.192-881.97526折现系数0.8490.7210.6120.52027净现值（万元）-1631.736667280.4307836238.1023751202.163044728累计净现值（万元）-1631.737-1351.306-1113.204-911.04029内部收益率=0.177773987计算内

3、部收益率：用鼠标单击“数据”菜单，选择模拟分析-“单变量求解”，弹出单变量求解对话框，在目标单元格输入框中输入$卩$28,在目标值输入框中输入0,在可变单元格输入框中输入$C$29,计算机计算出的内部收益率显示在C29单元格中。项目财务现金流量表经济效益计算分析期（年）567891011100100100100100100100118401184011840118401184011840118401184011840118401184011840118401184011451114511145111451114511145111451952595259525952595259525952516

4、97169716971697169716971697229229229229229229229389389389389389389389-36623412801119015791968内部收益率计算表经济效益计算分析期（年）5678910113893893893893893893890.5670.5070.4520.4040.3610.3220.287220.729197.080175.964157.111140.277125.248111.828-661.246-464.167-288.203-131.0929.185134.433246.2610.4410.3750.3180.2700.2290.1950.165171.6484206145.7396942123.7416481105.064001689.2055715575.7408234264.30845329-739.392-593.652-469.911-364.847-275.641-199.900-135.592单位：万元12100124171184077