房地產項目經營計劃模型.xlsx
下載文檔
上傳人:晴
編號:742117
2023-08-30
11頁
39.47KB
1、項目經營分析模型核心經營指標總收入1,000,000,000凈利潤106,538,780開發成本709,200,000期間費用75,111,758現金流回正周期1414全投資內部收益率29.8%29.8%經營性現金流資金峰值487,110,980自有資金峰值147,554,034地貨比40.0%資金峰值比例48.7%ROE76.4%76.4%ROIC#VALUE!#VALUE!一、土地用地面積60,000容積率2總可售面積100,000土地獲取時間2017/1/4二、計劃節點計劃周期周期調整實際周期開工66開盤1212售罄1818竣工2929交付3131三、銷售裝修標準毛坯裝修售價1,000銷2、售均價10,000銷售價格調整0總銷售額1,000,000,000首開總面積去化率50%剩余庫存比例庫存估值方式四、成本費用稅金1土地成本支付批次地價支付月份地價400,000,000112132工程成本(含前期、設計等)關聯節點支付比例毛坯工程可售單方成本3,092拿地-開工5%成本單方調整開工-開盤20%建安成本+其它工程成本309,200,000開盤-交付75%裝修成本0竣工-交付裝修100%3營銷管理費用關聯節點支付比例營銷/管理費比例6%拿地-開盤10%營銷/管理費比例調整0%開工-竣工80%營銷/管理費用總額60,000,000竣工-交付10%4融資外部融資占比70%5稅金增值稅53、1,099,284企業所得稅28,050,179稅金總額109,149,463六、跟投跟投股權比例規則累計經營性現金流跟投本金24,355,549跟投利潤分配5,326,939杠桿倍數跟投最終收益5,326,939杠桿利率跟投進入時間1前期資金利率10%前期資金成本-跟投總收益率21.9%凈利潤率10.7%10.7%稅金109,149,463自有資金內部收益率77.3%77.3%現金流貢獻峰值312,086,068現金流貢獻比例31.2%跟投年化收益率22.2%22.2%總建筑面積130,000土增稅清算不退稅裝修成本900調整后均價10,000銷售周期6庫存估值0地價支付比例地價支付金額504、%200,000,00050%200,000,0000支付周期每月支付金額62,576,667610,306,6671912,205,26320支付周期每月支付金額61,000,000172,823,52923,000,000綜合融資成本5%土地增值稅30,000,000稅率11%跟投股權比例5.0%加杠桿總跟投額24,355,549杠桿財務成本0跟投分紅節點交付跟投年化收益率22.2%現金流序序號號項項 目目合合計計#REF!#REF!#REF!123經經營營性性現現金金流流一一項項目目經經營營收收入入1,000,000,000000簽簽約約額額1,000,000,000000回回款款1,05、00,000,00000二二項項目目經經營營支支出出878,349,463403,576,6673,576,6673,576,6672.12.1土地成本400,000,000400,000,000002.22.2工程成本309,200,0002,576,6672,576,6672,576,6672.32.3裝修成本-0002.42.4營銷費用管理費用60,000,0001,000,0001,000,0001,000,0002.52.5稅金預征97,500,0000002.62.6稅金清算11,649,463000三項項目目經經營營性性現現金金流流(403,576,667)(3,576,667)6、(3,576,667)四累累計計經經營營性性現現金金流流487,110,980(403,576,667)(407,153,333)(410,730,000)5.1 融資余額282,503,667285,007,333287,511,0005.25.2財務費用15,111,7581,177,0991,187,5311,197,9635.35.3自有資金余額119,565,556121,073,000122,146,000123,219,000五五累累計計凈凈現現金金流流(不不含含自自有有資資金金)147,554,034(122,250,099)(123,333,531)(124,416,963)7、6.16.1跟投本金進入24,355,54924,355,549006.26.2跟投本金余額24,000,13324,355,54924,355,54924,355,5496.36.3自有跟投本金余額24,000,13324,355,54924,355,54924,355,5496.46.4跟投余額返還006.56.5杠桿資金余額0006.66.6杠桿利息-6.76.7前期資金額度-6.86.8前期利息-6.96.9跟投收益分配5,326,939-7.07.0跟投現金流5,326,939-24,355,549-7.17.1跟投現金流25,326,939-24,355,549-7.27.2經營性8、現金流峰值時間117.37.3自有資金峰值時間117.47.4總可售單方成本7,6927.57.5跟投年化收益率22.2%7.77.7全投資IRR29.8%(403,576,667)(3,576,667)(3,576,667)7.87.8自有資金IRR77.3%(122,250,099)(2,260,531)(2,270,963)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!45678910110000000000000000000000003,576,6673,576,6673,576,66713,130,19613,130,19613,130,19613,9、130,19613,130,196000000002,576,6672,576,6672,576,66710,306,66710,306,66710,306,66710,306,66710,306,667000000001,000,0001,000,0001,000,0002,823,5292,823,5292,823,5292,823,5292,823,5290000000000000000(3,576,667)(3,576,667)(3,576,667)(13,130,196)(13,130,196)(13,130,196)(13,130,196)(13,130,196)(414,306,10、667)(417,883,333)(421,460,000)#290,014,667292,518,333295,022,000304,213,137313,404,275322,595,412331,786,549340,977,6861,208,3941,218,8261,229,2581,267,5551,305,8511,344,1481,382,4441,420,740124,292,000125,365,000126,438,000130,377,059134,316,118138,255,176142,194,235146,133,294(125,500,394)(126,58311、,826)(127,667,258)#0000000024,355,54924,355,54924,355,54924,355,54924,355,54924,355,54924,355,54924,355,54924,355,54924,355,54924,355,54924,355,54924,355,54924,355,54924,355,54924,355,5490000000000000000-(3,576,667)(3,576,667)(3,576,667)(13,130,196)(13,130,196)(13,130,196)(13,130,196)(13,130,196)(2,12、281,394)(2,291,826)(2,302,258)(5,206,614)(5,244,910)(5,283,206)(5,321,503)(5,359,799)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!1213141516171819150,000,000380,000,000100,000,000100,000,000100,000,000100,000,00070,000,0000500,000,000100,000,000100,000,000100,000,000100,000,000100,000,00000150,000,00038013、,000,000100,000,000100,000,000100,000,000100,000,00070,000,000027,755,19652,078,79324,778,79324,778,79324,778,79324,778,79321,853,79315,028,7930000000010,306,66712,205,26312,205,26312,205,26312,205,26312,205,26312,205,26312,205,263000000002,823,5292,823,5292,823,5292,823,5292,823,5292,823,5292,823,514、292,823,52914,625,00037,050,0009,750,0009,750,0009,750,0009,750,0006,825,000000000000122,244,804327,921,20775,221,20775,221,20775,221,20775,221,20748,146,207(15,028,793)#(36,944,969)38,276,238113,497,446188,718,653263,939,861312,086,068297,057,276255,406,32425,861,4780000001,064,193107,756000000109,15、459,85311,083,491000000#(11,191,247)38,276,238113,497,446188,718,653263,939,861312,086,068297,057,2760000000018,243,3091,847,24800000018,243,3091,847,2480000006,112,24016,396,0601,847,2480000000000000-6,112,24016,396,0601,847,248-6,112,24016,396,0601,847,248-122,244,804327,921,20775,221,20775,221,2016、775,221,20775,221,20748,146,207(15,028,793)35,609,24898,268,60649,359,72975,221,20775,221,20775,221,20748,146,207(15,028,793)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!202122232425262700000000000000000000000015,028,79315,028,79315,028,79315,028,79315,205,26315,205,26312,205,26312,205,2630000000012,205,17、26312,205,26312,205,26312,205,26312,205,26312,205,26312,205,26312,205,263000000002,823,5292,823,5292,823,5292,823,5293,000,0003,000,000000000000000000000(15,028,793)(15,028,793)(15,028,793)(15,028,793)(15,205,263)(15,205,263)(12,205,263)(12,205,263)282,028,483266,999,690251,970,898236,942,105221,73618、,842206,531,579194,326,316182,121,053000000000000000000000000282,028,483266,999,690251,970,898236,942,105221,736,842206,531,579194,326,316182,121,0530000000000000000000000000000000000000000-(15,028,793)(15,028,793)(15,028,793)(15,028,793)(15,205,263)(15,205,263)(12,205,263)(12,205,263)(15,028,793)(119、5,028,793)(15,028,793)(15,028,793)(15,205,263)(15,205,263)(12,205,263)(12,205,263)#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!282930313233343500000000000000000000000012,205,26312,205,26312,205,26323,854,72600000000000012,205,26312,205,26312,205,26312,205,263000000000000000000000000000000011,649,4630000(20、12,205,263)(12,205,263)(12,205,263)(23,854,726)0000169,915,789157,710,526145,505,263121,650,537121,650,537121,650,537121,650,537121,650,537000000000000000000000000169,915,789157,710,526145,505,263121,650,537121,650,537121,650,537121,650,537121,650,5370000000000000000000000000000000000000000-5,326,9321、9-5,326,939-5,326,939-(12,205,263)(12,205,263)(12,205,263)(23,854,726)0000(12,205,263)(12,205,263)(12,205,263)(23,854,726)0000#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!36373839404142430000000000000000000000000000000000000000000000000000000000000000000000000000000000000000121,650,537121,650,537121,650,22、537121,650,537121,650,537121,650,537121,650,537121,650,537000000000000000000000000121,650,537121,650,537121,650,537121,650,537121,650,537121,650,537121,650,537121,650,5370000000000000000000000000000000000000000-0000000000000000#REF!#REF!#REF!#REF!#REF!44454647480000000000000000000000000000000000000000000000000000000121,650,537121,650,537121,650,537121,650,537121,650,537000000000000000121,650,537121,650,537121,650,537121,650,537121,650,5370000000000000000000000000-0000000000