房地產項目測算表表格自動計算.xls
下載文檔
上傳人:晴
編號:742715
2023-08-30
33頁
119.54KB
1、浙浙江江舟舟山山定定海海項項目目成成本本利利潤潤匯匯總總表表序號分項工程金額(元)按總建筑面積單方指標(元/)一、銷售收入448320810二、土地費用及契稅162424987.92937.59三、建筑安裝成本費用1620267592930.392.1前期費用11531127.712.2基礎設施配套費用18521494.432.3間接費用3947660.072.4地上建安費用854228802.5地下建安費用42603596.75四、其他費用(財務、管理、營銷、不可預見、稅金)84748414.771532.75五、利潤39120648.41707.53六、利潤率8.73%1 1、未未考考慮慮2、藍藍城城的的代代建建費費用用;2 2、建建安安成成本本按按毛毛坯坯房房考考慮慮;3 3、部部分分費費用用的的標標準準暫暫按按河河南南標標準準記記取取按計容面積單方指標(元/)4066.404056.432121.72979.411 1、未未考考慮慮藍藍城城的的代代建建費費用用;2 2、建建安安成成本本按按毛毛坯坯房房考考慮慮;3 3、部部分分費費用用的的標標準準暫暫按按河河南南標標準準記記取取浙浙江江舟舟山山定定海海項項目目成成本本測測算算表表序序號號分分項項名名稱稱單單位位數數量量單單價價合合計計一一、土土地地費費用用162424987.85162424987.851土地費用畝27.23573、20896.07155779999.992契稅元164073774.494%6562950.983印花稅元164073774.50.000582036.89二二、前前期期費費用用11531127.7111531127.711項目可行性研究報告費55291.830.844233.462三通一平55291.8315829377.453地質勘探費18156590780.004文物勘探費18156472624.005規劃設計費55291.835276459.156日照分析費39943.2139943.207指標核算費55291.831.582937.758施工圖設計費55291.8311608210.4、139人防工程設計費及圖審費6548.6327176813.0111圖紙審查費55291.832.5138229.5812防雷檢測費55291.83155291.8313地震安全性評價費39943.200.0014室內環境監測39943.21.559914.8015環境評價費用55291.83155291.8316景觀施工圖設計費1375628385168.0017大門開口費350000150000.0018土地勘界測繪費55291.83155291.8319水土保持方案編制項18000080000.0020水土保持補償流失費181561.221787.2021規劃高程點(標高測繪)個13005、03000.0022放線費棟6200012000.0023市政配套費用元55291.831508293774.50三三、基基礎礎設設施施配配套套費費18521494.4318521494.431電力工程費55291.83904976264.702給水工程費55291.83392156381.373排水工程費55291.83201105836.604燃氣工程費戶44430001332000.005熱力工程費55291.83502764591.506景觀綠化費137563504814600.007有線電視工程建設費戶444350155400.008智能化工程費55291.8315829377.456、9網絡管道預埋費55291.832110583.6610室外亮化工程55291.835276459.15四四、間間接接費費用用3947660.073947660.071監理費用55291.837387042.812造價咨詢費55291.832.5138229.583基坑、沉降觀測費55291.832.5138229.584樁基、土壤氡檢測費棟622000132000.005排污費55291.835276459.156測繪費(預測、實測)39943.23119829.607竣工驗收規劃復核平面及坐標 棟44460002664000.008竣工驗收地上建筑面積測繪 39943.21.559914.7、809房產初始登記費39943.20.831954.56五五、地地上上建建筑筑工工程程費費85422880.0085422880.001獨棟住宅0.000.002聯排住宅0.000.003疊加住宅0.000.004普通多層住宅0.000.00511層以下洋房住宅0.000.00618層及以下小高層住宅38283.71215082309976.50727層以下高層住宅0.000.00827層以上住宅0.000.009臨街商業1000.0018001800000.0010物業管理用房279.602150601140.0011社區便民店/服務站79.892150171763.5012垃圾收集站0.08、00.0013幼兒園0.000.0014其它(設備用房)300.001800540000.00六六、地地下下車車庫庫工工程程42603596.7542603596.751地下車庫工程6548.63270017681301.002人防地下車庫工程4400.00320014080000.003主樓地下工程4400.0021509460000.004售樓部、樣板房工程55291.83251382295.75七七、(一一)(六六)成成本本小小計計324451746.82324451746.82八八、其其他他費費用用84748414.7784748414.771營銷費用元4483208102.50%119、208020.252管理費用元4483208102.50%11208020.253財務費用元4483208102.50%11208020.254綜合稅率元44832081010.50%47073685.055不可預見費元1620267592.50%4050668.97九九、(五五)(十十一一)小小計計409200161.59409200161.59十、銷售收入元448320810十十一一、利利潤潤元元39120648.4139120648.41十二、利潤率按按總總面面積積單單方方造造價價備備注注4066.404066.40208.55208.55334.98334.9871.4071.401510、44.951544.95770.52770.525867.995867.991532.751532.75280.60280.60280.601178.52101.417400.737400.73707.53707.538.73%浙浙江江舟舟山山定定海海項項目目規規劃劃指指標標序號分項指標名稱單位數量備注1規劃凈用地面積18156.002總建筑面積55291.833地上總建筑面積39943.203.1獨棟住宅3.2聯排住宅3.3疊加住宅3.4普通多層住宅3.511層以下洋房住宅3.618層及以下小高層住宅38283.713.727層以下高層住宅0.003.827層以上住宅0.003.9臨街商業111、000.003.1物業管理用房279.603.11社區便民店/服務站79.893.12垃圾收集站3.13幼兒園3.14其它(設備用房)300.004地下總建筑面積15348.634.1主樓地下室面積4400.004.2地下車庫面積6548.634.3人防面積44005基地占地面積44006景觀道路占地面積137568戶數戶4449樓棟棟610地上停車位輛3111地下停車位輛28812容積率13建筑密度27.23427234浙浙江江舟舟山山定定海海項項目目成成本本測測算算表表銷銷售售收收入入表表序號可銷售項目單位可銷售面積銷售單價合計1獨棟住宅02聯排住宅03疊加住宅04普通多層住宅0511層以12、下洋房住宅0618層及以下小高層住宅38283.7111000421120810727層以下高層住宅000827層以上住宅0009臨街商業1000200002000000010地下車位輛28850000720000011地下儲藏室合計元448320810備注暫未考慮20212021年年項項目目目目標標成成本本核核對對一一季季度度一一、現現金金流流入入448,320,810403,488,729-1銷銷售售回回款款(不不含含稅稅價價)411,303,495370,173,1462銷銷售售回回款款(銷銷項項稅稅)37,017,31529,613,852二二、現現金金流流出出-(一)土土地地款款及及13、工工程程款款支支付付1土地征用及拆遷費用162,424,9882前期工程費用(價)11,531,1281,729,6693基礎設施建設費用(價)18,521,4944建筑安裝工程費用(價)-獨棟住宅-聯排住宅-疊加住宅-普通多層-帶電梯多層-高層-A類(18層以下)85,422,880高層-B類(18層-33層)-地下車庫42,603,5975公共配套設施建設費用(價)-6進項稅(二)期期間間費費用用37,571,721-1管理服務費(價)11,208,020-2開發間接費用(價)3,947,660-3銷售費用(價)11,208,020-4財務費用(價)11,208,020-5進項稅-(三)稅14、稅金金13,819,797-1預繳增值稅12,339,105-補繳增值稅-2增值稅附加稅1,480,693-3預繳土地增值稅00補繳土地增值稅4預繳所得稅-補繳所得稅三三、凈凈現現金金流流-四四、累累計計凈凈現現金金流流-五五、資資金金占占用用費費-資資金金占占用用率率0%MOICIRR6%ROE9%資金峰值-備備注注:1.1.補補繳繳增增值值稅稅=(銷銷售售回回款款累累計計數數-土土地地款款允允許許抵抵減減金金額額)/1./1.0909*0.*0.0909-增增值值稅稅進進項項稅稅累累計計數數-預預繳繳增增值值稅稅累累計計數數2.2.增增值值稅稅附附加加稅稅及及土土地地增增值值稅稅須須手手工15、工錄錄入入,否否則則會會出出現現循循環環引引用用公公式式鏈鏈接接錯錯誤誤3.IRR3.IRR為為內內部部收收益益率率,就就是是資資金金流流入入現現值值總總額額與與資資金金流流出出現現值值總總額額相相等等,即即凈凈現現值值為為零零時時的的折折現現率率。各各項項目目公公司司自自行行計計算算,將將結結果果填填到到3232行行C C列列。2021年一季度凈現金流-累計凈現金流-20222022年年二二季季度度三三季季度度四四季季度度一一季季度度二二季季度度-44,832,08144,832,081-41,130,35041,130,350-3,701,7313,701,73111,320,51220216、,252,21714,665,58149,744,125-11,320,512202,252,21714,665,58143,430,616-162,424,988-1,729,6693,459,3382,778,2241,852,1491,852,1493,704,299-8,542,28812,813,43212,813,43221,355,720-23,431,97814,911,259-3,362,4063,441,359-1,120,8021,120,802-78,953-1,120,8021,120,802-1,120,8021,120,802-2,951,1032,951,10317、-1,233,9101,233,910-148,069148,069000896641.62896641.62-672,481672,481-11,320,512-202,252,217-14,665,581-4,912,04444,832,081-11,320,512-213,572,729-228,238,310-233,150,354-188,318,27320212021年年-2022年二季度三季度四季度一季度二季度-11,320,512-202,252,217-14,665,581-4,912,04444,832,081-11,320,512-213,572,729-228,238,18、310-233,150,354-188,318,273一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度-250,000,000 -200,000,000 -150,000,000 -100,000,000 -50,000,000 -50,000,000 100,000,000 150,000,000 凈現金流 累計凈現金流 1.1.補補繳繳增增值值稅稅=(銷銷售售回回款款累累計計數數-土土地地款款允允許許抵抵減減金金額額)/1./1.0909*0.*0.0909-增增值值稅稅進進項項稅稅累累計計數數-預預繳繳增增值值稅稅累19、累計計數數2.2.增增值值稅稅附附加加稅稅及及土土地地增增值值稅稅須須手手工工錄錄入入,否否則則會會出出現現循循環環引引用用公公式式鏈鏈接接錯錯誤誤3.IRR3.IRR為為內內部部收收益益率率,就就是是資資金金流流入入現現值值總總額額與與資資金金流流出出現現值值總總額額相相等等,即即凈凈現現值值為為零零時時的的折折現現率率。各各項項目目公公司司自自行行計計算算,將將結結果果填填到到3232行行C C列列。2021年20232023年年三三季季度度四四季季度度一一季季度度二二季季度度三三季季度度44,832,08144,832,08144,832,08144,832,08144,832,081420、1,130,35041,130,35041,130,35041,130,35041,130,3503,701,7313,701,7313,701,7313,701,7313,701,731-6,392,46216,097,57410,663,60611,589,68123,084,316-9,705,1124,271,1445,197,219-2,306,2261,729,6693,704,2993,704,299926,075-12,813,4324,271,1444,271,1444,271,144-4,260,360-3,441,3593,441,3593,441,3593,441,3521、93,441,3591,120,8021,120,8021,120,8021,120,8021,120,80278,95378,95378,95378,95378,9531,120,8021,120,8021,120,8021,120,8021,120,8021,120,8021,120,8021,120,8021,120,8021,120,802-2,951,1032,951,1032,951,1032,951,1032,951,1031,233,9101,233,9101,233,9101,233,9101,233,910148,069148,069148,069148,069148,0622、9896641.62896641.62896641.62896641.62896641.62672,481672,481672,481672,481672,48144,832,08138,439,61928,734,50734,168,47533,242,400-143,486,192-105,046,573-76,312,066-42,143,591-8,901,19020222022年年-2023年三季度四季度一季度二季度三季度44,832,08138,439,61928,734,50734,168,47533,242,400-143,486,192-105,046,573-76,312,23、066-42,143,591-8,901,1902022年一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度-250,000,000 -200,000,000 -150,000,000 -100,000,000 -50,000,000 -50,000,000 100,000,000 150,000,000 凈現金流 累計凈現金流 20242024年年四四季季度度一一季季度度二二季季度度三三季季度度44,832,08144,832,08144,832,081-41,130,35041,130,35041,130,3503,7024、1,7313,701,7313,701,73111,240,1626,392,4626,392,462157,9064,847,700576,556-4,271,144-3,441,3593,441,3593,441,359157,9061,120,8021,120,8021,120,802-78,95378,95378,953157,9061,120,8021,120,8021,120,802-1,120,8021,120,8021,120,802-2,951,1032,951,1032,951,103-1,233,9101,233,9101,233,910-148,069148,0691425、8,069-896641.62896641.62896641.620672,481672,481672,481-33,591,91938,439,61938,439,619-157,90624,690,72963,130,348101,569,967101,412,060-#NUM!2024年四季度一季度二季度三季度33,591,91938,439,61938,439,619-157,90624,690,72963,130,348101,569,967101,412,060一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度一季度二季度三季度四季度-26、250,000,000 -200,000,000 -150,000,000 -100,000,000 -50,000,000 -50,000,000 100,000,000 150,000,000 凈現金流 累計凈現金流 20252025年年四四季季度度一一季季度度二二季季度度三三季季度度四四季季度度-157,906157,906157,906157,906157,906-157,906157,906157,906157,906157,906-157,906157,906157,906157,906157,906-00000-157,906-157,906-157,906-157,906-1527、7,906101,254,154101,096,248100,938,341100,780,435100,622,528-2025年四季度一季度二季度三季度四季度-157,906-157,906-157,906-157,906-157,906101,254,154101,096,248100,938,341100,780,435100,622,528-448,320,810-411,303,495-37,017,315-162,424,988-11,531,128-18,521,494-37,571,721-11,208,020-3,947,660-11,208,020-11,208,020-13,819,797-12,339,105-1,480,693-
地產規劃
上傳時間:2024-10-10
163份