2020年行性研究报告投资估算及财务分析全套计算表格（共21个附表EXCLE带公式.xlsx

2020年行性研究报告投资估算及财务分析全套计算表格（共21个附表EXCLE带公式.xlsx

《2020年行性研究报告投资估算及财务分析全套计算表格（共21个附表EXCLE带公式.xlsx》由会员分享，可在线阅读，更多相关《2020年行性研究报告投资估算及财务分析全套计算表格（共21个附表EXCLE带公式.xlsx（54页珍藏版）》请在冰点文库上搜索。

建设投资估算表（仅需填写标红部分，其余内容自动计算）人民币单位：

万元序号工程或费用名称计算面积单方造价第一部分工程费用1建筑工程费用2设备费用2.1主粮生产线2.2湿粮生产线2.3零食生产线2.4某某产品生产线设备小计（含运杂费）工程建设其他费用1土地费用2建设单位管理费3可行性研究费4勘察设计费5环境影响评价费6工程保险费7临时设施费8联合试车费9生产准备及开办费9.1生产职工培训费及提前进场费9.2办公及生活家具购置费第一、二部分费用合计三预备费1基本预备费2涨价预备费四建设投资合计比例（%）建筑工程费设备数量设备单价设备购置费15786.318050.015786.32500010000.0230006000.01850850.0112001200.018952.515786.318050.015786.318050.039.845.6安装工程计算基数费率其他费用合计902.534738.818050.010000.06000.0850.01200.018952.52991.92991.9100.0202000.02000.034738.81.50%521.1521.1市场价66.06.034738.780.20%69.569.5市场价2525.025.034738.80.25%86.886.834738.80.5%173.7173.718050.00.5%90.390.319.519.5130.00.113.013.0130.00.056.56.5902.52991.937730.61886.51886.51886.51886.50.0902.54878.439617.22.312.3备注建筑工程费链接表2数据2为设备购置费，当设备数量较多时，也可直接将设备购置数额填写到标蓝处数字,下面的2.1-2.4直接空着或删除即可项目征地100亩，20万元亩备注：

130为劳动定员人数建筑工程费估算表（仅需填写标红部分，其余内容自云序号名称工程量（n?

）单价（元/n?

）1主粮车间1256013002洁齿骨车间1000013003湿粮车间1000013004零食车间2000013005研发检测中心800018006猫狗试验场40009007锅炉房10009008废水处理站10009009冷库8000120010智能仓库6000120011办公楼27000100012宿舍楼18000100013餐厅300090014绿化19442.132015道路及其他96919.1550合计流动资金估算表（仅需填写标红部分，标红处可调整流动资金数额，其余内容自动计算）人民币单序号项目最低周转天数周转次数1流动资产1.1应收账款15241.2存货1.2.1原辅材料15241.2.2燃料动力15241.2.3在产品21801.2.4产成品15241.3现金15242流动负债2.1应付帐款5723流动资金（1-2）4流动资金本年增加额其中:

贷款5流动资金贷款6流动资金贷款利息其中:

新增利息建设期投产期达产期12345840.211111.611111.61903.63594.93594.93806.77362.37362.31666.73333.33333.313.113.113.1247.9470.1470.11879.03545.73545.7129.9154.5154.5559.91115.51115.5559.91115.51115.55280.39996.19996.15280.34715.80.03696.23301.10.03696.26997.36997.3160.8304.4304.4160.8143.60.0流动资金估算表（仅需填写标红部分，标红处可调整流动资金数额，其余内容自动计算）5678911111.611111.611111.611111.611111.63594.93594.93594.93594.93594.97362.37362.37362.37362.37362.33333.33333.33333.33333.33333.313.113.113.113.113.1470.1470.1470.1470.1470.13545.73545.73545.73545.73545.7154.5154.5154.5154.5154.51115.51115.51115.51115.51115.51115.51115.51115.51115.51115.59996.19996.19996.19996.19996.10.00.00.00.00.00.00.00.00.00.06997.36997.36997.36997.36997.3304.4304.4304.4304.4304.40.00.00.00.00.0达产期1011111.63594.97362.33333.313.1470.13545.7154.51115.51115.59996.10.00.06997.3304.40.0位:

