长租公寓测算表【经营测算1年、10年含公式和示例】.xlsx
- 文档编号:30866040
- 上传时间:2024-07-03
- 格式:XLSX
- 页数:9
- 大小:28.88KB
长租公寓测算表【经营测算1年、10年含公式和示例】.xlsx
《长租公寓测算表【经营测算1年、10年含公式和示例】.xlsx》由会员分享,可在线阅读,更多相关《长租公寓测算表【经营测算1年、10年含公式和示例】.xlsx(9页珍藏版)》请在冰豆网上搜索。
月租金4050房间数620收入单价年度合计1月2月3月4月公寓租金收入14136930.00125550.00200880.00376650.00627750.00出租率0.005%8%15%25%营收0.00125550.00200880.00376650.00627750.00增值收入69812.00620.00992.001860.003100.00收入合计14206742.00126170.00201872.00378510.00630850.000.00费用0.00基本管理费(收入*5%)710337.106308.5010093.6018925.5031542.50公寓直接经营费5822548.50人员费用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.0018000.00工程维修费用8000.00192000.0016000.0016000.0016000.0016000.00环境卫生费409800.0030400.0030400.0030400.0030400.00日常消杀费用20.00148800.0012400124001240012400垃圾清理费750.00225000.0015000150001500015000清洁耗材36000.003000300030003000公共事业费631944.0035550.0037224.0041130.0046710.00电费1.00360000.0030000.0030000.0030000.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.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绿化养护0.000.000.000.00房屋维修费用310000.00其他不可预见费用142067.421261.72018.723785.16308.5保险40000.000.000.000.000.00一切财产险40000.00公众责任险机损险财务费用78137.08693.941110.302081.813469.68费用合计6532885.60经营净收益(ebitda)7673856.405月6月7月8月9月10月11月878850.001004400.001255500.001506600.001757700.002008800.002134350.0035%40%50%60%70%80%85%878850.001004400.001255500.001506600.001757700.002008800.002134350.004340.004960.006200.007440.008680.009920.0010540.00883190.001009360.001261700.001514040.001766380.002018720.002144890.0044159.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.0045000.0045000.0045000.0045000.0045000.0045000.0018000.0018000.0018000.0018000.0018000.0018000.0018000.0016000.0016000.0016000.0016000.0016000.0016000.0016000.0030400.0030400.0037900.0037900.0037900.0037900.0037900.001240012400124001240012400124001240015000150002250022500225002250022500300030003000300030003000300052290.0055080.0060660.0060660.0060660.0060660.0060660.0030000.0030000.0030000.0030000.0030000.0030000.0030000.001260.001260.001260.001260.001260.001260.001260.0019530.0022320.0027900.0027900.0027900.0027900.0027900.001500.001500.001500.001500.001500.001500.001500.0010000.0010000.0010000.0010000.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.910093.61261715140.417663.820187.221448.90.000.000.000.000.000.000.004857.555551.486939.358327.229715.0911102.9611796.9012月收入依据2259900.0090%预估爬坡期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元/间预估网络平台费用,平均出租周期6个月10000.00月度组织客群活动,预计10000元/月按照年出租数30%为渠道出房预估0.000.00考虑大物业管理,无此费用0.00考虑大物业管理,无此费用0.00考虑大物业管理,无此费用0.00考虑大物业管理,无此费用0.00考虑大物业管理,无此费用0.00考虑大物业管理,无此费用按照500元/间预估年维修费用22710.6按照收入的1%预估0.00按照房间数预估40000元/年12490.83收款手续费月租金4050房间数620收入单价年度合计1月2月3月4月公寓租金收入27118800.002259900.002259900.002259900.002259900.00出租率0.0090%90%90%90%营收0.002259900.002259900.002259900.002259900.00增值收入133920.0011160.0011160.0011160.0011160.00收入合计27252720.002271060.002271060.002271060.002271060.000.00费用0.00基本管理费(收入*5%)1362636.00113553.00113553.00113553.00113553.00公寓直接经营费4619374.40人员费用1704000.00174000.00174000.00174000.00174000.00店长15000.00180000.0015000.0015000.0015000.0015000.00运营管家8000.00576000.0048000.0048000.0048000.0048000.00保洁人员费用4500.00540000.0045000.0045000.0045000.0045000.00保安人员费用6000.00216000.0018000.0018000.0018000.0018000.00工程维修费用8000.00192000.0016000.0016000.0016000.0016000.00环境卫生费409800.0030400.0030400.0030400.0030400.00日常消杀费用20.00148800.0012400124001240012400垃圾清理费750.00225000.0015000150001500015000清洁耗材36000.003000300030003000公共事业费727920.0035550.0037224.0041130.0046710.00电费1.00360000.0030000.0030000.0030000.0030000.00水费4.2015120.001260.001260.001260.001260.00网络通信45.00334800.0027900.0027900.0027900.0027900.00电话通讯费500.0018000.001500.001500.001500.001500.00市场费用882600.0010000.0010000.0010000.0010000.00网络端口372000.00客户活动120000.0010000.0010000.0010000.0010000.00租赁佣金390600.00设备维护582527.200.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绿化养护0.000.000.000.00房屋维修费用310000.00其他不可预见费用272527.2022710.622710.622710.622710.6保险40000.000.000.000.000.00一切财产险40000.00公众责任险机损险财务费用149889.9612490.8312490.8312490.8312490.83费用合计5982010.40经营净收益(ebitda)21270709.605月6月7月8月9月10月11月2259900.002259900.002259900.002259900.002259900.002259900.002259900.0090%90%90%90%90%90%90%2259900.002259900.002259900.002259900.002259900.002259900.002259900.0011160.0011160.0011160.0011160.0011160.0011160.0011160.002271060.002271060.002271060.002271060.002271060.002271060.002271060.00113553.00113553.00113553.00113553.00113553.00113553.00113553.00174000.00174000.00174000.00174000.00174000.00174000.00174000.0015000.0015000.0015000.0015000.0015000.0015000.0015000.0048000.0048000.0048000.0048000.0048000.0048000.0048000.0045000.0045000.0045000.0045000.0045000.0045000.0045000.0018000.0018000.0018000.0018000.0018000.0018000.0018000.0016000.0016000.0016000.0016000.0016000.0016000.0016000.0030400.0030400.0037900.0037900.0037900.0037900.0037900.001240012400124001240012400124001240015000150002250022500225002250022500300030003000300030003000300052290.0055080.0060660.0060660.0060660.0060660.0060660.0030000.0030000.0030000.0030000.0030000.0030000.0030000.001260.001260.001260.001260.001260.001260.001260.0027900.0027900.0027900.0027900.0027900.0027900.0027900.001500.001500.001500.001500.001500.001500.001500.0010000.0010000.0010000.0010000.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.0022710.622710.622710.622710.622710.622710.622710.60.000.000.000.000.000.000.0012490.8312490.8312490.8312490.8312490.8312490.8312490.8312月收入依据2259900.0090%2259900.0011160.002271060.00113553.00174000.0015000.00配置1名店长48000.00配置6名管家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按照300元/间预估网络平台费用,平均出租周期6个月10000.00月度组织客群活动,预计10000元/月按照年出租数30%为渠道出房预估0.000.00考虑大物业管理,无此费用0.00考虑大物业管理,无此费用0.00考虑大物业管理,无此费用0.00考虑大物业管理,无此费用0.00考虑大物业管理,无此费用0.00考虑大物业管理,无此费用按照500元/间预估年维修费用22710.6按照收入的1%预估0.00按照房间数预估40000元/年12490.83收款手续费年份第一年第二年第三年第四年年度涨幅0%0%2%2%1公寓租金14,136,930.0027,252,720.0027,797,774.4028,353,729.892广告及其他69,812.00133,920.00133,920.00133,920.003总收入14,206,742.0027,386,640.0027,931,694.4028,487,649.894委托管理费710,337.101,362,636.001,362,636.001,362,636.005公寓直接经营费3,129,744.002,841,720.002,841,720.002,841,720.006市场费用882,600.00882,600.00882,600.00882,600.007设备维护452,067.42582,527.20582,527.20582,527.208保险40,000.0040,000.0040,000.0040,000.009开办费(含开业营销、样板房软装)1,240,000.00-10经营财务费用(手续费、POS机)78,137.08150,626.52153,624.32156,682.0711总支出6,532,885.605,860,109.725,863,107.525,866,165.2712实际运营EBITDA7,673,856.4021,526,530.2822,068,586.8822,621,484.61第五年第六年第七年第八年第九年第十年2%2%2%2%2%2%28,920,804.4929,499,220.5830,089,204.9930,690,989.0931,304,808.8731,930,905.05133,920.00133,920.00133,920.00133,920.00133,920.00133,920.0029,054,724.4929,633,140.5830,223,124.9930,824,909.0931,438,728.8732,064,825.051,362,636.001,362,636.001,362,636.001,362,636.001,362,636.001,362,636.002,841,720.002,841,720.002,841,720.002,841,720.002,841,720.002,841,720.00882,600.00882,600.00882,600.00882,600.00882,600.00882,600.00582,527.20582,527.20582,527.20582,527.20582,527.20582,527.2040,000.0040,000.0040,000.0040,000.0040,000.0040,000.00-159,800.98162,982.27166,227.19169,537.00172,913.01176,356.545,869,284.185,872,465.475,875,710.395,879,020.205,882,396.215,885,839.7423,185,440.3023,760,675.1024,347,414.6024,945,888.8925,556,332.6626,178,985.31合计279,977,087.341,275,092.00281,252,179.3412,974,061.1028,705,224.008,826,000.005,694,812.22400,000.001,240,000.001,546,886.9959,386,984.31221,865,195.03
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 经营测算1年、10年含公式和示例 公寓 测算 经营 10 公式 示例