《某房地产项目经济测算表.xls》由会员分享，可在线阅读，更多相关《某房地产项目经济测算表.xls（24页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、基础数据表项目单位数值期初资本金万元10000期初资金万元8488贷款利率%5.85%X销售比例%90.00%Y销售比例%90.00%W销售比例%90.00%公积金提取比例%10.00%公益金提取比例%10.00%营业税紧急附加比率%5.55%土地增值税比率%1.00%所得税率%16.50%0.00%内部收益率测算基准比率%10.00%项目总体投入销售毛利率%19.89%X销售价格元10000Y销售价格元3000W销售价格元6000项目单位年 度1234土地亩180018002412X8000080000W1000015000Y600005000060000本年投资额的80%80%上年投资额的
2、20%20%568000064002203346000042001经经济济评评价价指指标标汇汇总总表表序号指标名称单位数量一一项项目目基基本本数数据据1项目总投资万元2976352自有资金万元100003借贷资金万元974643营业收入万元3715226利润总额万元495537所得税万元22428税后利润万元47311二二项项目目经经济济指指标标1全投资内部收益率%2资本金内部收益率%215.74%3投资利润率%16.65%9投资回收期年4.9510借款偿还期年2.89资产负债试算第一年第二年项目借方贷方项目借方贷方存货38919.1649131.1212978.16在建开发产品现金38119
3、.0048119.1669564.0069564.26在建工程固定资产净值9200.0019372.04固定资产投资借款18000.00开发产品投资借款20119.0053364.00资本金公积金216.07公益金216.07未分配利润0.001728.590.0086238.1686238.160.00138067.16138067.16第三年第四年第五年项目借方贷方项目借方贷方项目78499.0872821.9035884.7277147.9596881.0096881.0496300.0082351.3712428.012040.005981.0014138.0023981.001212
4、.421284.441212.421284.449699.3210275.520.00187808.09187808.090.00172343.72172343.720.00资产负债试算第六年借方贷方项目借方贷方28262.3679455.4721863.3053196.2099180.3695426.5368942.0729333.2959345.001190.57827.591190.57827.599524.586620.71186787.72186787.720.0090805.3790805.37第五年资产负债表序号项目第一年第二年第三年1资产48119.00103643.74121
5、748.891.1流动资产总额38919.0075071.7080748.841.1.1应收账款0.000.000.001.1.2存货38919.1675072.1280749.30其中：在建开发产品1.1.3现金(0.16)(0.42)(0.45)1.2在建工程1.3固定资产净值9200.0028572.0441000.051.4无形及递延资产净值2负债及所有者权益48119.00103643.74121748.892.1流动负债总额0.000.000.002.1.1应付帐款0.000.000.002.1.2短期借款2.2借款38119.0091483.0097464.002.2.1经营资金
6、借款2.2.2固定资产投资借款18000.0018000.0023981.002.2.3开发产品投资借款20119.0073483.0073483.00负债小计38119.0091483.0097464.002.3所有者权益10000.0012160.7424284.892.3.1资本金10000.0010000.0010000.002.3.2公积金0.00216.071428.492.3.3公益金0.00216.071428.492.3.4累计未分配利润0.001728.5911427.923资产负债率79.22%88.27%80.05%第四年第五年第六年96474.2949035.0257
7、310.9053434.245994.9714270.850.000.000.0039486.07(11707.04)(43039.94)13948.1817702.0157310.7943040.0543040.0543040.0596474.2949035.0257310.900.000.000.000.000.000.0059345.000.000.000.000.0059345.000.0059345.000.000.0037129.2949035.0257310.9010000.0010000.0010000.002712.933903.504731.092712.933903.50
8、4731.0921703.4431228.0137848.7261.51%0.00%0.00%资金来源与运用表序号项目合计第一年第二年1资金来源478986.4348119.0069564.001.1销售收入371522.430.0016200.001.2资本金10000.0010000.001.3银行贷款97464.0038119.0053364.002资金运用421675.6448119.1669564.262.1建设投资280879.4847004.1864712.302.6借款偿还97464.000.000.002.2财务费用16755.041114.983790.862.3土地增值税
9、3715.220.00162.002.4经营税金及附加20619.490.00899.102.5所得税2242.400.000.003盈余资金183415.37(1114.98)9187.304累计盈余资金183415.37(1114.98)8072.32说明1.借款为弥补投入资金缺口2.累计盈余资金即为当年先进存量第三年第四年第五年第六年96881.0096300.0099180.3668942.0790900.0096300.0099180.3668942.075981.000.000.000.0096881.0482351.3795426.5329333.2985400.3933338.
10、0626526.5223898.040.0038119.0059345.000.005526.704586.661735.840.00909.00963.00991.80689.425044.955344.655504.513826.280.000.001322.86919.5467295.2034442.2918374.6355230.9475367.52109809.80128184.43183415.37资金来源与运用表贷款还本付息结算表序号项目合计第一年第二年第三年第四年1 借款还本付息1.1第一笔借款年初借款累计381193811938119本年借款3811938119本年应计利息6
11、6901115223022301115本年偿付本金3811938119本年偿付利息66901115223022301115年末借款余额38119381193811901.2第二笔借款年初借款累计5336453364本年借款5336453364本年应计利息9365156131223122本年偿付本金53364本年偿付利息9365156131223122年末借款余额5336453364533641.3第三笔借款年初借款累计5981本年借款59815981本年应计利息700175350本年偿付本金5981本年偿付利息700175350年末借款余额598159811.4借款汇总年初借款累计038119
12、9148397464本年借款97464381195336459810本年应计利息167551115379155274587本年偿付本金9746400038119本年偿付利息167551115379155274587年末借款余额381199148397464593452 借款还本付息资金来源02.1 投资收回47311021611212412844第五年第六年00000533641561533641561059811755981175059345000173605934501736000119068276资资本本金金财财务务现现金金流流量量表表序号项目合计第一年第二年第三年第四年1现金流入0.0
13、016200.0090900.0096300.001.1销售收入（专指销售回款）371522.430.0016200.0090900.0096300.002现金流出198107.0611114.987012.7023604.8061857.712.1自有资金10000.0010000.002.2销售收入再投入47310.900.002160.7412124.1512844.402.6借款本金偿还97464.0038119.002.7借款利息偿还16755.041114.983790.865526.704586.662.4土地增值税3715.220.00162.00909.00963.002.3
14、经营税金及附加20619.490.00899.105044.955344.652.5所得税2242.400.000.000.000.003净现金流量173415.37-11114.989187.3067295.2034442.294折现净现金流量78865.97-9271.146392.0139053.3216672.11累计折现净现金流量78865.97-9271.14-2879.1436174.1852846.291.财务内部收益率：215.74%2.财务净现值：114158.33第五年第六年99180.3668942.0799180.3668942.0780805.7313711.131
15、1905.728275.8859345.001735.840.00991.80689.425504.513826.281322.86919.5418374.6355230.947418.9418600.7460265.2378865.97损损益益表表序号项目合计第一年第二年第三年第四年第五年1销售收入3715220162009090096300991802总成本费用2976340129787282277148794554土地增值税37150162909963992销售税金及附加2061908995045534555055利润总额49553021611212412844132296所得税2242
16、000013237税后利润47311021611212412844119068盈余公积金473102161212128411919公益金4731021612121284119110可分配利润37849017299699102769525投资利润率16.65%投资利税率24.83%资本金利润率495.53%万元第六年68942552316893826919592082768288286621投资计划与资金筹措表序号项目合计第一年第二年第三年1 投资总额2976354811968503909271.1 建设投资280879470046471285400 1.1.1 土地成本601201800018
17、00024120 1.1.2 前期工程费7127225321152285 1.1.3 建安工程费13240192002369230628 1.1.4 基础设施费54883131721646520856 1.1.5 公建配套设施费32211681420896 1.1.6 开发期间税费0 1.1.7 不可预见费7733132918212364 1.1.8 管理费7965136918752434 1.1.9 销售费用7430032418181.2 贷款利息167551115379155271.3 流动资金00002 资金筹措2976344811968503909272.1 自有资金100001000
18、02.2 借款97464381195336459812.3 销售收入再投入19017001513984946说明从第四年开始，资金平衡需要的销售收入再投入，仅需部分销售回收资金即可第四年第五年第六年3792528262238983333826527238980004740024520231342122743910022400888694637915715656192619841379458717360000379252826223898000379252826223898从第四年开始，资金平衡需要的销售收入再投入，仅需部分销售回收资金即可销售计划表销售年度物业第一年第二年第三年第四年第五年第六
19、年合计X建成面积（）0080,00080,00080,00064,002304,002销售比例90%90%90%90%销售面积（按实现90%计）72,00072,00072,00057,602273,602销售单价（元/）10,00010,00010,00010,000销售收入（万元）72,00072,00072,00057,602273,602Y建成面积（）060,00050,00060,00060,00042,001272,001销售比例90%90%90%90%90%销售面积（）54,00045,00054,00054,00037,801244,801销售单价（元/）3,0003,0003
20、,0003,0003,000销售收入（万元）16,20013,50016,20016,20011,34073,440W建成面积（）0010,00015,00020,334045,334销售比例90%90%90%销售面积（按实现90%计）9,00013,50018,30140,801销售单价（元/）6,0006,0006,000销售收入（万元）5,4008,10010,98024,480销售收入合计16,20090,90096,30099,18068,942371,522分 年 度 投 资 计 划 表序号项目合计（万元）建设经营期（年）单位：万元第一年第二年第三年第四年第五年1 1开开发发成成本
21、本265,48445,63562,51381,14830,49723,8281.1土地成本60,12018,00018,00024,1201.2前期工程费7,1272,2532,1152,2854741.2.1规划设计费4,3001,2041,3331,4623011.2.2可行性研究费6625301321.2.3地质勘探费662159199252531.2.4三通一平1,5033614515711201.3建筑安装工程费132,4019,20023,69230,62824,52023,1341.3.1*园7,1405,7121,4281.3.2X60,80012,80016,00016,00
22、01.3.3K4,2003,3608401.3.4J10,0008,0002,0001.3.5W4,0807201,2601,7341.3.6GL20,0008,0002,0008,0002,0001.3.7GLH1,5001,2003001.3.8Y24,4804,3204,6805,2205,4001.3.9EX200160401.4基础设施费54,88313,17216,46520,8564,3911.5公建配套费3,2211,6814208962241.6不可预见费7,7331,3291,8212,3648886942 2开开发发费费用用32,1502,4845,9909,7797,4
23、284,4342.1管理费用7,9651,3691,8752,4349157152.2销售费用7,43003241,8181,9261,9842.3财务费用16,7551,1153,7915,5274,5871,736合计297,63548,11968,50390,92737,92528,262合计（不含财务费用）280,87947,00464,71285,40033,33826,527第六年21,86321,22716,0003664,8606372,0356561,379023,89823,898投资估算表序号项目单位数量单价（元）总金额（万元）备 注开发成本土地费土地亩6012100,0
24、0060,120小小计计60,12060,120前期工程费规划设计费m2716670604,300可行性研究万元1324000.50%662地质勘探费万元1324000.50%662三通一平亩60122,5001,503小小计计7,1277,127建筑安装工程费*园m2476001,5007,140 Xm23040022,00060,800Km2140003,0004,200Jm2200005,00010,000Wm2453349004,080GL个2100,000,00020,000GLHm230005,0001,500Ym227200190024,480EXm210002,000200建建
25、筑筑面面积积小小计计m2705,937705,937132,400132,400基础设施费道路m22580011002,580排水m2716670201,433园林m2716670402,867供水m2716670201,433供电m2716670302,150电讯m271667010717煤气m271667010717消防m271667010717智能化m2716670302,150大市政亩4012100,00040,120小小计计54,88354,883公建配套SCm280001,200960HHm213331,200160污水及中水处理站m2109001水处理设备套37002,100小小
26、计计m210103,2213,221不可预见费万元257,752257,7527,7337,733按前5项合计的3%计算开发期间税费0 00 0开开发发成成本本合合计计265,484265,484开发费用财务费用万元16,755管理费用7,965管理费按开发成本的3%计算销售费用7,430按销售收入的2%计算小小计计32,15032,150投投资资总总额额297,634297,634物业细分表类别内容物业构成/数量占地面积容积率建筑面积（平方米）亩平方米*园A14026666.80.410667234B120133330.45333234C115100000.440002D150333340.
27、310000234EGL20001333340GLH40266673000EX50333351000410666756005106667400067F130200000.480002345*园园合合计计2265151001051600 J160400000.520000K170466670.314000234会会计计中中心心合合计计1308666734000L X152010133380.3304002Y5103400020.8272001 W1701133340.445334 HH30200000.48000 SC533331333*生生活活社社区区合合计计22351490007630670
28、M 192613340 2106667400 3 4 53872580010 66724480020 72211473340配配套套设设施施合合计计1382921338400总总 计计60124008022716670*地块用地平衡表单位：亩序号物业类别业态内容占地面积占地率1*园A400.67B200.33C150.25D500.83E211035.10F300.50小小计计2265226537.6737.672JJ601.00K*701.16*小小计计1301302.162.163L1152025.2825108.4831702.834300.50550.08小小计计2235223537.1837.184M1100.17234921.5353876.44667211.1872213.68小小计计1382138222.9922.995合合 计计60126012100.00100.00