投资项目财务计算模型全套表格含公式自动计算页岩砖项目一期.xls
下载文档
上传人:正***
编号:850777
2023-12-20
15页
57.50KB
1、借款还本付息计算表 单位:万元页页岩岩砖砖厂厂一一期期项项目目序序号号项项目目利利率率建建设设期期投投产产期期达达产产期期201120112012201220132013201420141 1借借款款及及还还本本付付息息1.11.1年年初初借借款款累累计计-28,01328,01323,04123,0416,8276,827建行借款7.5%7.5%28,01328,01323,04123,0416,8276,827短期借款7.5%7.5%-1.21.2本本年年借借入入本本金金27,00027,000-建行借款27,00027,000短期借款1.31.3本本年年应应计计利利息息1,0131,012、32,1012,1011,7281,728512512建行借款1,0131,0132,1012,1011,7281,728512512短期借款-1.41.4本本年年偿偿还还本本金金-4,9714,97116,21416,2146,8276,827建行借款4,9714,97116,21416,2146,8276,827短期借款1.51.5本本年年支支付付利利息息-2,1012,1011,7281,728512512建行借款2,1012,1011,7281,728512512短期借款2 2偿偿还还借借款款本本金金的的资资金金来来源源-7,0727,07217,94217,94220,37420,33、742.1利润42742712,48712,48715,89315,8932.2折旧6,5456,5455,3555,3554,3824,3822.3摊销1001001001001001002.4短期借款2015201520162016201720172018201820192019202020202021202120222022-21,39821,39821,39821,39821,39821,39821,39821,39821,39821,39821,39821,39821,39821,39821,39821,39817,71317,71318,36518,36518,89918,89914、9,33519,33519,69219,69219,98419,98420,84120,84120,84120,8413,5853,5852,9332,9332,4002,4001,9641,9641,6071,6071,3141,314457457457457100100100100100100100100100100100100100100100100借款还本付息计算表 单位:万元页页岩岩砖砖厂厂一一期期项项目目达达产产期期项目建成后三年还款宽限期短期还款在贷款第二年年底还与当年计入的利息相同损损益益表表 单单位位:万万元元页页岩岩砖砖厂厂一一期期项项目目序序号号项项目目合合计计投投产产期5、期达达产产期期201220122013201320142014生生产产负负荷荷60601001001001001 1 产产品品销销售售收收入入(不不含含增增值值税税)318,000318,00018,00018,00030,00030,00030,00030,0002 2销销售售税税金金及及附附加加(不不含含增增值值税税)5,1905,1902942944904904904903 3总总成成本本费费用用(不不含含增增值值税税)128,334128,33417,27917,27917,02417,02413,61813,6184 4利利润润总总额额184,476184,47642742712,46、8712,48715,89315,8935 5弥弥补补以以前前年年度度亏亏损损0 00 00 00 06 6应应纳纳税税所所得得额额184,476184,47642742712,48712,48715,89315,8937 7所所得得税税46,11946,1191071073,1223,1223,9733,9738 8税税后后利利润润138,357138,3573203209,3659,36511,92011,9208.1盈余公积金6,2846,28432329379371,1921,1928.2应付利润-8.3未分配利润132,073132,0732882888,4298,42910,7287、10,728累计未分配利润2882888,7178,71719,44419,4442015201520162016201720172018201820192019202020202021202110010010010010010010010010010010010010010030,00030,00030,00030,00030,00030,00030,00030,00030,00030,00030,00030,00030,00030,00049049049049049049049049049049049049049049011,79711,79711,14511,14510,61210,618、210,17610,1769,8199,8199,5269,5268,6698,66917,71317,71318,36518,36518,89918,89919,33519,33519,69219,69219,98419,98420,84120,8410 00 00 00 00 00 00 017,71317,71318,36518,36518,89918,89919,33519,33519,69219,69219,98419,98420,84120,8414,4284,4284,5914,5914,7254,7254,8344,8344,9234,9234,9964,9965,2105,29、1013,28513,28513,77413,77414,17414,17414,50114,50114,76914,76914,98814,98815,63115,6311,3291,3291,3771,3771,4171,41711,95711,95712,39712,39712,75712,75714,50114,50114,76914,76914,98814,98815,63115,63131,40131,40143,79743,79756,55456,55471,05571,05585,82485,824100,812100,812116,443116,443损损益益表表 单单位位:10、万万元元页页岩岩砖砖厂厂一一期期项项目目达达产产期期2022202210010030,00030,0004904908,6698,66920,84120,8410 020,84120,8415,2105,210企业所得税25%15,63115,631法定盈余公积金按税后利润的10%提取,当盈余公积金已达注册资本的50%时,即不再提取15,63115,631项目建成后三年还款宽限期132,073132,073短期还款在贷款第二年年底还损损益益表表 单单位位:万万元元法定盈余公积金按税后利润的10%提取,当盈余公积金已达注册资本的50%时,即不再提取总成本费用估算表 单位:万元页页岩岩砖砖厂厂一一11、期期项项目目序序号号项项目目合合计计投投产产期期达达产产期期 201220122013201320142014201520151 1外外购购原原材材料料31,80031,8001,8001,8003,0003,0003,0003,0003,0003,0002 2外外购购燃燃料料动动力力12,72012,7207207201,2001,2001,2001,2001,2001,2003工工资资及及福福利利费费11,35211,3521,0321,0321,0321,0321,0321,0321,0321,0324修修理理费费15,84015,8401,4401,4401,4401,4401,44012、1,4401,4401,4405折折旧旧费费31,00031,0006,5456,5455,3555,3554,3824,3823,5853,5856摊摊销销费费1,1001,1001001001001001001001001007利利息息支支出出4,3414,3412,1012,1011,7281,728512512-7.1长期借款利息4,3414,3412,1012,1011,7281,728512512-7.2流动资金借款利息-8其其他他费费用用15,84015,8401,4401,4401,4401,4401,4401,4401,4401,4409总总成成本本费费用用128,3341213、8,33417,27917,27917,02417,02413,61813,61811,79711,7979.1固固定定成成本本79,47379,47312,65812,65811,09511,0958,9068,9067,5977,5979.2可可变变成成本本48,86148,8614,6214,6215,9285,9284,7124,7124,2004,20010经经营营成成本本91,89391,8938,5338,5339,8409,8408,6248,6248,1128,112201620162017201720182018201920192020202020212021202220214、23,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,0003,000原材料由项目公司内部提供,只考虑开采成本1,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,2001,0321,0321,0321,0321,0321,0321,0321,0321,0321,0321,0321,0321,0321,032 全厂100人1,4401,4401,4401,4401,4401,4401,4401,4401,4401,4401,4401,4401,15、4401,440按固定资产投资4%计算2,9332,9332,4002,4001,9641,9641,6071,6071,3141,314457457457457残值5000100100100100100100100100100100100100100100 无形资产为1100万元-项目开始运作前两年向银行借流动资金1,4401,4401,4401,4401,4401,4401,4401,4401,4401,4401,4401,4401,4401,440按固定资产投资4%计算11,14511,14510,61210,61210,17610,1769,8199,8199,5269,5268,6616、98,6698,6698,6696,9456,9456,4126,4125,9765,9765,6195,6195,3265,3264,4694,4694,4694,4694,2004,2004,2004,2004,2004,2004,2004,2004,2004,2004,2004,2004,2004,2008,1128,1128,1128,1128,1128,1128,1128,1128,1128,1128,1128,1128,1128,112总成本费用估算表 单位:万元页页岩岩砖砖厂厂一一期期项项目目达达产产期期 工资4293.43的2倍,按照8600元计算双倍余额递减法原材料由项目公司17、内部提供,只考虑开采成本按固定资产投资4%计算无形资产为1100万元项目开始运作前两年向银行借流动资金按固定资产投资4%计算投投资资计计划划与与资资金金来来源源 单位:万元页页岩岩砖砖厂厂一一期期项项目目序序号号项项目目合合计计建建设设期期投投产产期期20112011201220121 1总总投投资资¥43,35443,354¥37,01337,013¥4,1014,1011.1固定资产投资¥36,00036,000¥36,00036,000¥-1.2建设期利息¥5,3545,354¥1,0131,013¥2,1012,101 1.2.2固定资产利息¥5,3545,354¥1,0131,01318、¥2,1012,101 1.2.2流动资金利息¥-¥-¥-1.3流动资金¥2,0002,000¥-¥2,0002,0002 2资资金金来来源源¥43,35443,354¥37,01337,013¥4,1014,1012.1自有资金¥11,00011,000¥9,0009,000¥2,0002,000 2.1.1固定资产投资¥9,0009,000¥9,0009,000 2.1.2流动资金¥2,0002,000¥2,0002,0002.2固定资产投资借款¥32,35432,354¥28,01328,013¥2,1012,101 2.2.1建行借款当年借款¥27,00027,000¥27,0002719、,000待还利息¥5,3545,354¥1,0131,013¥2,1012,101累计贷款金额¥32,35432,354¥28,01328,013¥30,11330,1132.3流动资金借款¥-¥-¥-当年借款¥-待还利息¥-¥-达达产产期期 2013201320142014¥1,7281,728¥512512¥-¥-¥1,7281,728¥512512¥1,7281,728¥512512¥-¥-¥-¥-¥1,7281,728¥512512总投资41725.86利率7.50%¥1,7281,728¥512512¥1,7281,728¥512512¥31,84231,842¥-¥-¥-投投资资计20、计划划与与资资金金来来源源 单位:万元销售收入、销售税金及附加估算表 单位:万元页页岩岩砖砖厂厂一一期期项项目目序序号号项项目目合合计计投投产产期期达达产产期期 201220122013201320142014201520151 1产产品品销销售售收收入入318,000318,00018,00018,00030,00030,00030,00030,00030,00030,0002 2销售税金及附加57,08757,0873,2313,2315,3865,3865,3865,3865,3865,3862.1增值税51,89851,8982,9382,9384,8964,8964,8964,89621、4,8964,896 2.1.1销售税额(17%)54,06054,0603,0603,0605,1005,1005,1005,1005,1005,100 2.1.2进项税额2,1622,1621221222042042042042042042.2城市维护建设税(7%)3,6333,6332062063433433433433433432.3教育费附加(3%)1,5571,55788881471471471471471472016201620172017201820182019201920202020202120212022202230,00030,00030,00030,00030,000322、0,00030,00030,00030,00030,00030,00030,00030,00030,0005,3865,3865,3865,3865,3865,3865,3865,3865,3865,3865,3865,3865,3865,3864,8964,8964,8964,8964,8964,8964,8964,8964,8964,8964,8964,8964,8964,8965,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,1005,100204204204204204204204204204204204204204204343343343343343343343343343343343343343343147147147147147147147147147147147147147147销售收入、销售税金及附加估算表 单位:万元页页岩岩砖砖厂厂一一期期项项目目达达产产期期 投入运营后一年内达到最大产量的60%,第二年达到最大页岩砖单价1.5元/块(标砖)
地产规划
上传时间:2024-10-10
163份