房地产公司项目盈利预测表模版

**地产控股有限公司,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,

**地块盈利预测,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,

楼面单价(不含契税)(元/平方米),,,,,"1,588","2,000","2,500","3,000","3,500","4,000","4,500","5,000","5,500","6,000","6,500","7,000","7,500"

楼面总价(不含契税)(元),,,,,"594,420,000","748,852,000","936,065,000","1,123,278,000","1,310,491,000","1,497,704,000","1,684,917,000","1,872,130,000","2,059,343,000","2,246,556,000","2,433,769,000","2,620,982,000","2,808,195,000"

投资总价(元),,,,,"1,643,419,942","1,797,851,942","1,985,064,942","2,172,277,942","2,359,490,942","2,546,703,942","2,733,916,942","2,921,129,942","3,108,342,942","3,295,555,942","3,482,768,942","3,669,981,942","3,857,194,942"

,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,

总用地面積(平方米),,,,,"450,155","450,155","450,155","450,155","450,155","450,155","450,155","450,155","450,155","450,155","450,155","450,155","450,155"

总建筑面積(平方米),,,,,"356,737","356,737","356,737","356,737","356,737","356,737","356,737","356,737","356,737","356,737","356,737","356,737","356,737"

总可售面积（平方米）,,,,,"374,426","374,426","374,426","374,426","374,426","374,426","374,426","374,426","374,426","374,426","374,426","374,426","374,426"

增价幅度(元),,,,,-,"154,432,000","187,213,000","187,213,000","187,213,000","187,213,000","187,213,000","187,213,000","187,213,000","187,213,000","187,213,000","187,213,000","187,213,000"

,,,,,,,,,,,,,,,,,,

,,,,,人民幣千元,人民幣千元,人民幣千元,人民幣千元,人民幣千元,人民幣千元,人民幣千元,人民幣千元,人民幣千元,人民幣千元,人民幣千元,人民幣千元,人民幣千元

收入,,,,,,,,,,,,,,,,,

,联排别墅,,,,"1,190,000","1,190,000","1,190,000","1,190,000","1,190,000","1,190,000","1,190,000","1,190,000","1,190,000","1,190,000","1,190,000","1,190,000","1,190,000"

,6-8层住宅,,,,"3,466,838","3,466,838","3,466,838","3,466,838","3,466,838","3,466,838","3,466,838","3,466,838","3,466,838","3,466,838","3,466,838","3,466,838","3,466,838"

,地下车位,,,,"166,640","166,640","166,640","166,640","166,640","166,640","166,640","166,640","166,640","166,640","166,640","166,640","166,640"

,,,,,,,,,,,,,,,,,,

,,,,,"4,823,478","4,823,478","4,823,478","4,823,478","4,823,478","4,823,478","4,823,478","4,823,478","4,823,478","4,823,478","4,823,478","4,823,478","4,823,478"

提供商品或服务的成本,,,,,,,,,,,,,,,,,

,土地成本(含3%契税),,,,"(612,253)","(771,318)","(964,147)","(1,156,976)","(1,349,806)","(1,542,635)","(1,735,465)","(1,928,294)","(2,121,123)","(2,313,953)","(2,506,782)","(2,699,611)","(2,892,441)"

,建筑成本(不含资本化利息),,,,"(1,025,914)","(1,025,914)","(1,025,914)","(1,025,914)","(1,025,914)","(1,025,914)","(1,025,914)","(1,025,914)","(1,025,914)","(1,025,914)","(1,025,914)","(1,025,914)","(1,025,914)"

,资本化利息,,,,"(23,086)","(23,086)","(23,086)","(23,086)","(23,086)","(23,086)","(23,086)","(23,086)","(23,086)","(23,086)","(23,086)","(23,086)","(23,086)"

营业税,,,,,,,,,,,,,,,,,

,出售物业,,,,"(265,291)","(265,291)","(265,291)","(265,291)","(265,291)","(265,291)","(265,291)","(265,291)","(265,291)","(265,291)","(265,291)","(265,291)","(265,291)"

,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,

毛利润,,,,,"2,896,934","2,737,869","2,545,039","2,352,210","2,159,381","1,966,551","1,773,722","1,580,892","1,388,063","1,195,234","1,002,404","809,575","616,745"

毛利润率(含土地增值税),,,,,41.5%,40.4%,38.7%,36.9%,35.0%,32.5%,30.0%,27.5%,25.0%,22.5%,20.0%,16.8%,12.8%

,,,,,,,,,,,,,,,,,,

减：,,,,,,,,,,,,,,,,,

,销售费用,,1.2%,,"(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)"

,管理费用,,1.2%,,"(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)","(57,882)"

,,,,,,,,,,,,,,,,,,

税前利润,,,,,"2,781,171","2,622,106","2,429,276","2,236,447","2,043,617","1,850,788","1,657,959","1,465,129","1,272,300","1,079,470","886,641","693,812","500,982"

,,,,,,,,,,,,,,,,,,

税项,,,,,,,,,,,,,,,,,

土地增值税扣除项,,,,,"2,336,085","2,534,917","2,775,953","3,016,990","3,258,027","3,499,064","3,740,100","3,981,137","4,222,174","4,463,211","4,704,247","4,945,284","5,186,321"

土地增值额,,,,,"2,487,392","2,288,561","2,047,524","1,806,487","1,565,451","1,324,414","1,083,377","842,340","601,304","360,267","119,230","(121,806)","(362,843)"

土地增值比例,,,,,106%,90%,74%,60%,48%,38%,29%,21%,14%,8%,3%,-2%,-7%

土地增值税,,,,,"(893,283)","(788,679)","(680,212)","(571,745)","(469,635)","(397,324)","(325,013)","(252,702)","(180,391)","(108,080)","(35,769)",-,-

企业所得税,,,,,"(471,972)","(458,357)","(437,266)","(416,175)","(393,496)","(363,366)","(333,236)","(303,107)","(272,977)","(242,848)","(212,718)","(173,453)","(125,246)"

,,,,,,,,,,,,,,,,,,

净利润,,,,,"1,415,916","1,375,070","1,311,798","1,248,526","1,180,487","1,090,098","999,709","909,320","818,932","728,543","638,154","520,359","375,737"

净利润率,,,,,29.4%,28.5%,27.2%,25.9%,24.5%,22.6%,20.7%,18.9%,17.0%,15.1%,13.2%,10.8%,7.8%

投资回報率,,,,,86.2%,76.5%,66.1%,57.5%,50.0%,42.8%,36.6%,31.1%,26.3%,22.1%,18.3%,14.2%,9.7%

,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,

平均成本(元/平方米),,,,,人民幣,人民幣,人民幣,人民幣,人民幣,人民幣,人民幣,人民幣,人民幣,人民幣,人民幣,人民幣,人民幣

土地,,,,,"1,588","2,000","2,500","3,000","3,500","4,000","4,500","5,000","5,500","6,000","6,500","7,000","7,500"

契税,,,,,48,60,75,90,105,120,135,150,165,180,195,210,225

利息,,,,,62,62,62,62,62,62,62,62,62,62,62,62,62

建築,,,,,"2,740","2,740","2,740","2,740","2,740","2,740","2,740","2,740","2,740","2,740","2,740","2,740","2,740"

,,,,,"4,437","4,862","5,377","5,892","6,407","6,922","7,437","7,952","8,467","8,982","9,497","10,012","10,527"

,,,,,,,,,,,,,,,,,,

平均售价(元/平方米),,,