內(nèi)部收益率計算模板

1、AB1c1 d123投資額項目41 235生產(chǎn)負(fù)荷（%）1001001006一、現(xiàn)金流入1200012000120007（一）產(chǎn)品銷售收入1200012000120008（二 ）回收固定資產(chǎn)余 值9值三）回收流動資金10二、現(xiàn)金流出13800108001080011（一）固定資產(chǎn)投資240012（二）流動資金60013（三）經(jīng)營成本10330.1110330.1110330.1114（四）銷售稅金及附加69.8969.8969.8915（五）所得稅40040040016三、全部投資凈現(xiàn)金流量-18001200120017量、累計增量凈現(xiàn)金流-1800-6006001920投資額項目211232

2、2凈現(xiàn)金流-18001200120023折現(xiàn)系數(shù)=0.120.8928571430.7971938780.71178024824凈現(xiàn)值（萬兀）-1607.142857956.6326531854.136297425累計凈現(xiàn)值（萬兀）-1607.142857-650.5102041203.626093326折現(xiàn)系數(shù)0.6026939740.3632400260.21892257427凈現(xiàn)值（萬兀）-1084.849152435.8880309262.707089428累計凈現(xiàn)值（萬兀）-1084.849152-648.9611215-386.254032129內(nèi)部收益率=0.659216856項

3、目財務(wù)現(xiàn)金流量表經(jīng)濟(jì)效益計算分析期（年）4567810010010010010012000120001200012000120001200012000120001200012000108001080010800108001080010330.1110330.1110330.1110330.1110330.1169.8969.8969.8969.8969.894004004004004001200120012001200120018003000420054006600內(nèi)部收益率計算表經(jīng)濟(jì)效益計算分析期（年）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