长租公寓测算表【经营测算1年、10年含公式和示例】

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

房间数,620,,,,,,,,,,,,,,

收入,单价,年度合计,1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,收入依据

公寓租金收入,,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%,预估爬坡期12个月

营收,,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,

收入合计,,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,,,,,,,,,,,,,

费用,,0.00,,,,,,,,,,,,,

基本管理费（收入*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,

公寓直接经营费,,5822548.50,,,,,,,,,,,,,

人员费用,,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名店长

运营管家,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名销售

保洁人员费用,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配比保洁，共计10名保洁(6名公区保洁，4名客房保洁)

保安人员费用,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,大堂及夜间楼层保安，共计3名保安

工程维修费用,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小时值守

环境卫生费,,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,

日常消杀费用,20.00,148800.00,12400,12400,12400,12400,12400,12400,12400,12400,12400,12400,12400,12400,按照20元/间/月计算

垃圾清理费,750.00,225000.00,15000,15000,15000,15000,15000,15000,22500,22500,22500,22500,22500,22500,前半年按照20桶垃圾计算，后半年按照30桶计算

清洁耗材,,36000.00,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,每月按照3000元预估

公共事业费,,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,

电费,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,考虑公共区位能耗，按照1000平米，每天平均能耗1000度计算，商业用电成本

水费,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,考虑公共区位能耗，每天能耗用水10吨

网络通信,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,按照出租率翻倍考虑宽带开通数量

电话通讯费,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元预估

市场费用,,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,

首年开办费用,,1240000.00,,,,,,,,,,,,,按照2000元/间，预估首年营销费用

网络端口,,372000.00,,,,,,,,,,,,,按照300元/间预估网络平台费用，平均出租周期6个月

客户活动,,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,月度组织客群活动，预计10000元/月

租赁佣金,,390600.00,,,,,,,,,,,,,按照年出租数30%为渠道出房预估

设备维护,,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,考虑大物业管理，无此费用

消防维保,,,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,考虑大物业管理，无此费用

生活水箱清洗,,,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,考虑大物业管理，无此费用

绿化养护,,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,考虑大物业管理，无此费用

房屋维修费用,,310000.00,,,,,,,,,,,,,按照500元/间预估年维修费用

其他不可预见费用,,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%预估

保险,,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,

一切财产险,,40000.00,,,,,,,,,,,,,按照房间数预估4000