上傳人:正***
編號:857475
2023-12-22
24頁
126KB
1、基礎數據表項目單位數值期初資本金萬元10000期初資金萬元8488貸款利率%5.85%X銷售比例%90.00%Y銷售比例%90.00%W銷售比例%90.00%公積金提取比例%10.00%公益金提取比例%10.00%營業稅緊急附加比率%5.55%土地增值稅比率%1.00%所得稅率%16.50%0.00%內部收益率測算基準比率%10.00%項目總體投入銷售毛利率%19.89%X銷售價格元10000Y銷售價格元3000W銷售價格元6000項目單位年 度1234土地畝180018002412X8000080000W1000015000Y600005000060000本年投資額的80%80%上年投資額的2、20%20%568000064002203346000042001經經濟濟評評價價指指標標匯匯總總表表序號指標名稱單位數量一一項項目目基基本本數數據據1項目總投資萬元2976352自有資金萬元100003借貸資金萬元974643營業收入萬元3715226利潤總額萬元495537所得稅萬元22428稅后利潤萬元47311二二項項目目經經濟濟指指標標1全投資內部收益率%2資本金內部收益率%215.74%3投資利潤率%16.65%9投資回收期年4.9510借款償還期年2.89資產負債試算第一年第二年項目借方貸方項目借方貸方存貨38919.1649131.1212978.16在建開發產品現金381193、.0048119.1669564.0069564.26在建工程固定資產凈值9200.0019372.04固定資產投資借款18000.00開發產品投資借款20119.0053364.00資本金公積金216.07公益金216.07未分配利潤0.001728.590.0086238.1686238.160.00138067.16138067.16第三年第四年第五年項目借方貸方項目借方貸方項目78499.0872821.9035884.7277147.9596881.0096881.0496300.0082351.3712428.012040.005981.0014138.0023981.0012124、.421284.441212.421284.449699.3210275.520.00187808.09187808.090.00172343.72172343.720.00資產負債試算第六年借方貸方項目借方貸方28262.3679455.4721863.3053196.2099180.3695426.5368942.0729333.2959345.001190.57827.591190.57827.599524.586620.71186787.72186787.720.0090805.3790805.37第五年資產負債表序號項目第一年第二年第三年1資產48119.00103643.741215、748.891.1流動資產總額38919.0075071.7080748.841.1.1應收賬款0.000.000.001.1.2存貨38919.1675072.1280749.30其中:在建開發產品1.1.3現金(0.16)(0.42)(0.45)1.2在建工程1.3固定資產凈值9200.0028572.0441000.051.4無形及遞延資產凈值2負債及所有者權益48119.00103643.74121748.892.1流動負債總額0.000.000.002.1.1應付帳款0.000.000.002.1.2短期借款2.2借款38119.0091483.0097464.002.2.1經營資金6、借款2.2.2固定資產投資借款18000.0018000.0023981.002.2.3開發產品投資借款20119.0073483.0073483.00負債小計38119.0091483.0097464.002.3所有者權益10000.0012160.7424284.892.3.1資本金10000.0010000.0010000.002.3.2公積金0.00216.071428.492.3.3公益金0.00216.071428.492.3.4累計未分配利潤0.001728.5911427.923資產負債率79.22%88.27%80.05%第四年第五年第六年96474.2949035.02577、310.9053434.245994.9714270.850.000.000.0039486.07(11707.04)(43039.94)13948.1817702.0157310.7943040.0543040.0543040.0596474.2949035.0257310.900.000.000.000.000.000.0059345.000.000.000.000.0059345.000.0059345.000.000.0037129.2949035.0257310.9010000.0010000.0010000.002712.933903.504731.092712.933903.508、4731.0921703.4431228.0137848.7261.51%0.00%0.00%資金來源與運用表序號項目合計第一年第二年1資金來源478986.4348119.0069564.001.1銷售收入371522.430.0016200.001.2資本金10000.0010000.001.3銀行貸款97464.0038119.0053364.002資金運用421675.6448119.1669564.262.1建設投資280879.4847004.1864712.302.6借款償還97464.000.000.002.2財務費用16755.041114.983790.862.3土地增值稅9、3715.220.00162.002.4經營稅金及附加20619.490.00899.102.5所得稅2242.400.000.003盈余資金183415.37(1114.98)9187.304累計盈余資金183415.37(1114.98)8072.32說明1.借款為彌補投入資金缺口2.累計盈余資金即為當年先進存量第三年第四年第五年第六年96881.0096300.0099180.3668942.0790900.0096300.0099180.3668942.075981.000.000.000.0096881.0482351.3795426.5329333.2985400.3933338.10、0626526.5223898.040.0038119.0059345.000.005526.704586.661735.840.00909.00963.00991.80689.425044.955344.655504.513826.280.000.001322.86919.5467295.2034442.2918374.6355230.9475367.52109809.80128184.43183415.37資金來源與運用表貸款還本付息結算表序號項目合計第一年第二年第三年第四年1 借款還本付息1.1第一筆借款年初借款累計381193811938119本年借款3811938119本年應計利息611、6901115223022301115本年償付本金3811938119本年償付利息66901115223022301115年末借款余額38119381193811901.2第二筆借款年初借款累計5336453364本年借款5336453364本年應計利息9365156131223122本年償付本金53364本年償付利息9365156131223122年末借款余額5336453364533641.3第三筆借款年初借款累計5981本年借款59815981本年應計利息700175350本年償付本金5981本年償付利息700175350年末借款余額598159811.4借款匯總年初借款累計03811912、9148397464本年借款97464381195336459810本年應計利息167551115379155274587本年償付本金9746400038119本年償付利息167551115379155274587年末借款余額381199148397464593452 借款還本付息資金來源02.1 投資收回47311021611212412844第五年第六年00000533641561533641561059811755981175059345000173605934501736000119068276資資本本金金財財務務現現金金流流量量表表序號項目合計第一年第二年第三年第四年1現金流入0.013、016200.0090900.0096300.001.1銷售收入(專指銷售回款)371522.430.0016200.0090900.0096300.002現金流出198107.0611114.987012.7023604.8061857.712.1自有資金10000.0010000.002.2銷售收入再投入47310.900.002160.7412124.1512844.402.6借款本金償還97464.0038119.002.7借款利息償還16755.041114.983790.865526.704586.662.4土地增值稅3715.220.00162.00909.00963.002.314、經營稅金及附加20619.490.00899.105044.955344.652.5所得稅2242.400.000.000.000.003凈現金流量173415.37-11114.989187.3067295.2034442.294折現凈現金流量78865.97-9271.146392.0139053.3216672.11累計折現凈現金流量78865.97-9271.14-2879.1436174.1852846.291.財務內部收益率:215.74%2.財務凈現值:114158.33第五年第六年99180.3668942.0799180.3668942.0780805.7313711.13115、1905.728275.8859345.001735.840.00991.80689.425504.513826.281322.86919.5418374.6355230.947418.9418600.7460265.2378865.97損損益益表表序號項目合計第一年第二年第三年第四年第五年1銷售收入3715220162009090096300991802總成本費用2976340129787282277148794554土地增值稅37150162909963992銷售稅金及附加2061908995045534555055利潤總額49553021611212412844132296所得稅224216、000013237稅后利潤47311021611212412844119068盈余公積金473102161212128411919公益金4731021612121284119110可分配利潤37849017299699102769525投資利潤率16.65%投資利稅率24.83%資本金利潤率495.53%萬元第六年68942552316893826919592082768288286621投資計劃與資金籌措表序號項目合計第一年第二年第三年1 投資總額2976354811968503909271.1 建設投資280879470046471285400 1.1.1 土地成本60120180001817、00024120 1.1.2 前期工程費7127225321152285 1.1.3 建安工程費13240192002369230628 1.1.4 基礎設施費54883131721646520856 1.1.5 公建配套設施費32211681420896 1.1.6 開發期間稅費0 1.1.7 不可預見費7733132918212364 1.1.8 管理費7965136918752434 1.1.9 銷售費用7430032418181.2 貸款利息167551115379155271.3 流動資金00002 資金籌措2976344811968503909272.1 自有資金10000100018、02.2 借款97464381195336459812.3 銷售收入再投入19017001513984946說明從第四年開始,資金平衡需要的銷售收入再投入,僅需部分銷售回收資金即可第四年第五年第六年3792528262238983333826527238980004740024520231342122743910022400888694637915715656192619841379458717360000379252826223898000379252826223898從第四年開始,資金平衡需要的銷售收入再投入,僅需部分銷售回收資金即可銷售計劃表銷售年度物業第一年第二年第三年第四年第五年第六19、年合計X建成面積()0080,00080,00080,00064,002304,002銷售比例90%90%90%90%銷售面積(按實現90%計)72,00072,00072,00057,602273,602銷售單價(元/)10,00010,00010,00010,000銷售收入(萬元)72,00072,00072,00057,602273,602Y建成面積()060,00050,00060,00060,00042,001272,001銷售比例90%90%90%90%90%銷售面積()54,00045,00054,00054,00037,801244,801銷售單價(元/)3,0003,000320、,0003,0003,000銷售收入(萬元)16,20013,50016,20016,20011,34073,440W建成面積()0010,00015,00020,334045,334銷售比例90%90%90%銷售面積(按實現90%計)9,00013,50018,30140,801銷售單價(元/)6,0006,0006,000銷售收入(萬元)5,4008,10010,98024,480銷售收入合計16,20090,90096,30099,18068,942371,522分 年 度 投 資 計 劃 表序號項目合計(萬元)建設經營期(年)單位:萬元第一年第二年第三年第四年第五年1 1開開發發成成本21、本265,48445,63562,51381,14830,49723,8281.1土地成本60,12018,00018,00024,1201.2前期工程費7,1272,2532,1152,2854741.2.1規劃設計費4,3001,2041,3331,4623011.2.2可行性研究費6625301321.2.3地質勘探費662159199252531.2.4三通一平1,5033614515711201.3建筑安裝工程費132,4019,20023,69230,62824,52023,1341.3.1*園7,1405,7121,4281.3.2X60,80012,80016,00016,0022、01.3.3K4,2003,3608401.3.4J10,0008,0002,0001.3.5W4,0807201,2601,7341.3.6GL20,0008,0002,0008,0002,0001.3.7GLH1,5001,2003001.3.8Y24,4804,3204,6805,2205,4001.3.9EX200160401.4基礎設施費54,88313,17216,46520,8564,3911.5公建配套費3,2211,6814208962241.6不可預見費7,7331,3291,8212,3648886942 2開開發發費費用用32,1502,4845,9909,7797,423、284,4342.1管理費用7,9651,3691,8752,4349157152.2銷售費用7,43003241,8181,9261,9842.3財務費用16,7551,1153,7915,5274,5871,736合計297,63548,11968,50390,92737,92528,262合計(不含財務費用)280,87947,00464,71285,40033,33826,527第六年21,86321,22716,0003664,8606372,0356561,379023,89823,898投資估算表序號項目單位數量單價(元)總金額(萬元)備 注開發成本土地費土地畝6012100,024、0060,120小小計計60,12060,120前期工程費規劃設計費m2716670604,300可行性研究萬元1324000.50%662地質勘探費萬元1324000.50%662三通一平畝60122,5001,503小小計計7,1277,127建筑安裝工程費*園m2476001,5007,140 Xm23040022,00060,800Km2140003,0004,200Jm2200005,00010,000Wm2453349004,080GL個2100,000,00020,000GLHm230005,0001,500Ym227200190024,480EXm210002,000200建建25、筑筑面面積積小小計計m2705,937705,937132,400132,400基礎設施費道路m22580011002,580排水m2716670201,433園林m2716670402,867供水m2716670201,433供電m2716670302,150電訊m271667010717煤氣m271667010717消防m271667010717智能化m2716670302,150大市政畝4012100,00040,120小小計計54,88354,883公建配套SCm280001,200960HHm213331,200160污水及中水處理站m2109001水處理設備套37002,100小小26、計計m210103,2213,221不可預見費萬元257,752257,7527,7337,733按前5項合計的3%計算開發期間稅費0 00 0開開發發成成本本合合計計265,484265,484開發費用財務費用萬元16,755管理費用7,965管理費按開發成本的3%計算銷售費用7,430按銷售收入的2%計算小小計計32,15032,150投投資資總總額額297,634297,634物業細分表類別內容物業構成/數量占地面積容積率建筑面積(平方米)畝平方米*園A14026666.80.410667234B120133330.45333234C115100000.440002D150333340.27、310000234EGL20001333340GLH40266673000EX50333351000410666756005106667400067F130200000.480002345*園園合合計計2265151001051600 J160400000.520000K170466670.314000234會會計計中中心心合合計計1308666734000L X152010133380.3304002Y5103400020.8272001 W1701133340.445334 HH30200000.48000 SC533331333*生生活活社社區區合合計計2235149000763067028、M 192613340 2106667400 3 4 53872580010 66724480020 72211473340配配套套設設施施合合計計1382921338400總總 計計60124008022716670*地塊用地平衡表單位:畝序號物業類別業態內容占地面積占地率1*園A400.67B200.33C150.25D500.83E211035.10F300.50小小計計2265226537.6737.672JJ601.00K*701.16*小小計計1301302.162.163L1152025.2825108.4831702.834300.50550.08小小計計2235223537.1837.184M1100.17234921.5353876.44667211.1872213.68小小計計1382138222.9922.995合合 計計60126012100.00100.00