商业地产项目投资估算及财务分析.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