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

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

《财务内部收益率(修改)计算表.xls》由会员分享，可在线阅读，更多相关《财务内部收益率(修改)计算表.xls（3页珍藏版）》请在冰点文库上搜索。

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.00124,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,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.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.27910.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.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内内部部收收益益率率=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.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%