商业地产项目运营财务测算.xls

《商业地产项目运营财务测算.xls》由会员分享，可在线阅读，更多相关《商业地产项目运营财务测算.xls（29页珍藏版）》请在三一办公上搜索。

1、南南华华置置地地广广场场项项目目使使用用权权销销售售（租租赁赁）回回款款预预测测方方案案总总表表可销售总面积20000平米使用面积实际销售比例100%实际销售面积20000平米使用面积单铺使用面积5 58 81111平米使用面积销售折扣比例95%第一年租金为市场之80%此市场租金为包括租金及相关管理及物业费用等依次年租金为上年之90%1年2年3年4年5年6年7年8年方方案案单单铺铺使使用用面面积积（平平米米）市市场场租租金金（元元/月月/平平使使用用面面积积）销销售售折折扣扣首首付付比比例例第第一一年年租租金金为为市市场场之之依依次次年年租租金金为为上上年年之之使使用用面面积积平平米米月月租租

2、金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际

3、总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入方方案案A A方方案案A-1-1A-1-15 590095%30%80%90%72043,200164,160,00064877,760295,488,000583104,976398,908,800525125,971478,690,560472141,718538,526,880425153,055581,609,030383160,708610,689,482344165,299628,137,753方方案案A-1-2A-1-25 580095%30%80%90%64038,40014

4、5,920,00057669,120262,656,00051893,312354,585,600467111,974425,502,720420125,971478,690,560378136,049516,985,805340142,851542,835,095306146,933558,344,669方方案案A-1-3A-1-35 570095%30%80%90%56033,600127,680,00050460,480229,824,00045481,648310,262,40040897,978372,314,880367110,225418,854,240331119,043452

5、,362,579298124,995474,980,708268128,566488,551,586方方案案A-2-1A-2-15 590095%40%80%90%164,160,000295,488,000398,908,800478,690,560538,526,880581,609,030610,689,482628,137,753方方案案A-2-2A-2-25 580095%40%80%90%145,920,000262,656,000354,585,600425,502,720478,690,560516,985,805542,835,095558,344,669方方案案A-2-3A

6、-2-35 570095%40%80%90%127,680,000229,824,000310,262,400372,314,880418,854,240452,362,579474,980,708488,551,586方方案案A-3-1A-3-15 590095%50%80%90%164,160,000295,488,000398,908,800478,690,560538,526,880581,609,030610,689,482628,137,753方方案案A-3-2A-3-25 580095%50%80%90%145,920,000262,656,000354,585,600425,5

7、02,720478,690,560516,985,805542,835,095558,344,669方方案案A-3-3A-3-35 570095%50%80%90%127,680,000229,824,000310,262,400372,314,880418,854,240452,362,579474,980,708488,551,586方方案案B B方方案案B-1-1B-1-18 880095%30%80%90%64061,440145,920,000576110,592262,656,000518149,299354,585,600467179,159425,502,720420201,5

8、54478,690,560378217,678516,985,805340228,562542,835,095306235,092558,344,669方方案案B-1-2B-1-28 870095%30%80%90%56053,760127,680,00050496,768229,824,000454130,637310,262,400408156,764372,314,880367176,360418,854,240331190,468452,362,579298199,992474,980,708268205,706488,551,586方方案案B-1-3B-1-38 860095%30%

9、80%90%48046,080109,440,00043282,944196,992,000389111,974265,939,200350134,369319,127,040315151,165359,017,920283163,259387,739,354255171,422407,126,321230176,319418,758,502方方案案B-2-1B-2-18 880095%40%80%90%145,920,000262,656,000354,585,600425,502,720478,690,560516,985,805542,835,095558,344,669方方案案B-2-

10、2B-2-28 870095%40%80%90%127,680,000229,824,000310,262,400372,314,880418,854,240452,362,579474,980,708488,551,586方方案案B-2-3B-2-38 860095%40%80%90%109,440,000196,992,000265,939,200319,127,040359,017,920387,739,354407,126,321418,758,502方方案案B-3-1B-3-18 880095%50%80%90%145,920,000262,656,000354,585,600425

11、,502,720478,690,560516,985,805542,835,095558,344,669方方案案B-3-2B-3-28 870095%50%80%90%127,680,000229,824,000310,262,400372,314,880418,854,240452,362,579474,980,708488,551,586方方案案B-3-3B-3-38 860095%50%80%90%109,440,000196,992,000265,939,200319,127,040359,017,920387,739,354407,126,321418,758,502方方案案C C方

