Serviced Accommodation Valuation Model
Direct replication of the financial matrix with live formulas & interactive edits
YOUR AIRBNB CONSULTANT
Serviced Accommodation Analysis
Monthly Expenses
| Rent / Mortgage | £ |
| Council Tax / business rates | £ |
| Broadband | £ |
| Maintenance | £ |
| Water Rates | £ |
| Electric & Gas | £ |
| Insurance | £ |
| TV License / Cable Subscription | £ |
| Miscellaneous | £ |
| Total Bills Per Month | £ 2,965.00 |
| total Bills Per Annum | £ 35,580.00 |
| Housekeeping | |
| Linen |
| Scenarios | Worst Case | Best Case | Blended |
|---|---|---|---|
| Price per night | £ | £ | £ 212.50 |
| Max Nights per year | 365 | 365 | 365 |
| Total Annual income at 100% occupancy | £ 63,875.00 | £ 91,250.00 | £ 77,562.50 |
| Management Fee (%) | % | ||
Upfront Costs
| Deposit | |
| Rent/Mortgage | |
| Furniture | |
| Photographer | |
| Staging costs | |
| Sourcing fee | |
| Additional Charges | |
| Other | |
| Total | 11,950 |
ROI (%)
| 50% | -31.63% |
| 75% | 101.43% |
| 90% | 181.26% |
| 100% | 234.49% |
Full Occupancy & Cashflow Breakdown
18.00% OTA Fee · £212.50 blended price| Occupancy Rate | Nights BK'd Per Month | Annual Income | Monthly Income | 18.00% OTA Fee | Rent/Mort | Fixed Bills | House-keeping | Management | Monthly Cashflow | Yearly Cash low |
|---|---|---|---|---|---|---|---|---|---|---|
| 20% | 6 | £15,512.50 | £1,292.71 | £232.69 | £2,500.00 | £465.00 | £0.00 | £0.00 | -£1,904.98 | -£22,859.75 |
| 25% | 8 | £19,390.63 | £1,615.89 | £290.86 | £2,500.00 | £465.00 | £0.00 | £0.00 | -£1,639.97 | -£19,679.69 |
| 30% | 9 | £23,268.75 | £1,939.06 | £349.03 | £2,500.00 | £465.00 | £0.00 | £0.00 | -£1,374.97 | -£16,499.63 |
| 35% | 11 | £27,146.88 | £2,262.24 | £407.20 | £2,500.00 | £465.00 | £0.00 | £0.00 | -£1,109.96 | -£13,319.56 |
| 40% | 12 | £31,025.00 | £2,585.42 | £465.37 | £2,500.00 | £465.00 | £0.00 | £0.00 | -£844.96 | -£10,139.50 |
| 45% | 14 | £34,903.13 | £2,908.59 | £523.55 | £2,500.00 | £465.00 | £0.00 | £0.00 | -£579.95 | -£6,959.44 |
| Minimum Break Even Occupancy | ||||||||||
| 50% | 15 | £38,781.25 | £3,231.77 | £581.72 | £2,500.00 | £465.00 | £0.00 | £0.00 | -£314.95 | -£3,779.37 |
| 55% | 17 | £42,659.38 | £3,554.95 | £639.89 | £2,500.00 | £465.00 | £0.00 | £0.00 | -£49.94 | -£599.31 |
| 60% | 18 | £46,537.50 | £3,878.13 | £698.06 | £2,500.00 | £465.00 | £0.00 | £0.00 | £215.06 | £2,580.75 |
| 65% | 20 | £50,415.63 | £4,201.30 | £756.23 | £2,500.00 | £465.00 | £0.00 | £0.00 | £480.07 | £5,760.81 |
| 70% | 21 | £54,293.75 | £4,524.48 | £814.41 | £2,500.00 | £465.00 | £0.00 | £0.00 | £745.07 | £8,940.88 |
| Targeted Occupancy Rate | ||||||||||
| 75% | 23 | £58,171.88 | £4,847.66 | £872.58 | £2,500.00 | £465.00 | £0.00 | £0.00 | £1,010.08 | £12,120.94 |
| 80% | 24 | £62,050.00 | £5,170.83 | £930.75 | £2,500.00 | £465.00 | £0.00 | £0.00 | £1,275.08 | £15,301.00 |
| 85% | 26 | £65,928.13 | £5,494.01 | £988.92 | £2,500.00 | £465.00 | £0.00 | £0.00 | £1,540.09 | £18,481.06 |
| Dream Occupancy Rate | ||||||||||
| 90% | 27 | £69,806.25 | £5,817.19 | £1,047.09 | £2,500.00 | £465.00 | £0.00 | £0.00 | £1,805.09 | £21,661.13 |
| 95% | 29 | £73,684.38 | £6,140.36 | £1,105.27 | £2,500.00 | £465.00 | £0.00 | £0.00 | £2,070.10 | £24,841.19 |
| 100% | 30 | £77,562.50 | £6,463.54 | £1,163.44 | £2,500.00 | £465.00 | £0.00 | £0.00 | £2,335.10 | £28,021.25 |