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

1、月租金4050房间数620收入单价年度合计1月2月3月4月公寓租金收入14136930.00125550.00200880.00376650.00627750.00出租率0.00X8%营收0.00125550.00200880.00376650.00627750.00增值收入69812.00620.00992.001860.003100.00收入合计14206742.00126170.00201872.00378510.00630850000.000.00基本管理费(收入*5%)710337.106308.5010093.6018025.5031542.50公寓直接经耳费5822548.50人

2、员费用2088000.00174000.00174000.00174000.00174000.00店长15000.00180000.0015000.0015000.0015000.0015000.00运百管家8000 00576000.0048000.0048000.0048000.0048000.00百销8000.00384000.0032000.0032000.0032000.0032000.00保洁人员费用4500.00540000.0045000.0045000.0045000.0045000.00保安人员费用6000.00216000.0018000.0018000.0018000.

3、0018000.00I程维修费用8000.00192000.0016000.0016000.0016000.0016000.00环境卫生费409800.0030400.0030400.0030400.0030400.00日常消杀费用20.00148800.0012400124001240012400垃圾清理身750.00225000.0015000150001500015000清洁耗材36000.003000300030003000公共事业费631044.0035550.0037224.0041130.0046710.00电费1.00360000.0030000.0030000.0030000

4、.0030000.00水为4.2015120.001260.001260.001260.001260.00网络通信45.00238824.002790.004464.008370.0013950.00电话通讯费500.0018000.001500.001500.001500.001500.00市场费用2122600.0010000.0010000.0010000.0010000.00首年开办费用1240000.00网络端口372000.00客户活动120000.0010000.0010000.0010000.0010000.00租赁佣金390600.00设备维护452067.420.000.0

5、00.000.00电梯维保0.000.000.000.00消防维保0.000.000.000.00水泵维保0.000.000.000.00生活水箱清洗0.000.000.000.00强电维保0.000.000.000.00绿化养护0.000.000.000.00房屋维修药用310000.00其他小可预见费用142067.421261.72018.723785.16308.5保险40000.000.000.000.000.00一切财产险40000.00公众责任险机损险财务费用78137.08603.941110.302081.813469.68费用合计6532885.60经营净收益(ebitda

6、)7673856405月6月7月8月9月10月11月878850.001004400.001255500.001506600 001757700.002008800.002134350.0035%4350%60%70M80M89*878850.001004400.001255500.001506600.001757700.002008800.002134350.004340.004960.006200.007440.008680.009920.0010540.00883190.001009360 001261700.001514040001766380002018720002144800.00

7、44159.5050468.0063085.0075702.0088319.00100936.00107244.50174000.00174000.00174000.00174000.00174000.00174000.00174000.0015000.0015000.0015000.0015000.0015000.0015000.0015000.0048000.0048000.0048000.0048000.0048000.0048000.0048000.0032000.0032000.0032000.0032000.0032000.0032000.0032000.0045000.00450

8、00.0045000.0045000.0045000.0045000.0045000.0018000.0018000.0018000.0018000.0018000.0018000.0018000.0016000.0016000.0016000.0016000.0016000.0016000.0016000.0030400.0030400.0037900.0037900.0037000.0037000.0037900.00124001240012400124001240012400124001500015000225002250022500225002250030003000300030003

9、0003000300052290.0055080.0060660.0060660.0060660.0060660.0060660.0030000.0030000.0030000.0030000.0030000.0030000.0030000.001260.001260.001260.001260.001260.001260.001260.0019530.0022320.0027900.0027900.0027000.0027900.0027900.001500.001500.001500.001500.001500.001500.001500.0010000.0010000.0010000.0

10、010000.0010000.0010000.0010000.0010000.0010000.0010000.0010000.0010000.0010000.0010000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.008831.010093.612

11、61715140.417663.820187.221448.90.000.000.000.000.000.000.004857.555551.486030.358327.229715.0911102.0611796.90I1112月收入依据2259900.0000%预估爬坡期12个月2259900.0011160.002271060 00113553.00174000.0015000.00配置1名店长48000.00配置6名管家32000.00首年配置4名销售45000.00按照1:60配比保洁.共计10名保洁（6名公区保洁.4名客房保洁）18000.00大堂及夜间楼层保安.共计3名保安16000.00配置2名维修,24小时值守37900.0012400按照20元/间/月计算22500前半年按照20桶垃圾计宜，后半年按照30桶计篁3000每月按照3000元预估60660.0030000.00考虑公共区位能耗.按照1000平米.每天平均能耗1000度计篁.商业用电成本1260.00考虑公共区位能耗.每天能耗用水10吨27900.00按照出租率翻倍考虑宽带开通数量1500.00按照3部电话.每月500元预估10000.00按照2000元/间，预估首年营销费用按照300元/间强估网络平台