12、方案案C-1-1C-1-1111170095%30%80%90%56073,920127,680,000504133,056229,824,000454179,626310,262,400408215,551372,314,880367242,495418,854,240331261,894452,362,579298274,989474,980,708268282,846488,551,586方方案案C-1-2C-1-2111160095%30%80%90%48063,360109,440,000432114,048196,992,000389153,965265,939,200350184

13、,758319,127,040315207,852359,017,920283224,481387,739,354255235,705407,126,321230242,439418,758,502方方案案C-1-3C-1-3111150095%30%80%90%40052,80091,200,00036095,040164,160,000324128,304221,616,000292153,965265,939,200262173,210299,181,600236187,067323,116,128213196,421339,271,934191202,033348,965,418方方案

14、案C-2-1C-2-1111170095%40%80%90%127,680,000229,824,000310,262,400372,314,880418,854,240452,362,579474,980,708488,551,586方方案案C-2-2C-2-2111160095%40%80%90%109,440,000196,992,000265,939,200319,127,040359,017,920387,739,354407,126,321418,758,502方方案案C-2-3C-2-3111150095%40%80%90%91,200,000164,160,000221,616

15、,000265,939,200299,181,600323,116,128339,271,934348,965,418方方案案C-3-1C-3-1111170095%50%80%90%127,680,000229,824,000310,262,400372,314,880418,854,240452,362,579474,980,708488,551,586方方案案C-3-2C-3-2111160095%50%80%90%109,440,000196,992,000265,939,200319,127,040359,017,920387,739,354407,126,321418,758,50

