《建設(shè)項(xiàng)目評(píng)估》課程設(shè)計(jì)

河北農(nóng)業(yè)大學(xué)現(xiàn)代科技學(xué)院《建設(shè)項(xiàng)目評(píng)估》課程設(shè)計(jì)——希望新建電子配件廠項(xiàng)目評(píng)估報(bào)告2017年月日目錄一、課程設(shè)計(jì)基礎(chǔ)資料1、生產(chǎn)規(guī)模2、實(shí)行進(jìn)度3、建設(shè)投資估量4、流動(dòng)資本估量5、投資使用計(jì)劃與資本根源6、銷售收入和銷售稅金及附帶估量7、產(chǎn)品總成本估量8、利潤測算9、評(píng)論參數(shù)二、項(xiàng)目財(cái)務(wù)效益評(píng)估1、項(xiàng)目協(xié)助財(cái)務(wù)報(bào)表1.1產(chǎn)品銷售收入和銷售稅金及附帶估量表1.2總成本花費(fèi)估量表1.3固定財(cái)產(chǎn)折舊、無形財(cái)產(chǎn)及遞延財(cái)產(chǎn)攤銷估量表1.4借錢還本付息表1.5建設(shè)項(xiàng)目投資估量表1.6投資使用計(jì)劃于資本籌備表2、項(xiàng)目基本財(cái)務(wù)報(bào)表2.1項(xiàng)目資本金現(xiàn)金流量表2.2利潤與利潤分派表2.3項(xiàng)目投資現(xiàn)金流量表3、評(píng)論指標(biāo)3.1盈余能力評(píng)論指標(biāo)3.2清賬能力評(píng)論指標(biāo)三、項(xiàng)目風(fēng)險(xiǎn)評(píng)估1、盈虧均衡剖析2、單要素敏感性剖析四、項(xiàng)目評(píng)估結(jié)論一、課程設(shè)計(jì)基礎(chǔ)資料生產(chǎn)規(guī)模該項(xiàng)目建成后擬生產(chǎn)當(dāng)前市場上所需的計(jì)算機(jī)配件，設(shè)計(jì)生產(chǎn)規(guī)模為年產(chǎn)100萬件。實(shí)行進(jìn)度該項(xiàng)目擬二年建成，第三年投產(chǎn)，當(dāng)年生產(chǎn)負(fù)荷達(dá)到設(shè)計(jì)生產(chǎn)能力的70%，第四年達(dá)到90%，第五年達(dá)到100%。生產(chǎn)期按12年計(jì)算，計(jì)算期為14年。建設(shè)投資估量經(jīng)估量，該項(xiàng)目建設(shè)投資總數(shù)為5700萬元（不含建設(shè)期利息），此中：估計(jì)形成固定財(cái)產(chǎn)4910萬元，無形財(cái)產(chǎn)490萬元，其余財(cái)產(chǎn)300萬元。流動(dòng)資本估量該項(xiàng)目的流動(dòng)資本估量總數(shù)為1150萬元。投資使用計(jì)劃與資本根源建設(shè)投資分年使用計(jì)劃按第一年投入2000萬元，第二年投入3700萬元；流動(dòng)資本從投產(chǎn)第一年開始按生產(chǎn)負(fù)荷進(jìn)行安排。該項(xiàng)目的資本金為2110萬元，此頂用于建設(shè)投資1700萬元，其余用于流動(dòng)資金。建設(shè)投資缺口部分由中國建設(shè)銀行貸款解決，年利率為6%（可參照有關(guān)銀行官方網(wǎng)站獲得最新利率信息）；流動(dòng)資本缺口部分由中國工商銀行貸款解決，年利率為4%。銷售收入和銷售稅金及附帶估量依據(jù)市場剖析，估計(jì)產(chǎn)品的市場售價(jià)（不含稅）為100元／件（任選范圍內(nèi)的數(shù)值）。本產(chǎn)品采納價(jià)外計(jì)稅，增值稅稅率為17%，城市保護(hù)建設(shè)稅和教育費(fèi)附帶的稅率分別為7%和3%。產(chǎn)品總成本估量（1）該項(xiàng)目正常年份的外購原資料、燃料動(dòng)力費(fèi)（不含稅）為5000萬元；（2）據(jù)測算，該項(xiàng)目的年薪資及福利費(fèi)估量為150萬元；（3）固定財(cái)產(chǎn)折舊費(fèi)按均勻年限法計(jì)算，折舊年限為12年，殘值率為5%；4）無形財(cái)產(chǎn)按10年攤銷，其余財(cái)產(chǎn)按5年攤銷；5）維修費(fèi)按折舊費(fèi)的4%計(jì)??；6）年其余花費(fèi)為320萬元；（7）項(xiàng)目在生產(chǎn)經(jīng)營時(shí)期的應(yīng)計(jì)利息所有計(jì)入財(cái)務(wù)花費(fèi)。建設(shè)投資借錢在生產(chǎn)經(jīng)營期按整年計(jì)息；流動(dòng)資本當(dāng)年借錢按整年計(jì)息。利潤測算1）所得稅率按25%考慮；2）盈余公積金按稅后利潤的10%計(jì)取。評(píng)論參數(shù)設(shè)基準(zhǔn)利潤率為15%；基準(zhǔn)投資利潤率和資本金凈利潤率分別為20%和30%；基準(zhǔn)的靜態(tài)投資回收期和動(dòng)向投資回收期分別為7年和10年；中國建設(shè)銀行對(duì)這種項(xiàng)目所要求的借錢償還期不可以超出6年。建設(shè)投資借錢本金償還：等本金償還，利息照付。按年進(jìn)行償還。二、項(xiàng)目財(cái)務(wù)效益評(píng)估1、項(xiàng)目協(xié)助財(cái)務(wù)報(bào)表1.1產(chǎn)品銷售收入和銷售稅金及附帶估量表計(jì)算期序號(hào)項(xiàng)目

