1、建建筑筑規規模模估估算算表表項項目目戶戶型型單單套套面面積積 一一梯梯戶戶數數樓樓層層單單元元棟棟數數建建筑筑面面積積住宅多層一房0兩房852730小三房0三房1202730四房1452730復式0小小計計0小高層一房0兩房9021111121780小三房10021211024000三房13021211031200四房0復式0小小計計76980高層一房0兩房0小三房0三房0四房0復式0小小計計0洋房第一層0第二層0第三層0第四層0第五層0第六層0小小計計0別墅獨棟200100聯排180100雙拼160100疊加1101000寫字樓0酒店賓館0商業180012111600公建配套0合計78580
2、占地面積(畝)占地面積(平方米)容積率建筑密度建筑面積(平方米)基座面積(平方米)40.1229531295312.82.825%25%826868268673837383項目建筑面積(平方米)基座面積(平方米)容積率建筑密度規劃標準8268673832.825%擬定規模7858073802.725%基基座座面面積積戶戶數數000000000000000019802422000240260024000006580722000000000000000000000000000000000000000080007380基座面積(平方米)738373831 12 23 34 4銷銷售售價價格格(元元/
3、平平方方米米)均價 項目1(住宅)項目2(小高層)400050006000 項目3(高層)項目4(商業)項目5(地下車位)銷銷售售計計劃劃(平平方方米米)78580 項目1(住宅)0.0050.0010.0010.0010.001 項目2(小高層)76980200003000026980 項目3(高層)0.0050.0010.0010.0010.001 項目4(商業)16001600 項目5(地下車位)0.0050.0010.0010.0010.001開開發發計計劃劃(平平方方米米)78580 項目1(多層)土建0 項目1(多層)安裝0 項目2(小高層)土建769802000030000269
4、80 項目2(小高層)安裝76980200003000026980 項目3(高層)土建0 項目3(高層)安裝0 項目4(商業)土建16001600 項目4(商業)安裝16001600 項目5(地下車位)土建0 項目5(地下車位)安裝0回回款款計計劃劃 項目1(住宅)項目2(小高層)100%100%100%100%項目3(高層)100%100%100%100%項目4(商業)100%100%100%100%項目5(地下車位)100%100%100%100%出出租租價價格格(元元/平平方方米米)項目1(地上車位)項目2 項目3出出租租計計劃劃(平平方方米米)0 項目1(地上車位)0 項目20 項目3
5、0出出租租率率(%)(%)項目1(地上車位)項目2 項目3土地費用序號項目合計12341土地出讓金379837982交易服務費19193土地權屬調查及地籍測繪004%交易契稅152152000共計39693969000前期工程費用序號項目合計12341可行性研究費20202規劃設計費44443水文地質勘測費10105三通一平44443%其他26660969020共計384178969020基礎設施建設費用序號項目合計12341供電工程02供水工程03供氣工程04排污工程05道路工程06通訊工程07綠化工程08照明工程09環衛設施010其他400400共計400400000公共配套設施建設費序號
6、項目合計12341會所02社區醫院03幼兒園04中小學05公共廁所06停車場07垃圾中轉站08水電機房09其他400100200共計40000100200建筑安裝工程費用序號項目合計12341 項項目目1 1(住住宅宅)0 000001.1 土建工程費0 00000 建筑面積(平方米)0000 單價(元/平方米)6006006006006001.2 安裝工程費0 00000 建筑面積(平方米)0000 單價(元/平方米)50505050502 項項目目2 2(小小高高層層)846884682000320029982702.1 土建工程費769876982000300026980 建筑面積(平方
7、米)2000030000269800 單價(元/平方米)100010001000100010002.2 安裝工程費7707700200300270 建筑面積(平方米)0200003000026980 單價(元/平方米)1001001001001003 項項目目3 3(高高層層)0 000003.1 土建工程費0 00000 建筑面積(平方米)0000 單價(元/平方米)120012001200120012003.2 安裝工程費0 00000 建筑面積(平方米)0000 單價(元/平方米)2002002002002004 項項目目4 4(商商業業)4004000004004.1 土建工程費240
8、240000240 建筑面積(平方米)0001600 單價(元/平方米)150015001500150015004.2 安裝工程費160160000160 建筑面積(平方米)0001600 單價(元/平方米)100010001000100010005 項項目目5 5(地地下下車車位位)0 000005.1 土建工程費0 00000 建筑面積(平方米)0000 單價(元/平方米)00005.2 安裝工程費0 00000 建筑面積(平方米)0000 單價(元/平方米)0000共計8868200032002998670開發間接費序號項目合計12341教育附加費1311312防空地下室易地建設費137
9、313733新型墻體材料專項費70704散裝水泥專項基金13135工程定額測定費16166施工管理費34347建筑工程監督費20208安全監督費17179白蟻防治費131310房屋面積測量費121211交易手續費525212登記手續費6614其他費用100100共計18571857000銷售費用序號項目合計12345.0%銷售代理費用195904007508090.0%廣告宣傳及推廣費用000000.0%其他銷售費用00000共計 19590400750809銷售費用投入計劃100%20%30%30%15%1959392588588294項目總投資估算表序號項目合計1234一開發建設投資196
10、4691154360430215071房地產開發成本161798481339532849171.1土地費用396939690001.2前期工程費3841789690201.3基礎設施建設費4004000001.4建筑安裝工程費88682000320029986701.5公共配套設施建設費400001002001.6開發間接費185718570001.7不可預見費302779996272房地產開發費用346663496510195902.1銷售費用19593925885882942.2管理費用8051611611611612.3財務費用70281216270135二經營資金0三項目總投資額196
11、4691154360430215071開發產品投資1964691154360430215072固定資產投資03經營資金00000項目回款進度表序號項目合計12341項目1(多層)000002項目2(小高層)391880800015000161883項目3(高層)000004項目4(商業)000005項目5(地下車位)00000小計39188391880800015000161882006項目1(多層)00 00 0項目2(小高層)00 00 0項目3(高層)00 00 0項目4(商業)00 00 0項目5(地下車位)00 00 02007項目1(多層)00 00 0項目2(小高層)800080
12、0080000 0項目3(高層)00 00 0項目4(商業)00 00 0項目5(地下車位)00 00 02008項目1(多層)00 00 0項目2(小高層)1500015000150000 0項目3(高層)00 00 0項目4(商業)00 00 0項目5(地下車位)00 00 02009項目1(多層)00 0項目2(小高層)161881618816188項目3(高層)00 0項目4(商業)00 0項目5(地下車位)00 02010項目1(多層)0項目2(小高層)0項目3(高層)0項目4(商業)0項目5(地下車位)02011項目1(多層)0項目2(小高層)0項目3(高層)0項目4(商業)0項目
13、5(地下車位)0小計3918839188080001500016188投資使用計劃與資金籌措表序號項目合計12341總投資1964619646911591154360436043024302150715071.1經營資金000001.2固定資產投資000001.3開發產品投資196469115436043021507 其中:不含財務費用189449034414440321372 財務費用702812162701352資金籌措35017350171150511505901790171262712627150715072.1權益資金850585050002.1.1 資本金750075002.1.2
14、 股票融資02.1.3 股東投資100510052.1.4 政府投資02.2債務資金500030002000002.2.1 長期貸款5000300020002.2.2 短期貸款02.2.3 企業債券02.2.4 融資租賃02.3收入資金21512070171262715072.3.1 預售收入2151270171262715072.3.2 租金收入02.3.3 自營收入02.3.4 貼補收入02.3.5 其他收入0貸款還本付息計劃表序號項目合計12341長期借款償還1.1年初借款本息累計3000500025001.2本年借款500030002000001.3本年應計利息702812162701
15、351.4本年還本付息57028121627702635 還本5000250025005.40%付息702812162701351.5年末借款本息累計30005000250002短期借款償還2.1年初借款本息累計0002.2本年借款000002.3本年應計利息000002.4本年還本付息00000 還本7.11%付息02.5年末借款本息累計00003本年還本付息570281216277026353.1 本年還本500000250025003.2 本年付息702812162701354還本資金來源972101548529928744.1攤銷000004.2折舊000004.3稅后利潤972101
16、548529928744.4其他05償還長期貸款本金能力47210154827993746利息備付率1911127297償債備付率218218長期借款償還期(年)4銷售收入與經營稅金估算表序號項目合計12341銷售收入391880800015000161881.1可銷售面積(平方米)7858002000030000285801.2平均售價元(元/平方米)498704000500056641.3銷售比例(%)0%25%38%36%經營稅金及附加215504408258905%營業稅195904007508097%城市維護建設稅13702853573%教育費附加590122324土地增值稅預征估算
17、表序號項目合計12341項項目目1 1(多多層層)1.0%1.0%1.0%1.0%銷售收入000001.0%預征稅額000002項項目目2 2(小小高高層層)1.0%1.0%1.0%1.0%銷售收入391880800015000161881.0%預征稅額3920801501623項項目目3 3(高高層層)1.0%1.0%1.0%1.0%銷售收入000001.0%預征稅額000004項項目目4 4(商商業業)1%1%1%1%銷售收入000001.0%預征稅額000005預征土地增值稅總額392080150162累計預征土地增值稅080230392土地增值稅估算附表序號項目合計12341銷售收入3
18、91880800015000161882累計銷售收入0800023000391883開發成本1617904061609160274累計開發成本0406110152161795銷售比例0%25%38%36%85%累計銷售比例0%25%64%100%25%64%100%土地增值稅估算表序號項目合計12341銷售收入78376000391882扣除項目46377000231882.1 開發成本32359000161792.2 開發費用323600016182.3 銷售稅金431100021552.4 其他扣除額647200032363增值額000160004增值比例0%0%0%69%5增值稅率0%0
19、%0%40%6速算扣除率0%0%0%5%7土地增值稅00052409已交土地增值稅0802303929本年應繳土地增值稅0004849自營收入及經營稅金估算表序號項目合計12341自營收入02經營稅金及附加000005%營業稅000007%城市維護建設稅000003%教育費附加000003凈轉售收入000003.1轉售價格03.2轉售成本03.3轉售稅金00000租金收入及經營稅金估算表序號項目合計12341租金收入(萬元)000001.1.1 可出租面積(平方米)00001.1.2 單位租金(元/月/平方米)00001.1.3 出租率(%)0%0%0%0%1.2.1 可出租面積(平方米)00
20、001.2.2 單位租金(元/月/平方米)00001.2.3 出租率(%)0%0%0%0%1.3.1 可出租面積(平方米)00001.3.2 單位租金(元/月/平方米)00001.3.3 出租率(%)0%0%0%0%2經營稅金及附加000005%營業稅000007%城市維護建設稅000003%教育費附加000004凈轉售收入000004.1轉售價格04.2轉售成本04.3轉售稅金00000經營成本分攤表序號項目合計12341 項項目目1 1(住住宅宅)0.00%已銷售面積00000銷售比例20%20%20%20%開發總成本000002 項項目目2 2(小小高高層層)97.96%已銷售面積769
21、800200003000026980銷售比例0%26%39%35%開發總成本1563004061609154783 項項目目3 3(高高層層)0.00%已銷售面積00000銷售比例20%20%20%20%開發總成本000004 項項目目4 4(商商業業)2.04%已銷售面積16000001600銷售比例0%0%0%100%開發總成本5490005495 項項目目5 5(地地下下車車位位)已銷售面積00000銷售比例20%20%20%20%開發總成本04合計161790406160916027固定資產折舊固定資產3466折舊年限20殘值率5%年折舊額165固定資產轉售年限15固定資產轉售成本99
22、7出租部分轉售月租金(元/平方米/月)100出租面積(平方米)1000出租率(%)80%運營費用(萬元)20%凈租金收益(萬元)76.8收益年限(年)50報酬率(%)8%轉售價格(萬元)940自營部分轉售年經營收入(萬元)1000年經營成本(萬元)20年經營費用(萬元)30經營稅金及附加(萬元)52.25正常利潤率(%)10%年凈收益(萬元)797.75經營年限(年)10報酬率(%)7%轉售價格(萬元)5603成本費用估算表序號項目合計12341開開發發成成本本16179104061609160271.1 銷售部分1617904061609160271.2 出租部分010年01.3 自營部分0
23、2開開發發費費用用346663496510195902.1 銷售費用19593925885882942.2 管理費用805161161161161 折舊0 攤銷02.3 財務費用702812162701353開發成本費用19646644502671106617利潤與利潤分配表序號項目合計12341經營收入391880800015000161881.1銷售收入391880800015000161881.2租金收入000001.3自營收入000002開發成本費用196566445026711066173補貼收入(先征返還)04經營費用(出租和自營產業)05經營稅金及附加21550440825890
24、6土地增值稅預征3920801501627土地增值稅484900048498利潤總額1343102534706538329彌補前年度虧損47047010應納稅所得額12961020647065383225%所得稅3240051617669581%所得稅預征130021713811凈利潤(稅后利潤)9721015485299287412期初未分配利潤01254542113可供分配利潤75107015486553829510%法定盈余公積金97201555302871212三三項項基基金金00000 儲儲備備基基金金00000 企企業業發發展展基基金金00000 職職工工獎獎勵勵及及福福利利基基金
25、金00000可供投資者分配利潤013936023800715應付優先股股利00%任意盈余公積金0000016應付普通股股利017各投資方可分配利潤013936023800718各投資方利潤分配4919013960280110%A方491901396028010%B方000000%C方0000018年末未分配利潤012545421720719息稅前利潤8127507335396720息稅折舊攤銷前利潤8127507335396721盈余公積9720155530287現金流量表(全部投資)序號項目合計12341 1現現金金流流入入391880800015000161881.1銷售收入3918808
26、00015000161881.2租金收入000001.3自營收入000001.4補貼收入(先征返還)000001.5回收其他資金01.6回收固定資產余值01.7回收經營資金01.8凈轉售收入000002 2現現金金流流出出2987390545351684182642.1開發產品投資(不含財務費用)1894490344144403213722.2經營資金000002.3經營費用(出租和自營產業)000002.4經營稅金及附加215504408258902.5土地增值稅預征3920801501622.6土地增值稅4849000484925%調整所得稅3533206881834992 職職工工獎獎勵
27、勵及及福福利利基基金金000003所得稅后凈現金流量93159315-9054264981597924累計所得稅后凈現金流量-9054-6406175396774所得稅后凈現值38453845-7873200353654531累計所得稅后凈現值-7873-5871-50640255所得稅前凈現金流量1284912849-9034333699938916累計所得稅前凈現金流量-9034-56984295132116所得稅前凈現值61556155-7856252365705098累計所得稅前凈現值-7856-533312376335計算指標所得稅前實際內部收益率(FIRR)37.86%表面內部收益
28、率(FIRR)51.64%財務凈現值(FNPV)6155投資回收期(靜態/動態)年2.572.81通貨膨脹率10.00%15%基準收益率(Ie)15%FIRR(稅前)51.64%現金流量表(資本金)序號項目合計12341 1現現金金流流入入391880800015000161881.1銷售收入391880800015000161881.2租金收入000001.3自營收入000001.4補貼收入(先征返還)000001.5回收其他資金000001.6回收固定資產余值000001.7回收經營資金000001.8凈轉售收入000002 2現現金金流流出出51356115861026918138110
29、002.1權益資金850585050002.2債務資金500030002000002.3收入資金2151207017126271506.50082.4經營費用(出租和自營產業)000002.5經營稅金及附加215504408258902.6土地增值稅預征3920801501622.7土地增值稅484900048492.8所得稅3240051617669582.9借款本利償還57028121627702635 職職工工獎獎勵勵及及福福利利基基金金000003所得稅后凈現金流量-12168-12168-11586-2269-31385188累計所得稅后凈現金流量-11586-13855-16993
30、-118064所得稅后凈現值-11447-11447-10533-1875-23583543累計所得稅后凈現值-10533-12408-14766-112225所得稅前凈現金流量-8927-8927-11586-1753-13726146累計所得稅前凈現金流量-11586-13339-14711-85656所得稅前凈現值-9039-9039-10533-1449-10314198累計所得稅前凈現值-10533-11981-13012-8815計算指標所得稅前實際內部收益率(FIRR)-37.12%表面內部收益率(FIRR)-30.83%財務凈現值(FNPV)-9039投資回收期(靜態/動態)年
31、21.0021.00通貨膨脹率10.00%10%基準收益率(Ie)10%FIRR(稅前)-30.83%財務計劃現金流量表序號項目合計12341 1經經營營活活動動凈凈現現金金流流量量28552069641225993291.11.1現現金金流流入入391880800015000161881.1.1 銷售收入391880800015000161881.1.2 租金收入000001.1.3 自營收入000001.1.4 補貼收入(先征返還)000001.1.5 其他流入01.21.2現現金金流流出出1063601036274168591.2.1 房地產投資(不含利息)189449034414440
32、3213721.2.2 經營資金000001.2.3 經營費用(出租和自營產業)000001.2.4 經營稅金及附加215504408258901.2.5 土地增值稅預征3920801501621.2.6 土地增值稅484900048491.2.7 所得稅3240051617669581.2.8 職職工工獎獎勵勵及及福福利利基基金金00001.2.9 其他流出02 2投投資資活活動動凈凈現現金金流流量量000002.12.1現現金金流流入入000002.1.1 回收固定資產余值000002.1.2 回收經營資金000002.1.3 凈轉售收入000002.1.4 回收其他資金000002.1.
33、5 其他流入02.22.2現現金金流流出出000002.2.1 權益投資02.2.2 債權投資02.2.3 購建投資02.2.4 其他投資03 3籌籌資資活活動動凈凈現現金金流流量量390114241645-3372-34363.13.1現現金金流流入入13505115052000003.1.1 權益資金850585050003.1.2 債務資金500030002000003.1.6 其他流入03.23.2現現金金流流出出1311581355337234363.2.1 借款本金償還500000250025003.2.2 各種利息支出702812162701353.2.3 應付利潤(股利分配)7
34、41301396028013.2.4 其他流出04盈余資金28941114248609888758935累計盈余資金11424200332891934813資產負債表序號項目12341資產174243047137588405861.1流動資產總額174243047137588405861.1.1 應收帳款00001.1.2 存貨60001043886695773 其中:在建工程600010438866957731.1.3 貨幣資金1.1.4 累計盈余資金114242003328919348131.2長期投資1.3固定資產凈值1.4無形及遞延資產凈值2負債及所有者權益11505149141711
35、0166842.1流動負債總額00002.1.1 應付帳款2.1.2 短期借款2.1.3 遞延稅金2.2長期負債總額30005000250002.2.1 經營資金借款2.2.2 開發產品投資借款3000500025000負債小計30005000250002.3所有者權益8505991414610166842.3.1 資本金85058505850585052.3.2 資本公積2.3.3 累計盈余公積金01556859722.3.4 累計未分配利潤0125454217207比率指標參考指標資產負債率(%)70%17%16%7%0%流動比率(%)120%#DIV/0!#DIV/0!#DIV/0!#D
36、IV/0!速動比率(%)65%#DIV/0!#DIV/0!#DIV/0!#DIV/0!主要經濟指標表序號名稱單位數據項項目目設設計計參參數數projectproject designdesign parameterparameter1房地產開發產品總建筑面積total building area of real estate deveolpment平方米785801.1商品住宅銷售面積sale area of commercial residential building平方米769801.2商業用房銷售面積sale area of mercantile occupancy平方米16001.3
37、車位銷售面積sale area of loading lot平方米1.3出租物業面積rent area of real estate平方米1.4自營資產self-support assets平方米2自營收入self-support income萬元0經經濟濟數數據據economiceconomic datadata1總投資overhead expenses萬元196462開發產品投資gross investment萬元19646 其中:財務費用operation funds萬元7023單位成本unilateralism price元/平方米25004資金籌措financing萬元35017 其
38、中:權益資金equity funds萬元8505 債權資金indebtedness funds萬元5000 收入資金receipts funds萬元215125經營收入萬元391886開發成本real estate development costs萬元16179 其中:固定成本fund cost萬元85177開發費用萬元34668經營費用(出租和自營產業)萬元09應繳稅金taxes due萬元10636 經營稅金及附加management taxes and additional expense 萬元2155 土地增值稅commercial housing sale net income e
39、stimating chart萬元5240 所得稅commercial housing sale net income estimating chart萬元324010利潤總額total profit萬元1343111稅后利潤after-tax profit 萬元972112可分配利潤distributive profits萬元4919財財務務評評價價指指標標financialfinancial evaluationevaluation indexindex1總投資收益率(ROI)%71.94%2投資利潤率earning power of real assets%13.67%3投資凈利潤率ne
40、t earning power of real assets%9.90%4投資利稅率(不含所得稅)%21.20%5資本金利潤率profit-cost ratio%31.58%6資本金凈利潤率(ROE)net profit-cost ratio%22.86%7全部投資內部收益率(所得稅前)total investment internal rate of return%51.64%8全部投資投資回收期(所得稅前)年2.819全部投資內部收益率(所得稅后)%38.47%10全部投資投資回收期(所得稅后)年3.1211項目建設經營期construct and manage period of pro
41、ject年511房地產投資長期借款償還期period of compensate long term loans of real estate investment年12自營部分盈虧平衡點(經營達綱率)break-even point of self-support part%5 56 67 78 89 91010111112121313(產權面積)0.0010.0010.001100%100%100%100%100%100%100%100%單位:萬元5678910111213000000000000000000單位:萬元5678910111213000000000000000000單位:萬元
42、5678910111213000000000單位:萬元567891011121310010000000000單位:萬元5678910111213000000000000000000000000000600600600600600600600600600000000000000000000505050505050505050000000000000000000000000000100010001000100010001000100010001000000000000000000000100100100100100100100100100000000000000000000000000000120
43、0120012001200120012001200120012000000000000000000002002002002002002002002002000000000000000000000000000001500150015001500150015001500150015000000000000000000001000100010001000100010001000100010000000000000000000000000000000000000000000000000000000000000000000000000005678910111213000000000單位:萬元567891
44、01112130000000000000000000000000000000000005%9800000000567891011121336200000000103000000000000000000000000000000000000000000001000000000000000000030000000025900000000980000000016100000000000000000362000000003620000000000000000056789101112130000000000000000000000000000000000000000000000000000000 00 0
45、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0000000000單位:萬元56789101112133623620 00 00 00 00 00 00 00 000000000000000000036200000000362000000000000000003623620 00 00 00 00 00 00 00 0000000000000000000362000000003620單位:萬元567891011121300000000000000000000000000000000000000000000
46、0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000單位:萬元5678910111213000000000000000000#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%000000000000000000000000000000000000單位:萬元56789101112131.0%1.0%1.0%1.0%1.
47、0%1.0%1.0%1.0%1.0%0000000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%0000000000000000001%1%1%1%1%1%1%1%1%000000000000000000000000000000000000單位:萬元5678910111213000000000391883918839188391883918839188391883918839188000000000161791617916179161791
48、6179161791617916179161790%0%0%0%0%0%0%0%0%100%100%100%100%100%100%100%100%100%100%0%0%0%0%0%0%0%0%單位:萬元5678910111213391880023188001617900161800215500323600160000069%40%5%52400000000單位:萬元5678910111213000000000000000000000000000000000000000000000000000000單位:萬元56789101112130000000000000000000000000000%
49、0%0%0%0%0%0%0%0%0000000000000000000%0%0%0%0%0%0%0%0%0000000000000000000%0%0%0%0%0%0%0%0%000000000000000000000000000000000000000000000000000000單位:萬元567891011121300000000020%0%0%0%0%0%0%0%0%0000000000000000000%0%0%0%0%0%0%0%0%00000000000000000020%0%0%0%0%0%0%0%0%0000000000000000000%0%0%0%0%0%0%0%0%000
50、00000000000000020%0%0%0%0%0%0%0%0%000000000單位:萬元567891011121300000000000000000000000002590000000098000000001610000000000000000025900000000單位:萬元5678910111213000000000000000000000000000000000000259000000000000000000000000000000000000000000000000000000000000000000000000000000007207648658375254472842553
51、830344731027207648658375254472842553830344731020000000000000000000000000000000000000000000007207648658375254472842553830344731020000000007207648658375254472842553830344731027216495845254734263833453107216495845254734263833453100000000000000000006486583752544728425538303447310227920000000000000000000
52、00000000單位:萬元56789101112130000000000000000000000000000000000000000000000000000003620000000036200000000000000000000000000000000000000000000000000000000000000000000000-36200000000931593159315931593159315931593159315-18000000000384538453845384538453845384538453845-36200000000128491284912849128491284912
53、849128491284912849-18000000000615561556155615561556155615561556155所得稅后25.88%38.47%38452.793.1210.00%15%FIRR(稅后)38.47%單位:萬元567891011121300000000000000000000000000000000000000000000000000000000000000000000000000000000036200000000000000000000000000361.970000000000000000000000000000000000000000000000000
54、0000000000000000000000-36200000000-12168-12168-12168-12168-12168-12168-12168-12168-12168-22500000000-11447-11447-11447-11447-11447-11447-11447-11447-11447-3620000000051.64%-8927-8927-8927-8927-8927-8927-8927-8927-8927-22500000000-9039-9039-9039-9039-9039-9039-9039-9039-9039所得稅后-48.87%-43.76%-1144721
55、.0021.0010.00%10%FIRR(稅后)-43.76%單位:萬元567891011121300000000000000000000000000000000000000000000000000000000000000036200000000000000000000000000000000000000000000000000000000000000000000000-30.83%000000000000000000000000000000000000000000000000000000000000000-721-649-584-525-473-426-383-345-3100000000
56、00000000000000000000721649584525473426383345310000000000000000000721649584525473426383345310-721-649-584-525-473-426-383-345-310340923344332860323343186131436310533070830398單位:萬元56789101112133409233443328603233431861314363105330708303983409233443328603233431861314363105330708303980000000000000000003
57、409233443328603233431861314363105330708303981596315314147311420513732133071292412579122690000000000000000000000000000000000001596315314147311420513732133071292412579122698505850585058505850585058505850585059729729729729729729729729726486583752544728425538303447310227920%0%0%0%0%0%0%0%0%#DIV/0!#DIV/0
58、!#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!備注24.29%14.28%61.43%包括:土地、前期、基礎、公共、間接、財務、管理年平均年平均年平均年平均年平均建設期起14141515161617171818191920201415161718192000000000000000141516171819200000000000000014151617181920000000014151617181920000000
59、014151617181920000000000000000000000600600600600600600600000000000000005050505050505000000000000000000000010001000100010001000100010000000000000000010010010010010010010000000000000000000000012001200120012001200120012000000000000000020020020020020020020000000000000000000000015001500150015001500150015
60、000000000000000010001000100010001000100010000000000000000000000000000000000000000000000000000000000014151617181920000000014151617181920000000000000000000000000000000000001415161718192000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001415
61、16171819200000000000000000000000000000000000000000000000000141516171819200 00 00 00 00 00 00 0000000000000000000000000000000000000 00 00 00 00 00 00 0000000000000000000000141516171819200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001415161
62、718192000000000000000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0%0%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0000000000000000000000000000141516171819201.0%1.0%1.0%1.0%1.0%1.0%1.0%000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%000000000000001.0%1.0%1.0%1.0%1.0%1.0%1.0%000000000000001%1%1%1%1%1%1%000000000
63、0000000000000000000141516171819200000000391883918839188391883918839188391880000000161791617916179161791617916179161790%0%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!100%100%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0%0%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!14151617181920141516171819200000000000000000000000000000000000
64、00000000141516171819200000000000000000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%0%0000000000000000000000000000000000000000001415161718192000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%0%000000000000000%0%0%0%0%0%
65、0%0000000141516171819200000000000000000000000000000000000000000000000000000141516171819200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000279225132261203518321649148427922513226120351832164914840000000000000000000000000000000000027922513226120351832164914840
66、000000279225132261203518321649148427925122620418316514827925122620418316514800000000000000251322612035183216491484133500000000000000000000014151617181920000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000093159315931593159315931593150000000
67、38453845384538453845384538450000000128491284912849128491284912849128490000000615561556155615561556155615514151617181920000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000-12168-12168-12168-12168-12168-121
68、68-121680000000-11447-11447-11447-11447-11447-11447-114470000000-8927-8927-8927-8927-8927-8927-89270000000-9039-9039-9039-9039-9039-9039-9039141516171819200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
69、000000000-279-251-226-204-183-165-14800000000000000000000027925122620418316514800000000000000279251226204183165148-279-251-226-204-183-165-14830119298682964129438292552909028941141516171819203011929868296412943829255290902894130119298682964129438292552909028941000000000000003011929868296412943829255
70、290902894111990117391151211309111261096110812000000000000000000000000000011990117391151211309111261096110812850585058505850585058505850597297297297297297297225132261203518321649148413350%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!#DIV/0!#DIV/0!#DIV/0!#DIV/0!1 1
71、2 23 3銷銷售售價價格格(元元/平平方方米米)均價 項目1(住宅)10%000 項目2(小高層)10%040005000 項目3(高層)10%000 項目4(商業)0%000 項目5(地下車位)0%000銷銷售售計計劃劃(平平方方米米)項目1(住宅)0%0.0010.0010.001 項目2(小高層)0%02000030000 項目3(高層)0%0.0010.0010.001 項目4(商業)0%000 項目5(地下車位)0%0.0010.0010.001銷銷售售金金額額(萬萬元元)項目1(住宅)0000 項目2(小高層)43106.80880016500 項目3(高層)0000 項目4(商
72、業)0000 項目5(地下車位)0000開開發發計計劃劃(平平方方米米)土建面積合計12000%200003000026980安裝面積合計1000%02000030000出出租租價價格格(元元/平平方方米米/月月)項目1(地上車位)000 項目2000 項目3000出出租租計計劃劃(平平方方米米)項目1(地上車位)000 項目2000 項目3000出出租租率率(%)(%)項目1(地上車位)0%0%0%項目20%0%0%項目30%0%0%現金流量表(全部投資)序號項目合計1231 1現現金金流流入入4310708800165001.1銷售收入4310708800165001.2租金收入00001
73、.3自營收入00001.4補貼收入00001.5回收其他資金00001.6回收固定資產余值00001.7回收經營資金00001.8凈轉售收入00002 2現現金金流流出出276559123613275542.1固定成本881967235727172.2可變成本102152400380035382.3經營資金00002.4經營費用(出租和自營產業)000020.0%經營稅金及附加86210176033005 5所所得得稅稅前前凈凈現現金金流流量量15452-912326688946調整項目調整幅度FIRR土建成本0%53.66%安裝成本0%住宅價格10%小高層價格10%高層價格10%商業價格0%
74、車位價格-30%-25%-20%-15%-10%基準方案56.10%56.10%56.10%56.10%56.10%土建成本72.00%69.00%66.00%64.00%61.00%安裝成本住宅價格小高層價格21.19%27.35%33.35%39.21%44.95%高層價格商業價格56.10%56.10%56.10%56.10%56.10%車位價格-30%-25%-20%-15%-10%-5%0%5%10%15%20%25%30%0.00%10.00%20.00%30.00%40.00%50.00%60.00%70.00%80.00%90.00%100.00%基準方案土建成本安裝成本住宅價
75、格小高層價格高層價格商業價格車位價格4 45 56 67 78 89 9101011111212000000000600000000000000000000000000000000000000(產權面積)0.0010.001000000026980000000000.0010.00100000001600000000000.0010.001000000000000000017806.80000000000000000000000000000000000016000000000028580000000000000000000000000000000000000000000000000000000
76、000000000%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%單位:萬元456789101112178070000000017807000000000000000000000000000000000000000000000000000000000000000000000004582264000000054326400000004780000000000000000000000000035610000000013225-2640000000-5%0%5%10%15%20%25%30%56.10%56.10%56.10%56.10%56
77、.10%56.10%56.10%56.10%58.52%56.10%53.75%51.45%49.22%47.04%44.92%42.85%56.10%55.97%55.85%55.72%55.59%55.46%55.33%56.10%50.57%56.10%61.54%66.90%72.19%77.41%82.56%87.66%56.10%56.10%56.10%56.10%56.10%56.10%56.10%56.10%56.10%56.10%-30%-25%-20%-15%-10%-5%0%5%10%15%20%25%30%0.00%10.00%20.00%30.00%40.00%50.
78、00%60.00%70.00%80.00%90.00%100.00%基準方案土建成本安裝成本住宅價格小高層價格高層價格商業價格車位價格1313141415151616171718181919202000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000%0%0%0%0%0%0%0%0
79、%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%131415161718192000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000項項目目可可變變參參數數概概率率分分析析項目數值概率值(P)-20%-10%010%20%銷售價格(元/)498720%20%50%10%0%銷售面積(萬)7.85815%80%5%0%0%成本費用(萬元)196465%10%60%20%5%營業稅及
80、附加稅率20%指指標標指指數數說說明明PX098.30%98.30%利潤大于0的概率PX=00.00%0.00%利潤等于1的概率PX01.70%1.70%利潤小于2的概率期望值(EX)66656665方差(DX)1098165810981658標準差()33143314變異系數()0.500.50注注:標標準準差差越越小小,說說明明隨隨機機變變量量取取值值偏偏離離其其期期望望值值的的離離散散程程度度越越小小,項項目目風風險險就就越越小小。注注:變變異異系系數數排排除除了了不不同同規規模模的的投投資資項項目目由由于于期期望望值值大大小小而而產產生生的的風風險險大大小小的的影影響響;變變異異系系數
81、數越越小小,項項目目風風險險越越小小。發生概率利潤額EXDX合計10.0015004348766658052100%0.00300023837666554993100%0.01800041986665702237100%0.006000-1546-966654044860.001500-3511-5666515530220.00800068565566652920.0160004891786665503220.0960002927281666513413870.03200096231666510406250.008000-1003-8666547028330.00050093645666536
82、430.0010007399766655400.006000543533666590770.002000347076665204100.0005001505166651330840.000000118720666500.00000099070666500.00000079430666500.00000059780666500.000000401406665050.00000093640666500.00000073990666500.00000054350666500.00000034700666500.000000150506665060.0015006856106665550.003000
83、489115666594350.01800029275366652515100.006000962666651951170.001500-1003-266658817870.0080009677776665726090.01600077131236665175760.0960005748552666580634注注:標標準準差差越越小小,說說明明隨隨機機變變量量取取值值偏偏離離其其期期望望值值的的離離散散程程度度越越小小,項項目目風風險險就就越越小小。注注:變變異異系系數數排排除除了了不不同同規規模模的的投投資資項項目目由由于于期期望望值值大大小小而而產產生生的的風風險險大大小小的的影影響響;
84、變變異異系系數數越越小小,項項目目風風險險越越小小。0.032000378412166652656150.008000181915666518784180.0005001249966665170190.00100010534116665149740.0060008570516665217750.002000660513666570.000500464126665204890.000000153200666500.000000133560666500.000000113910666500.00000094270666500.0000007462066650100.0000001814206665
85、00.000000161770666500.000000142130666500.000000122480666500.00000010284066650110.0037509364356665273200.007500739955666540470.04500054352456665680790.01500034705266651530780.00375015056666599812120.0200001249925066656807570.0400001053442166655989600.2400008570205766658710150.080000660552866652830.02
86、0000464193666581939130.001250156342066651005590.002500136693466651226630.0150001170517666653810380.0050009740496665472940.00125077761066651543140.000000187690666500.000000168040666500.000000148400666500.000000128750666500.00000010911066650150.000000219040666500.000000199390666500.000000179750666500.
87、000000160100666500.00000014046066650160.0007501187296665203360.0015009907156665157720.0090007943716665147010.003000597818666514140.0007504014366655271170.004000153206166652996870.0080001335610766653581730.04800011391547666510723510.016000942715166651220600.00400074623066652544180.0002501876956665366
88、280.0005001680486665514070.003000148404566652004980.00100012875136665385710.00025010911366654507190.000000222170666500.000000202530666500.000000182880666500.000000163240666500.00000014359066650200.000000256660666500.000000237010666500.000000217370666500.000000197720666500.00000017808066650210.000000
89、143800666500.000000124150666500.000000104510666500.00000084860666500.0000006522066650220.000000181420666500.000000161770666500.000000142130666500.000000122480666500.00000010284066650230.000000219040666500.000000199390666500.000000179750666500.000000160100666500.00000014046066650240.000000256660666500.000000237010666500.000000217370666500.000000197720666500.00000017808066650250.000000294280666500.000000274630666500.000000254990666500.000000235340666500.000000215700666501.0000001.00000011504115046665666510981658