16、2方方案案C-3-3C-3-3111150095%50%80%90%91,200,000164,160,000221,616,000265,939,200299,181,600323,116,128339,271,934348,965,418南南华华置置地地广广场场项项目目使使用用权权销销售售（租租赁赁）回回款款预预测测方方案案总总表表(附附表表）可销售总面积20000平米使用面积实际销售比例100%实际销售面积20000平米使用面积单铺使用面积5 58 81111平米使用面积规划及分割所占比例25%25%60%60%15%15%100%面积分配5000120003000平米使用面积销售折扣比

17、例95%第一年租金为市场之80%此市场租金为包括租金及相关管理及物业费用等依次年租金为上年之90%1年2年3年4年5年6年7年8年方方案案单单铺铺使使用用面面积积（平平米米）市市场场租租金金（元元/月月/平平使使用用面面积积）销销售售折折扣扣第第一一年年租租金金为为市市场场之之依依次次年年租租金金为为上上年年之之规规划划及及分分割割所所占占比比例例使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（

18、元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入使使用用面面积积平平米米月月租租金金（元元）单单铺铺总总金金额额（元元）实实际际总总收收入入方方案案一一方方案案A-1-1A-1-15 590095%80%90%25%72043,20041,040,000

19、64877,76073,872,000583104,97699,727,200525125,971119,672,640472141,718134,631,720425153,055145,402,258383160,708152,672,370344165,299157,034,438方方案案B-1-1B-1-18 880095%80%90%60%64061,44087,552,000576110,592157,593,600518149,299212,751,360467179,159255,301,632420201,554287,214,336378217,678310,191,483

20、340228,562325,701,057306235,092335,006,802方方案案C-1-1C-1-1111170095%80%90%15%56073,92019,152,000504133,05634,473,600454179,62646,539,360408215,55155,847,232367242,49562,828,136331261,89467,854,387298274,98971,247,106268282,84673,282,738合合 计计100%100%147,744,000147,744,000265,939,200265,939,200359,017,9

21、20359,017,920430,821,504430,821,504484,674,192484,674,192523,448,127523,448,127549,620,534549,620,534565,323,978565,323,978方方案案二二方方案案A-1-2A-1-25 580095%80%90%25%64038,40036,480,00057669,12065,664,00051893,31288,646,400467111,974106,375,680420125,971119,672,640378136,049129,246,451340142,851135,708,7

22、74306146,933139,586,167方方案案B-1-2B-1-28 870095%80%90%60%56053,76076,608,00050496,768137,894,400454130,637186,157,440408156,764223,388,928367176,360251,312,544331190,468271,417,548298199,992284,988,425268205,706293,130,951方方案案C-1-2C-1-2111160095%80%90%15%48063,36016,416,000432114,04829,548,800389153,9

23、6539,890,880350184,75847,869,056315207,85253,852,688283224,48158,160,903255235,70561,068,948230242,43962,813,775合合 计计100%100%129,504,000129,504,000233,107,200233,107,200314,694,720314,694,720377,633,664377,633,664424,837,872424,837,872458,824,902458,824,902481,766,147481,766,147495,530,894495,530,89

24、4方方案案三三方方案案A-1-3A-1-35 570095%80%90%25%56033,60031,920,00050460,48057,456,00045481,64877,565,60040897,97893,078,720367110,225104,713,560331119,043113,090,645298124,995118,745,177268128,566122,137,896方方案案B-1-3B-1-38 860095%80%90%60%48046,08065,664,00043282,944118,195,200389111,974159,563,520350134,36

25、9191,476,224315151,165215,410,752283163,259232,643,612255171,422244,275,793230176,319251,255,101方方案案C-1-3C-1-3111150095%80%90%15%40052,80013,680,00036095,04024,624,000324128,30433,242,400292153,96539,890,880262173,21044,877,240236187,06748,467,419213196,42150,890,790191202,03352,344,813合合 计计100%100%

26、111,264,000111,264,000200,275,200200,275,200270,371,520270,371,520324,445,824324,445,824365,001,552365,001,552394,201,676394,201,676413,911,760413,911,760425,737,810425,737,810南南华华置置地地广广场场地地下下部部分分使使用用权权出出售售（租租赁赁）回回款款预预测测方方案案方案A-1-1总使用面积(B1+B2)20000 平方米单个铺位使用面积5 5平方米市场目前租金参考900 元/平方米/使用面积销售折扣95%首付比例3

27、0%第一年租金为市场之80%依次年租金为上年之90%年年限限使使用用面面积积平平米米月月租租金金单单铺铺月月租租金金单单铺铺年年租租金金 单单铺铺总总金金额额合合计计总总金金额额单单铺铺折折后后金金额额95%95%单单铺铺首首付付金金额额 30%30%单单铺铺贷贷款款金金额额70%70%单单铺铺月月供供实实际际折折后后首首付付合合计计实实际际总总收收入入17207203,60043,20043,20043,200172,800,000172,800,00041,04012,31228,7282,52849,248,00049,248,000164,160,00026483,24038,8807

28、7,76077,760311,040,000311,040,00073,87222,16251,7102,28688,646,40088,646,400295,488,00035832,91634,992104,976104,976419,904,000419,904,00099,72729,91869,8092,116119,672,640119,672,640398,908,80045252,62431,493125,971125,971503,884,800503,884,800119,67335,90283,7711,962143,607,168143,607,168478,690,5

29、605 54722,36228,344141,718141,718566,870,400566,870,400134,63240,39094,2421,815161,558,064161,558,064538,526,8806 64252,12625,509153,055153,055612,220,032612,220,032145,40243,621101,7821,693174,482,709174,482,709581,609,0307 73831,91322,958160,708160,708642,831,034642,831,034152,67245,802106,8711,56

30、7183,206,845183,206,845610,689,4828 83441,72220,662165,299165,299661,197,635661,197,635157,03447,110109,9241,451188,441,326188,441,326628,137,753南南华华置置地地广广场场地地下下部部分分使使用用权权出出售售（租租赁赁）回回款款预预测测方方案案方案A-1-2总使用面积(B1+B2)20000 平方米单个铺位使用面积5 5平方米市场目前租金参考800 元/平方米/使用面积销售折扣95%首付比例30%第一年租金为市场之80%依次年租金为上年之90%年年限限使

31、使用用面面积积平平米米月月租租金金单单铺铺月月租租金金单单铺铺年年租租金金 单单铺铺总总金金额额合合计计总总金金额额单单铺铺折折后后金金额额95%95%单单铺铺首首付付金金额额 30%30%单单铺铺贷贷款款金金额额70%70%单单铺铺月月供供实实际际折折后后首首付付合合计计实实际际总总收收入入16406403,20038,40038,40038,400153,600,000153,600,00036,48010,94425,5362,24743,776,00043,776,000145,920,00025762,88034,56069,12069,120276,480,000276,480,0

32、0065,66419,69945,9652,03278,796,80078,796,800262,656,00035182,59231,10493,31293,312373,248,000373,248,00088,64626,59462,0521,881106,375,680106,375,680354,585,60044672,33327,994111,974111,974447,897,600447,897,600106,37631,91374,4631,744127,650,816127,650,816425,502,7205 54202,10025,194125,971125,971

33、503,884,800503,884,800119,67335,90283,7711,614143,607,168143,607,168478,690,5606 63781,89022,675136,049136,049544,195,584544,195,584129,24638,77490,4731,505155,095,741155,095,741516,985,8057 73401,70120,407142,851142,851571,405,363571,405,363135,70940,71394,9961,393162,850,529162,850,529542,835,0958

34、 83061,53118,367146,933146,933587,731,231587,731,231139,58641,87697,7101,290167,503,401167,503,401558,344,669南南华华置置地地广广场场地地下下部部分分使使用用权权出出售售（租租赁赁）回回款款预预测测方方案案方案A-1-3总使用面积(B1+B2)20000 平方米单个铺位使用面积5 5平方米市场目前租金参考700 元/平方米/使用面积销售折扣95%首付比例30%第一年租金为市场之80%依次年租金为上年之90%年年限限使使用用面面积积平平米米月月租租金金单单铺铺月月租租金金单单铺铺年年租租金

35、金 单单铺铺总总金金额额合合计计总总金金额额单单铺铺折折后后金金额额95%95%单单铺铺首首付付金金额额 30%30%单单铺铺贷贷款款金金额额70%70%单单铺铺月月供供实实际际折折后后首首付付合合计计实实际际总总收收入入15605602,80033,60033,60033,600134,400,000134,400,00031,9209,57622,3441,96638,304,00038,304,000127,680,00025042,52030,24060,48060,480241,920,000241,920,00057,45617,23740,2191,77868,947,20068

36、,947,200229,824,00034542,26827,21681,64881,648326,592,000326,592,00077,56623,27054,2961,64693,078,72093,078,720310,262,40044082,04124,49497,97897,978391,910,400391,910,40093,07927,92465,1551,526111,694,464111,694,464372,314,8805 53671,83722,045110,225110,225440,899,200440,899,200104,71431,41473,2991

37、,412125,656,272125,656,272418,854,2406 63311,65319,840119,043119,043476,171,136476,171,136113,09133,92779,1631,316135,708,774135,708,774452,362,5797 72981,48817,856124,995124,995499,979,693499,979,693118,74535,62483,1221,219142,494,212142,494,212474,980,7088 82681,33916,071128,566128,566514,264,8275

38、14,264,827122,13836,64185,4971,129146,565,476146,565,476488,551,586南南华华置置地地广广场场地地下下部部分分使使用用权权出出售售（租租赁赁）回回款款预预测测方方案案方案A-2-1总使用面积(B1+B2)20000 平方米单个铺位使用面积5 5平方米市场目前租金参考900 元/平方米/使用面积销售折扣95%首付比例40%第一年租金为市场之80%依次年租金为上年之90%年年限限使使用用面面积积平平米米月月租租金金单单铺铺月月租租金金单单铺铺年年租租金金 单单铺铺总总金金额额合合计计总总金金额额单单铺铺折折后后金金额额95%95%单单

39、铺铺首首付付金金额额 40%40%单单铺铺贷贷款款金金额额60%60%单单铺铺月月供供实实际际折折后后首首付付合合计计实实际际总总收收入入17207203,60043,20043,20043,200172,800,000172,800,00041,04016,41624,6242,16765,664,00065,664,000164,160,00026483,24038,88077,76077,760311,040,000311,040,00073,87229,54944,3231,960118,195,200118,195,200295,488,00035832,91634,992104,9

40、76104,976419,904,000419,904,00099,72739,89159,8361,814159,563,520159,563,520398,908,80045252,62431,493125,971125,971503,884,800503,884,800119,67347,86971,8041,681191,476,224191,476,224478,690,5605 54722,36228,344141,718141,718566,870,400566,870,400134,63253,85380,7791,556215,410,752215,410,752538,52

41、6,8806 64252,12625,509153,055153,055612,220,032612,220,032145,40258,16187,2411,451232,643,612232,643,612581,609,0307 73831,91322,958160,708160,708642,831,034642,831,034152,67261,06991,6031,343244,275,793244,275,793610,689,4828 83441,72220,662165,299165,299661,197,635661,197,635157,03462,81494,2211,2

42、44251,255,101251,255,101628,137,753南南华华置置地地广广场场地地下下部部分分使使用用权权出出售售（租租赁赁）回回款款预预测测方方案案方案A-2-2总使用面积(B1+B2)20000 平方米单个铺位使用面积5 5平方米市场目前租金参考800 元/平方米/使用面积销售折扣95%首付比例40%第一年租金为市场之80%依次年租金为上年之90%年年限限使使用用面面积积平平米米月月租租金金单单铺铺月月租租金金单单铺铺年年租租金金 单单铺铺总总金金额额合合计计总总金金额额单单铺铺折折后后金金额额95%95%单单铺铺首首付付金金额额 40%40%单单铺铺贷贷款款金金额额60%

43、60%单单铺铺月月供供实实际际折折后后首首付付合合计计实实际际总总收收入入16406403,20038,40038,40038,400153,600,000153,600,00036,48014,59221,8881,92658,368,00058,368,000145,920,00025762,88034,56069,12069,120276,480,000276,480,00065,66426,26639,3981,742105,062,400105,062,400262,656,00035182,59231,10493,31293,312373,248,000373,248,00088,

44、64635,45953,1881,612141,834,240141,834,240354,585,60044672,33327,994111,974111,974447,897,600447,897,600106,37642,55063,8251,495170,201,088170,201,088425,502,7205 54202,10025,194125,971125,971503,884,800503,884,800119,67347,86971,8041,383191,476,224191,476,224478,690,5606 63781,89022,675136,049136,0

45、49544,195,584544,195,584129,24651,69977,5481,290206,794,322206,794,322516,985,8057 73401,70120,407142,851142,851571,405,363571,405,363135,70954,28481,4251,194217,134,038217,134,038542,835,0958 83061,53118,367146,933146,933587,731,231587,731,231139,58655,83483,7521,106223,337,868223,337,868558,344,66

46、9南南华华置置地地广广场场地地下下部部分分使使用用权权出出售售（租租赁赁）回回款款预预测测方方案案方案A-2-3总使用面积(B1+B2)20000 平方米单个铺位使用面积5 5平方米市场目前租金参考700 元/平方米/使用面积销售折扣95%首付比例40%第一年租金为市场之80%依次年租金为上年之90%年年限限使使用用面面积积平平米米月月租租金金单单铺铺月月租租金金单单铺铺年年租租金金 单单铺铺总总金金额额合合计计总总金金额额单单铺铺折折后后金金额额95%95%单单铺铺首首付付金金额额 40%40%单单铺铺贷贷款款金金额额60%60%单单铺铺月月供供实实际际折折后后首首付付合合计计实实际际总总收

47、收入入15605602,80033,60033,60033,600134,400,000134,400,00031,92012,76819,1521,68551,072,00051,072,000127,680,00025042,52030,24060,48060,480241,920,000241,920,00057,45622,98234,4741,52491,929,60091,929,600229,824,00034542,26827,21681,64881,648326,592,000326,592,00077,56631,02646,5391,411124,104,960124,1

48、04,960310,262,40044082,04124,49497,97897,978391,910,400391,910,40093,07937,23155,8471,308148,925,952148,925,952372,314,8805 53671,83722,045110,225110,225440,899,200440,899,200104,71441,88562,8281,210167,541,696167,541,696418,854,2406 63311,65319,840119,043119,043476,171,136476,171,136113,09145,23667

49、,8541,128180,945,032180,945,032452,362,5797 72981,48817,856124,995124,995499,979,693499,979,693118,74547,49871,2471,045189,992,283189,992,283474,980,7088 82681,33916,071128,566128,566514,264,827514,264,827122,13848,85573,283967195,420,634195,420,634488,551,586南南华华置置地地广广场场地地下下部部分分使使用用权权出出售售（租租赁赁）回回款款

50、预预测测方方案案方案A-3-1总使用面积(B1+B2)20000 平方米单个铺位使用面积5 5平方米市场目前租金参考900 元/平方米/使用面积销售折扣95%首付比例50%第一年租金为市场之80%依次年租金为上年之90%年年限限使使用用面面积积平平米米月月租租金金单单铺铺月月租租金金单单铺铺年年租租金金 单单铺铺总总金金额额合合计计总总金金额额单单铺铺折折后后金金额额95%95%单单铺铺首首付付金金额额 50%50%单单铺铺贷贷款款金金额额50%50%单单铺铺月月供供实实际际折折后后首首付付合合计计实实际际总总收收入入17207203,60043,20043,20043,200172,800,