财务内部收益率(修改)计算表.xls

1、1项目财务净现金流量表2 单位：万元3 项 目经济效益计算分析期（年）4012345678910115生产负荷（%）-60.0080.00100.00100.00100.00100.00100.00100.00100.00101.006一、现金流入-74,976.0099,968.00124,960.00124,960.00124,960.00124,960.00124,960.00124,960.00124,960.00124,961.007（一）产品销售收入74,976.0099,968.00124,960.00124,960.00124,960.00124,960.00124,960.0

2、0124,960.00124,960.00124,961.008（二）回收固定资产余值9（三）回收流动资金10 二、现金流出11,527.0011,527.0082,485.3096,203.59117,692.84116,929.83116,929.83116,929.83116,929.83116,929.83116,929.83116,929.8311（一）固定资产投资11,527.0011,527.0012（二）流动资金-10,122.001,556.77763.0113（三）经营成本71,618.0093,653.09115,687.67115,687.67115,687.67115

3、,687.67115,687.67115,687.67115,687.67115,687.6714（四）销售税金及附加745.30993.731,242.161,242.161,242.161,242.161,242.161,242.161,242.161,242.1615（五）所得税-16 三、全部投资净现金流量-11,527.00-11,527.00-7,509.303,764.417,267.168,030.178,030.178,030.178,030.178,030.178,030.178,031.1717 四、累计增量净现金流量-11,527.00-23,054.00-30,563

4、.30-26,798.89-19,531.73-11,501.56-3,471.394,558.7812,588.9520,619.1228,649.2936,680.461819内部收益率计算表20项 目经济效益计算分析期（年）210123456789101122 净现金流-11,527.00-11,527.00-7,509.303,764.417,267.168,030.178,030.178,030.178,030.178,030.178,030.178,031.1723 折现系数(测试1)20%1.00000.83330.69440.57870.48230.40190.33490.27

5、910.23260.19380.16150.134624 净现值（万元）-11,527.00-9,605.45-5,214.462,178.463,504.953,227.332,689.302,241.221,867.821,556.251,296.871,081.0025 累计净现值（万元）-11,527.00-21,132.45-26,346.91-24,168.45-20,663.50-17,436.17-14,746.87-12,505.65-10,637.83-9,081.58-7,784.71-6,703.7126 折现系数(测试2)19%1.00000.84030.70620.

6、59340.49870.41900.35210.29590.24870.20900.17560.147627 净现值（万元）-11,527.00-9,686.14-5,303.072,233.803,624.133,364.642,827.422,376.131,997.101,678.311,410.101,185.4028 累计净现值（万元）-11,527.00-21,213.14-26,516.21-24,282.41-20,658.28-17,293.64-14,466.22-12,090.09-10,092.99-8,414.68-7,004.58-5,819.1829内内部部收收益

7、益率率=17.28%17.56%折现系数差额1%累计净现值比例-1.72 说明：1、有颜色阴影栏已设置好公式其数据会自动计算生成，无颜色栏的数据须手工录入；2、折现系数(测试1)栏必须大于折现系数(测试2)栏；3、折现系数测试1、测试2栏数据须手工调试至L25、L28栏累计净现值数据接近于零为止，其中L25栏为接近于零的负值，L28栏为接近于零的正值。4、如经济效益计算分析期不足10年，可将EM列之间不需要的列删除，同时不要忘记将第4、第21行中的年数修改，以免导致数据计算错误。1213141516102.00103.00104.00105.00106.00124,962.00124,963.

8、00124,964.00124,965.00124,966.00124,962.00124,963.00124,964.00124,965.00124,966.00116,929.83116,929.83116,929.83116,929.83116,929.83115,687.67115,687.67115,687.67115,687.67115,687.671,242.161,242.161,242.161,242.161,242.168,032.178,033.178,034.178,035.178,036.1744,712.6352,745.8060,779.9768,815.1476,851.3112131415168,032.178,033.178,034.178,035.178,036.170.11220.09350.07790.06490.0541901.21751.10625.86521.48434.76-5,802.50-5,051.40-4,425.54-3,904.06-3,469.300.12400.10420.08760.07360.0618995.99837.06703.79591.39496.64-4,823.19-3,986.13-3,282.34-2,690.95-2,194.3117.56%