| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||
2 | Key Facts & Assumptions | ||||||||
3 | Location | Model | Business | ||||||
4 | Type of Property | Partner | Investment | 2500000 | Depreciation | ||||
5 | No. of Rooms | 12 | Rental | 4100000 | |||||
6 | No. of Beds | 21 | Return | 1600000 | |||||
7 | Property Investment | 2,500,000 | 320000 | ||||||
8 | Annual occcupancy Growth % | 7% | |||||||
9 | Annual ADR Growth % | 7% | |||||||
10 | Revenue share % | 4.5% | |||||||
11 | |||||||||
12 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total | |||
13 | Avg. Occupancy | 85% | 91% | 90% | 90% | 90% | 89% | ||
14 | ADR | 2350 | 2515 | 2691 | 2879 | 3080 | 2703 | ||
15 | |||||||||
16 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total | |||
17 | |||||||||
18 | Bed Revenue (A) | 15,310,838 | 17,529,378 | 18,560,518 | 19,859,754 | 21,249,937 | 92,510,424 | ||
19 | |||||||||
20 | Revenue Share (B) | 688,988 | 788,822 | 835,223 | 893,689 | 956,247 | 4,162,969 | ||
21 | |||||||||
22 | IRR (C) | ||||||||
23 | -2,500,000 | 688,988 | 788,822 | 835,223 | 893,689 | 956,247 | 19% | ||
24 | |||||||||
25 | |||||||||
26 | |||||||||
27 |