長租公寓測算表【經(jīng)營測算1年、10年含公式和示例】

月租金,4050,,,,,,,,,,,,,,

房間數(shù),620,,,,,,,,,,,,,,

收入,單價(jià),年度合計(jì),1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,收入依據(jù)

公寓租金收入,,14136930.00,125550.00,200880.00,376650.00,627750.00,878850.00,1004400.00,1255500.00,1506600.00,1757700.00,2008800.00,2134350.00,2259900.00,

出租率,,0.00,5%,8%,15%,25%,35%,40%,50%,60%,70%,80%,85%,90%,預(yù)估爬坡期12個(gè)月

營收,,0.00,125550.00,200880.00,376650.00,627750.00,878850.00,1004400.00,1255500.00,1506600.00,1757700.00,2008800.00,2134350.00,2259900.00,

增值收入,,69812.00,620.00,992.00,1860.00,3100.00,4340.00,4960.00,6200.00,7440.00,8680.00,9920.00,10540.00,11160.00,

收入合計(jì),,14206742.00,126170.00,201872.00,378510.00,630850.00,883190.00,1009360.00,1261700.00,1514040.00,1766380.00,2018720.00,2144890.00,2271060.00,

,,0.00,,,,,,,,,,,,,

費(fèi)用,,0.00,,,,,,,,,,,,,

基本管理費(fèi)（收入*5%）,,710337.10,6308.50,10093.60,18925.50,31542.50,44159.50,50468.00,63085.00,75702.00,88319.00,100936.00,107244.50,113553.00,

公寓直接經(jīng)營費(fèi),,5822548.50,,,,,,,,,,,,,

人員費(fèi)用,,2088000.00,174000.00,174000.00,174000.00,174000.00,174000.00,174000.00,174000.00,174000.00,174000.00,174000.00,174000.00,174000.00,

店長,15000.00,180000.00,15000.00,15000.00,15000.00,15000.00,15000.00,15000.00,15000.00,15000.00,15000.00,15000.00,15000.00,15000.00,配置1名店長

運(yùn)營管家,8000.00,576000.00,48000.00,48000.00,48000.00,48000.00,48000.00,48000.00,48000.00,48000.00,48000.00,48000.00,48000.00,48000.00,配置6名管家

營銷,8000.00,384000.00,32000.00,32000.00,32000.00,32000.00,32000.00,32000.00,32000.00,32000.00,32000.00,32000.00,32000.00,32000.00,首年配置4名銷售

保潔人員費(fèi)用,4500.00,540000.00,45000.00,45000.00,45000.00,45000.00,45000.00,45000.00,45000.00,45000.00,45000.00,45000.00,45000.00,45000.00,按照1:60配比保潔，共計(jì)10名保潔(6名公區(qū)保潔，4名客房保潔)

保安人員費(fèi)用,6000.00,216000.00,18000.00,18000.00,18000.00,18000.00,18000.00,18000.00,18000.00,18000.00,18000.00,18000.00,18000.00,18000.00,大堂及夜間樓層保安，共計(jì)3名保安

工程維修費(fèi)用,8000.00,192000.00,16000.00,16000.00,16000.00,16000.00,16000.00,16000.00,16000.00,16000.00,16000.00,16000.00,16000.00,16000.00,配置2名維修，24小時(shí)值守

環(huán)境衛(wèi)生費(fèi),,409800.00,30400.00,30400.00,30400.00,30400.00,30400.00,30400.00,37900.00,37900.00,37900.00,37900.00,37900.00,37900.00,

日常消殺費(fèi)用,20.00,148800.00,12400,12400,12400,12400,12400,12400,12400,12400,12400,12400,12400,12400,按照20元/間/月計(jì)算

垃圾清理費(fèi),750.00,225000.00,15000,15000,15000,15000,15000,15000,22500,22500,22500,22500,22500,22500,前半年按照20桶垃圾計(jì)算，后半年按照30桶計(jì)算

清潔耗材,,36000.00,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,每月按照3000元預(yù)估

公共事業(yè)費(fèi),,631944.00,35550.00,37224.00,41130.00,46710.00,52290.00,55080.00,60660.00,60660.00,60660.00,60660.00,60660.00,60660.00,

電費(fèi),1.00,360000.00,30000.00,30000.00,30000.00,30000.00,30000.00,30000.00,30000.00,30000.00,30000.00,30000.00,30000.00,30000.00,考慮公共區(qū)位能耗，按照1000平米，每天平均能耗1000度計(jì)算，商業(yè)用電成本

水費(fèi),4.20,15120.00,1260.00,1260.00,1260.00,1260.00,1260.00,1260.00,1260.00,1260.00,1260.00,1260.00,1260.00,1260.00,考慮公共區(qū)位能耗，每天能耗用水10噸

網(wǎng)絡(luò)通信,45.00,238824.00,2790.00,4464.00,8370.00,13950.00,19530.00,22320.00,27900.00,27900.00,27900.00,27900.00,27900.00,27900.00,按照出租率翻倍考慮寬帶開通數(shù)量

電話通訊費(fèi),500.00,18000.00,1500.00,1500.00,1500.00,1500.00,1500.00,1500.00,1500.00,1500.00,1500.00,1500.00,1500.00,1500.00,按照3部電話，每月500元預(yù)估

市場費(fèi)用,,2122600.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,

首年開辦費(fèi)用,,1240000.00,,,,,,,,,,,,,按照2000元/間，預(yù)估首年?duì)I銷費(fèi)用

網(wǎng)絡(luò)端口,,372000.00,,,,,,,,,,,,,按照300元/間預(yù)估網(wǎng)絡(luò)平臺費(fèi)用，平均出租周期6個(gè)月

客戶活動,,120000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,10000.00,月度組織客群活動，預(yù)計(jì)10000元/月

租賃傭金,,390600.00,,,,,,,,,,,,,按照年出租數(shù)30%為渠道出房預(yù)估

設(shè)備維護(hù),,452067.42,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,

電梯維保,,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,考慮大物業(yè)管理，無此費(fèi)用

消防維保,,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,考慮大物業(yè)管理，無此費(fèi)用

水泵維保,,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,考慮大物業(yè)管理，無此費(fèi)用

生活水箱清洗,,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,考慮大物業(yè)管理，無此費(fèi)用

強(qiáng)電維保,,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,考慮大物業(yè)管理，無此費(fèi)用

綠化養(yǎng)護(hù),,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,考慮大物業(yè)管理，無此費(fèi)用

房屋維修費(fèi)用,,310000.00,,,,,,,,,,,,,按照500元/間預(yù)估年維修費(fèi)用

其他不可預(yù)見費(fèi)用,,142067.42,1261.7,2018.72,3785.1,6308.5,8831.9,10093.6,12617,15140.4,17663.8,20187.2,21448.9,22710.6,按照收入的1%預(yù)估

保險(xiǎn),,40000.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,

一切財(cái)產(chǎn)險(xiǎn),,40000.00,,,,,,,,,,,,,按照房間數(shù)預(yù)估4000