投資項(xiàng)目財(cái)務(wù)計(jì)算模型全套表格含公式自動(dòng)計(jì)算頁(yè)巖磚項(xiàng)目一期.xls
下載文檔
上傳人:正***
編號(hào):850777
2023-12-20
15頁(yè)
57.50KB
1、借款還本付息計(jì)算表 單位:萬(wàn)元頁(yè)頁(yè)巖巖磚磚廠廠一一期期項(xiàng)項(xiàng)目目序序號(hào)號(hào)項(xiàng)項(xiàng)目目利利率率建建設(shè)設(shè)期期投投產(chǎn)產(chǎn)期期達(dá)達(dá)產(chǎn)產(chǎn)期期201120112012201220132013201420141 1借借款款及及還還本本付付息息1.11.1年年初初借借款款累累計(jì)計(jì)-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本本年年應(yīng)應(yīng)計(jì)計(jì)利利息息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償償還還借借款款本本金金的的資資金金來(lái)來(lái)源源-7,0727,07217,94217,94220,37420,33、742.1利潤(rùn)42742712,48712,48715,89315,8932.2折舊6,5456,5455,3555,3554,3824,3822.3攤銷(xiāo)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借款還本付息計(jì)算表 單位:萬(wàn)元頁(yè)頁(yè)巖巖磚磚廠廠一一期期項(xiàng)項(xiàng)目目達(dá)達(dá)產(chǎn)產(chǎn)期期項(xiàng)目建成后三年還款寬限期短期還款在貸款第二年年底還與當(dāng)年計(jì)入的利息相同損損益益表表 單單位位:萬(wàn)萬(wàn)元元頁(yè)頁(yè)巖巖磚磚廠廠一一期期項(xiàng)項(xiàng)目目序序號(hào)號(hào)項(xiàng)項(xiàng)目目合合計(jì)計(jì)投投產(chǎn)產(chǎn)期5、期達(dá)達(dá)產(chǎn)產(chǎn)期期201220122013201320142014生生產(chǎn)產(chǎn)負(fù)負(fù)荷荷60601001001001001 1 產(chǎn)產(chǎn)品品銷(xiāo)銷(xiāo)售售收收入入(不不含含增增值值稅稅)318,000318,00018,00018,00030,00030,00030,00030,0002 2銷(xiāo)銷(xiāo)售售稅稅金金及及附附加加(不不含含增增值值稅稅)5,1905,1902942944904904904903 3總總成成本本費(fèi)費(fèi)用用(不不含含增增值值稅稅)128,334128,33417,27917,27917,02417,02413,61813,6184 4利利潤(rùn)潤(rùn)總總額額184,476184,47642742712,46、8712,48715,89315,8935 5彌彌補(bǔ)補(bǔ)以以前前年年度度虧虧損損0 00 00 00 06 6應(yīng)應(yīng)納納稅稅所所得得額額184,476184,47642742712,48712,48715,89315,8937 7所所得得稅稅46,11946,1191071073,1223,1223,9733,9738 8稅稅后后利利潤(rùn)潤(rùn)138,357138,3573203209,3659,36511,92011,9208.1盈余公積金6,2846,28432329379371,1921,1928.2應(yīng)付利潤(rùn)-8.3未分配利潤(rùn)132,073132,0732882888,4298,42910,7287、10,728累計(jì)未分配利潤(rùn)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、萬(wàn)萬(wàn)元元頁(yè)頁(yè)巖巖磚磚廠廠一一期期項(xiàng)項(xiàng)目目達(dá)達(dá)產(chǎn)產(chǎn)期期2022202210010030,00030,0004904908,6698,66920,84120,8410 020,84120,8415,2105,210企業(yè)所得稅25%15,63115,631法定盈余公積金按稅后利潤(rùn)的10%提取,當(dāng)盈余公積金已達(dá)注冊(cè)資本的50%時(shí),即不再提取15,63115,631項(xiàng)目建成后三年還款寬限期132,073132,073短期還款在貸款第二年年底還損損益益表表 單單位位:萬(wàn)萬(wàn)元元法定盈余公積金按稅后利潤(rùn)的10%提取,當(dāng)盈余公積金已達(dá)注冊(cè)資本的50%時(shí),即不再提取總成本費(fèi)用估算表 單位:萬(wàn)元頁(yè)頁(yè)巖巖磚磚廠廠一一11、期期項(xiàng)項(xiàng)目目序序號(hào)號(hào)項(xiàng)項(xiàng)目目合合計(jì)計(jì)投投產(chǎn)產(chǎn)期期達(dá)達(dá)產(chǎn)產(chǎn)期期 201220122013201320142014201520151 1外外購(gòu)購(gòu)原原材材料料31,80031,8001,8001,8003,0003,0003,0003,0003,0003,0002 2外外購(gòu)購(gòu)燃燃料料動(dòng)動(dòng)力力12,72012,7207207201,2001,2001,2001,2001,2001,2003工工資資及及福福利利費(fèi)費(fèi)11,35211,3521,0321,0321,0321,0321,0321,0321,0321,0324修修理理費(fèi)費(fèi)15,84015,8401,4401,4401,4401,4401,44012、1,4401,4401,4405折折舊舊費(fèi)費(fèi)31,00031,0006,5456,5455,3555,3554,3824,3823,5853,5856攤攤銷(xiāo)銷(xiāo)費(fèi)費(fèi)1,1001,1001001001001001001001001007利利息息支支出出4,3414,3412,1012,1011,7281,728512512-7.1長(zhǎng)期借款利息4,3414,3412,1012,1011,7281,728512512-7.2流動(dòng)資金借款利息-8其其他他費(fèi)費(fèi)用用15,84015,8401,4401,4401,4401,4401,4401,4401,4401,4409總總成成本本費(fèi)費(fèi)用用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經(jīng)經(jīng)營(yíng)營(yíng)成成本本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原材料由項(xiàng)目公司內(nèi)部提供,只考慮開(kāi)采成本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按固定資產(chǎn)投資4%計(jì)算2,9332,9332,4002,4001,9641,9641,6071,6071,3141,314457457457457殘值5000100100100100100100100100100100100100100100 無(wú)形資產(chǎn)為1100萬(wàn)元-項(xiàng)目開(kāi)始運(yùn)作前兩年向銀行借流動(dòng)資金1,4401,4401,4401,4401,4401,4401,4401,4401,4401,4401,4401,4401,4401,440按固定資產(chǎn)投資4%計(jì)算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總成本費(fèi)用估算表 單位:萬(wàn)元頁(yè)頁(yè)巖巖磚磚廠廠一一期期項(xiàng)項(xiàng)目目達(dá)達(dá)產(chǎn)產(chǎn)期期 工資4293.43的2倍,按照8600元計(jì)算雙倍余額遞減法原材料由項(xiàng)目公司17、內(nèi)部提供,只考慮開(kāi)采成本按固定資產(chǎn)投資4%計(jì)算無(wú)形資產(chǎn)為1100萬(wàn)元項(xiàng)目開(kāi)始運(yùn)作前兩年向銀行借流動(dòng)資金按固定資產(chǎn)投資4%計(jì)算投投資資計(jì)計(jì)劃劃與與資資金金來(lái)來(lái)源源 單位:萬(wàn)元頁(yè)頁(yè)巖巖磚磚廠廠一一期期項(xiàng)項(xiàng)目目序序號(hào)號(hào)項(xiàng)項(xiàng)目目合合計(jì)計(jì)建建設(shè)設(shè)期期投投產(chǎn)產(chǎn)期期20112011201220121 1總總投投資資¥43,35443,354¥37,01337,013¥4,1014,1011.1固定資產(chǎn)投資¥36,00036,000¥36,00036,000¥-1.2建設(shè)期利息¥5,3545,354¥1,0131,013¥2,1012,101 1.2.2固定資產(chǎn)利息¥5,3545,354¥1,0131,01318、¥2,1012,101 1.2.2流動(dòng)資金利息¥-¥-¥-1.3流動(dòng)資金¥2,0002,000¥-¥2,0002,0002 2資資金金來(lái)來(lái)源源¥43,35443,354¥37,01337,013¥4,1014,1012.1自有資金¥11,00011,000¥9,0009,000¥2,0002,000 2.1.1固定資產(chǎn)投資¥9,0009,000¥9,0009,000 2.1.2流動(dòng)資金¥2,0002,000¥2,0002,0002.2固定資產(chǎn)投資借款¥32,35432,354¥28,01328,013¥2,1012,101 2.2.1建行借款當(dāng)年借款¥27,00027,000¥27,0002719、,000待還利息¥5,3545,354¥1,0131,013¥2,1012,101累計(jì)貸款金額¥32,35432,354¥28,01328,013¥30,11330,1132.3流動(dòng)資金借款¥-¥-¥-當(dāng)年借款¥-待還利息¥-¥-達(dá)達(dá)產(chǎn)產(chǎn)期期 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¥-¥-¥-投投資資計(jì)20、計(jì)劃劃與與資資金金來(lái)來(lái)源源 單位:萬(wàn)元銷(xiāo)售收入、銷(xiāo)售稅金及附加估算表 單位:萬(wàn)元頁(yè)頁(yè)巖巖磚磚廠廠一一期期項(xiàng)項(xiàng)目目序序號(hào)號(hào)項(xiàng)項(xiàng)目目合合計(jì)計(jì)投投產(chǎn)產(chǎn)期期達(dá)達(dá)產(chǎn)產(chǎn)期期 201220122013201320142014201520151 1產(chǎn)產(chǎn)品品銷(xiāo)銷(xiāo)售售收收入入318,000318,00018,00018,00030,00030,00030,00030,00030,00030,0002 2銷(xiāo)售稅金及附加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銷(xiāo)售稅額(17%)54,06054,0603,0603,0605,1005,1005,1005,1005,1005,100 2.1.2進(jìn)項(xiàng)稅額2,1622,1621221222042042042042042042.2城市維護(hù)建設(shè)稅(7%)3,6333,6332062063433433433433433432.3教育費(fèi)附加(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銷(xiāo)售收入、銷(xiāo)售稅金及附加估算表 單位:萬(wàn)元頁(yè)頁(yè)巖巖磚磚廠廠一一期期項(xiàng)項(xiàng)目目達(dá)達(dá)產(chǎn)產(chǎn)期期 投入運(yùn)營(yíng)后一年內(nèi)達(dá)到最大產(chǎn)量的60%,第二年達(dá)到最大頁(yè)巖磚單價(jià)1.5元/塊(標(biāo)磚)
地產(chǎn)商業(yè)
上傳時(shí)間:2024-11-21
85份
地產(chǎn)規(guī)劃
上傳時(shí)間:2024-10-10
163份
水利工程
上傳時(shí)間:2024-11-05
31份
合同表格
上傳時(shí)間:2024-12-17
28份
運(yùn)營(yíng)管理
上傳時(shí)間:2023-11-22
22份
運(yùn)營(yíng)管理
上傳時(shí)間:2021-04-30
8份