房地產(chǎn)年度預(yù)算表

,,,,,,,,,,,,,,,,,,,,,,,

項目財務(wù)分析假定,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

開發(fā)計劃,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,地塊編號,,,土地面積,地上建筑面積,地下建筑面積,小計,,套數(shù),車位數(shù),容積率,,,,,,,,,,,

,,,,,,,平方米,,,,,,,,,,,,,,,

,1#地塊,"在建,2013年底竣工",,"46,768","112,244","23,199","135,443",,"1,221",630,2.40,,,,,,,,,,,

,,1#地回遷住宅,,"42,326","93,739","11,414","105,153",,"1,221",293,,,,,,,,,,,,

,,1#地回遷商業(yè),,,"14,592",,"14,592",,,,,,,,,,,,,,,

,,1#地配套設(shè)施,,,"3,913",,"3,913",,,,,,,,,,,,,,,

,,1#地地下車庫,,,,"11,785","11,785",34.97032641,,337,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,2#地塊,擬建，2014年4月開工,,"47,777","122,308","30,509","152,817",,"1,173",696,2.56,,,,,,,,,,,

,,2#地回遷住宅,,,"106,504","14,550","121,054",,"1,173",296,,,,,,,,,,,,

,,2#地回遷商業(yè),,,"13,817",,"13,817",,,,,,,,,,,,,,,

,,2#地配套設(shè)施,,,"1,987",,"1,987",,,,,,,,,,,,,,,

,,2#地地下車庫,,,,"15,959","15,959",39.8975,,400,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,3#地塊,擬建，2014年9月開工,,"63,004","201,534","40,000","241,534",,"1,700","1,092",3.20,,,,,,,,,,,

,,3#地商品住宅,,,"157,934","20,000","177,934",,"1,700",558,,,,,,,,,,,,

,,3#地辦公公寓,,,"32,000",,"32,000",,,,,,,,,,,,,,,

,,3#地底商,,,"11,600",,"11,600",,,,,,,,,,,,,,,

,,3#地地下車庫,,,,"20,000","20,000",37.4339132,,534,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,4#地塊,擬建，2015年9月開工,,"24,371","122,615","45,000","167,615",,810,735,5.03,,,,,,,,,,,

,,4#地辦公公寓,,,"65,415","17,487","82,902",,810,0,,,,,,,,,,,,

,,4#地集中商業(yè),,,"57,200",,"57,200",,,,,,,,,,,,,,,

,,4#地地下車庫,,,,"27,513","27,513",37.4339132,,735,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,5#地塊,在建，2015年全部竣工,,"40,135","126,722","29,153","155,875",,"1,098",673,3.16,,,,,,,,,,,

,,5#地商品住宅,,"16,360","118,811","13,739","132,550",,"1,098",213,,,,,,,,,,,,

,,5#地底商,,,"2,173",,"2,173",,,,,,,,,,,,,,,

,,5#地配套設(shè)施,,,"5,738",326,"6,064",,,,,,,,,,,,,,,

,,5#地地下車庫,,,,"15,088","15,088",,,460,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,6#地塊,在建，2015年竣工,,"30,788","95,929","26,904","122,833",,896,631,3.12,,,,,,,,,,,

,,6#地商品住宅,,,"90,853","8,368","99,221",,896,172,,,,,,,,,,,,

,,6#地底商,,,"4,904","1,858","6,762",,,,,,,,,,,,,,,

,,6#地配套設(shè)施,,,172,,172,,,,,,,,,,,,,,,

,,6#地地下車庫,,,,"16,678","16,678",,,459,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,7#地塊,擬建，2015年9月開工,,"11,569","46,270","16,000","62,270",,0,427,4.00,,,,,,,,,,,

,,7#地辦公公寓,,,"23,730",,"23,730",,,,,,,,,,,,,,,

,,7#地集中商業(yè),,,"22,540",,"22,540",,,,,,,,,,,,,,,

,,7#地地下車庫,,,,"16,000","16,000",37.4339132,,427,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,8#地塊,擬建，2015年9月開工,,"12,242","52,640","18,600","71,240",,0,496,4.30,,,,,,,,,,,

