内部收益率计算模板

1、AB1c1 d123投资额项目41 235生产负荷（%）1001001006一、现金流入1200012000120007（一）产品销售收入1200012000120008（二 ）回收固定资产余 值9值三）回收流动资金10二、现金流出13800108001080011（一）固定资产投资240012（二）流动资金60013（三）经营成本10330.1110330.1110330.1114（四）销售税金及附加69.8969.8969.8915（五）所得税40040040016三、全部投资净现金流量-18001200120017量、累计增量净现金流-1800-6006001920投资额项目211232

2、2净现金流-18001200120023折现系数=0.120.8928571430.7971938780.71178024824净现值（万兀）-1607.142857956.6326531854.136297425累计净现值（万兀）-1607.142857-650.5102041203.626093326折现系数0.6026939740.3632400260.21892257427净现值（万兀）-1084.849152435.8880309262.707089428累计净现值（万兀）-1084.849152-648.9611215-386.254032129内部收益率=0.659216856项

3、目财务现金流量表经济效益计算分析期（年）4567810010010010010012000120001200012000120001200012000120001200012000108001080010800108001080010330.1110330.1110330.1110330.1110330.1169.8969.8969.8969.8969.894004004004004001200120012001200120018003000420054006600内部收益率计算表经济效益计算分析期（年）45678120012001200120012000.6355180780.5674268

4、560.5066311210.4523492150.403883228762.6216941680.9122269607.9573454542.8190584484.6598736966.24778741647.1600142255.117362797.9364183282.5962920.1319433160.0795214420.0479270940.028885370.017409039158.331979695.425729957.5125123334.6624445820.89084646-227.9220526-132.4963227-74.98381034-40.32136576-19.4305193k单位：万元9101001001200012120'1200012000'120'0108001080010330.1110330.1169.8969.894004001200132078009120910120013200.3606100250.321973237432.73203425.00467233715.3283224140