建稅設(shè)率期

生產(chǎn)期123456789101112131100010001000100010001000100010001000100營業(yè)收入70009000000000000.數(shù)目（萬件）709010010010010010010010010010010.市場售價(jià)（不含稅）10010010010010010010010010010010010.0.110171307145214521452145214521452145214521452145進(jìn)項(xiàng)稅7.09.69.99.99.99.99.99.99.99.99.99.9222.247.247.247.247.247.247.247.247.247.247增值稅91310101010101010101010.10171307145214521452145214521452145214521452145進(jìn)項(xiàng)稅額.09.69.99.99.99.99.99.99.99.99.99.9.銷項(xiàng)稅額11901530170017001700170017001700170017001700170銷售稅金17.222.224.724.724.724.724.724.724.724.724.724.及附帶93000000000.城市保護(hù)12.115.517.217.217.217.217.217.217.217.217.217.建設(shè)稅06999999999.教育費(fèi)附加5.196.677.417.417.417.417.417.417.417.417.417.4第三年投產(chǎn)，當(dāng)年生產(chǎn)負(fù)荷達(dá)到設(shè)計(jì)生產(chǎn)能力的70%，第四年達(dá)到90%，第五年達(dá)到100%。生產(chǎn)期按12年計(jì)算，計(jì)算期為14年第三年?duì)I業(yè)收入=100*0.7*100=7000（萬元）進(jìn)項(xiàng)稅=7000/1.17*0.17=1017.09（萬元）銷項(xiàng)稅額=7000*0.17=1190（萬元）增值稅=1190-1017.09=172.91城市建設(shè)保護(hù)稅=172.91*0.07=12.10教育費(fèi)附帶=172.91*0.03=5.19銷售稅金及附帶=12.10+5.19=17.29第四年?duì)I業(yè)收入=100*0.9*100=9000（萬元）進(jìn)項(xiàng)稅=9000/1.17*0.17=1307.69（萬元）銷項(xiàng)稅額=9000*0.17=1530增值稅=1530-1307.69=222.31城市建設(shè)保護(hù)稅=222.31*0.07=15.56教育費(fèi)附帶=222.31*0.03=6.67銷售稅金及附帶=15.56+6.67=22.23第5-14年?duì)I業(yè)收入=100*100=10000（萬元）進(jìn)項(xiàng)稅=1000/1.17*0.17=1452.99（萬元）銷項(xiàng)稅額=1000*0.17=1700（萬元）增值稅=1700-1452.99=247.01城市建設(shè)保護(hù)稅=247.01*0.07=17.29教育費(fèi)及附帶=247.01*0.03=7.41銷售稅金及附帶=7.41+17.29=24.701.2總成本花費(fèi)估量表1234567891011350045005000500050005000500050005000515015015015015015015015015016.1216.1216.1216.1216.1216.1216.1216.1216.12163203203203203203203203203203986.124986.125486.125486.125486.125486.125486.125486.125486.125486403.10403.10403.10403.10403.10403.10403.10403.10403.1040310910910910910949494949280.51238.69196.87155.06113.2471.4229.6029.6029.60294778.735736.916195.106153.286111.466009.645967.825967.825967.82596736504650515051505150515051505150515051128.7321086.9141045.0971003.279961.462859.644817.824817.824817.824817.（1）該項(xiàng)目正常年份的外購原資料、燃料動(dòng)力費(fèi)（不含稅）為5000萬元；（2）據(jù)測算，該項(xiàng)目的年薪資及福利費(fèi)估量為150萬元；（3）固定財(cái)產(chǎn)折舊費(fèi)按均勻年限法計(jì)算，折舊年限為12年，殘值率為5%；（4）無形財(cái)產(chǎn)按10年攤銷，其余財(cái)產(chǎn)按5年攤銷；（5）維修費(fèi)按折舊費(fèi)的4%計(jì)?。?）年其余花費(fèi)為320萬元；折舊費(fèi)，攤銷費(fèi)下表計(jì)算1.3固定財(cái)產(chǎn)折舊、無形財(cái)產(chǎn)和其余財(cái)產(chǎn)攤銷估量表、無形財(cái)產(chǎn)和其余財(cái)產(chǎn)攤銷估量表固定財(cái)產(chǎn)總值5091.81234567891011091.84688.704285.603882.503479.403076.302673.202270.101867.001463.901060.8003.10403.10403.10403.10403.10403.10403.10403.10403.10403.10403.10688.74285.603882.503479.403076.302673.202270.101867.001463.901060.80657.7049044139234329424519614798494949494949494949494944139234329424519614798490300240180120606060606060240180120600估計(jì)形成固定財(cái)產(chǎn)4910萬元，無形財(cái)產(chǎn)490萬元，其余財(cái)產(chǎn)300萬元。固定財(cái)產(chǎn)總值=30+151.80+4910=5091.80（萬元）折舊年限為12年殘值為5%，年均折舊額=5091.80*0.95/12=403.10殘值為5091.80*0.05=254.60無形財(cái)產(chǎn)為490萬元攤銷10年，其余財(cái)產(chǎn)300萬元攤銷5年前五年攤銷花費(fèi)=490/10+300/5=109元后5年為49萬元維修費(fèi)為折舊費(fèi)的4%=403.10*0.04=16.12萬元1.4借錢還本付息表(等本金償還，利息照付）借錢還本付息表(等本金償還，利息照付）利率123456789101110304181.803484.842787.882090.921393.96697.00.00%10003000.00%30151.8280.51238.69196.87155.06113.2471.4229.6029.6029.6029.00%696.96696.96696.96696.96696.96697.00.00%280.51238.69196.87155.06113.2471.4229.6029.6029.6029.00%10304181.83484.842787.882090.921393.96697.000.00建設(shè)期借錢12建設(shè)投資自由資本1000700貸款10003000流動(dòng)資本自有資本410貸款740因此建設(shè)期第一年利息為1000*0.5*0.06=30（萬元）第二年利息為(1030+0.5*3000）*0.06=151.8(萬元)第3-8年利息為年初借錢還本累計(jì)*0.06+流動(dòng)資本的利息流動(dòng)資本利息從第三開始為740*0.04=29.60等本金償還，利息照付等本金=4181.80/6=696.96（萬元）1.5建設(shè)項(xiàng)目投資估量表(未考慮建設(shè)期利息）建設(shè)項(xiàng)目投資估量表(未考慮建設(shè)期利息）序號(hào)項(xiàng)目共計(jì)1固定財(cái)產(chǎn)花費(fèi)49002無形財(cái)產(chǎn)花費(fèi)4903其余財(cái)產(chǎn)花費(fèi)3004建設(shè)投資共計(jì)5700經(jīng)估量，該項(xiàng)目建設(shè)投資總數(shù)為5700萬元（不含建設(shè)期利息），此中：估計(jì)形成固定財(cái)產(chǎn)4910萬元，無形財(cái)產(chǎn)490萬元，其余財(cái)產(chǎn)300萬元1.6投資項(xiàng)目計(jì)劃于資本籌備表1總投資8087.581.1建設(shè)投資57001.2建設(shè)期利息1237.581.3流動(dòng)資本11502資本籌備8087.582.1項(xiàng)目資本金21102.1.1用于建設(shè)投資17002.2.2用于流動(dòng)資本4102.2債務(wù)資本5977.582.2.1用于建設(shè)投資40002.2.2用于建設(shè)期利息1237.582.2.3用于流動(dòng)資本740表中數(shù)據(jù)根源1.4和1.5項(xiàng)目基本財(cái)務(wù)報(bào)表12345678910117000900010000100001000010000100001000010000700090001000010000100001000010000100001000010007005565.986788.327383.817352.457321.087304.766598.596598.596598.59100070034.134.134.134.134.134.134.134.134.1696.96696.96696.96696.96696.96697.00280.51238.69196.87155.06113.2471.4259.2059.2059.203986.124986.125486.125486.125486.125486.125486.125486.125486.1217.2922.2324.7024.7024.7024.7024.7024.7024.70550.99810.21945.05955.50965.96991.41994.47994.47994.4700.00-700.001434.022211.682616.192647.552678.922695.243401.413401.413401.41.86960.75610.65750.57180.49720.43230.37590.32690.28430.24720.214969.57-529.30942.891264.541300.711144.611007.10881.08966.89840.78731.1169.57-1398.87-455.97808.562109.273253.884260.995142.076108.966949.747680.842.2利潤及利潤分派表12345678910110.00007000900010000100001000010000100001000010000106.5317.2922.2324.7024.7024.7024.7024.7024.7024.70241.674778.735736.916195.106153.286111.466009.645997.425997.425997.4259970.001.802203.983240.853780.203822.023863.843965.663977.883977.883977.8839770.001.802203.983240.853780.203822.023863.843965.663977.883977.883977.8839770.45550.99810.21945.05955.50965.96991.41994.47994.47994.479941.351652.982430.642835.152866.512897.882974.242983.412983.412983.4129830.00000000001.351652.982430.642835.152866.512897.882974.242983.412983.412983.4129833.13165.30243.06283.52286.65289.79297.42298.34298.34298.342988.211487.682187.582551.642579.862608.092676.822685.072685.072685.0726850.000.000.000.000.002.782484.493479.553977.083977.083977.084037.084037.084037.084037.0840379.982996.593991.654489.184489.184489.184489.184489.184489.184489.1844892.3項(xiàng)目投資現(xiàn)金流量表合計(jì)1234567891011121314現(xiàn)金116102流99470090010010010010010010010054.1001071入.600000000000000000600401營116700900100100100100100100100100100100.業(yè)00000000000000000000000001收.00入回收固定資產(chǎn).余2542542值.60.6回收流動(dòng).資7403金.00740現(xiàn)709200370409510560560560560560560560560560560270.0.00.09.24.16.66.66.66.66.66.66.66.66.66.6金流0200485555555559出建2設(shè)570.投0.02003701資000流2動(dòng)115.資0.095.95.95.95.95.95.95.95.95.95.95.95.2金0838383838383838383838387經(jīng)2營638398498548548548548548548548548548548.成33.6.16.16.16.16.16.16.16.16.16.16.16.13本49242424242424242424242424營業(yè)2稅.28617.22.24.24.24.24.24.24.24.24.24.24.金4.53292370707070707070707070及附加維持運(yùn)營.投0.05資0所得稅前凈現(xiàn)金460-20-37290389439439439439439439439464439513流24.00.00.0.75.83.33.33.33.33.33.33.37.93.33.33量580000625555555551累244-20-57-27109548988142186230274318364408460470000.00.99.6.59.93.276.69.63.56.49.97.91.24.計(jì)所.780000247266195306499932858得稅前凈現(xiàn)金流量調(diào)整所129109109109109109109109116109128得31.7259738.38.38.38.38.38.38.31.98.33.35稅15.19.954444444943所得稅330-20-37217292329329329329329329329348329384后93.00.00.5.51.85.05.05.05.05.05.05.05.95.09.9凈6440000761111111618現(xiàn)金流量累計(jì)所得稅后凈現(xiàn)金164-20-57-35-60269598928125158191224259292330流50000.00.24.2.52.47.42.477.72.67.62.48.43.93.7量.580000437455464748494546442.1、2.2、2.3表中數(shù)據(jù)來自1項(xiàng)目協(xié)助財(cái)務(wù)報(bào)表評(píng)論指標(biāo)3.1盈余能力指標(biāo)財(cái)務(wù)凈現(xiàn)值為累計(jì)折現(xiàn)金流量最后一年=9498.47內(nèi)部利潤率0.57用excelIRR函數(shù)數(shù)據(jù)源為折現(xiàn)金流量靜態(tài)投資回收期=3+455.97/2211.68=3.21動(dòng)向投資回收期==3+445.97/1264.54=3.35投資利潤率=年均息稅前利潤（12年算）比上總投資（根源資本籌備表中）=47.66%資本金利潤率=年據(jù)凈利潤（12年算）比上總投資=34.65%3.2清賬能力指標(biāo)償債備付率=息稅前利潤/對(duì)付利息償債備付率=（息稅前利潤加折舊加攤銷-公司所得稅）/應(yīng)還本付息金額1234567891011121314利息885145202256351565681681681681690690備付.717.70.14.92.12.59.39.39.39.32.12.1率%7%2%4%5%8%8%8%8%8%5%5%償債250340396414434455590590590590588588備付.20.02.51.74.86.19