,,8#地辦公公寓,,,"37,640",,"37,640",,,,,,,,,,,,,,,

,,8#地底商,,,"15,000",,"15,000",,,,,,,,,,,,,,,

,,8#地地下車庫,,,,"18,600","18,600",37.4339132,,496,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,土地面積,地上建筑面積,地下建筑面積,總建筑面積,,住宅套數(shù),車位數(shù),容積率,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,"276,654","880,262","229,365","1,109,627",,"6,898","5,380",3.18,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,回遷面積（含保障房）,,可銷售面積（地上）,,,,,開工日期,2013/10/1,,,,,,,,,,,

,,,回遷住宅,回遷商業(yè),商品住宅,辦公公寓,底商,集中商業(yè),,竣工日期,2017/9/30,,,,,,,,,,,

,,,"200,243","28,409","367,598","158,785","33,677","79,740",,評價日,2013/6/20,,,,,,,,,,,

,,,"228,652",,"639,800",,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

開發(fā)成本,項目財務(wù)分析假定,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,土地、市政配套以及建設(shè)成本,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,土地費用,,,,,,,,,,,,,,,,,,,,,

,,,,面積/規(guī)模,,,收費標準,,,,土地費用,,,,,,,,,,,

,,,,平方米,,,,,,,萬元,,,,,,,,,,,

,,土地出讓金,,0,0,,#DIV/0!,萬/畝,返還7.9億元,105%,#DIV/0!,,,,,,,,,,,

,,土地契稅,,,,,4.0%,按土地交易總額收取,,,#DIV/0!,,,,,,,,,,,

,,安置補償費,,"1,045",,,"12,000",/戶/年（按5年計算）,,,"6,270",,,,,,,,,,,

,,拆遷及三通一平費,,0,全部土地（含回遷區(qū)）,,100,元/平方米（按土地面積）,,,0,,,,,,,,,,,

,,回遷樓建設(shè)費,,0,回遷建筑面積（不含車庫）,,#REF!,元/平方米（按商品房建筑面積）,,,#REF!,,,,,,,,,,,

,,,,,,,#DIV/0!,元/平方米,,土地費總計,#DIV/0!,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,大市政配套費,,,,,,#DIV/0!,元/平方米,,大市政配套費總計,0,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,環(huán)境及紅線內(nèi)配套建設(shè)費,,,,,,#DIV/0!,元/平方米,,環(huán)境及小區(qū)配套費總計,0,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,建安成本,,,,,,,,,建安成本總計,0,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,建筑面積,建安成本,,大市政配套費,,小區(qū)環(huán)境及配套,,建筑成本,,,,,,,,,,,

,,,,平方米,元/平方米,,元/平方米,,元/平方米,,萬元,,,,,,,,,,,

,回遷地塊（1、2）,回遷住宅（1號地）,,-,"1,800",-,-,-,200,-,-,,,,,,,,,,,

,,回遷住宅（2號地）,,-,"1,800",-,-,-,200,-,-,,,,,,,,,,,

,,回遷商業(yè),,-,"2,000",-,-,-,200,-,-,,,,,,,,,,,

,,回遷地上配套設(shè)施,,-,"2,000",-,-,-,-,-,-,,,,,,,,,,,

,,回遷地下配套設(shè)施,,-,"2,600",-,-,-,-,-,-,,,,,,,,,,,

,開發(fā)地塊（3、4、5、6、7、8）,商品住宅,,-,"2,000",-,77,-,280,-,-,,,,,,,,,,,

,,辦公公寓,,-,"2,000",-,77,-,280,-,-,,,,,,,,,,,

,,底商,,-,"2,000",-,77,-,280,-,-,,,,,,,,,,,

,,集中商業(yè),,-,"3,000",-,77,-,280,-,-,,,,,,,,,,,

,,地上配套設(shè)施,,-,"2,000",-,-,-,-,-,-,,,,,,,,,,,

,,地下配套設(shè)施,,-,"2,800",-,-,-,-,-,-,,,,,,,,,,,