万元1111111.63594.97362.33333.313.1470.13545.7154.51115.51115.59996.10.00.06997.3304.40.0项目总投资使用计划与资金筹措表人民币单位:

万元序号项目年份合计建设期11总投资49613.339617.21.1建设投资39617.239617.21.2建设期利息0.00.01.3流动资金9996.10.02资金筹措49613.339617.22.1项目资本金42616.039617.22.1.1用于建设投资39617.239617.22.1.2用于建设期利息0.00.02.1.3用于流动资金2998.80.02.2债务资金6997.30.02.2.1用于建设投资0.00.02.2.2用于流动资金6997.30.02.3其他资金0.00.03资本金基数总投资42616.03.1建设投资39617.23.2建设期利息0.03.3铺底流动资金2998.84资本金比例100.0%投产期达产期235280.34715.85280.34715.85280.34715.81584.11414.81584.11414.83696.23301.13696.23301.1营业收入、营业税金及附加和增值税估算表（仅需填写标红部分，其余自动计算）人民币单位：

万元序号项目单位产量1营业收入1.1宠物粮吨800001.2软包罐头吨300001.3零食吨100001.42营业税金与附加2.1营业税2.2消费税2.3城建税2.4教育费附加3增值税3.1销项税额3.2进项税额价格（万元/单位）建设期投产期达产期123负荷100%100%59000.0#0.936000.072000.01.218000.036000.01.05000.010000.00.00.0325.8657.1190.1383.3135.8273.82715.05475.78572.617145.35857.611669.6营业收入、营业税金及附加和增值税估算表（仅需填写标红部分，其余自动计算）45678100%100%100%100%100%#72000.072000.072000.072000.072000.036000.036000.036000.036000.036000.010000.010000.010000.010000.010000.00.00.00.00.00.0657.1657.1657.1657.1657.1383.3383.3383.3383.3383.3273.8273.8273.8273.8273.85475.75475.75475.75475.75475.717145.317145.317145.317145.317145.311669.611669.611669.611669.611669.6达产期91011100%100%100%#72000.072000.072000.036000.036000.036000.010000.010000.010000.00.00.00.0657.1657.1657.1383.3383.3383.3273.8273.8273.85475.75475.75475.717145.317145.317145.311669.611669.611669.6总成本费用估算表（此处无需填写，均有公式链接）人民币单位：

万元序号项目合计建设期1生产负荷1外购原材料费7600002外购燃料及动力费31443工资福利费94624修理费225585其他费用270185.1其他制造费用110775.2其他管理费用47315.3其他营业费用112106经营成本（1+2+3+4+5）8221827折旧费451168摊销费209利息支出290010总成本费用合计C6+7+8+9）87021810.1其中：

可变成本77530010.2固定成本94918投产期达产期234550%100%100%100%40000.080000.080000.080000.0314.4314.4314.4314.4946.2946.2946.2946.22255.82255.82255.82255.82170.82760.82760.82760.81107.71107.71107.71107.7473.1473.1473.1473.1590.01180.01180.01180.045687.286277.286277.286277.24511.64511.64511.64511.62.02.02.02.0160.8304.4304.4304.450361.591095.191095.191095.141850.681494.481494.481494.48511.09600.89600.89600.8678910100%100%100%100%100%80000.080000.080000.080000.080000.0314.4314.4314.4314.4314.4946.2946.2946.2946.2946.22255.82255.82255.82255.82255.82760.82760.82760.82760.82760.81107.71107.71107.71107.71107.7473.1473.1473.1473.1473.11180.01180.01180.01180.01180.086277.286277.286277.286277.286277.24511.64511.64511.64511.64511.62.02.02.02.02.0304.4304.4304.4304.4304.491095.191095.191095.191095.191095.181494.481494.481494.481494.481494.49600.89600.89600.89600.89600.8达产期11100%80000.0314.4946.22255.82760.81107.7473.11180.086277.24511.62.0304.491095.181494.49600.8外购原材料及燃料动力费估算表（仅需填写标红部分，其余自动计算）人民币单位:

