财务模型-项目投资.xls

《财务模型-项目投资.xls》由会员分享，可在线阅读，更多相关《财务模型-项目投资.xls（7页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、序号项目名称单位数量备注一财务评价数据工程建设总估算（含增值税）万元512,754.17项目总投资（报批总投资）万元 485,588.671.1建设投资万元425,309.811.2建设期借款利息万元22,790.231.3流动资金万元215,513.761.4可抵扣增值税万元-27,165.502年均营业收入万元/年2,489,281.403成本费用3.1年均总成本费用万元/年2,206,316.654利润4.1利润总额万元/年315,932.124.2净利润万元/年236,949.095年均营业税金及附加万元/年115,000.466年均增值税万元/年61,873.17二项目财务评价指标1

2、财务内部收益率43.81%税后全投资财务净现值万元935,275.51 税后全投资静态投资回收期年3.33 税后全投资2财务内部受益率55.66%税前全投资财务净现值万元1,341,595.40 税前全投资静态投资回收期年3.04 税前全投资4总投资利润率65.06%总投资利税率101.49%财财务务测测算算模模型型关关键键指指标标单位：万元总投资512,754建设期2 年折旧率：增值税17.00%营业税率：5.60%所得税率：25.00%基准折现率：设备保险费率项目计算期（第n年）建设期运营期（万元）012123损损益益表表收入2,489,281.402,489,281.402,489,28

3、1.40营运费用2,206,316.652,206,316.652,206,316.65增值税34,707.6734,707.6734,707.67设备保险费-折旧-财务费用-营业税金及附加115,000.46115,000.46115,000.46税税前前利利润润-133,256.62133,256.62133,256.62所得税-33,314.1633,314.1633,314.16税税后后利利润润-99,942.4799,942.4799,942.47现现金金流流量量表表经经营营活活动动产产生生的的现现金金流流量量净净额额-99,942.4799,942.4799,942.47销售产品收

4、到的现金2,489,281.402,489,281.402,489,281.40支付经营活动支出-2,241,024.32-2,241,024.32-2,241,024.32支付的各项税费-148,314.62-148,314.62-148,314.62投投资资活活动动产产生生的的现现金金流流量量净净额额-512,754.17-采购固定资产-512,754.17筹筹资资活活动动产产生生的的现现金金流流量量净净额额-信托基金投入信托财务费用-当当期期现现金金之之增增加加/（减减少少）净净额额-512,754.1799,942.4799,942.4799,942.47累累计计现现金金之之增增加加/

5、（减减少少）净净额额-512,754.17-512,754.17-512,754.17-412,811.71-312,869.24-212,926.78投资活动指标评价：静态投资回收期PP=5.87 年净现值NPV（税后）=486,670 万元内部收益率IRR(税后）=14.43%总投资收益率ROI=19.49%合计456789102,489,281.402,489,281.402,489,281.402,489,281.402,489,281.402,489,281.402,489,281.4024,892,814.002,206,316.652,206,316.652,206,316.65

6、2,206,316.652,206,316.652,206,316.652,206,316.6522,063,166.5034,707.6734,707.6734,707.6734,707.6734,707.6734,707.6734,707.67347,076.70-115,000.46115,000.46115,000.46115,000.46115,000.46115,000.46115,000.461,150,004.60133,256.62133,256.62133,256.62133,256.62133,256.62133,256.62133,256.621,332,566.203

7、3,314.1633,314.1633,314.1633,314.1633,314.1633,314.1633,314.16333,141.5599,942.4799,942.4799,942.4799,942.4799,942.4799,942.4799,942.47999,424.6599,942.4799,942.4799,942.4799,942.4799,942.4799,942.4799,942.472,489,281.402,489,281.402,489,281.402,489,281.402,489,281.402,489,281.402,489,281.40-2,241,0

8、24.32-2,241,024.32-2,241,024.32-2,241,024.32-2,241,024.32-2,241,024.32-2,241,024.32-148,314.62-148,314.62-148,314.62-148,314.62-148,314.62-148,314.62-148,314.62-99,942.4799,942.4799,942.4799,942.4799,942.4799,942.4799,942.47-112,984.31-13,041.8486,900.62186,843.09286,785.55386,728.02486,670.48运营期（万元

9、）财财务务测测算算模模型型关关键键指指标标单位：万元总投资512,754建设期2 年折旧率：增值税17.00%营业税率：5.60%所得税率：基准折现率：设备保险费率项目计算期（第n年）建设期运营期（万元）012123损损益益表表收入2,489,281.402,489,281.402,489,281.40营运费用2,206,316.652,206,316.652,206,316.65增值税34,707.6734,707.6734,707.67设备保险费-折旧-财务费用-营业税金及附加115,000.46115,000.46115,000.46税税前前利利润润-133,256.62133,256.

10、62133,256.62所得税-税税后后利利润润-133,256.62133,256.62133,256.62现现金金流流量量表表经经营营活活动动产产生生的的现现金金流流量量净净额额-133,256.62133,256.62133,256.62销售产品收到的现金2,489,281.402,489,281.402,489,281.40支付经营活动支出-2,241,024.32-2,241,024.32-2,241,024.32支付的各项税费-115,000.46-115,000.46-115,000.46投投资资活活动动产产生生的的现现金金流流量量净净额额-512,754.17-采购固定资产-5

11、12,754.17筹筹资资活活动动产产生生的的现现金金流流量量净净额额-信托基金投入信托财务费用-当当期期现现金金之之增增加加/（减减少少）净净额额-512,754.17133,256.62133,256.62133,256.62累累计计现现金金之之增增加加/（减减少少）净净额额-512,754.17-512,754.17-512,754.17-379,497.55-246,240.93-112,984.31投资活动指标评价：静态投资回收期PP=3.15 年净现值NPV（税后）=819,812 万元内部收益率IRR(税后）=22.60%总投资收益率ROI=25.99%合计456789102,4

12、89,281.402,489,281.402,489,281.402,489,281.402,489,281.402,489,281.402,489,281.4024,892,814.002,206,316.652,206,316.652,206,316.652,206,316.652,206,316.652,206,316.652,206,316.6522,063,166.5034,707.6734,707.6734,707.6734,707.6734,707.6734,707.6734,707.67347,076.70-115,000.46115,000.46115,000.46115,0

13、00.46115,000.46115,000.46115,000.461,150,004.60133,256.62133,256.62133,256.62133,256.62133,256.62133,256.62133,256.621,332,566.20-133,256.62133,256.62133,256.62133,256.62133,256.62133,256.62133,256.621,332,566.20133,256.62133,256.62133,256.62133,256.62133,256.62133,256.62133,256.622,489,281.402,489,

14、281.402,489,281.402,489,281.402,489,281.402,489,281.402,489,281.40-2,241,024.32-2,241,024.32-2,241,024.32-2,241,024.32-2,241,024.32-2,241,024.32-2,241,024.32-115,000.46-115,000.46-115,000.46-115,000.46-115,000.46-115,000.46-115,000.46-133,256.62133,256.62133,256.62133,256.62133,256.62133,256.62133,256.62-20,272.31153,528.93286,785.55420,042.17553,298.79686,555.41819,812.03运营期（万元）