,,地下車庫,,-,"3,000",-,-,-,-,-,-,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,-,,商品房建筑成本,#DIV/0!,元/平方米,,建筑成本總計,0,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,專業(yè)費,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,規(guī)劃設(shè)計費,,,,,3%,建筑成本,,0,,,,,,,,,,,

,,,項目管理,,,,,1%,建筑成本,,0,,,,,,,,,,,

,,,評估費,,,,,0%,建筑成本,,0,,,,,,,,,,,

,,,內(nèi)部設(shè)計,,,,,0%,建筑成本,,0,,,,,,,,,,,

,,,其他顧問費,,,,,0.5%,建筑成本,,0,,,,,,,,,,,

,,,,,,,總共,5%,建筑成本,,0,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,其它費用,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,不可預(yù)見費,,,,,5%,建筑成本,,,,,,,,,,,,,

,,,銷售費用,,,,,1%,銷售收入,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,財務(wù)條件,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,股東借款,,,,,4,億元,,,,,,,,,,,,,

,,,信托融資額度,,,,,5.5,億元,其中4億元期限1年，剩余1.5億1.5年期限,,,,,,,,,,,,

,,,信托融資成本,,,,,16%,每年,,,,,,,,,,,,,

,,,信托融資周期,,,,,1.5,年,,,,,,,,,,,,,

,,,開發(fā)貸款融資額,,,,,8,億元,,,,,,,,,,,,,

,,,開發(fā)貸款利息,,,,,9%,每年,,,,,,,,,,,,,

,,,貼現(xiàn)率,,,,,10%,,,,,,,,,,,,,,

,,,資本化率,,,,,15%,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,稅費,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,營業(yè)稅,,,,,5.65%,按營業(yè)收入記,,,,,,,,,,,,,

,,,土地增值稅,,,,,#REF!,增值額,預(yù)征,2.0%,,,,,,,,,,,

,,,企業(yè)所得稅,,,,,25%,按利潤記,預(yù)征,3.75%,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

經(jīng)營計劃,項目財務(wù)分析假定,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,營銷方案,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,平方米,,,售價(元/平方米),,開售日期,銷售進度,,,,,,,,漲價幅度,,,,

,,,,,,,,,,第1季度,第2季度,第3季度,第4季度,第5季度,第6季度,第7季度,第8季度,,,,,

,,0,,0,,,"5,900",,2015年5月,15%,35%,55%,75%,85%,95%,100%,100%,1.3%,,,,

,,0,,0,,,"5,900",,2015年5月,15%,35%,55%,75%,85%,95%,100%,100%,1.3%,,,,

,,0,,0,,,"15,000",,2015年5月,15%,35%,55%,75%,85%,95%,100%,100%,1.3%,,,,

,,0,,,0,個車位,"120,000",萬/個,2016年1月,15%,35%,55%,75%,85%,95%,100%,100%,1.3%,,,,

,,0,,0,,,"5,800",,2016年10月,100%,4號地項目擬定制開發(fā)，建成后一次性售出。,,,,,,,,,,,

,,0,,0,,,"7,500",,2016年10月,100%,,,,,,,,,,,,

,,0,,,0,個車位,"120,000",萬/個,2016年10月,100%,,,,,,,,,,,,

,,0,,0,,,"5,800",,2014年6月,50%,60%,70%,80%,90%,100%,100%,100%,1.3%,,,,

,,0,,0,,,"15,000",,2014年6月,15%,30%,45%,60%,75%,90%,100%,100%,1.3%,,,,

,,0,,,0,個車位,"120,000",萬/個,2015年6月,15%,35%,55%,75%,85%,95%,100%,100%,1.3%,,,,

,,0,,0,,,"5,900",,2014年6月,50%,60%,80%,90%,100%,100%,100%,100%,1.3%,,,,

,,0,,0,,,"15,000",,2014年6月,15%,30%,45%,60%,75%,90%,100%,100%,1.3%,,,,

,,0,,,0,個車位,"120,000",萬/個,2015年3月,15%,35%,55%,75%,85%,95%,100%,100%,1.3%,,,,

,,0,,0,,,"5,800",,1899年12月,100%,7號地項目擬定制開發(fā)，建成后一次性售出。,,,,,,,,,,,

