财务内部收益率计算表

1项目财务净现金流量 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 2单位：万元3项目经济效益计算 分析 定性数据统计分析pdf销售业绩分析模板建筑结构震害分析销售进度分析表京东商城竞争战略分析 期（年）4123456789105一、现金流入-07,600.0011,400.0019,000.0028,500.0028,500.0028,500.0028,500.0028,500.0028,500.006（一）产品销售收入-07,600.0011,400.0019,000.0028,500.0028,500.0028,500.0028,500.0028,500.0028,500.007（二）回收固定资产余值8（三）回收流动资金9二、现金流出21,460.0016,899.246,738.1010,749.2015,811.9115,876.9715,929.4716,055.4016,055.4016,055.4010（一）固定资产投资20,300.0012,105.0011（二）流动资金760.00740.0012（三）经营成本400.003,334.005,241.007,655.0010,672.5010,672.5010,672.5010,672.5010,672.5010,672.5013（四）销售税金及附加-0418.00627.001,045.001,567.501,567.501,567.501,567.501,567.501,567.5014（五）所得税-0302.24870.102,049.203,571.913,636.973,689.473,815.403,815.403,815.4015三、全部投资净现金流量-21,460.00-9,299.244,661.908,250.8012,688.0912,623.0312,570.5312,444.6012,444.6012,444.6016四、累计增量净现金流量-21,460.00-30,759.24-26,097.34-17,846.54-5,158.457,464.5820,035.1132,479.7144,924.3157,368.911718内部收益率计算表19项目经济效益计算分析期（年）201234567891021净现金流-21,460.00-9,299.244,661.908,250.8012,688.0912,623.0312,570.5312,444.6012,444.6012,444.6022折现系数(测试1)23%0.81300.66100.53740.43690.35520.28880.23480.19090.15520.126223净现值（万元）-17,446.98-6,146.802,505.313,604.774,506.813,645.532,951.562,375.671,931.401,570.5124累计净现值（万元）-17,446.98-23,593.78-21,088.47-17,483.70-12,976.89-9,331.36-6,379.80-4,004.13-2,072.73-502.2225折现系数(测试2)22%0.81970.67190.55070.45140.37000.30330.24860.20380.16700.136926净现值（万元）-17,590.76-6,248.162,567.313,724.414,694.593,828.563,125.032,536.212,078.251,703.6727累计净现值（万元）-17,590.76-23,838.92-21,271.61-17,547.20-12,852.61-9,024.05-5,899.02-3,362.81-1,284.56419.1128内部收益率=22.45%折现系数差额1%累计净现值比例0.45说明：1、有颜色阴影栏已设置好公式其数据会自动计算生成，无颜色栏的数据须手工录入；2、折现系数(测试1)栏必须大于折现系数(测试2)栏；3、折现系数测试1、测试2栏数据须手工调试至M24、M27栏累计净现值数据接近于零为止，其中M24栏为接近于零的负值，M27栏为接近于零的正值。4、如经济效益计算分析期不足10年，可将E－M列之间不需要的列删除，同时不要忘记将第4、第20行中的年数修改，以免导致数据计算错误。1项目财务净现金流量表2单位：万元3项目经济效益计算分析期（年）4123456789105一、现金流入-07,600.0011,400.0019,000.0028,500.0028,500.0028,500.0028,500.0028,500.0028,500.006（一）产品销售收入-07,600.0011,400.0019,000.0028,500.0028,500.0028,500.0028,500.0028,500.0028,500.007（二）回收固定资产余值8（三）回收流动资金9二、现金流出21,460.0016,899.246,738.1010,749.2015,811.9115,876.9715,929.4716,055.4016,055.4016,055.4010（一）固定资产投资20,300.0012,105.0011（二）流动资金760.00740.0012（三）经营成本400.003,334.005,241.007,655.0010,672.5010,672.5010,672.5010,672.5010,672.5010,672.5013（四）销售税金及附加-0418.00627.001,045.001,567.501,567.501,567.501,567.501,567.501,567.5014（五）所得税-0302.24870.102,049.203,571.913,636.973,689.473,815.403,815.403,815.4015三、全部投资净现金流量-21,460.00-9,299.244,661.908,250.8012,688.0912,623.0312,570.5312,444.6012,444.6012,444.60（税前）净现金流量-21,460.00-8,997.015,532.0010,300.0016,260.0016,260.0016,260.0016,260.0016,260.0016,260.001718内部收益率计算表19项目经济效益计算分析期（年）201234567891021净现金流-21,460.00-8,997.015,532.0010,300.0016,260.0016,260.0016,260.0016,260.0016,260.0016,260.0022折现系数(测试1)30%0.76920.59170.45520.35010.26930.20720.15940.12260.09430.072523净现值（万元）-16,507.03-5,323.532,518.173,606.034,378.823,369.072,591.841,993.481,533.321,178.8524累计净现值（万元）-16,507.03-21,830.56-19,312.39-15,706.36-11,327.54-7,958.47-5,366.63-3,373.15-1,839.83-660.9825折现系数(测试2)29%0.77520.60090.46580.36110.27990.21700.16820.13040.10110.078426净现值（万元）-16,635.79-5,406.302,576.813,719.334,551.173,528.422,734.932,120.301,643.891,274.7827累计净现值（万元）-16,635.79-22,042.09-19,465.28-15,745.95-11,194.78-7,666.36-4,931.43-2,811.13-1,167.24107.5428内部收益率=29.14%折现系数差额1%累计净现值比例0.14说明：1、有颜色阴影栏已设置好公式其数据会自动计算生成，无颜色栏的数据须手工录入；2、折现系数(测试1)栏必须大于折现系数(测试2)栏；3、折现系数测试1、测试2栏数据须手工调试至M24、M27栏累计净现值数据接近于零为止，其中M24栏为接近于零的负值，M27栏为接近于零的正值。4、如经济效益计算分析期不足10年，可将E－M列之间不需要的列删除，同时不要忘记将第4、第20行中的年数修改，以免导致数据计算错误。1项目财务净现金流量表2单位：万元3项目经济效益计算分析期（年）4123456789105一、现金流入-07,600.0011,400.0019,000.0028,500.0028,500.0028,500.0028,500.0028,500.0028,500.006（一）产品销售收入-07,600.0011,400.0019,000.0028,500.0028,500.0028,500.0028,500.0028,500.0028,500.007（二）回收固定资产余值8（三）回收流动资金9二、现金流出21,950.0017,903.247,791.3016,854.0021,785.8621,590.7021,433.1816,055.4016,055.4016,055.4010（一）固定资产投资20,300.0012,105.0011（二）流动资金760.00740.0012（三）经营成本400.003,334.005,241.007,655.0010,672.5010,672.5010,672.5010,672.5010,672.5010,672.5013（四）销售税金及附加-0418.00627.001,045.001,567.501,567.501,567.501,567.501,567.501,567.5014（五）所得税-0302.24870.102,049.203,571.913,636.973,689.473,815.403,815.403,815.4015三、借款本金偿还-0-0-05,000.005,000.005,000.005,000.00-0-0-016四、借款利息偿还490.001,004.001,053.201,104.80973.95713.73503.71-0-0-017五、全部投资净现金流量-21,950.00-10,303.243,608.702,146.006,714.146,909.307,066.8212,444.6012,444.6012,444.6018六、累计增量净现金流量-21,950.00-32,253.24-28,644.54-26,498.54-19,784.40-12,875.10-5,808.286,636.3219,080.9231,525.521920内部收益率计算表21项目经济效益计算分析期（年）221234567891023净现金流-21,950.00-10,303.243,608.702,146.006,714.146,909.307,066.8212,444.6012,444.6012,444.6024折现系数(测试1)13%0.88500.78310.69310.61330.54280.48030.42510.37620.33290.294625净现值（万元）-19,425.75-8,068.472,501.191,316.143,644.443,318.543,004.114,681.664,142.813,666.1826累计净现值（万元）-19,425.75-27,494.22-24,993.03-23,676.89-20,032.45-16,713.91-13,709.80-9,028.14-4,885.33-1,219.1527折现系数(测试2)12%0.89290.79720.71180.63550.56740.50660.45230.40390.36060.322028净现值（万元）-19,599.16-8,213.742,568.671,363.783,809.603,500.253,196.325,026.374,487.524,007.1629累计净现值（万元）-19,599.16-27,812.90-25,244.23-23,880.45-20,070.85-16,570.60-13,374.28-8,347.91-3,860.39146.7730内部收益率=12.11%折现系数差额1%累计净现值比例0.11说明：1、有颜色阴影栏已设置好公式其数据会自动计算生成，无颜色栏的数据须手工录入；2、折现系数(测试1)栏必须大于折现系数(测试2)栏；3、折现系数测试1、测试2栏数据须手工调试至M26、M29栏累计净现值数据接近于零为止，其中M26栏为接近于零的负值，M29栏为接近于零的正值。4、如经济效益计算分析期不足10年，可将E－M列之间不需要的列删除，同时不要忘记将第4、第20行中的年数修改，以免导致数据计算错误。1项目财务净现金流量表2单位：万元3项目经济效益计算分析期（年）4123456789105一、现金流入-07,600.0011,400.0019,000.0028,500.0028,500.0028,500.0028,500.0028,500.0028,500.006（一）产品销售收入-07,600.0011,400.0019,000.0028,500.0028,500.0028,500.0028,500.0028,500.0028,500.007（二）回收固定资产余值8（三）回收流动资金9二、现金流出21,950.0017,903.247,791.3016,854.0021,785.8621,590.7021,433.1816,055.4016,055.4016,055.4010（一）固定资产投资20,300.0012,105.0011（二）流动资金760.00740.0012（三）经营成本400.003,334.005,241.007,655.0010,672.5010,672.5010,672.5010,672.5010,672.5010,672.5013（四）销售税金及附加-0418.00627.001,045.001,567.501,567.501,567.501,567.501,567.501,567.5014（五）所得税-0302.24870.102,049.203,571.913,636.973,689.473,815.403,815.403,815.4015三、借款本金偿还-0-0-05,000.005,000.005,000.005,000.00-0-0-016四、借款利息偿还490.001,004.001,053.201,104.80973.95713.73503.71-0-0-017五、全部投资净现金流量-21,950.00-10,303.243,608.702,146.006,714.146,909.307,066.8212,444.6012,444.6012,444.6018（税前）净现金流量-21,950.00-10,001.014,478.804,195.2010,286.0510,546.2710,756.2916,260.0016,260.0016,260.0019内部收益率计算表20项目经济效益计算分析期（年）211234567891022净现金流-21,950.00-10,001.014,478.804,195.2010,286.0510,546.2710,756.2916,260.0016,260.0016,260.0023折现系数(测试1)20%0.83330.69440.57870.48230.40190.33490.27910.23260.19380.161524净现值（万元）-18,290.94-6,944.702,591.882,023.344,133.963,531.953,002.083,782.083,151.192,625.9925累计净现值（万元）-18,290.94-25,235.64-22,643.76-20,620.42-16,486.46-12,954.51-9,952.43-6,170.35-3,019.16-393.1726折现系数(测试2)19%0.84030.70620.59340.49870.41900.35210.29590.24870.20900.175627净现值（万元）-18,444.59-7,062.712,657.722,092.154,309.853,713.343,182.794,043.863,398.342,855.2628累计净现值（万元）-18,444.59-25,507.30-22,849.58-20,757.43-16,447.58-12,734.24-9,551.45-5,507.59-2,109.25746.0129内部收益率=19.65%折现系数差额1%累计净现值比例0.65说明：1、有颜色阴影栏已设置好公式其数据会自动计算生成，无颜色栏的数据须手工录入；2、折现系数(测试1)栏必须大于折现系数(测试2)栏；3、折现系数测试1、测试2栏数据须手工调试至M25、M28栏累计净现值数据接近于零为止，其中M25栏为接近于零的负值，M28栏为接近于零的正值。4、如经济效益计算分析期不足10年，可将E－M列之间不需要的列删除，同时不要忘记将第4、第20行中的年数修改，以免导致数据计算错误。