商業地產項目投資估算及財務分析.xls
下載文檔
上傳人:正***
編號:857066
2023-12-22
13頁
85.50KB
1、項項目目總總投投資資估估算算表表序序號號項項目目名名稱稱總總額額(萬萬元元)占占總總投投資資比比例例1地 價8,951.0432.8%2前期工程費745.922.7%3建安工程13,799.5250.6%4不可預見費727.272.7%5管理費436.361.6%6其他費用324.901.2%8財務費用1,087.134.0%7銷售費用1,202.314.4%9合 計27,274.46100.0%附附表表2:項項目目開開發發總總成成本本估估算算表表容積率=2.0計入容積率建筑面積(m2)106560序序號號項項目目名名稱稱計計算算程程式式單單價價(元元/m2)金金額額(萬萬元元)備備注注一土地2、成本8408,951.04二前期工程費2.1勘察測量費20213.122.2規劃設計費30319.682.3臨時供水供電10106.562.4場地平整及道路10106.56前期工程小計2.12.470746三建筑安裝工程費3.1基礎工程費90959.043.2土建工程費7507,992.003.3安裝工程費4554,8483.3.1 水電安裝1001,065.603.3.2 電梯工程80852.483.3.3 空調工程-3.3.4 消防工程60639.363.3.5 通訊工程15159.843.3.6 室外配套1601,704.963.3.7 煤氣管道20213.123.3.8 對講系統1513、59.843.3.9 公用天線553.283.4地下室3.5建安工程小計3.13.51,29513,799.52四不可預見費68727.27五管理費用41436.36六其他費用6.1工程監理費15159.846.2市交通管理局0.121.286.3市道橋管理局0.373.946.4市建設局(散裝水泥)-6.5墻改基金553.286.6白蟻防治10106.56其他費用小計6.16.730324.90七合計(二)(六)1,50516,033.98八總開發成本(一)+(七)2,34524,985.02附附表表3:投投資資計計劃劃表表單位:萬元序號 項目名稱投資總額第第1 1季季第第2 2季季第第3 4、3季季第第4季季第第5季季第第6 6季季第第7 7季季第第8 8季季第第9季季一土地成本8951.048951.04二前期費用745.92149.18149.18149.18149.18三基礎工程費959.04227.77227.77227.77四主體工程費7992.00899.10999.00899.10999.00五水電安裝1065.60119.88133.20119.88133.20六消防工程639.3671.9379.9271.9379.92七電梯工程852.4895.90106.5695.90106.56八通迅工程159.8417.9819.9817.9819.98九煤氣工程213.5、1223.9826.6423.9826.64十對講系統159.8417.9819.9817.9819.98十一 公用天線53.285.996.665.996.66十二 室外配套1704.96191.81213.12191.81213.12十三 不可預見費727.2748.4848.4848.4848.4848.4848.4848.4848.4848.48十四 管理費436.3629.0929.0929.0929.0929.0929.0929.0929.0929.09十五 其他費用324.9092.8392.8310.7110.7110.7110.7110.7110.7110.71十六 合計246、985.029270.63319.59316.06987.391781.92922.12987.391781.92922.12注:1.土地成本按計算初期一次性投入計。2.按照通常情況,工程費用中5%留取保修金及滯留金,竣工驗收后一年付出。3.工程款的支付與工程進度表相對應,不考慮工程隊大額墊資,按工程進度付款,竣工驗收后支付率達95%,其它部分在工程建設過程中平均投入。投投資資計計劃劃表表(續續表表)單位:萬元第第10季季第第1111季季第第1212季季第第1313季季第第14季季第第15季季第第1616季季第第1717季季第第1818季季第第19季季149.1811.99227.7711.97、911.9911.99999.00999.00999.00999.0099.9099.9013.32119.88133.2013.32119.88133.2013.3213.327.9971.9379.927.9971.9379.927.997.9910.6695.90106.5610.6695.90106.5610.6610.662.0017.9819.982.0017.9819.982.002.002.6623.9826.642.6623.9826.642.662.662.0017.9819.982.0017.9819.982.002.000.675.996.660.675.996.6608、.670.6721.31191.81213.1221.31191.81213.1221.3121.3148.4848.4848.4848.4848.4848.4829.0929.0929.0929.0929.0929.0910.7110.7110.7110.7110.7110.711159.881781.92922.121159.881632.74694.35172.49172.49附附表表3:序號 項目名稱一土地成本二前期費用三基礎工程費四主體工程費五水電安裝六消防工程七電梯工程八通迅工程九煤氣工程十對講系統十一 公用天線十二 室外配套十三 不可預見費十四 管理費十五 其他費用十六 合計附附9、表表4:項項目目銷銷售售回回款款計計劃劃表表項目內容銷銷售售建建筑筑面面積積(m2)銷銷售售價價格格(元元/m2)總總價價(萬萬元元)備備注注住宅89560.003,30029,554.80商業12000.0010,00012,000.00合計101560.0041,554.80住宅銷售率95%商鋪銷售率100%銷售收入40,077.06計算期(季度)銷銷售售比比例例回回款款比比例例回回款款金金額額合合計計住住宅宅商商業業住住宅宅商商業業住住宅宅商商業業123455.00%3.33%985.16985.1667.50%6.67%1,970.321,970.3277.50%10.00%7.50%10、6.67%2,216.61800.003,016.6187.50%10.00%7.50%10.00%2,216.611,200.003,416.6198.75%10.00%8.33%10.00%2,462.901,200.003,662.90107.50%10.00%7.92%10.00%2,339.761,200.003,539.76117.50%10.00%7.50%10.00%2,216.611,200.003,416.61128.75%10.00%8.33%10.00%2,462.901,200.003,662.90137.50%10.00%7.92%10.00%2,339.761,211、00.003,539.76147.50%10.00%7.50%10.00%2,216.611,200.003,416.61158.75%10.00%8.33%10.00%2,462.901,200.003,662.90167.50%10.00%7.92%10.00%2,339.761,200.003,539.76172.50%4.17%3.33%1,231.45400.001,631.45181.25%1.67%492.58492.58190.42%123.15123.15合計95.00%100%95.00%100%28,077.0612,000.0040,077.06注:剩余5%住宅作為企業12、留存資產,銷售回款計劃綜合考慮銀行按揭放款時間。附附表表5:資資金金來來源源與與運運用用表表單位:萬元序序號號 季季度度項項目目1 12 23 34 45 56 67 78 89 9一資金來源10,000.001,000.00900.002,300.002,985.161,970.323,016.613,416.6111,662.901經營活動產生的現金來源985.161,970.323,016.613,416.613,662.901.1銷售收入985.161,970.323,016.613,416.613,662.902 籌資活動產生的現金來源10,000.001,000.00900.00113、,300.001,000.005,000.002.1自有資金1,000.001,000.00900.001,300.001,000.005,000.002.2銀行借款9,000.003其它來源1,000.001,000.003,000.00二資金運用9,406.52455.48451.951,123.281,997.611,217.611,489.722,325.6619,881.211建設期開發成本9,270.63319.59316.06987.391,781.92922.12987.391,781.92922.122經營期當期發生營業成本3銷售費用29.5559.1190.50102.5014、109.894銷售稅費50.24100.49153.85174.25186.815所得稅122.10131.10162.406盈余公積7應付利潤8借款本金償還18,500.009借款利息支付135.89135.89135.89135.89135.89135.89135.89135.89三盈余資金593.48544.52448.051,176.72987.55752.711,526.891,090.95-8,218.31四累計盈余資金593.481,138.001,586.052,762.773,750.324,503.036,029.937,120.88-1,097.4310103,539.715、63,539.763,539.761,603.541,159.88106.19180.53156.941,936.21838.78附附表表5:序序號號 季季度度項項目目一資金來源1經營活動產生的現金來源1.1銷售收入2 籌資活動產生的現金來源2.1自有資金2.2銀行借款3其它來源二資金運用1建設期開發成本2經營期當期發生營業成本3銷售費用4銷售稅費5所得稅6盈余公積7應付利潤8借款本金償還9借款利息支付三盈余資金四累計盈余資金資資金金來來源源與與運運用用表表(續續表表)單位:萬元1111121213131414151516161717181819193,416.613,662.903,539.16、763,416.613,662.903,539.761,631.45492.58123.153,416.613,662.903,539.763,416.613,662.903,539.761,631.45492.58123.153,416.613,662.903,539.763,416.613,662.903,539.761,631.45492.58123.152,210.151,381.211,603.542,060.971,153.44616.15204.4861.74187.931,781.92922.121,159.881,632.74694.35172.49172.49102.50117、09.89106.19102.50109.89106.1948.9414.783.69174.25186.81180.53174.25186.81180.5383.2025.126.28151.48162.40156.94151.48162.40156.9472.3321.845.461,206.462,281.691,936.211,355.642,509.462,923.601,426.97430.84-64.782,045.244,326.936,263.147,618.7810,128.2413,051.8414,478.8114,909.6614,844.87附附表表5:序序號號 季18、季度度項項目目一資金來源1經營活動產生的現金來源1.1銷售收入2 籌資活動產生的現金來源2.1自有資金2.2銀行借款3其它來源二資金運用1建設期開發成本2經營期當期發生營業成本3銷售費用4銷售稅費5所得稅6盈余公積7應付利潤8借款本金償還9借款利息支付三盈余資金四累計盈余資金附附表表6:損損益益及及利利潤潤表表單位:萬元序序號號項項目目合合計計第第1 1季季第第2 2季季第第3 3季季第第4季季第第5季季第第6 6季季第第7 7季季第第8 8季季第第9季季1銷售收入40,077.06985.161,970.323,016.613,416.613,662.902開發成本24,985.02614.19、171,228.351,880.632,130.002,283.543銷售費用1,202.3129.5559.1190.50102.50109.894財務費用1,087.13135.89135.89135.89135.89135.89135.89135.89135.890.005銷售稅費2,043.9350.24100.49153.85174.25186.816利潤總額10,758.67-135.89-135.89-135.89-135.89155.30446.49755.75873.981,082.667補前期虧損155.30446.49-58.228所得稅1,613.800.00122.120、0131.10162.409稅后利潤9,144.87-135.89-135.89-135.89-135.890.000.00691.87742.88920.26成本利潤率33.5%損損益益及及利利潤潤表表(續續表表)單位:萬元第第10季季第第1111季季第第1212季季第第1313季季第第14季季第第15季季第第1616季季第第1717季季第第1818季季第第19季季3,539.763,416.613,662.903,539.763,416.613,662.903,539.761,631.45492.58123.152,206.772,130.002,283.542,206.772,130.021、02,283.542,206.771,017.09307.0976.77106.19102.50109.89106.19102.50109.89106.1948.9414.783.690.000.000.000.000.000.000.00180.53174.25186.81180.53174.25186.81180.5383.2025.126.281,046.271,009.871,082.661,046.271,009.871,082.661,046.27482.22145.5936.40156.94151.48162.40156.94151.48162.40156.9472.3321.822、45.46889.33858.39920.26889.33858.39920.26889.33409.88123.7630.94附附表表6:序序號號項項目目1銷售收入2開發成本3銷售費用4財務費用5銷售稅費6利潤總額7補前期虧損8所得稅9稅后利潤附附表表7:現現金金流流量量表表(全全部部投投資資)單位:萬元序序號號 季季度度項項目目合合計計1234567891現金流入40,077.06985.161,970.323,016.613,416.613,662.901.1銷售收入40,077.06985.161,970.323,016.613,416.613,662.901.2出租收入1.3 其他收23、入2現金流出29,845.069,270.63319.59316.06987.391,861.721,081.711,353.832,189.771,381.212.1建設期開發成本24,985.029,270.63319.59316.06987.391,781.92922.12987.391,781.92922.122.2經營期當期成本2.3銷售費用1,202.3129.5559.1190.50102.50109.892.4銷售稅費2,043.9350.24100.49153.85174.25186.812.5所得稅1,613.80122.10131.10162.403凈現金流量10,23224、.00-9,270.63-319.59-316.06-987.39-876.56888.611,662.781,226.842,281.694累計凈現金流量-9,270.63-9,590.22-9,906.28-10,893.66-11,770.23-10,881.62-9,218.84-7,991.99-5,710.315凈現值6,169.19-9,270.63-313.50-304.13-932.01-811.63807.101,481.491,072.251,956.186累計凈現值-9,270.63-9,584.13-9,888.25-10,820.26-11,631.89-10,8225、4.79-9,343.30-8,271.04-6,314.86計算指標:財務內部收益率=27.82%財務凈現值(I=8%)=6,169動態投資回收期(年)=3.60現現金金流流量量表表(全全部部投投資資)(續續表表)單位:萬元101112131415161718193,539.763,416.613,662.903,539.763,416.613,662.903,539.761,631.45492.58123.153,539.763,416.613,662.903,539.763,416.613,662.903,539.761,631.45492.58123.151,603.542,210.126、51,381.211,603.542,060.971,153.44616.15204.4861.74187.931,159.881,781.92922.121,159.881,632.74694.35172.49172.49106.19102.50109.89106.19102.50109.89106.1948.9414.783.69180.53174.25186.81180.53174.25186.81180.5383.2025.126.28156.94151.48162.40156.94151.48162.40156.9472.3321.845.461,936.211,206.462,2827、1.691,936.211,355.642,509.462,923.601,426.97430.84-64.78-3,774.09-2,567.63-285.951,650.273,005.915,515.378,438.979,865.9410,296.7810,232.001,628.36995.301,846.461,537.031,055.651,916.892,190.681,048.87310.65-45.82-4,686.51-3,691.21-1,844.74-307.71747.932,664.824,855.505,904.376,215.016,169.19附附表表7:序28、序號號 季季度度項項目目1現金流入1.1銷售收入1.2出租收入1.3 其他收入2現金流出2.1建設期開發成本2.2經營期當期成本2.3銷售費用2.4銷售稅費2.5所得稅3凈現金流量4累計凈現金流量5凈現值6累計凈現值附附表表8:敏敏感感性性分分析析表表因因素素變變化化情情況況相相關關指指標標變變化化情情況況敏敏感感性性分分析析結結果果總總建建筑筑面面積積(m2)銷銷售售價價格格(元元/m2)銷銷售售收收入入(萬萬元元)總總投投資資(萬萬元元)稅稅后后利利潤潤(萬萬元元)投投資資利利潤潤率率財財務務凈凈現現值值(萬萬元元)內內部部收收益益率率動動態態投投資資回回收收期期(年年)基基本本方方案案(29、容容積積率率=2.2)220,000220,000住住宅宅3300330040,07740,07727,27427,2749,1459,14533.5%33.5%6,1696,16927.82%27.82%3.603.60商商業業1000010000銷售價格變化價價格格下下降降10%10%220,000住宅2970297068,07655,9707,33913.10%3,33313.57%3.94商業90009000價價格格上上升升10%10%220,000住宅3630363083,20556,42419,15734.00%13,03528.57%3.28商業1100011000工程造價變化工工程程造造價價增增加加10%10%220,000住宅330075,64159,51810,42517.50%5,74317.22%3.81商業10000工工程程造造價價減減少少10%10%220,000住宅330075,64152,87616,07130.40%10,62525.39%3.46商業10000