,,0,,0,,,"7,500",,1899年12月,100%,,,,,,,,,,,,

,,0,,,0,個車位,"120,000",萬/個,1899年12月,100%,,,,,,,,,,,,

,,0,,0,,,"5,800",,1899年12月,100%,8號地項目擬定制開發(fā)，建成后一次性售出。,,,,,,,,,,,

,,0,,0,,,"15,000",,1899年12月,100%,,,,,,,,,,,,

,,0,,,0,個車位,"120,000",萬/個,1899年12月,100%,,,,,,,,,,,,

,,,,0,0,(回遷區(qū)地下車位暫不考慮出售）,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,項目現(xiàn)金流出量分析,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,現(xiàn)金流出,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,期間,,,,,總計,0,1,,,2,,,3,,,4,,,5,,

,從,,,,,萬元,,1899/12/31,1900/1/31,1900/3/2,1900/4/2,1900/5/3,1900/6/3,1900/7/4,1900/8/4,1900/9/4,1900/10/5,1900/11/5,1900/12/6,1901/1/6,1901/2/6,1901/3/9

,,,,,,,,,,,,,,,,,,,,,,,

,,0.0,,,,"39,308",,"38,576",52,52,52,52,52,52,52,52,52,52,52,52,52,52

,,,0.0,,,"35,524",,"35,524",,,,,,,,,,,,,,

,,,0.0,,,"3,000",,"3,000",,,,,,,,,,,,,,

,,,0.0,,,784,,52,52,52,52,52,52,52,52,52,52,52,52,52,52,52

,,,0.0,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,0.0,,,,"1,552",,-,-,-,-,-,-,-,-,-,776,776,-,-,-,-

,,,0.0,,,"1,552",,-,-,-,-,-,-,-,-,-,776,776,-,-,-,-

,,,,0.0,,"1,216",,,,,,,,,,,608,608,,,,

,,,,0.0,,246,,,,,,,,,,,123,123,,,,

,,,,0.0,,89,,,,,,,,,,,45,45,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,0.0,,,,"4,163",,-,,,-,,,565,565,565,502,502,502,321,321,321

,,,0.0,,,"1,625",,-,,,-,,,-,,,361,361,361,181,181,181

,,,,0.0,,"1,406",,,,,,,,,,,312,312,312,156,156,156

,,,,0.0,,219,,,,,,,,,,,49,49,49,24,24,24

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,0.0,,,"2,538",,-,,,-,,,565,565,565,141,141,141,141,141,141

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,"2,495",,,,,,,,554,554,554,139,139,139,139,139,139

,,,,0.0,,43,,,,,,,,10,10,10,2,2,2,2,2,2

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,0.0,,,,"39,030",,"3,284","2,591","2,286",-,-,-,"3,107","3,107","3,107","3,185","3,185","3,185","3,998","3,998","3,998"

,,,0.0,,,"12,586",,405,405,405,-,-,-,659,659,659,"1,332","1,332","1,332","1,799","1,799","1,799"

,,,,0.0,,"2,024",,193,193,193,,,,193,193,193,193,193,193,96,96,96

,,,,1號2號樓,,"2,612",,,,,,,,254,254,254,308,308,308,308,308,308

,,,,0.0,,638,,61,61,61,,,,61,61,61,61,61,61,30,30,30

,,,,0.0,,820,,78,78,78,,,,78,78,78,78,78,78,39,39,39

,,,,0.0,,773,,74,74,74,,,,74,74,74,74,74,74,37,37,37

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,"3,547",,,,,,,,,,,383,383,383,799,799,799

,,,,0.0,,511,,,,,,,,,,,55,55,55,115,115,115

,,,,0.0,,773,,,,,,,,,,,84,84,84,174,174,174

,,,,0.0,,886,,,,,,,,,,,96,96,96,199,199,199

,,,,,,-,,,,,,,,,,,,,,,,

,,,0.0,,,"26,444",,"2,878","2,186","1,880",-,-,-,"2,447","2,447","2,447","1,853","1,853","1,853","2,199","2,199","2,199"

,,,,0.0,,744,,,,,,,,,,,,,,248,248,248

,,,,0.0,,128,,,,,,,,,,,,,,43,43,43

,,,,0.0,,46,,,,,,,,,,,,,,15,15,15

,,,,0.0,,120,,,,,,,,,,,,,,40,40,40

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,"8,518",,946,"1,420",473,,,,946,946,946,473,473,473,473,473,473

,,,,16號樓,,"1,192",,,,,,,,132,132,132,132,132,132,132,132,132

,,,,0.0,,152,,17,17,17,,,,17,17,17,8,8,8,8,8,8

,,,,0.0,,434,,48,48,48,,,,48,48,48,24,24,24,24,24,24

,,,,0.0,,"1,584",,176,176,176,,,,176,176,176,88,88,88,88,88,88

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,"10,257",,"1,282",321,962,,,,855,855,855,855,855,855,855,855,855

,,,,0.0,,751,,94,47,47,,,,63,63,63,63,63,63,63,63,63

,,,,0.0,,17,,2,1,1,,,,1,1,1,1,1,1,1,1,1

,,,,0.0,,"2,502",,313,156,156,,,,208,208,208,208,208,208,208,208,208

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,0.0,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,0,,,,"1,756",,148,117,103,-,-,-,140,140,140,143,143,143,180,180,180

,,,,,,-,,,,,,,,,,,,,,,,

,,0,,,,"2,251",,164,130,114,100,100,100,155,155,155,159,159,159,200,200,200

,,,,,,-,,,,,,,,,,,,,,,,

,,0,,,,-,,-,,,-,,,-,,,-,,,-,,

,,,,,,-,,,,,,,,,,,,,,,,

,,0,,,,"2,400",,,,-,,,-,,,-,,,-,,,"2,400"

,,,,,,-,,,,,,,,,,,,,,,,

,,0,,,,"5,400",,,,,,,,,,"1,800",-,,"1,800",-,,"1,800"

,,,,,,-,,,,,,,,,,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,歸還信托借款本金,,,,"40,000",,,,,,,,,,,,,"40,000",,,

,,,,,,-,,,,,,,,,,,,,,,,

,,歸還銀行貸款,,,,-,,,,,,,,,,,,,,,,

,,,,,,"80,000",,-,,,,,,"80,000",,,,,,,,

,,累計貸款,,,,"80,000",,-,,,-,-,-,"80,000",-,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,歸還股東借款,,,,"38,000",,"9,000",,"10,000","8,000",,,"11,000",,,,,,,,

,,,,,,-,,,,,,,,,,,,,,,,

,,現(xiàn)金總流出,,,,"173,860",,"51,172","2,889","12,555","8,152",152,152,"15,018","4,018","5,818","4,818","4,818","45,842","4,751","4,751","8,951"

,項目現(xiàn)金流入量分析,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,現(xiàn)金流入,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,期間,,,,,共計,0,1,,,2,,,3,,,4,,,5,,

,從,,,,,萬元,,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,-,-,,,-,,,-,,,-,,,-,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,-,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,-,-,,,-,,,-,,,-,,,-,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,,,

,,,銷售收入,,,0,-,-,,,-,,,-,,,-,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,個車位,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,-,-,,,-,,,-,,,-,,,-,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,-,-,,,-,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,個車位,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,-,-,-,-,,

,,,售價增長(%),,,,,,,,,,,,,,,,,1.3%,,

,,,銷售率(%),,,,,,,,,,,,,,35%,10%,5%,0%,,

,,,銷售量,,,0,-,-,,,-,,,-,,,-,-,-,-,,

,,,銷售收入,,,0,-,-,,,-,,,-,,,-,-,-,-,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,-,-,,,-,,,-,,,-,,,-,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,個車位,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,,,

,,,銷售收入,,,0,-,-,,,-,,,-,,,-,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,"5,900","5,900","5,900"

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,35%,10%,5%

,,,銷售量,,,0,-,-,,,-,,,,,,,,,-,-,-

,,,銷售收入,,,0,-,-,,,-,,,-,,,-,,,-,-,-

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,,,,,,,,,,,,

,,,銷售收入,,,0,-,-,,,-,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,個車位,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,,,

,,,銷售收入,,,0,-,-,,,-,,,-,,,-,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,個車位,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,平方米,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,0,,,0,個車位,,,,,,,,,,,,,,,,,

,,,售價,,,,,,,,,,,,,,,,,,,

,,,售價增長(%),,,,,,,,,,,,,,,,,,,

,,,銷售率(%),,,,,,,,,,,,,,,,,,,

,,,銷售量,,,,-,-,,,-,,,-,,,-,,,-,,

,,,銷售收入,,,0,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,銷售總收入,,,0,0,0,,,0,,,0,,,0,0,0,0,0,0

,,,,,,0,,,,,,,,,,,,,,,,

,,,,商品住宅銷售面積（平方米）,,0,0,0,,,0,,,0,,,0,0,0,0,0,0

,,,,,銷售收入（萬元）,0,0,0,,,0,,,0,,,0,0,0,0,0,0

,,,,,,,,,,,,,,,,,,,,,,,

,,,,公寓辦公銷售面積（平方米）,,0,0,0,,,0,,,0,,,0,,,0,,

,,,,,銷售收入（萬元）,0,0,0,,,0,,,0,,,0,,,0,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,底商銷售面積（平方米）,,0,0,0,,,0,,,0,,,0,,,0,,

,,,,,銷售收入（萬元）,0,0,0,,,0,,,0,,,0,,,0,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,集中商業(yè)銷售面積（平方米）,,0,0,0,,,0,,,0,,,0,,,0,,

,,,,,銷售收入（萬元）,0,0,0,,,0,,,0,,,0,,,0,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,車位銷售數(shù)量（個）,,0,0,0,,,0,,,0,,,0,,,0,,

,,,,,銷售收入（萬元）,0,0,0,,,0,,,0,,,0,,,0,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,土地出讓金返還,,,"79,000",,,,25000,,,,15000,,,,,39000,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,信托借款流入,,,"55,000",,55000,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,銀行貸款流入,,,"80,000",,,,,,,,80000,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,股東借款流入,,,0,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,,,現(xiàn)金總流入,,,"214,000",0,55000,0,25000,0,0,0,95000,0,0,0,0,39000,0,0,0

,,,,,,,,,,,,,,,,,,,,,,,

,現(xiàn)金流量分析匯總,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,稅費,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,期間,,,,,總計,0,1,,,2,,,3,,,4,,,5,,

,從,,,,,萬元,,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31,1899/12/31

,,,,,,,,,,,,,,,,,,,,,,,

,,,營業(yè)稅,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,土地增值稅,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,所得稅,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,,,,,,,,,,,,,,,,,,,,,

,,,全部稅費,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,現(xiàn)金流量匯總,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,總現(xiàn)金流出,,,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,,,,,,,,,,,,,,,,,,,,,

,,,,總投資,,0.0,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,總現(xiàn)金流入,,,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,0.0,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,,,,,,,,,,,,,,,,,,,,,

,稅前凈流量,,,,,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0

,,,,,,,,,,,,,,,,,,,,,,,

,稅后凈流量,,,,,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-

,,,現(xiàn)金盈余（假設(shè)期初為0）,,,,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-,-

,,,,,,,,,,,,,,,,,,,,,,,

,項目敏感性分析,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,

,NPV和IRR對于售價和建安成本的敏感度,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,萬元,,,,,,,,,,,,

,凈現(xiàn)值,建安成本,,售價變化百分比,,,,,,,,,,,,,,,,,,

,,元/平方米,#REF!,-15%,-10%,-5%,0%,5%,10%,15%,,,浮動指數(shù),,,,,,,,,

,建安成本改變,#VALUE!,-30%,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,,,,,,,,,,,,

,,#VALUE!,-25%,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,,,成本,,0%,,,,,,,

,,#VALUE!,-20%,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,,,售價,,0%,,,,,,,

,,#VALUE!,-15%,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,,,租金,,0%,,,,,,,

,,#VALUE!,-10%,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,,,入住率,,0%,,,,,,,

,,#VALUE!,-5%,#REF!,#REF!,#R