1、123456銷銷售售價(jià)價(jià)格格(元元/平平方方米米)均價(jià) 項(xiàng)目1(住宅)30003100 項(xiàng)目2(小高層)340035003600 項(xiàng)目3(高層)41004200 項(xiàng)目4(商業(yè))11700 項(xiàng)目5(地下車位)銷銷售售計(jì)計(jì)劃劃(平平方方米米)144000 項(xiàng)目1(住宅)619203456027360 項(xiàng)目2(小高層)4464012960244807200 項(xiàng)目3(高層)25920201605760 項(xiàng)目4(商業(yè))1152011520 項(xiàng)目5(地下車位)0開開發(fā)發(fā)計(jì)計(jì)劃劃(平平方方米米)144000 項(xiàng)目1(多層)土建576004000017600 項(xiàng)目1(多層)安裝576003000027600
2、項(xiàng)目2(小高層)土建4320020000200003200 項(xiàng)目2(小高層)安裝43200150001500013200 項(xiàng)目3(高層)土建288001000018800 項(xiàng)目3(高層)安裝2880028800 項(xiàng)目4(商業(yè))土建1440014400 項(xiàng)目4(商業(yè))安裝1440014400 項(xiàng)目5(地下車位)土建0 項(xiàng)目5(地下車位)安裝0回回款款計(jì)計(jì)劃劃 項(xiàng)目1(住宅)100%100%項(xiàng)目2(小高層)100%100%100%項(xiàng)目3(高層)100%100%項(xiàng)目4(商業(yè))100%100%項(xiàng)目5(地下車位)出出租租價(jià)價(jià)格格(元元/平平方方米米)項(xiàng)目1(地上車位)項(xiàng)目2 項(xiàng)目3出出租租計(jì)計(jì)劃劃(平平
3、方方米米)項(xiàng)目1(地上車位)項(xiàng)目2 項(xiàng)目3出出租租率率(%)(%)項(xiàng)目1(地上車位)項(xiàng)目2 項(xiàng)目3土地費(fèi)用序號(hào)項(xiàng)目合計(jì)1234561土地出讓金10800108002征地費(fèi)用03拆遷安置補(bǔ)償費(fèi)04土地轉(zhuǎn)讓費(fèi)05土地租用費(fèi)06土地投資折價(jià)07交易服務(wù)費(fèi)18184%交易契稅43243200000共計(jì)112501125000000前期工程費(fèi)用序號(hào)項(xiàng)目合計(jì)1234561規(guī)劃設(shè)計(jì)研究費(fèi)4004002水文地質(zhì)勘測(cè)費(fèi)03道路費(fèi)04供水費(fèi)05供電費(fèi)05三通一平03%其他4847710010120700共計(jì)88447710010120700前期工程費(fèi)用投入計(jì)劃100%20%30%30%15%5%884177265
4、265133440基礎(chǔ)設(shè)施建設(shè)費(fèi)用序號(hào)項(xiàng)目合計(jì)1234561供電工程02供水工程03供氣工程04排污工程05道路工程06通訊工程07綠化工程08照明工程09環(huán)衛(wèi)設(shè)施03%其他4847710010120700共計(jì)4847710010120700基礎(chǔ)設(shè)施建設(shè)費(fèi)用投入計(jì)劃100%20%30%30%15%5%4849714514573240公共配套設(shè)施建設(shè)費(fèi)序號(hào)項(xiàng)目合計(jì)1234561居委會(huì)02派出所03托兒所04幼兒園05公共廁所06停車場(chǎng)03%其他4847710010120700共計(jì)4847710010120700公共配套設(shè)施建設(shè)費(fèi)投入計(jì)劃100%20%30%30%15%5%484971451457
5、3240建筑安裝工程費(fèi)用序號(hào)項(xiàng)目合計(jì)1234561 項(xiàng)項(xiàng)目目1 1(住住宅宅)374437442550119400001.1 土建工程費(fèi)34563456240010560000 建筑面積(平方米)40000176000000 單價(jià)(元/平方米)6006006006006006006001.2 安裝工程費(fèi)2882881501380000 建筑面積(平方米)30000276000000 單價(jià)(元/平方米)505050505050502 項(xiàng)項(xiàng)目目2 2(小小高高層層)47524752021502150452002.1 土建工程費(fèi)4320432002000200032000 建筑面積(平方米)0200
6、0020000320000 單價(jià)(元/平方米)10001000100010001000100010002.2 安裝工程費(fèi)432432015015013200 建筑面積(平方米)015000150001320000 單價(jià)(元/平方米)1001001001001001001003 項(xiàng)項(xiàng)目目3 3(高高層層)403240320012002832003.1 土建工程費(fèi)34563456001200225600 建筑面積(平方米)00100001880000 單價(jià)(元/平方米)12001200120012001200120012003.2 安裝工程費(fèi)57657600057600 建筑面積(平方米)0002
7、880000 單價(jià)(元/平方米)2002002002002002002004 項(xiàng)項(xiàng)目目4 4(商商業(yè)業(yè))360036000003600004.1 土建工程費(fèi)21602160000216000 建筑面積(平方米)0001440000 單價(jià)(元/平方米)15001500150015001500150015004.2 安裝工程費(fèi)14401440000144000 建筑面積(平方米)0001440000 單價(jià)(元/平方米)10001000100010001000100010005 項(xiàng)項(xiàng)目目5 5(地地下下車車位位)0 00000005.1 土建工程費(fèi)0 0000000 建筑面積(平方米)000000
8、單價(jià)(元/平方米)0000005.2 安裝工程費(fèi)0 0000000 建筑面積(平方米)000000 單價(jià)(元/平方米)000000共計(jì)16128255033443350688400開發(fā)間接費(fèi)序號(hào)項(xiàng)目合計(jì)1234561土地使用稅02市政支管線分?jǐn)傎M(fèi)03供電貼費(fèi)04用電權(quán)費(fèi)05分散建設(shè)市政公用設(shè)施建設(shè)費(fèi)06綠化建設(shè)費(fèi)07臨時(shí)用地08臨建費(fèi)09施工圖預(yù)算或標(biāo)底編制費(fèi)010工程合同預(yù)算或標(biāo)底審查費(fèi)011招標(biāo)管理費(fèi)012總承包管理費(fèi)013合同公證費(fèi)014施工執(zhí)照費(fèi)015工程質(zhì)量監(jiān)督費(fèi)016工程監(jiān)理費(fèi)017竣工圖編制費(fèi)018工程保險(xiǎn)費(fèi)03%其他費(fèi)用4847710010120700共計(jì)48477100101
9、20700開發(fā)間接費(fèi)投入計(jì)劃100%20%30%30%15%5%4849714514573240銷售費(fèi)用序號(hào)項(xiàng)目合計(jì)1234565.0%銷售代理費(fèi)用292951864442854379500.0%廣告宣傳及推廣費(fèi)用00000000.0%其他銷售費(fèi)用0000000共計(jì) 29295186444285437950銷售費(fèi)用投入計(jì)劃100%20%30%30%15%5%29295868798794391460項(xiàng)目總投資估算表序號(hào)項(xiàng)目合計(jì)123456一開發(fā)建設(shè)投資339871534848944901853630701房地產(chǎn)開發(fā)成本3025314601385538627935001.1土地費(fèi)用11250112
10、50000001.2前期工程費(fèi)884477100101207001.3基礎(chǔ)設(shè)施建設(shè)費(fèi)48477100101207001.4建筑安裝工程費(fèi)161282550334433506884001.5公共配套設(shè)施建設(shè)費(fèi)48477100101207001.6開發(fā)間接費(fèi)48477100101207001.7不可預(yù)見費(fèi)53995109110225002房地產(chǎn)開發(fā)費(fèi)用37347471040104060030702.1銷售費(fèi)用292958687987943914602.2管理費(fèi)用80516116116116116102.3財(cái)務(wù)費(fèi)用0000000二經(jīng)營(yíng)資金0三項(xiàng)目總投資額33987153484894490185363
11、0701開發(fā)產(chǎn)品投資339871534848944901853630702固定資產(chǎn)投資03經(jīng)營(yíng)資金0000000項(xiàng)目回款進(jìn)度表序號(hào)項(xiàng)目合計(jì)1234561項(xiàng)目1(多層)1885010368848200002項(xiàng)目2(小高層)155660440685682592003項(xiàng)目3(高層)106850008266241904項(xiàng)目4(商業(yè))1347800001347805項(xiàng)目5(地下車位)0000000小計(jì)585795857910368128888568108581589802006項(xiàng)目1(多層)1036810368103680 0項(xiàng)目2(小高層)00 00 0項(xiàng)目3(高層)00 00 0項(xiàng)目4(商業(yè))00
12、00 0項(xiàng)目5(地下車位)00 00 02007項(xiàng)目1(多層)8482848284820 0項(xiàng)目2(小高層)4406440644060 0項(xiàng)目3(高層)00 00 0項(xiàng)目4(商業(yè))00 00 0項(xiàng)目5(地下車位)00 00 02008項(xiàng)目1(多層)00 00 0項(xiàng)目2(小高層)8568856885680 0項(xiàng)目3(高層)00 00 0項(xiàng)目4(商業(yè))00 00 0項(xiàng)目5(地下車位)00 00 02009項(xiàng)目1(多層)00 00 0項(xiàng)目2(小高層)2592259225920 0項(xiàng)目3(高層)8266826682660 0項(xiàng)目4(商業(yè))00 00 0項(xiàng)目5(地下車位)00 00 02010項(xiàng)目1(多
13、層)00 00 0項(xiàng)目2(小高層)00 00 0項(xiàng)目3(高層)2419241924190 0項(xiàng)目4(商業(yè))1347813478134780 0項(xiàng)目5(地下車位)00 00 02011項(xiàng)目1(多層)00 0項(xiàng)目2(小高層)00 0項(xiàng)目3(高層)00 0項(xiàng)目4(商業(yè))00 0項(xiàng)目5(地下車位)00 0小計(jì)58579585791036812888856810858158980投資使用計(jì)劃與資金籌措表序號(hào)項(xiàng)目合計(jì)1234561總投資33987339871534848944901853630701.1經(jīng)營(yíng)資金00000001.2固定資產(chǎn)投資00000001.3開發(fā)產(chǎn)品投資3398715348489449
14、0185363070 其中:不含財(cái)務(wù)費(fèi)用33987153484894490185363070 財(cái)務(wù)費(fèi)用00000002資金籌措33986339861534848944901853630702.1權(quán)益資金1534815348000002.1.1 資本金500050002.1.2 股票融資02.1.3 股東投資10348103482.1.4 政府投資02.2債務(wù)資金40000400000002.2.1 長(zhǎng)期貸款400040002.2.2 短期貸款02.2.3 企業(yè)債券02.2.4 融資租賃02.3收入資金1463808944901853630702.3.1 預(yù)售收入1463889449018536
15、3072.3.2 租金收入02.3.3 自營(yíng)收入02.3.4 貼補(bǔ)收入02.3.5 其他收入0銷售收入與經(jīng)營(yíng)稅金估算表序號(hào)項(xiàng)目合計(jì)1234561銷售收入5857910368128888568108581589801.1可銷售面積(平方米)144000345604032024480273601728001.2平均售價(jià)元(元/平方米)30003196350039689200#DIV/0!1.3銷售比例(%)24%28%17%19%12%0%2經(jīng)營(yíng)稅金及附加322257070947159787402.1營(yíng)業(yè)稅292951864442854379502.2城市維護(hù)建設(shè)稅205364530385602.
16、3教育費(fèi)附加8816191316240土地增值稅預(yù)征估算表序號(hào)項(xiàng)目合計(jì)1234561項(xiàng)項(xiàng)目目1 1(多多層層)1.0%1.0%1.0%1.0%1.0%1.0%銷售收入1885010368848200001.0%預(yù)征稅額1881048500002項(xiàng)項(xiàng)目目2 2(小小高高層層)1.0%1.0%1.0%1.0%1.0%1.0%銷售收入155660440685682592001.0%預(yù)征稅額1560448626003項(xiàng)項(xiàng)目目3 3(高高層層)1.0%1.0%1.0%1.0%1.0%1.0%銷售收入106850008266241901.0%預(yù)征稅額107000832404項(xiàng)項(xiàng)目目4 4(商商業(yè)業(yè))1%1
17、%1%1%1%1%銷售收入1347800001347801.0%預(yù)征稅額135000013505預(yù)征土地增值稅總額586104129861091590累計(jì)預(yù)征土地增值稅104233318427586586土地增值稅估算附表序號(hào)項(xiàng)目合計(jì)1234561銷售收入5857910368128888568108581589802累計(jì)銷售收入1036823256318244268258579585793開發(fā)成本302535480698950076586619104累計(jì)開發(fā)成本548012469174762406230253302535銷售比例24%28%17%19%12%0%6累計(jì)銷售比例24%52%69%
18、88%100%100%土地增值稅估算表序號(hào)項(xiàng)目合計(jì)1234561銷售收入10126142682585792扣除項(xiàng)目76180000336284255102.1 開發(fā)成本5431624062302532.2 開發(fā)費(fèi)用54322406302502.3 銷售稅金55692347322202.4 其他扣除額108634812605103增值額00090531602804增值比例#DIV/0!#DIV/0!#DIV/0!27%38%#DIV/0!5增值稅率30%30%6速算扣除率0%0%7土地增值稅0002716480808已交土地增值稅4275869本年應(yīng)繳土地增值稅22891933自營(yíng)收入及經(jīng)營(yíng)稅金
19、估算表序號(hào)項(xiàng)目合計(jì)1234561自營(yíng)收入02經(jīng)營(yíng)稅金及附加00000002.1營(yíng)業(yè)稅00000002.2城市維護(hù)建設(shè)稅00000002.3教育費(fèi)附加00000003凈轉(zhuǎn)售收入00000003.1轉(zhuǎn)售價(jià)格03.2轉(zhuǎn)售成本03.3轉(zhuǎn)售稅金0000000租金收入及經(jīng)營(yíng)稅金估算表序號(hào)項(xiàng)目合計(jì)1234561租金收入(萬(wàn)元)00000001.1.1 可出租面積(平方米)0000001.1.2 單位租金(元/月/平方米)0000001.1.3 出租率(%)0%0%0%0%0%0%1.2.1 可出租面積(平方米)0000001.2.2 單位租金(元/月/平方米)0000001.2.3 出租率(%)0%0%0%
20、0%0%0%1.3.1 可出租面積(平方米)0000001.3.2 單位租金(元/月/平方米)0000001.3.3 出租率(%)0%0%0%0%0%0%2經(jīng)營(yíng)稅金及附加00000002.1營(yíng)業(yè)稅00000002.2城市維護(hù)建設(shè)稅00000002.3教育費(fèi)附加00000004凈轉(zhuǎn)售收入00000004.1轉(zhuǎn)售價(jià)格04.2轉(zhuǎn)售成本04.3轉(zhuǎn)售稅金0000000經(jīng)營(yíng)成本分?jǐn)偙硇蛱?hào)項(xiàng)目合計(jì)1234561 項(xiàng)項(xiàng)目目1 1(住住宅宅)43.00%已銷售面積6192034560273600000銷售比例56%44%0%0%0%0%開發(fā)總成本98185480433800002 項(xiàng)項(xiàng)目目2 2(小小高高層層)
21、31.00%已銷售面積4464001296024480720000銷售比例0%29%55%16%0%0%開發(fā)總成本91310265150071473003 項(xiàng)項(xiàng)目目3 3(高高層層)18.00%已銷售面積259200002016057600銷售比例0%0%0%78%22%0%開發(fā)總成本65750005114146104 項(xiàng)項(xiàng)目目4 4(商商業(yè)業(yè))8.00%已銷售面積115200000115200銷售比例0%0%0%0%100%0%開發(fā)總成本47300000473005 項(xiàng)項(xiàng)目目5 5(地地下下車車位位)已銷售面積0000000銷售比例#DIV/0!#DIV/0!#DIV/0!#DIV/0!#D
22、IV/0!#DIV/0!開發(fā)總成本04合計(jì)30253548069895007658661910固定資產(chǎn)折舊固定資產(chǎn)3734折舊年限20殘值率5%年折舊額177固定資產(chǎn)轉(zhuǎn)售年限15固定資產(chǎn)轉(zhuǎn)售成本1074出租部分轉(zhuǎn)售月租金(元/平方米/月)100出租面積(平方米)1000出租率(%)80%運(yùn)營(yíng)費(fèi)用(萬(wàn)元)20%凈租金收益(萬(wàn)元)76.8收益年限(年)50報(bào)酬率(%)8%轉(zhuǎn)售價(jià)格(萬(wàn)元)940自營(yíng)部分轉(zhuǎn)售年經(jīng)營(yíng)收入(萬(wàn)元)1000年經(jīng)營(yíng)成本(萬(wàn)元)20年經(jīng)營(yíng)費(fèi)用(萬(wàn)元)30經(jīng)營(yíng)稅金及附加(萬(wàn)元)52.25正常利潤(rùn)率(%)10%年凈收益(萬(wàn)元)797.75經(jīng)營(yíng)年限(年)10報(bào)酬率(%)7%轉(zhuǎn)售價(jià)格(
23、萬(wàn)元)5603成本費(fèi)用估算表序號(hào)項(xiàng)目合計(jì)1234561開開發(fā)發(fā)成成本本302535490698950076586619101.1 銷售部分302535480698950076586619101.2 出租部分010年0001.3 自營(yíng)部分02開開發(fā)發(fā)費(fèi)費(fèi)用用37347471040104060030702.1 銷售費(fèi)用292958687987943914602.2 管理費(fèi)用8051611611611611610 折舊0 攤銷02.3 財(cái)務(wù)費(fèi)用00000003開發(fā)成本費(fèi)用33987623780296047718764980利潤(rùn)與利潤(rùn)分配表序號(hào)項(xiàng)目合計(jì)1234561經(jīng)營(yíng)收入58579103681288
24、88568108581589801.1銷售收入5857910368128888568108581589801.2租金收入00000001.3自營(yíng)收入00000002開發(fā)成本費(fèi)用339976237802960477187649803補(bǔ)貼收入(先征返還)04經(jīng)營(yíng)費(fèi)用(出租和自營(yíng)產(chǎn)業(yè))05經(jīng)營(yíng)稅金及附加322257070947159787406土地增值稅預(yù)征5861041298610915907土地增值稅42230002289193308利潤(rùn)總額17137356141502050785659109彌補(bǔ)前年度虧損010應(yīng)納稅所得額171373561415020507856591011所得稅565511
25、751370676259217501%所得稅預(yù)征171364220866011稅后利潤(rùn)114822386278113735264416010%法定盈余公積金114823927813753442012期初未分配利潤(rùn)1933399247054660777113可供分配利潤(rùn)8733821474435522851788635777115應(yīng)付優(yōu)先股股利00%任意盈余公積金000000016應(yīng)付普通股股利017各投資方可分配利潤(rùn)21474435522851788635777118各投資方利潤(rùn)分配574521544452351886377710%A方57452154445235188637770%B方000
26、00000%C方000000018年末未分配利潤(rùn)19333992470546607771699419息稅前利潤(rùn)3561415020507856591020息稅折舊攤銷前利潤(rùn)3561415020507856591021盈余公積1148239278137534420現(xiàn)金流量表(全部投資)序號(hào)項(xiàng)目合計(jì)1234561 1現(xiàn)現(xiàn)金金流流入入5857910368128888568108581589801.1銷售收入5857910368128888568108581589801.2租金收入00000001.3自營(yíng)收入00000001.4補(bǔ)貼收入(先征返還)00000001.5回收其他資金01.6回收固定資產(chǎn)余
27、值01.7回收經(jīng)營(yíng)資金01.8凈轉(zhuǎn)售收入00000002 2現(xiàn)現(xiàn)金金流流出出47673171977102613511789544902.1開發(fā)產(chǎn)品投資(不含財(cái)務(wù)費(fèi)用)339871534848944901853630702.2經(jīng)營(yíng)資金00000002.3經(jīng)營(yíng)費(fèi)用(出租和自營(yíng)產(chǎn)業(yè))00000002.4經(jīng)營(yíng)稅金及附加322257070947159787402.5土地增值稅預(yù)征5861041298610915902.6土地增值稅42230002289193302.7所得稅565511751370676259217503凈現(xiàn)金流量10906-682957862433-932104480累計(jì)凈現(xiàn)金流量-6
28、829-1043139045910907109074所得稅前凈現(xiàn)金流量16562-565471563110-673126230累計(jì)所得稅前凈現(xiàn)金流量-565415024612393916562165625凈現(xiàn)值4698-593943751600-53351950累計(jì)凈現(xiàn)值-5939-156337-496469946996所得稅前凈現(xiàn)值8430-491754112045-38562760累計(jì)所得稅前凈現(xiàn)值-49174942539215484308430計(jì)算指標(biāo)所得稅前所得稅后實(shí)際內(nèi)部收益率(FIRR)4.39%17.01%表面內(nèi)部收益率(FIRR)14.83%28.71%財(cái)務(wù)凈現(xiàn)值(FNPV)8
29、4304698投資回收期(靜態(tài)/動(dòng)態(tài))年3.262.773.493.91通貨膨脹率10.00%10.00%15%基準(zhǔn)收益率(Ie)15%15%FIRR(稅前)87%項(xiàng)目變動(dòng)幅度123原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值現(xiàn)金流入10%1036811405128881417785689425現(xiàn)金流出15%17197197777102816761357055合計(jì)-6829-83725786601024332370基準(zhǔn)收益率15%0.86960.75610.6575凈現(xiàn)值4698-5939-72804375454416001558累計(jì)凈現(xiàn)值3256-5939-7280-1563-273637-1178
30、現(xiàn)金流量表(資本金)序號(hào)項(xiàng)目合計(jì)1234561 1現(xiàn)現(xiàn)金金流流入入5857910368128888568108581589801.1銷售收入5857910368128888568108581589801.2租金收入00000001.3自營(yíng)收入00000001.4補(bǔ)貼收入(先征返還)00000001.5回收其他資金00000001.6回收固定資產(chǎn)余值00000001.7回收經(jīng)營(yíng)資金00000001.8凈轉(zhuǎn)售收入00000002 2現(xiàn)現(xiàn)金金流流出出47672171977101613411790544902.1權(quán)益資金1534815348000002.2債務(wù)資金40000400000002.3收入資
31、金1463808944901853630702.4經(jīng)營(yíng)費(fèi)用(出租和自營(yíng)產(chǎn)業(yè))00000002.5經(jīng)營(yíng)稅金及附加322257070947159787402.6土地增值稅預(yù)征5861041298610915902.7土地增值稅42230002289193302.8所得稅565511751370676259217502.9借款本利償還00000003凈現(xiàn)金流量10908-682957872434-932104490累計(jì)凈現(xiàn)金流量-6829-1042139145910908109084凈現(xiàn)值4699-593843761600-53351950累計(jì)凈現(xiàn)值-5938-156337-496469946995
32、所得稅前凈現(xiàn)金流量16563-565471563110-673126240累計(jì)所得稅前凈現(xiàn)金流量-565415024612393916563165636所得稅前凈現(xiàn)值8431-491654112045-38562760累計(jì)所得稅前凈現(xiàn)值-49164952540215584318431計(jì)算指標(biāo)所得稅前所得稅后實(shí)際內(nèi)部收益率(FIRR)4.64%12.18%表面內(nèi)部收益率(FIRR)15.10%23.40%財(cái)務(wù)凈現(xiàn)值(FNPV)84314699投資回收期(靜態(tài)/動(dòng)態(tài))年通貨膨脹率10.00%10.00%15%基準(zhǔn)收益率(Ie)15%15%FIRR(稅前)87%財(cái)務(wù)計(jì)劃現(xiàn)金流量表序號(hào)項(xiàng)目合計(jì)1234
33、561 1經(jīng)經(jīng)營(yíng)營(yíng)活活動(dòng)動(dòng)凈凈現(xiàn)現(xiàn)金金流流量量44894851910681733576041075601.11.1現(xiàn)現(xiàn)金金流流入入5857910368128888568108581589801.1.1 銷售收入5857910368128888568108581589801.1.2 租金收入00000001.1.3 自營(yíng)收入00000001.1.4 補(bǔ)貼收入(先征返還)00000001.1.5 其他流入01.21.2現(xiàn)現(xiàn)金金流流出出136861849220712333254514201.2.1 房地產(chǎn)投資(不含利息)339871534848944901853630701.2.2 經(jīng)營(yíng)資金0000
34、0001.2.3 經(jīng)營(yíng)費(fèi)用(出租和自營(yíng)產(chǎn)業(yè))00000001.2.4 經(jīng)營(yíng)稅金及附加322257070947159787401.2.5 土地增值稅預(yù)征5861041298610915901.2.6 土地增值稅42230002289193301.2.7 所得稅565511751370676259217501.2.8 其他流出02 2投投資資活活動(dòng)動(dòng)凈凈現(xiàn)現(xiàn)金金流流量量00000002.12.1現(xiàn)現(xiàn)金金流流入入00000002.1.1 回收固定資產(chǎn)余值00000002.1.2 回收經(jīng)營(yíng)資金00000002.1.3 凈轉(zhuǎn)售收入00000002.1.4 回收其他資金00000002.1.5 其他流入0
35、2.22.2現(xiàn)現(xiàn)金金流流出出00000002.2.1 權(quán)益投資02.2.2 債權(quán)投資02.2.3 購(gòu)建投資02.2.4 其他投資03 3籌籌資資活活動(dòng)動(dòng)凈凈現(xiàn)現(xiàn)金金流流量量10614151333556-523-518-863-7773.13.1現(xiàn)現(xiàn)金金流流入入1934815348400000003.1.1 權(quán)益資金1534815348000003.1.2 債務(wù)資金40000400000003.1.6 其他流入03.23.2現(xiàn)現(xiàn)金金流流出出87342154445235188637773.2.1 借款本金償還00000003.2.2 各種利息支出00000003.2.3 應(yīng)付利潤(rùn)(股利分配)873
36、42154445235188637773.2.4 其他流出04盈余資金555082365214237681270869892-7775累計(jì)盈余資金236523788944701517876167960902貸款還本付息計(jì)劃表序號(hào)項(xiàng)目合計(jì)1234561長(zhǎng)期借款償還1.1年初借款本息累計(jì)041004305452047461.2本年借款40000400000001.3本年應(yīng)計(jì)利息205801002052152262371.4本年還本付息0000000 還本05.00%付息01.5年末借款本息累計(jì)0410043054520474649842短期借款償還2.1年初借款本息累計(jì)000002.2本年借款00
37、000002.3本年應(yīng)計(jì)利息00000002.4本年還本付息0000000 還本7.11%付息02.5年末借款本息累計(jì)0000003本年還本付息00000003.1 本年還本00000003.2 本年付息00000004還本資金來(lái)源238627811373526441604.1攤銷00000004.2折舊00000004.3稅后利潤(rùn)11482238627811373526441604.4其他05償還長(zhǎng)期貸款本金能力11482238627811373526441606利息備付率#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!7償債備付率#DIV/
38、0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!8長(zhǎng)期借款償還期(年)4資產(chǎn)負(fù)債表序號(hào)項(xiàng)目1234561資產(chǎn)2965248327533705756061679609021.1流動(dòng)資產(chǎn)總額2965248327533705756061679609021.1.1 應(yīng)收帳款0000001.1.2 存貨6000104388669577300 其中:在建工程600010438866957731.1.3 貨幣資金1.1.4 累計(jì)盈余資金2365237889447015178761679609021.2長(zhǎng)期投資1.3固定資產(chǎn)凈值1.4無(wú)形及遞延資產(chǎn)凈值2負(fù)債及所有者權(quán)益
39、1751923957250122523529014284742.1流動(dòng)負(fù)債總額0000002.1.1 應(yīng)付帳款2.1.2 短期借款2.1.3 遞延稅金2.2長(zhǎng)期負(fù)債總額0410043054520474649842.2.1 經(jīng)營(yíng)資金借款2.2.2 開發(fā)產(chǎn)品投資借款041004305452047464984負(fù)債小計(jì)0410043054520474649842.3所有者權(quán)益1751919857207072071524268234912.3.1 資本金1534815348153481534815348153482.3.2 資本公積2.3.3 累計(jì)盈余公積金239517654707114811482.3
40、.4 累計(jì)未分配利潤(rùn)193339924705466077716994比率指標(biāo)參考指標(biāo)資產(chǎn)負(fù)債率(%)70%0%8%8%8%8%8%流動(dòng)比率(%)120%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!速動(dòng)比率(%)65%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!主要經(jīng)濟(jì)指標(biāo)表序號(hào)名稱單位數(shù)據(jù)備注項(xiàng)項(xiàng)目目設(shè)設(shè)計(jì)計(jì)參參數(shù)數(shù)projectproject designdesign parameterparameter1房地產(chǎn)開發(fā)產(chǎn)品總建筑面積total building area of real estate deveolp
41、ment平方米1440001.1商品住宅銷售面積sale area of commercial residential building平方米1324801.2商業(yè)用房銷售面積sale area of mercantile occupancy平方米115201.3車位銷售面積sale area of loading lot平方米1.3出租物業(yè)面積rent area of real estate平方米1.4自營(yíng)資產(chǎn)self-support assets平方米2自營(yíng)收入self-support income萬(wàn)元0經(jīng)經(jīng)濟(jì)濟(jì)數(shù)數(shù)據(jù)據(jù)economiceconomic datadata1總投資overhe
42、ad expenses萬(wàn)元339872開發(fā)產(chǎn)品投資gross investment萬(wàn)元33987 其中:財(cái)務(wù)費(fèi)用operation funds萬(wàn)元03單方價(jià)格unilateralism price元/平方米23604資金籌措financing萬(wàn)元33986 其中:權(quán)益資金equity funds萬(wàn)元15348 債權(quán)資金indebtedness funds萬(wàn)元4000 收入資金receipts funds萬(wàn)元146385經(jīng)營(yíng)收入萬(wàn)元585796開發(fā)成本real estate development costs萬(wàn)元302537開發(fā)費(fèi)用萬(wàn)元37348經(jīng)營(yíng)費(fèi)用(出租和自營(yíng)產(chǎn)業(yè))萬(wàn)元09應(yīng)繳稅金taxe
43、s due萬(wàn)元13686 經(jīng)營(yíng)稅金及附加management taxes and additional expense 萬(wàn)元3222 土地增值稅commercial housing sale net income estimating chart萬(wàn)元4808 所得稅commercial housing sale net income estimating chart萬(wàn)元565510利潤(rùn)總額total profit萬(wàn)元1713711稅后利潤(rùn)after-tax profit 萬(wàn)元1148212可分配利潤(rùn)distributive profits萬(wàn)元5745財(cái)財(cái)務(wù)務(wù)評(píng)評(píng)價(jià)價(jià)指指標(biāo)標(biāo)financialf
44、inancial evaluationevaluation indexindex1投資利潤(rùn)率earning power of real assets%10.08%年平均2投資凈利潤(rùn)率net earning power of real assets%6.76%年平均3投資利稅率(不含所得稅)%14.81%年平均4資本金利潤(rùn)率profit-cost ratio%22.33%年平均5資本金凈利潤(rùn)率net profit-cost ratio%14.96%年平均6全部投資內(nèi)部收益率(所得稅前)total investment internal rate of return%14.83%7全部投資投資回收
45、期(所得稅前)年2.778全部投資內(nèi)部收益率(所得稅后)%28.71%9全部投資投資回收期(所得稅后)年3.9110項(xiàng)目建設(shè)經(jīng)營(yíng)期construct and manage period of project年511房地產(chǎn)投資長(zhǎng)期借款償還期period of compensate long term loans of real estate investment年建設(shè)期起12自營(yíng)部分盈虧平衡點(diǎn)(經(jīng)營(yíng)達(dá)綱率)break-even point of self-support part%789101112131415161718(產(chǎn)權(quán)面積)單位:萬(wàn)元78910111213141516171800000
46、0000000000000000000單位:萬(wàn)元78910000000000000000000000000000000000000單位:萬(wàn)元789101112131415161718000000000000000000000000000000000000單位:萬(wàn)元789101112131415161718000000000000000000000000000000000000單位:萬(wàn)元7891011121314151617180000000000000000000000000000000000006006006006006006006006006006006006000000000000000
47、000000000005050505050505050505050500000000000000000000000000000000000001000100010001000100010001000100010001000100010000000000000000000000000001001001001001001001001001001001001000000000000000000000000000000000000001200120012001200120012001200120012001200120012000000000000000000000000002002002002002
48、002002002002002002002000000000000000000000000000000000000001500150015001500150015001500150015001500150015000000000000000000000000001000100010001000100010001000100010001000100010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007891011121314151617180000
49、00000000000000000000000000000000單位:萬(wàn)元78910111213141516171800000000000000000000000000000000000000000000000000000000000078910111213141516171800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
50、00000000000000000000000000000007891011121314151617180000000000000000000000000000000000000000000000000000000000000000000000000 00 00 00 00 0000000000000單位:萬(wàn)元789101112131415161718000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000單位:
51、萬(wàn)元78910111213141516171800000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0!#DIV/0!000000000000000000000000000000000000000000000000單位:萬(wàn)元7891011121314151617181.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%000000000
52、0000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000000000001%1%1%1%1%1%1%1%1%1%1%1%000000000000000000000000000000000000586586586586586586586586586586586586單位:萬(wàn)元7891011121314151617180000000000005857958
53、579585795857958579585795857958579585795857958579585790000000000003025330253302533025330253302533025330253302533025330253302530%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0!#DIV/0!100%100%100%100%100%100%100%100%100%#DIV/0!#DIV/0!#DIV/0!單位:萬(wàn)元789101112131415161718000000000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#D
54、IV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!000000000000單位:萬(wàn)元789101112131415161718000000000000000000000000000000000000000000000000000000000000000000000000單位:萬(wàn)元7891011121314151617180000000000000000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0
55、%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%000000000000000000000000000000000000000000000000000000000000000000000000單位:萬(wàn)元7891011121314151617180000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%00000000000000000
56、00000000%0%0%0%0%0%0%0%0%0%0%0%000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!000000000000單位:萬(wàn)元7891011121314151617180000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000單位:萬(wàn)元789101112131415161718000000
57、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000699462955665509945894130371733453011271024392195699462955665509945894130371733453011271024392195000000000000699462955665509945894130371733
58、453011271024392195699629567510459413372335301271244219699629567510459413372335301271244219000000000000000000000000629556655099458941303717334530112710243921951975000000000000000000000000000000000000單位:萬(wàn)元7891011121314151617180000000000000000000000000000000000000000000000000000000000000000000000000000
59、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001090710907109071090710907109071090610906109061090610906109060000000000001656216562165621656216562165621656216562165621656216562165620000000000004699469946994698469846984698469846984698469846980000
60、00000000843084308430843084308430843084308430843084308430FIRR(稅后)49%456789原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值108581194315898174870000000011789135585449626700000000-932-16141044811221000000000.57180.49720.43230.37590.32690.2843-533-9235195557900000000-496-21014699347846993478469934784699347846993478單
61、位:萬(wàn)元78910111213141516171800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010908109081090810908109081090810908
62、1090810908109081090810908000000000000469946994699469946994699469946994699469946994699000000000000165631656316563165631656316563165631656316563165631656316563000000000000843184318431843184318431843184318431843184318431FIRR(稅后)49%單位:萬(wàn)元7891011121314151617180000000000000000000000000000000000000000000000
63、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000-699-629-567-510-459-413-372-335-301-271-244-2190000000000000000000000000000000000006996295675
64、10459413372335301271244219000000000000000000000000699629567510459413372335301271244219-699-629-567-510-459-413-372-335-301-271-244-219602035957359007584975803857625572535691956617563465610355883單位:萬(wàn)元78910111213141516171849845233549457696058636066787012736377318118852400000000000024926227528830331833
65、4351368387406426000000000000523354945769605863606678701273637731811885248950000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/
66、0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!單位:萬(wàn)元789101112131415161718602035957359007584975803857625572535691956617563465610355883602035957359007584975803857625572535691956617563465610355883000000000000000000000000602035957359007584975803857625
67、572535691956617563465610355883280242765627364271432698726892268542687026937270532721527421000000000000523354945769605863606678701273637731811885248950523354945769605863606678701273637731811885248950523354945769605863606678701273637731811885248950227912216221595210852062620213198421950719206189351869
68、1184721534815348153481534815348153481534815348153481534815348153481148114811481148114811481148114811481148114811486295566550994589413037173345301127102439219519759%9%10%10%11%12%12%13%14%14%15%16%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0
69、!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!19201920000000000019200000001920000000192000000060060000005050000000100010000000100100000000120012000000200200000000150015000000100010000000000000000000192000000019200000000000192000000000000000000000000000000000192000000000000000192000
70、00000000000000000019200000#DIV/0!#DIV/0!#DIV/0!#DIV/0!0000000019201.0%1.0%00001.0%1.0%00001.0%1.0%00001%1%0000005865861920005857958579003025330253#DIV/0!#DIV/0!#DIV/0!#DIV/0!19200000#DIV/0!#DIV/0!00192000000000000019200000000%0%00000%0%00000%0%0000000000001920000%0%00000%0%00000%0%00000%0%0000#DIV/0
71、!#DIV/0!00192000000000000000019200000000000000000000000000000197517781975177800197517781981781981780000177816000000001920000000000000000000000000000000109061090600165621656200469846980084308430101112131415原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值00000000000000024502450407040700000-2450-2450-4070-407000.2
72、4720.21490.18690.16250.14130.1229000-530-460-660-5700469834784698342546983379469833134698325646983256192000000000000000000000000000000000000000001090810908004699469900165631656300843184311920000000000000000000000000000000000000000000-198-1780000001981780000198178-198-17855686555081920895093970044747
73、0009397986700000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!1920556865550855686555080000556865550827671279630093979867939798679397986718274180961534815348114811481778160017%18%#DIV/0!#DIV/0!#DIV/0!#DIV/0!1617181920原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值變動(dòng)值原始值變動(dòng)值0000000000000000000000000000000.10690.09290.08080.0703
74、0.061100000000004698325646983256469832564698325646983256123456銷銷售售價(jià)價(jià)格格(元元/平平方方米米)均價(jià) 項(xiàng)目1(多層)30003100 項(xiàng)目2(小高層)340035003600 項(xiàng)目3(高層)41004200 項(xiàng)目4(商鋪)11700 項(xiàng)目5(地下車位)銷銷售售計(jì)計(jì)劃劃(平平方方米米)144000(產(chǎn)權(quán)面積)項(xiàng)目1(多層)619203456027360 項(xiàng)目2(小高層)4464012960244807200 項(xiàng)目3(高層)25920201605760 項(xiàng)目4(商鋪)1152011520 項(xiàng)目5(地下車位)0開開發(fā)發(fā)計(jì)計(jì)劃劃(平平方
75、方米米)144000 項(xiàng)目1(多層)土建576004000017600 項(xiàng)目1(多層)安裝576003000027600 項(xiàng)目2(小高層)土建4320020000200003200 項(xiàng)目2(小高層)安裝43200150001500013200 項(xiàng)目3(高層)土建288001000018800 項(xiàng)目3(高層)安裝2880028800 項(xiàng)目4(商鋪)土建1440014400 項(xiàng)目4(商鋪)安裝1440014400 項(xiàng)目5(地下車位)土建0 項(xiàng)目5(地下車位)安裝0回回款款計(jì)計(jì)劃劃 項(xiàng)目1(多層)80%80%項(xiàng)目2(小高層)80%80%80%項(xiàng)目3(高層)80%80%項(xiàng)目4(商鋪)80%80%項(xiàng)目5
76、(地下車位)出出租租價(jià)價(jià)格格(元元/平平方方米米)項(xiàng)目1(地上車位)100 項(xiàng)目2 項(xiàng)目3出出租租計(jì)計(jì)劃劃(平平方方米米)項(xiàng)目1(地上車位)1440 項(xiàng)目2 項(xiàng)目3出出租租率率(%)(%)項(xiàng)目1(地上車位)80%項(xiàng)目2 項(xiàng)目3土地費(fèi)用序號(hào)項(xiàng)目合計(jì)1234561土地出讓金10800108002征地費(fèi)用03拆遷安置補(bǔ)償費(fèi)04土地轉(zhuǎn)讓費(fèi)05土地租用費(fèi)06土地投資折價(jià)07交易服務(wù)費(fèi)18184%交易契稅43243200000共計(jì)112501125000000前期工程費(fèi)用序號(hào)項(xiàng)目合計(jì)1234561規(guī)劃設(shè)計(jì)研究費(fèi)4004002水文地質(zhì)勘測(cè)費(fèi)03道路費(fèi)04供水費(fèi)05供電費(fèi)05三通一平03%其他48477100
77、10120700共計(jì)88447710010120700前期工程費(fèi)用投入計(jì)劃100%20%30%30%15%5%884177265265133440基礎(chǔ)設(shè)施建設(shè)費(fèi)用序號(hào)項(xiàng)目合計(jì)1234561供電工程02供水工程03供氣工程04排污工程05道路工程06通訊工程07綠化工程08照明工程09環(huán)衛(wèi)設(shè)施03%其他4847710010120700共計(jì)4847710010120700基礎(chǔ)設(shè)施建設(shè)費(fèi)用投入計(jì)劃100%20%30%30%15%5%4849714514573240公共配套設(shè)施建設(shè)費(fèi)序號(hào)項(xiàng)目合計(jì)1234561居委會(huì)02派出所03托兒所04幼兒園05公共廁所06停車場(chǎng)03%其他4847710010120
78、700共計(jì)4847710010120700公共配套設(shè)施建設(shè)費(fèi)投入計(jì)劃100%20%30%30%15%5%4849714514573240建筑安裝工程費(fèi)用序號(hào)項(xiàng)目合計(jì)1234561 項(xiàng)項(xiàng)目目1 1(多多層層)374437442550119400001.1 土建工程費(fèi)34563456240010560000 建筑面積(平方米)40000176000000 單價(jià)(元/平方米)6006006006006006006001.2 安裝工程費(fèi)2882881501380000 建筑面積(平方米)30000276000000 單價(jià)(元/平方米)505050505050502 項(xiàng)項(xiàng)目目2 2(小小高高層層)475
79、24752021502150452002.1 土建工程費(fèi)4320432002000200032000 建筑面積(平方米)02000020000320000 單價(jià)(元/平方米)10001000100010001000100010002.2 安裝工程費(fèi)432432015015013200 建筑面積(平方米)015000150001320000 單價(jià)(元/平方米)1001001001001001001003 項(xiàng)項(xiàng)目目3 3(高高層層)403240320012002832003.1 土建工程費(fèi)34563456001200225600 建筑面積(平方米)00100001880000 單價(jià)(元/平方米)1
80、2001200120012001200120012003.2 安裝工程費(fèi)57657600057600 建筑面積(平方米)0002880000 單價(jià)(元/平方米)2002002002002002002004 項(xiàng)項(xiàng)目目4 4(商商鋪鋪)360036000003600004.1 土建工程費(fèi)21602160000216000 建筑面積(平方米)0001440000 單價(jià)(元/平方米)15001500150015001500150015004.2 安裝工程費(fèi)14401440000144000 建筑面積(平方米)0001440000 單價(jià)(元/平方米)100010001000100010001000100
81、05 項(xiàng)項(xiàng)目目5 5(地地下下車車位位)0 00000005.1 土建工程費(fèi)0 0000000 建筑面積(平方米)000000 單價(jià)(元/平方米)0000005.2 安裝工程費(fèi)0 0000000 建筑面積(平方米)000000 單價(jià)(元/平方米)000000共計(jì)16128255033443350688400開發(fā)間接費(fèi)序號(hào)項(xiàng)目合計(jì)1234561土地使用稅02市政支管線分?jǐn)傎M(fèi)03供電貼費(fèi)04用電權(quán)費(fèi)05分散建設(shè)市政公用設(shè)施建設(shè)費(fèi)06綠化建設(shè)費(fèi)07臨時(shí)用地08臨建費(fèi)09施工圖預(yù)算或標(biāo)底編制費(fèi)010工程合同預(yù)算或標(biāo)底審查費(fèi)011招標(biāo)管理費(fèi)012總承包管理費(fèi)013合同公證費(fèi)014施工執(zhí)照費(fèi)015工程質(zhì)量
82、監(jiān)督費(fèi)016工程監(jiān)理費(fèi)017竣工圖編制費(fèi)018工程保險(xiǎn)費(fèi)03%其他費(fèi)用4847710010120700共計(jì)4847710010120700開發(fā)間接費(fèi)投入計(jì)劃100%20%30%30%15%5%4849714514573240銷售費(fèi)用序號(hào)項(xiàng)目合計(jì)1234565.0%銷售代理費(fèi)用292951864442854379500.0%廣告宣傳及推廣費(fèi)用00000000.0%其他銷售費(fèi)用0000000共計(jì) 29295186444285437950銷售費(fèi)用投入計(jì)劃100%20%30%30%15%5%29295868798794391460項(xiàng)目總投資估算表序號(hào)項(xiàng)目合計(jì)123456一開發(fā)建設(shè)投資339871534
83、848944901853630701房地產(chǎn)開發(fā)成本3025314601385538627935001.1土地費(fèi)用1125011250000001.2前期工程費(fèi)884477100101207001.3基礎(chǔ)設(shè)施建設(shè)費(fèi)48477100101207001.4建筑安裝工程費(fèi)161282550334433506884001.5公共配套設(shè)施建設(shè)費(fèi)48477100101207001.6開發(fā)間接費(fèi)48477100101207001.7不可預(yù)見費(fèi)53995109110225002房地產(chǎn)開發(fā)費(fèi)用37347471040104060030702.1銷售費(fèi)用292958687987943914602.2管理費(fèi)用80516
84、116116116116102.3財(cái)務(wù)費(fèi)用0000000二經(jīng)營(yíng)資金0三項(xiàng)目總投資額339871534848944901853630701開發(fā)產(chǎn)品投資339871534848944901853630702固定資產(chǎn)投資03經(jīng)營(yíng)資金0000000項(xiàng)目回款進(jìn)度表序號(hào)項(xiàng)目合計(jì)1234561項(xiàng)目1(多層)1885010368848200002項(xiàng)目2(小高層)155660440685682592003項(xiàng)目3(高層)106850008266241904項(xiàng)目4(商鋪)1347800001347805項(xiàng)目5(地下車位)0000000小計(jì)585795857910368128888568108581589802006
85、項(xiàng)目1(多層)103688294829420742074項(xiàng)目2(小高層)00 00 0項(xiàng)目3(高層)00 00 0項(xiàng)目4(商鋪)00 00 0項(xiàng)目5(地下車位)00 00 02007項(xiàng)目1(多層)84826785678516961696項(xiàng)目2(小高層)440635253525881881項(xiàng)目3(高層)00 00 0項(xiàng)目4(商鋪)00 00 0項(xiàng)目5(地下車位)00 00 02008項(xiàng)目1(多層)00 00 0項(xiàng)目2(小高層)85686854685417141714項(xiàng)目3(高層)00 00 0項(xiàng)目4(商鋪)00 00 0項(xiàng)目5(地下車位)00 00 02009項(xiàng)目1(多層)00 00 0項(xiàng)目2(
86、小高層)259220742074518518項(xiàng)目3(高層)82666612661216531653項(xiàng)目4(商鋪)00 00 0項(xiàng)目5(地下車位)00 00 02010項(xiàng)目1(多層)00 00 0項(xiàng)目2(小高層)00 00 0項(xiàng)目3(高層)241919351935484484項(xiàng)目4(商鋪)13478107831078326962696項(xiàng)目5(地下車位)00 00 02011項(xiàng)目1(多層)00 0項(xiàng)目2(小高層)00 0項(xiàng)目3(高層)00 0項(xiàng)目4(商鋪)00 0項(xiàng)目5(地下車位)00 0小計(jì)5857958579829412384943210400148903180投資使用計(jì)劃與資金籌措表序號(hào)項(xiàng)目
87、合計(jì)1234561總投資33987339871534848944901853630701.1經(jīng)營(yíng)資金00000001.2固定資產(chǎn)投資00000001.3開發(fā)產(chǎn)品投資33987153484894490185363070 其中:不含財(cái)務(wù)費(fèi)用33987153484894490185363070 財(cái)務(wù)費(fèi)用00000002資金籌措15583155832896200327423688425402.1權(quán)益資金00000002.1.1 資本金02.1.2 股票融資02.1.3 股東投資02.1.4 政府投資02.2債務(wù)資金00000002.2.1 長(zhǎng)期貸款02.2.2 短期貸款02.2.3 企業(yè)債券02.2.
88、4 融資租賃02.3收入資金155832896200327423688425402.3.1 預(yù)售收入15583289620032742368842542.3.2 租金收入02.3.3 自營(yíng)收入02.3.4 貼補(bǔ)收入02.3.5 其他收入0銷售收入與經(jīng)營(yíng)稅金估算表序號(hào)項(xiàng)目合計(jì)1234561銷售收入5857910368128888568108581589801.1可銷售面積(平方米)144000345604032024480273601728001.2平均售價(jià)元(元/平方米)30003196350039689200#DIV/0!1.3銷售比例(%)24%28%17%19%12%0%2經(jīng)營(yíng)稅金及附加
89、322257070947159787402.1營(yíng)業(yè)稅292951864442854379502.2城市維護(hù)建設(shè)稅205364530385602.3教育費(fèi)附加8816191316240土地增值稅預(yù)征估算表序號(hào)項(xiàng)目合計(jì)1234561項(xiàng)項(xiàng)目目1 1(多多層層)1.0%1.0%1.0%1.0%1.0%1.0%銷售收入1885010368848200001.0%預(yù)征稅額1881048500002項(xiàng)項(xiàng)目目2 2(小小高高層層)1.0%1.0%1.0%1.0%1.0%1.0%銷售收入155660440685682592001.0%預(yù)征稅額1560448626003項(xiàng)項(xiàng)目目3 3(高高層層)1.0%1.0%1
90、.0%1.0%1.0%1.0%銷售收入106850008266241901.0%預(yù)征稅額107000832404項(xiàng)項(xiàng)目目4 4(商商業(yè)業(yè))1%1%1%1%1%1%銷售收入1347800001347801.0%預(yù)征稅額135000013505預(yù)征土地增值稅總額586104129861091590累計(jì)預(yù)征土地增值稅104233318427586586土地增值稅估算附表序號(hào)項(xiàng)目合計(jì)1234561銷售收入5857910368128888568108581589802累計(jì)銷售收入1036823256318244268258579585793開發(fā)成本302535480698950076586619104累
91、計(jì)開發(fā)成本548012469174762406230253302535銷售比例24%28%17%19%12%0%6累計(jì)銷售比例24%52%69%88%100%100%土地增值稅估算表序號(hào)項(xiàng)目合計(jì)1234561銷售收入10126142682585792扣除項(xiàng)目76180000336284255102.1 開發(fā)成本5431624062302532.2 開發(fā)費(fèi)用54322406302502.3 銷售稅金55692347322202.4 其他扣除額108634812605103增值額00090531602804增值比例#DIV/0!#DIV/0!#DIV/0!27%38%#DIV/0!5增值稅率30%
92、30%6速算扣除率0%0%7土地增值稅0002716480808已交土地增值稅4275869本年應(yīng)繳土地增值稅22891933自營(yíng)收入及經(jīng)營(yíng)稅金估算表序號(hào)項(xiàng)目合計(jì)1234561自營(yíng)收入3001002經(jīng)營(yíng)稅金及附加170000062.1營(yíng)業(yè)稅150000052.2城市維護(hù)建設(shè)稅10000002.3教育費(fèi)附加00000003凈轉(zhuǎn)售收入00000003.1轉(zhuǎn)售價(jià)格03.2轉(zhuǎn)售成本03.3轉(zhuǎn)售稅金0000000租金收入及經(jīng)營(yíng)稅金估算表序號(hào)項(xiàng)目合計(jì)1234561租金收入(萬(wàn)元)467000001381.1.1可出租面積(平方米)0000014401.1.2單位租金(元/月/平方米)000001001.1
93、.3出租率(%)0%0%0%0%0%80%1.2.1可出租面積(平方米)0000001.2.2單位租金(元/月/平方米)0000001.2.3出租率(%)0%0%0%0%0%0%1.3.1可出租面積(平方米)0000001.3.2單位租金(元/月/平方米)0000001.3.3出租率(%)0%0%0%0%0%0%2經(jīng)營(yíng)稅金及附加260000082.1營(yíng)業(yè)稅230000072.2城市維護(hù)建設(shè)稅20000002.3教育費(fèi)附加10000004凈轉(zhuǎn)售收入00000004.1轉(zhuǎn)售價(jià)格04.2轉(zhuǎn)售成本04.3轉(zhuǎn)售稅金0000000經(jīng)營(yíng)成本分?jǐn)偙硇蛱?hào)項(xiàng)目合計(jì)1234561 項(xiàng)項(xiàng)目目1 1(多多層層)43.0
94、0%已銷售面積6192034560273600000銷售比例56%44%0%0%0%0%開發(fā)總成本98185480433800002 項(xiàng)項(xiàng)目目2 2(小小高高層層)31.00%已銷售面積4464001296024480720000銷售比例0%29%55%16%0%0%開發(fā)總成本91310265150071473003 項(xiàng)項(xiàng)目目3 3(高高層層)18.00%已銷售面積259200002016057600銷售比例0%0%0%78%22%0%開發(fā)總成本65750005114146104 項(xiàng)項(xiàng)目目4 4(商商鋪鋪)8.00%已銷售面積115200000115200銷售比例0%0%0%0%100%0%開
95、發(fā)總成本47300000473005 項(xiàng)項(xiàng)目目5 5(地地下下車車位位)已銷售面積0000000銷售比例#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!開發(fā)總成本04合計(jì)30253548069895007658661910固定資產(chǎn)折舊固定資產(chǎn)3734折舊年限20殘值率5%年折舊額177固定資產(chǎn)轉(zhuǎn)售年限15固定資產(chǎn)轉(zhuǎn)售成本1074出租部分轉(zhuǎn)售月租金(元/平方米/月)100出租面積(平方米)1000出租率(%)80%運(yùn)營(yíng)費(fèi)用(萬(wàn)元)20%凈租金收益(萬(wàn)元)76.8收益年限(年)50報(bào)酬率(%)8%轉(zhuǎn)售價(jià)格(萬(wàn)元)940自營(yíng)部分轉(zhuǎn)售年經(jīng)營(yíng)收入(萬(wàn)元)1000年經(jīng)營(yíng)
96、成本(萬(wàn)元)20年經(jīng)營(yíng)費(fèi)用(萬(wàn)元)30經(jīng)營(yíng)稅金及附加(萬(wàn)元)52.25正常利潤(rùn)率(%)10%年凈收益(萬(wàn)元)797.75經(jīng)營(yíng)年限(年)10報(bào)酬率(%)7%轉(zhuǎn)售價(jià)格(萬(wàn)元)5603.062成本費(fèi)用估算表序號(hào)項(xiàng)目合計(jì)1234561開開發(fā)發(fā)成成本本302535490698950076586619101.1 銷售部分302535480698950076586619101.2 出租部分010年0001.3 自營(yíng)部分02開開發(fā)發(fā)費(fèi)費(fèi)用用37347471040104060030702.1 銷售費(fèi)用292958687987943914602.2 管理費(fèi)用8051611611611611610 折舊0 攤銷02
97、.3 財(cái)務(wù)費(fèi)用00000003開發(fā)成本費(fèi)用33987623780296047718764980利潤(rùn)與利潤(rùn)分配表序號(hào)項(xiàng)目合計(jì)1234561經(jīng)營(yíng)收入593461036812888856810858158982381.1銷售收入5857910368128888568108581589801.2租金收入467000001381.3自營(yíng)收入300000001002開發(fā)成本費(fèi)用339976237802960477187649803補(bǔ)貼收入(先征返還)04經(jīng)營(yíng)費(fèi)用(出租和自營(yíng)產(chǎn)業(yè))60205經(jīng)營(yíng)稅金及附加3264570709471597874136土地增值稅預(yù)征5861041298610915907土地增值
98、稅42230002289193308利潤(rùn)總額1780235614150205078565912059彌補(bǔ)前年度虧損010應(yīng)納稅所得額17802356141502050785659120511所得稅5875117513706762592175681%所得稅預(yù)征178364220866211稅后利潤(rùn)11927238627811373526441613712三項(xiàng)基金178935841720679662215%儲(chǔ)備基金596119139692622175%企業(yè)發(fā)展基金596119139692622175%職工獎(jiǎng)勵(lì)及福利基金5961191396926221713利潤(rùn)歸還投資50014應(yīng)付優(yōu)先股股利15應(yīng)
99、付普通股股利16期初未分配利潤(rùn)10701655817313262817可供投資者分配利潤(rùn)9638152823641167447375411718各投資方利潤(rùn)分配289145870935013411263510%A方964153236117453751210%B方964153236117453751210%C方964153236117453751219年末未分配利潤(rùn)1070165581731326288220息稅前利潤(rùn)356141502050785659120521息稅折舊攤銷前利潤(rùn)35613561415020507856591205現(xiàn)金流量表(全部投資)序號(hào)項(xiàng)目合計(jì)1234561 1現(xiàn)現(xiàn)金金流
100、流入入593468294123849432104001489034181.1銷售收入585798294123849432104001489031801.2租金收入467000001381.3自營(yíng)收入300000001001.4補(bǔ)貼收入(先征返還)00000001.5回收其他資金01.6回收固定資產(chǎn)余值01.7回收經(jīng)營(yíng)資金01.8凈轉(zhuǎn)售收入00000002 2現(xiàn)現(xiàn)金金流流出出4799417197710261351178954491012.1開發(fā)產(chǎn)品投資(不含財(cái)務(wù)費(fèi)用)339871534848944901853630702.2經(jīng)營(yíng)資金00000002.3經(jīng)營(yíng)費(fèi)用(出租和自營(yíng)產(chǎn)業(yè))600000020
101、2.4經(jīng)營(yíng)稅金及附加3264570709471597874132.5土地增值稅預(yù)征5861041298610915902.6土地增值稅42230002289193302.7所得稅5875117513706762592175682.8職工獎(jiǎng)勵(lì)及福利基金596119139692622173凈現(xiàn)金流量11351-890352823297-139094403317累計(jì)凈現(xiàn)金流量-8903-3621-323-17137727110444所得稅前凈現(xiàn)金流量17822-760867914042-1104118363391累計(jì)所得稅前凈現(xiàn)金流量-7608-8173225212113957173485凈現(xiàn)值56
102、84-809443662477-94958621872累計(jì)凈現(xiàn)值-8094-3728-1251-2200366255346所得稅前凈現(xiàn)值10474-691756123037-75473491914累計(jì)所得稅前凈現(xiàn)值-6917-13041733978832810242計(jì)算指標(biāo)所得稅前所得稅后實(shí)際內(nèi)部收益率(FIRR)56.33%30.34%表面內(nèi)部收益率(FIRR)61.02%34.25%財(cái)務(wù)凈現(xiàn)值(FNPV)104745684投資回收期(靜態(tài)/動(dòng)態(tài))年3.262.773.493.91通貨膨脹率3.00%3.00%10%基準(zhǔn)收益率(Ie)10%10%FIRR(稅前)61%項(xiàng)目變動(dòng)幅度123原始值
103、變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值現(xiàn)金流入10%829491241238413622943210375現(xiàn)金流出15%17197197777102816761357055合計(jì)-8903-106535282545532973320基準(zhǔn)收益率15%0.86960.75610.6575凈現(xiàn)值3861-7742-92643994412521682183累計(jì)凈現(xiàn)值2327-7742-9264-3748-5138-1579-2955現(xiàn)金流量表(資本金)序號(hào)項(xiàng)目合計(jì)1234561 1現(xiàn)現(xiàn)金金流流入入593468294123849432104001489034181.1銷售收入5857982941238494321
104、04001489031801.2租金收入467000001381.3自營(yíng)收入300000001001.4補(bǔ)貼收入(先征返還)00000001.5回收其他資金00000001.6回收固定資產(chǎn)余值00000001.7回收經(jīng)營(yíng)資金00000001.8凈轉(zhuǎn)售收入00000002 2現(xiàn)現(xiàn)金金流流出出29590474542103975694293961012.1權(quán)益資金00000002.2債務(wù)資金00000002.3收入資金155832896200327423688425402.4經(jīng)營(yíng)費(fèi)用(出租和自營(yíng)產(chǎn)業(yè))6000000202.5經(jīng)營(yíng)稅金及附加3264570709471597874132.6土地增值稅預(yù)征
105、5861041298610915902.7土地增值稅42230002289193302.8所得稅5875117513706762592175682.9借款本利償還00000002.10職工獎(jiǎng)勵(lì)及福利基金596119139692622173凈現(xiàn)金流量29756354981745457345854943317累計(jì)凈現(xiàn)金流量354911723171802063726131294484凈現(xiàn)值19105308661803588197727311434累計(jì)凈現(xiàn)值30869267128551483217563189975所得稅前凈現(xiàn)金流量36227484496826202374378903392累計(jì)所得稅前
106、凈現(xiàn)金流量484414526207282447132361357526所得稅前凈現(xiàn)值23306421273214078214039231466累計(jì)所得稅前凈現(xiàn)值42121153315611177512167423140計(jì)算指標(biāo)所得稅前所得稅后實(shí)際內(nèi)部收益率(FIRR)4.64%12.18%表面內(nèi)部收益率(FIRR)15.10%23.40%財(cái)務(wù)凈現(xiàn)值(FNPV)2330619105投資回收期(靜態(tài)/動(dòng)態(tài))年通貨膨脹率10.00%10.00%15%基準(zhǔn)收益率(Ie)15%15%FIRR(稅前)#NUM!財(cái)務(wù)計(jì)劃現(xiàn)金流量表序號(hào)項(xiàng)目合計(jì)1234561 1經(jīng)經(jīng)營(yíng)營(yíng)活活動(dòng)動(dòng)凈凈現(xiàn)現(xiàn)金金流流量量453396
107、4451017781997146974833171.11.1現(xiàn)現(xiàn)金金流流入入593468294123849432104001489034181.1.1銷售收入585798294123849432104001489031801.1.2租金收入467000001381.1.3自營(yíng)收入300000001001.1.4補(bǔ)貼收入(先征返還)00000001.1.5其他流入01.21.2現(xiàn)現(xiàn)金金流流出出14007184922071233325451421011.2.1房地產(chǎn)投資(不含利息)339871534848944901853630701.2.2經(jīng)營(yíng)資金00000001.2.3經(jīng)營(yíng)費(fèi)用(出租和自營(yíng)產(chǎn)業(yè)
108、)6000000201.2.4經(jīng)營(yíng)稅金及附加3264570709471597874131.2.5土地增值稅預(yù)征5861041298610915901.2.6土地增值稅42230002289193301.2.7所得稅5875117513706762592175681.2.8職工獎(jiǎng)勵(lì)及福利基金596119139692622171.2.9其他流出02 2投投資資活活動(dòng)動(dòng)凈凈現(xiàn)現(xiàn)金金流流量量00000002.12.1現(xiàn)現(xiàn)金金流流入入00000002.1.1回收固定資產(chǎn)余值00000002.1.2回收經(jīng)營(yíng)資金00000002.1.3凈轉(zhuǎn)售收入00000002.1.4回收其他資金00000002.1.5其
109、他流入02.22.2現(xiàn)現(xiàn)金金流流出出00000002.2.1權(quán)益投資02.2.2債權(quán)投資02.2.3購(gòu)建投資02.2.4其他投資03 3籌籌資資活活動(dòng)動(dòng)凈凈現(xiàn)現(xiàn)金金流流量量-2891-458-709-350-134-1126-353.13.1現(xiàn)現(xiàn)金金流流入入00000003.1.1權(quán)益資金00000003.1.2債務(wù)資金00000003.1.6其他流入03.23.2現(xiàn)現(xiàn)金金流流出出28914587093501341126353.2.1借款本金償還00000003.2.2各種利息支出00000003.2.3應(yīng)付利潤(rùn)(股利分配)28914587093501341126353.2.4利潤(rùn)歸還投資50
110、0500000003.2.5其他流出04盈余資金424475987946878487012862232825累計(jì)盈余資金59871545423303303153893642218貸款還本付息計(jì)劃表序號(hào)項(xiàng)目合計(jì)1234561長(zhǎng)期借款償還1.1年初借款本息累計(jì)000001.2本年借款00000001.3本年應(yīng)計(jì)利息00000001.4本年還本付息0000000 還本05.00%付息01.5年末借款本息累計(jì)0000002短期借款償還2.1年初借款本息累計(jì)000002.2本年借款00000002.3本年應(yīng)計(jì)利息00000002.4本年還本付息0000000 還本7.00%付息02.5年末借款本息累計(jì)0
111、000003本年還本付息00000003.1 本年還本00000003.2 本年付息00000004還本資金來(lái)源23862781137352644161374.1攤銷00000004.2折舊00000004.3稅后利潤(rùn)1192723862781137352644161374.4其他05償還長(zhǎng)期貸款本金能力1192723862781137352644161376利息備付率#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!7償債備付率#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!8長(zhǎng)期借款償還期(年
112、)4資產(chǎn)負(fù)債表序號(hào)項(xiàng)目1234561資產(chǎn)1406028470336853825942116422181.1流動(dòng)資產(chǎn)總額1406028470336853825942116422181.1.1 應(yīng)收帳款2074257817142172318001.1.2 存貨6000104388669577300 其中:在建工程600010438866957731.1.3 貨幣資金1.1.4 累計(jì)盈余資金598715454233033031538936422181.2長(zhǎng)期投資1.3固定資產(chǎn)凈值1.4無(wú)形及遞延資產(chǎn)凈值2負(fù)債及所有者權(quán)益14282072102339232901022.1流動(dòng)負(fù)債總額0000002.1
113、.1 應(yīng)付帳款2.1.2 短期借款2.1.3 遞延稅金2.2長(zhǎng)期負(fù)債總額0000002.2.1 經(jīng)營(yíng)資金借款2.2.2 開發(fā)產(chǎn)品投資借款000000負(fù)債小計(jì)0000002.3所有者權(quán)益14282072102339232901022.3.1 資本金0000002.3.2 資本公積2.3.3 累計(jì)盈余公積金35841720679662212.3.4 累計(jì)未分配利潤(rùn)10701655817313262882比率指標(biāo)參考指標(biāo)資產(chǎn)負(fù)債率(%)70%0%0%0%0%0%0%流動(dòng)比率(%)120%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!速動(dòng)比率(%)65%#DIV/
114、0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!主要經(jīng)濟(jì)指標(biāo)表序號(hào)名稱單位數(shù)據(jù)備注項(xiàng)項(xiàng)目目設(shè)設(shè)計(jì)計(jì)參參數(shù)數(shù)projectproject designdesign parameterparameter1房地產(chǎn)開發(fā)產(chǎn)品總建筑面積total building area of real estate deveolpment平方米1440001.1商品住宅銷售面積sale area of commercial residential building平方米1324801.2商業(yè)用房銷售面積sale area of mercantile occupancy平方米115201.3車
115、位銷售面積sale area of loading lot平方米1.3出租物業(yè)面積rent area of real estate平方米1.4自營(yíng)資產(chǎn)self-support assets平方米2自營(yíng)收入self-support income萬(wàn)元300經(jīng)經(jīng)濟(jì)濟(jì)數(shù)數(shù)據(jù)據(jù)economiceconomic datadata1總投資total investment for the project萬(wàn)元339872開發(fā)產(chǎn)品投資development investment萬(wàn)元33987 其中:財(cái)務(wù)費(fèi)用thereinto:free of financial cost萬(wàn)元03單方價(jià)格unilateralism
116、price元/平方米23604資金籌措financing萬(wàn)元15583 其中:權(quán)益資金equity funds萬(wàn)元0 債權(quán)資金indebtedness funds萬(wàn)元0 收入資金receipts funds萬(wàn)元155835經(jīng)營(yíng)收入萬(wàn)元593466開發(fā)成本real estate development costs萬(wàn)元302537開發(fā)費(fèi)用萬(wàn)元37348經(jīng)營(yíng)費(fèi)用(出租和自營(yíng)產(chǎn)業(yè))萬(wàn)元609應(yīng)繳稅金taxes due萬(wàn)元13947 經(jīng)營(yíng)稅金及附加Tax and additional expense萬(wàn)元3264 土地增值稅萬(wàn)元4808 所得稅Income tax萬(wàn)元587510利潤(rùn)總額total amo
117、unt of profits萬(wàn)元1780211稅后利潤(rùn)net income萬(wàn)元1192712可分配利潤(rùn)distributive profits 萬(wàn)元2891財(cái)財(cái)務(wù)務(wù)評(píng)評(píng)價(jià)價(jià)指指標(biāo)標(biāo)financialfinancial evaluationevaluation indexindex1投資利潤(rùn)率earning power of real assets%10.48%年平均2投資凈利潤(rùn)率net earning power of real assets%7.02%年平均3投資利稅率(不含所得稅)%15.23%年平均4資本金利潤(rùn)率profit-cost ratio%#DIV/0!年平均5資本金凈利潤(rùn)率ne
118、t profit-cost ratio%#DIV/0!年平均6全部投資內(nèi)部收益率(所得稅前)total investment internal rate of return%61.02%7全部投資投資回收期(所得稅前)年2.778全部投資內(nèi)部收益率(所得稅后)%34.25%9全部投資投資回收期(所得稅后)年3.9110項(xiàng)目建設(shè)經(jīng)營(yíng)期construct and manage period of project年511房地產(chǎn)投資長(zhǎng)期借款償還期period of compensate long term loans of real estate investment年建設(shè)期起12自營(yíng)部分盈虧平衡點(diǎn)(
119、經(jīng)營(yíng)達(dá)綱率)break-even point of self-support part%789101112131415161718100100(產(chǎn)權(quán)面積)1440144090%100%單位:萬(wàn)元789101112131415161718000000000000000000000000單位:萬(wàn)元78910000000000000000000000000000000000000單位:萬(wàn)元789101112131415161718000000000000000000000000000000000000單位:萬(wàn)元789101112131415161718000000000000000000000000
120、000000000000單位:萬(wàn)元7891011121314151617180000000000000000000000000000000000006006006006006006006006006006006006000000000000000000000000005050505050505050505050500000000000000000000000000000000000001000100010001000100010001000100010001000100010000000000000000000000000001001001001001001001001001001001001
121、000000000000000000000000000000000000001200120012001200120012001200120012001200120012000000000000000000000000002002002002002002002002002002002002000000000000000000000000000000000000001500150015001500150015001500150015001500150015000000000000000000000000001000100010001000100010001000100010001000100010
122、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000789101112131415161718000000000000000000000000000000000000單位:萬(wàn)元78910111213141516171800000000000000000000000000000000000000000000000000000000000078910111213141516171800000000000000000000000000000000000000
123、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007891011121314151617180000000000000000000000000000000000000000000000000000000000000000000000000 00 00 00 00 0000000000000單位:萬(wàn)元789101112131415161718
124、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000單位:萬(wàn)元78910111213141516171800000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0!#DIV/0!00000000
125、0000000000000000000000000000000000000000單位:萬(wàn)元7891011121314151617181.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000000000001%1%1%1%1%1%1%1%1%
126、1%1%1%000000000000000000000000000000000000586586586586586586586586586586586586單位:萬(wàn)元7891011121314151617180000000000005857958579585795857958579585795857958579585795857958579585790000000000003025330253302533025330253302533025330253302533025330253302530%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0!#DIV/0!100%100%100%1
127、00%100%100%100%100%100%#DIV/0!#DIV/0!#DIV/0!單位:萬(wàn)元789101112131415161718000000000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!000000000000單位:萬(wàn)元789101112131415161718100100660000000000550000000000000000000000000000000000000000000000000000000000
128、單位:萬(wàn)元7891011121314151617181561730000000000144014400000000000100100000000000090%100%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%9100000000000890000000000110000000000000000000000000000000000000000000000單位:萬(wàn)元78910111213141516171800
129、00000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%0000000000000000000000000%0%0%0%0%0%0%0%0%0%0%0%000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!000000000000單位
130、:萬(wàn)元7891011121314151617180000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000單位:萬(wàn)元789101112131415161718256273000000000000000000000015617300000000001001000000000000000000000000202014150000000000000000000000000000000000221238000000000022123800000000007378000000000
131、02200000000001481590000000000222400000000007800000000007800000000007800000000008288950000000001261350000000000384100000000001314000000000013140000000000131400000000008895000000000022123800000000002212380000000000單位:萬(wàn)元78910111213141516171825627300000000000000000000001561730000000000100100000000000000
132、000000000000000000000010711400000000000000000000000000000000002020000000000014150000000000000000000000000000000000737800000000007800000000001481590000000000111931135211352113521135211352113521135211352113521135211351229246000000000017577178231782317823178231782317823178231782317823178221782276740000
133、0000005610568556845684568456845684568456845684568456841171150000000000103601047410474104741047410474104741047410474104741047410474FIRR(稅后)34%456789原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值10400114401489016379341837602562812733000011789135585449626710111610712311413100-1390-2118944010112331736441481581591
134、70000.57180.49720.43230.37590.32690.2843-795-121146935027143415755659525500-2374-4166231986137532436380924963861255138612551單位:萬(wàn)元789101112131415161718256273000000000000000000000015617300000000001001000000000000000000000000000000000000000000000000000000000000000000000000107113000000000000000000000000
135、000000000000000000000020200000000000141500000000000000000000000000000000007378000000000000000000000078000000000014815900000000002959629756297562975629756297562975629756297562975629756297565652000000000019053191051910519105191051910519105191051910519105191051910522924600000000003598136227362273622736
136、2273622736227362273622736227362273622786800000000000232262330623306233062330623306233062330623306233062330623306FIRR(稅后)#NUM!單位:萬(wàn)元78910111213141516171814815900000000002562730000000000000000000000156173000000000010010000000000000000000000001071130000000000000000000000000000000000202000000000001415000
137、000000000000000000000000000000073780000000000780000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000-38-41000000000000000000000000000000000000000000000038410000000000000000000000000000000000384100000000000000000000001111190000000000423294244742447424474244742
138、447424474244742447424474244742447單位:萬(wàn)元789101112131415161718000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000148159000000000000000000000000000000000014815900000000001481590000000000#DIV/0!#DIV/0
139、!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!單位:萬(wàn)元78910111213141516171842329424474244742447424474244742447424474244742447424474244742329424474244742447424474244742447424474244742447424474244
140、70000000000000000000000004232942447424474244742447424474244742447424474244742447424471111190000000000000000000000000000000000000000000000000000000000111119000000000000000000000022240000000000889500000000000%0%0%0%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#
141、DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!19201920000000000019200000001920000000192000000060060000005050000000100010000000100100000000120012000000200200000000150015000000100010000000000000000000192000000019200000000000192000000000000000000000000
142、00000000019200000000000000019200000000000000000000019200000#DIV/0!#DIV/0!#DIV/0!#DIV/0!0000000019201.0%1.0%00001.0%1.0%00001.0%1.0%00001%1%0000005865861920005857958579003025330253#DIV/0!#DIV/0!#DIV/0!#DIV/0!19200000#DIV/0!#DIV/0!00192000000000000019200000000%0%00000%0%00000%0%0000000000001920000%0%0
143、0000%0%00000%0%00000%0%0000#DIV/0!#DIV/0!0019200000000000000001920000000000000000000000000000000000000000000000000000019200000000000000000000000000000000011351113510017822178220056845684001047410474101112131415原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值00000000000000024502450407040704000-2450-2450-4070-407
144、0-40.24720.21490.18690.16250.14130.1229000-530-460-660-5700386125513861249838612452386123863861232938612328192000000000000000000000000000000000000000000029756297560019105191050036227362270023306233061920000000000000000000000000000000000000000000000000000000000000000042447424471920000000000000000000000000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!192042447424474244742447000042447424470000000000000000000%0%#DIV/0!#DIV/0!#DIV/0!#DIV/0!1617181920原始值變動(dòng)值原始值變動(dòng)值原始值變動(dòng)值變動(dòng)值原始值變動(dòng)值000000000004040400000-40-40-400000.10690.09290.08080.07030.061100000000003861232838612328386123273861232738612327