万元序号项目单位单价（万元/单位）-外购原辅材料1原材料种类吨0.62原材料种类吨0.4燃料动力1电万kWh0.72新水万n?

5.0年耗量计算期123负荷100%100%40000.080000.010000030000.060000.05000010000.020000.0314.4314.4448313.4313.40.19501.01.0外购原材料及燃料动力费估算表（仅需填写标红部分，其余自动计算）45678100%100%100%100%100%80000.080000.080000.080000.080000.060000.060000.060000.060000.060000.020000.020000.020000.020000.020000.0314.4314.4314.4314.4314.4313.4313.4313.4313.4313.41.01.01.01.01.0计算期91011100%100%100%80000.080000.080000.060000.060000.060000.020000.020000.020000.0314.4314.4314.4313.4313.4313.41.01.01.0固定资产折旧费估算表（此处无需填写，均有公式链接）人民币单位:

万元序号项目折旧年限建设期11建筑物20原值折旧费净值2设备10原值折旧费净值3固定资产投资原值折旧费净值运营期234515786.3749.8749.8749.8749.815036.414286.613536.712786.939597.73761.83761.83761.83761.835835.932074.128312.324550.655383.94511.64511.64511.64511.650872.346360.741849.137337.4678910749.8749.8749.8749.8749.812037.011287.210537.39787.59037.63761.83761.83761.83761.83761.820788.817027.013265.29503.45741.74511.64511.64511.64511.64511.632825.828314.223802.619290.914779.3运营期11749.88287.83761.81979.94511.610267.7工资及福利费估算表（仅需填写标红部分，其余自动计算）人民币单位：

万元序号项目合计计算期11工人人数110人均年工资6.0工资额660.02技术人员人数15人均年工资8.0工资额120.03管理人员人数5人均年工资10.0工资额50.04工资总额（1+2+3）830.05福利费116.26合计（4+5）946.223451101101101106.06.06.06.0660.0660.0660.0660.0151515158.08.08.08.0120.0120.0120.0120.0555510.010.010.010.050.050.050.050.0830.0830.0830.0830.0116.2116.2116.2116.2946.2946.2946.2946.26789101101101101101106.06.06.06.06.0660.0660.0660.0660.0660.015151515158.08.08.08.08.0120.0120.0120.0120.0120.05555510.010.010.010.010.050.050.050.050.050.0830.0830.0830.0830.0830.0116.2116.2116.2116.2116.2946.2946.2946.2946.2946.2计算期111106.0660.0158.0120.0510.050.0830.0116.2946.2项目投资现金流量表（此处无需填写，均有公式链接）人自序号项目合计建设期1生产负荷50%1现金流入1141263.81.1营业收入1121000.01.2补贴收入1.3回收固定资产余值10267.71.4回收流动资金9996.12现金流出930030.739617.22.1建设投资39617.239617.22.2流动资金9996.10.02.3经营成本822181.60.02.4营业税金及附加6239.50.02.5增值税51996.22.6维持运营投资3所得税前净现金流量（1-2）211233.1-39617.24累计所得税前净现金流量1139674.2-39617.25调整所得税48861.70.06所得税后净现金流量（3-5）162371.4-39617.27累计所得税后净现金流量888167.6-39617.2计算指标所得税前所得税后项目投资财务内部收益率44.91%36.23%项目投资财务净现值（i=13%）73706.651403.4项目投资回收期（年）1.992.06投产期达产期2345100%100%100%59000.0118000.0118000.0118000.059000.0118000.0118000.0118000.054008.397125.892409.992409.95280.34715.845687.286277.286277.286277.2325.8657.1657.1657.12715.05475.75475.75475.74991.720874.225590.125590.14991.725866.051456.077046.11439.65269.15269.15269.13552.115605.120320.920320.93552.119157.239478.259799.1计算指标所得税前所得税后项目投资财务内部收益率44.91%36.23%项目投资财务净现值（i=13%）73706.651403.4项目投资回收期（年）1.992.066789100%100%100%100%118000.0118000.0118000.0118000.0118000.0118000.0118000.0118000.092409.992409.992409.992409.986277.286277.286277.286277.2657.1657.1657.1657.15475.75475.75475.75475.725590.125590.125590.125590.1102636.1128226.2153816.3179406.35269.15269.15269.15269.120320.920320.920320.920320.980120.0100441.0120761.9141082.9计算指标所得税前所得税后项目投资财务内部收益率44.91%36.23%项目投资财务净现值（i=13%）73706.651403.4项目投资回收期（年）1.992.06达产期%币单位：

