投资项目财务计算模型全套表格含公式自动计算页岩砖项目二期.xls
下载文档
上传人:正***
编号:850776
2023-12-20
15页
55.50KB
1、借款还本付息计算表 单位:万元页页岩岩砖砖厂厂二二期期项项目目序序号号项项目目利利率率建建设设期期投投产产期期达达产产期期201320132014201420152015201620161 1借借款款及及还还本本付付息息1.11.1年年初初借借款款累累计计-56,02556,02546,08246,08213,65413,654建行借款7.5%7.5%56,02556,02546,08246,08213,65413,654短期借款7.5%7.5%-1.21.2本本年年借借入入本本金金54,00054,000-建行借款54,00054,000短期借款1.31.3本本年年应应计计利利息息2,0252、2,0254,2024,2023,4563,4561,0241,024建行借款2,0252,0254,2024,2023,4563,4561,0241,024短期借款-1.41.4本本年年偿偿还还本本金金-9,9439,94332,42832,42813,65413,654建行借款9,9439,94332,42832,42813,65413,654短期借款1.51.5本本年年支支付付利利息息-4,2024,2023,4563,4561,0241,024建行借款4,2024,2023,4563,4561,0241,024短期借款2 2偿偿还还借借款款本本金金的的资资金金来来源源-14,145143、,14535,88435,88440,74940,7492.1利润-2,100-2,10023,19623,19630,82530,8252.2折旧16,00016,00012,44412,4449,6799,6792.3摊销2442442442442442442.4短期借款201720172018201820192019202020202021202120222022-42,79742,79742,79742,79742,79742,79742,79742,79742,79742,79742,79742,79735,02435,02436,69736,69737,99837,99839,014、039,01041,35441,35441,35441,3547,5287,5285,8555,8554,5544,5543,5423,5421,1991,1991,1991,199244244244244244244244244244244244244借款还本付息计算表 单位:万元页页岩岩砖砖厂厂二二期期项项目目达达产产期期项目建成后三年还款宽限期短期还款在贷款第二年年底还与当年计入的利息相同损损益益表表 单单位位:万万元元页页岩岩砖砖厂厂二二期期项项目目序序号号项项目目合合计计投投产产期期达达产产期期201420142015201520162016生生产产负负荷荷60601001001005、1001 1 产产品品销销售售收收入入(不不含含增增值值税税)516,000516,00036,00036,00060,00060,00060,00060,0002 2销销售售税税金金及及附附加加(不不含含增增值值税税)8,4218,4215885889799799799793 3总总成成本本费费用用(不不含含增增值值税税)224,220224,22037,51237,51235,82535,82528,19628,1964 4利利润润总总额额283,359283,359-2,100-2,10023,19623,19630,82530,8255 5弥弥补补以以前前年年度度亏亏损损2,1002,6、1000 02,1002,1000 06 6应应纳纳税税所所得得额额281,259281,259-2,100-2,10021,09621,09630,82530,8257 7所所得得税税70,84070,840-5,2745,2747,7067,7068 8税税后后利利润润212,519212,519-2,100-2,10017,92217,92223,11923,1198.1盈余公积金12,33312,333-1,7921,7922,3122,3128.2应付利润-8.3未分配利润200,186200,186-2,100-2,10016,12916,12920,80720,807累计未分配利7、润804,903804,903-2,100-2,10014,03014,03034,83734,8379 9本本公公司司获获得得利利润润20172017201820182019201920202020202120212022202210010010010010010010010010010010010060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00060,00097997997997997997997997997997997997923,99723,99722,32422,32421,02221,02220,08、1020,01017,66717,66717,66717,66735,02435,02436,69736,69737,99837,99839,01039,01041,35441,35441,35441,3540 00 00 00 00 00 035,02435,02436,69736,69737,99837,99839,01039,01041,35441,35441,35441,3548,7568,7569,1749,1749,5009,5009,7539,75310,33810,33810,33810,33826,26826,26827,52327,52328,49928,49929,2589、29,25831,01531,01531,01531,0152,6272,6272,7522,7522,8502,85023,64123,64124,77124,77125,64925,64929,25829,25831,01531,01531,01531,01558,47858,47883,24983,249108,898108,898138,155138,155169,171169,171200,186200,186损损益益表表 单单位位:万万元元页页岩岩砖砖厂厂二二期期项项目目达达产产期期企业所得税25%法定盈余公积金按税后利润的10%提取,当盈余公积金已达注册资本的50%时,即不再提取10、项目建成后三年还款宽限期短期还款在贷款第二年年底还法定盈余公积金按税后利润的10%提取,当盈余公积金已达注册资本的50%时,即不再提取总成本费用估算表 单位:万元页页岩岩砖砖厂厂二二期期项项目目序序号号项项目目合合计计投投产产期期达达产产期期 20142015201620171 1外外购购原原材材料料51,60051,6003,6003,6006,0006,0006,0006,0006,0006,0002 2外外购购燃燃料料动动力力20,64020,6401,4401,4402,4002,4002,4002,4002,4002,4003工工资资及及福福利利费费18,57618,5762,06411、2,0642,0642,0642,0642,0642,0642,0644修修理理费费25,92025,9202,8802,8802,8802,8802,8802,8802,8802,8805折折旧旧费费62,00062,00016,00016,00012,44412,4449,6799,6797,5287,5286摊摊销销费费2,2002,2002442442442442442442442447利利息息支支出出8,6828,6824,2024,2023,4563,4561,0241,024-7.1长期借款利息8,6828,6824,2024,2023,4563,4561,0241,024-7.12、2流动资金借款利息-8其其他他费费用用25,92025,9202,8802,8802,8802,8802,8802,8802,8802,8809总总成成本本费费用用224,220224,22037,51237,51235,82535,82528,19628,19623,99723,9979.1固固定定成成本本143,298143,29828,27028,27023,96923,96918,77118,77115,59715,5979.2可可变变成成本本80,92280,9229,2429,24211,85611,8569,4249,4248,4008,40010经经营营成成本本151,338113、51,33817,06617,06619,68019,68017,24817,24816,22416,224201820192020202120226,0006,0006,0006,0006,0006,0006,0006,0006,0006,000原材料由项目公司内部提供,只考虑开采成本2,4002,4002,4002,4002,4002,4002,4002,4002,4002,4002,0642,0642,0642,0642,0642,0642,0642,0642,0642,064全厂200人工资4293.43的2倍,按照8600元计算2,8802,8802,8802,8802,8802,814、802,8802,8802,8802,880按固定资产投资4%计算5,8555,8554,5544,5543,5423,5421,1991,1991,1991,199残值10000双倍余额递减法244244244244244244244244244244无形资产为2200万元-项目开始运作前两年向银行借流动资金2,8802,8802,8802,8802,8802,8802,8802,8802,8802,880按固定资产投资4%计算22,32422,32421,02221,02220,01020,01017,66717,66717,66717,66713,92413,92412,62212,6215、211,61011,6109,2679,2679,2679,2678,4008,4008,4008,4008,4008,4008,4008,4008,4008,40016,22416,22416,22416,22416,22416,22416,22416,22416,22416,224总成本费用估算表 单位:万元页页岩岩砖砖厂厂二二期期项项目目达达产产期期 工资4293.43的2倍,按照8600元计算投投资资计计划划与与资资金金来来源源 单位:万元页页岩岩砖砖厂厂二二期期项项目目序序号号项项目目合合计计建建设设期期投投产产期期20132013201420141 1总总投投资资¥86,7078616、,707¥74,02574,025¥8,2028,2021.1固定资产投资¥72,00072,000¥72,00072,000¥-1.2建设期利息¥10,70710,707¥2,0252,025¥4,2024,202 1.2.2固定资产利息¥10,70710,707¥2,0252,025¥4,2024,202 1.2.2流动资金利息¥-¥-¥-1.3流动资金¥4,0004,000¥-¥4,0004,0002 2资资金金来来源源¥86,70786,707¥74,02574,025¥8,2028,2022.1自有资金¥22,00022,000¥18,00018,000¥4,0004,000 2.117、.1固定资产投资¥18,00018,000¥18,00018,000 2.1.2流动资金¥4,0004,000¥4,0004,0002.2固定资产投资借款¥64,70764,707¥56,02556,025¥4,2024,202 2.2.1建行借款当年借款¥54,00054,000¥54,00054,000待还利息¥10,70710,707¥2,0252,025¥4,2024,202累计贷款金额¥64,70764,707¥56,02556,025¥60,22760,2272.3流动资金借款¥-¥-¥-当年借款¥-待还利息¥-¥-达达产产期期 2015201520162016¥3,4563,4518、6¥1,0241,024¥-¥-¥3,4563,456¥1,0241,024¥3,4563,456¥1,0241,024¥-¥-¥-¥-¥3,4563,456¥1,0241,024总投资41725.86利率7.50%¥3,4563,456¥1,0241,024¥3,4563,456¥1,0241,024¥63,68363,683¥-¥-¥-投投资资计计划划与与资资金金来来源源 单位:万元销售收入、销售税金及附加估算表 单位:万元页页岩岩砖砖厂厂二二期期项项目目序序号号项项目目合合计计投投产产期期达达产产期期 20142015201620171 1产产品品销销售售收收入入516,000516,019、0036,00036,00060,00060,00060,00060,00060,00060,0002 2销售税金及附加92,63292,6326,4636,46310,77110,77110,77110,77110,77110,7712.1增值税84,21184,2115,8755,8759,7929,7929,7929,7929,7929,792 2.1.1销售税额(17%)87,72087,7206,1206,12010,20010,20010,20010,20010,20010,200 2.1.2进项税额3,5093,5092452454084084084084084082.2城市维护20、建设税(7%)5,8955,8954114116856856856856856852.3教育费附加(3%)2,5262,5261761762942942942942942942018201920202021202260,00060,00060,00060,00060,00060,00060,00060,00060,00060,00010,77110,77110,77110,77110,77110,77110,77110,77110,77110,7719,7929,7929,7929,7929,7929,7929,7929,7929,7929,79210,20010,20010,20010,20010,20010,20010,20010,20010,20010,200408408408408408408408408408408685685685685685685685685685685294294294294294294294294294294销售收入、销售税金及附加估算表 单位:万元达达产产期期 投入运营后一年内达到最大产量的60%,第二年达到最大页岩砖单价1.5元/块(标砖)
地产规划
上传时间:2024-10-10
163份