万元1011100%100%118000.0138263.8118000.0118000.010267.79996.192409.992409.986277.286277.2657.1657.15475.75475.725590.145853.9204996.4250850.35269.15269.120320.940584.8161403.8201988.6项目资本金现金流量表（此处无需填写，均有公式链接）人民币单序号项目合计建设期1生产负荷（%）1现金流入1141263.81.1营业收入1121000.01.2补贴收入0.01.3回收固定资产余值10267.71.4回收流动资金9996.12现金流出972484.239617.22.1项目资本金42616.039617.22.3借款本金偿还1314.20.02.4借款利息支付0.00.02.5经营成本822181.60.02.6营业税金及附加6239.50.02.7所得税48136.70.02.8增值税51996.22.9维持运营投资0.00.03净现金流量（1-2）168779.6-39617.2计算指标：

资本金财务内部收益率40.16%投产期达产期23455010010010059000.0118000.0118000.0118000.059000.0118000.0118000.0118000.051711.599017.797603.097603.01584.11414.80.00.00.00.00.00.00.045687.286277.286277.286277.2325.8657.1657.1657.11399.45193.05193.05193.02715.05475.75475.75475.70.00.00.00.07288.518982.320397.020397.0678910100100100100100118000.0118000.0118000.0118000.0118000.0118000.0118000.0118000.0118000.0118000.097603.097603.097603.097603.098260.00.00.00.00.0657.10.00.00.00.00.086277.286277.286277.286277.286277.2657.1657.1657.1657.1657.15193.05193.05193.05193.05193.05475.75475.75475.75475.75475.70.00.00.00.00.020397.020397.020397.020397.019740.0达产期位：

万元11100138263.8118000.010267.79996.198260.0657.10.086277.2657.15193.05475.70.040003.8利润和利润分配表（此处无需填写，均有公式链接，需要修改的地方仅为生产负荷，例如生产第一年左序号项目合计建设期1生产负荷1营业收入#02营业税金及附加624003增值税519964总成本费用87021805补贴收入6利润总额（1-2-3-4+5）19254707弥补以前年度亏损008应纳税所得额（6-7）19254709所得税48137010净利润（6-9）144410011期初未分配利润12可供分配的利润（10+11）13提取法定盈余公积金14441014可供投资者分配的利润（12-13）15应付优先股股利16提取任意盈余公积金17应付普通股股利（14-15-16）投产期达产期2345100%100%100%100%59000.0118000.0118000.0118000.0325.8657.1657.1657.12715.05475.75475.75475.7503629109591095910955597.720772.120772.120772.10.00.00.00.05597.720772.120772.120772.11399.45193.05193.05193.04198.315579.115579.115579.14198.315579.115579.115579.1419.81557.91557.91557.93778.414021.214021.214021.2188.9701.1701.1701.10.00.00.00.0利润和利润分配表（此处无需填写，均有公式链接，需要修改的地方仅为生产负荷，例如生产第一年左678100%100%100%118000.0118000.0118000.0657.1657.1657.15475.75475.75475.791095910959109520772.120772.120772.10.00.00.020772.120772.120772.15193.05193.05193.015579.115579.115579.115579.115579.115579.11557.91557.91557.914021.214021.214021.2701.1701.1701.10.00.00.0达产期18各投资方利润分配：

其中：

投资方19未分配利润（14-15-16-17）1234710其中：

偿还借款累计未分配利润20息税前利润（利润总额+利息支出）195447021息税折旧摊销前利润（息稅前利润+折旧+摊销）24058300.00.00.00.03589.513320.113320.113320.13589.516909.630229.743549.85758.521076.521076.521076.5