A 32-room hotel in Santa Catalina, a block from the market, run as a three-star since 1998. Why it is available: the owner is seventy-four and his children run restaurants, not hotels (The seller needs out). What we do: a full refurbishment over the winter, reopen as a four-star boutique for the market's trade, hold five years. What has to be true: · 210 EUR ADR at 70 % — Palma's boutique set runs from 190 to 260. · The winter closure fits between October and April. · The Balearic moratorium leaves an existing licence untouched, which it does.
Assumptions template MASTER v2. Figures are projections rather than forecasts or guarantees, and follow from the assumptions set out in this document. Prepared for discussion among Marisol and its investors; not an offer or a solicitation.
Nightly rates and cleaning fees include IVA; the model deducts it.
| Line | Type | Net m² | ADR | Cleaning | Monthly rent |
|---|---|---|---|---|---|
| Double room | STR | 26 | 210 € | — | — |
| Suite | STR | 44 | 320 € | — | — |
What it costs to own the building, ready to trade.
The GP's structuring fee (1 %) sits in every cost base; its financing fee (1 %) only where the deal is financed, so an all-equity structure carries the first and not the second.
Capitalised at the exit-year NOI.
Total operating revenue, GOP and NOI. The dashed line is occupancy, on its own scale.
Figures in € thousands; margins on total operating revenue. Stabilised from operating year 3. USALI order: revenue, departmental and undistributed expenses, GOP before any management fee, the fees, the owner's charges, EBITDA, the reserve, NOI.
| Line | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Total |
|---|---|---|---|---|---|---|---|---|
| Occupancy | 76 % | 79 % | 82 % | 82 % | 82 % | 82 % | 82 % | 82 % |
| Blended ADR incl. IVA | 226 | 238 | 242 | 247 | 252 | 257 | 262 | — |
| Blended ADR ex-IVA | 205 | 216 | 220 | 225 | 229 | 234 | 238 | — |
| Accommodation | 1821k | 1992k | 2109k | 2151k | 2194k | 2238k | 2283k | 14790k |
| Total operating revenue | 1821k | 1992k | 2109k | 2151k | 2194k | 2238k | 2283k | 14790k |
| Platform commission | -310k | -339k | -359k | -366k | -373k | -381k | -388k | -2514k |
| Cleaning | -42k | -45k | -48k | -49k | -50k | -51k | -52k | -335k |
| Linen | -18k | -19k | -20k | -21k | -21k | -22k | -22k | -144k |
| Amenities | -12k | -13k | -14k | -14k | -14k | -14k | -15k | -96k |
| Departmental expenses | -382k | -416k | -440k | -449k | -458k | -467k | -477k | -3089k |
| Admin / accounting | -2k | -2k | -2k | -3k | -3k | -3k | -3k | -18k |
| Utilities + community | -53k | -54k | -55k | -56k | -57k | -58k | -59k | -391k |
| Maintenance | -22k | -24k | -25k | -26k | -26k | -27k | -27k | -177k |
| IT / tech | -15k | -16k | -16k | -16k | -17k | -17k | -17k | -114k |
| Building manager | -15k | -15k | -16k | -16k | -16k | -17k | -17k | -112k |
| Extended appliance warranty | -2k | -2k | -2k | -2k | -2k | -2k | -2k | -11k |
| Undistributed expenses | -109k | -113k | -116k | -118k | -120k | -123k | -125k | -824k |
| GOP | 1330k | 1464k | 1553k | 1584k | 1616k | 1648k | 1681k | 10877k |
| GOP margin | 73 % | 73 % | 74 % | 74 % | 74 % | 74 % | 74 % | 74 % |
| Management fee — 15,5 % of total operating revenue | -282k | -309k | -327k | -333k | -340k | -347k | -354k | -2292k |
| Management fees | -282k | -309k | -327k | -333k | -340k | -347k | -354k | -2292k |
| Income before non-operating | 1048k | 1155k | 1226k | 1251k | 1276k | 1301k | 1327k | 8585k |
| Property tax (IBI) | -17k | -17k | -18k | -18k | -18k | -19k | -19k | -126k |
| Insurance | -6k | -6k | -6k | -6k | -6k | -6k | -6k | -43k |
| Non-operating | -23k | -23k | -24k | -24k | -25k | -25k | -26k | -169k |
| EBITDA | 1025k | 1132k | 1203k | 1227k | 1251k | 1276k | 1302k | 8415k |
| FF&E reserve | -46k | -50k | -53k | -54k | -55k | -56k | -57k | -370k |
| NOI | 979k | 1082k | 1150k | 1173k | 1196k | 1220k | 1245k | 8046k |
| NOI margin | 54 % | 54 % | 55 % | 55 % | 55 % | 55 % | 55 % | 55 % |
The highlighted row is the basis Marisol quotes.
| Scenario | LTV | Senior debt | All-in rate | Debt service | DSCR | Total equity | LP equity | LP IRR | LP × |
|---|---|---|---|---|---|---|---|---|---|
| No debt | 0 % | 0 € | — | — | — | 10.882.576 € | 8.706.061 € | 14,50 % | 2,19× |
| 50% LTV | 50 % | 5.496.811 € | 2,75 % | 447.631 € | 2,57 | 5.618.696 € | 4.494.957 € | 20,40 % | 2,98× |
| 60% LTV | 60 % | 6.596.173 € | 2,75 % | 537.157 € | 2,14 | 4.541.871 € | 3.633.496 € | 22,85 % | 3,37× |
On the 50% LTV basis. What the lender is owed before anything reaches equity. Coverage is year by year, so it opens below the stabilised figure above and climbs as the building fills. Figures in € thousands.
| Line | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Total |
|---|---|---|---|---|---|---|---|---|
| NOI | 979k | 1082k | 1150k | 1173k | 1196k | 1220k | 1245k | 8046k |
| Loan interest | -147k | -139k | -130k | -122k | -113k | -103k | -94k | -848k |
| Principal repaid | -300k | -309k | -317k | -326k | -335k | -344k | -354k | -2286k |
| Cash after debt service | 532k | 634k | 702k | 725k | 749k | 773k | 797k | 4912k |
| DSCR | 2,19 | 2,42 | 2,57 | 2,62 | 2,67 | 2,73 | 2,78 | — |
| Cumulative cash | 532k | 1166k | 1868k | 2594k | 3342k | 4115k | 4912k | — |
At 50 % LTV. The distributable column is the cash line from the page before. Figures in € thousands, except yield.
| Year | Distributable | Tier A | Tier B | Tier C | LP | GP | LP yield |
|---|---|---|---|---|---|---|---|
| Y1 | 532k | 532k | 0k | 0k | 425k | 106k | 9,5 % |
| Y2 | 634k | 634k | 0k | 0k | 508k | 127k | 11,3 % |
| Y3 | 702k | 702k | 0k | 0k | 562k | 140k | 12,5 % |
| Y4 | 725k | 725k | 0k | 0k | 580k | 145k | 12,9 % |
| Y5 | 749k | 749k | 0k | 0k | 599k | 150k | 13,3 % |
| Y6 | 773k | 773k | 0k | 0k | 618k | 155k | 13,8 % |
| Y7 | 797k | 797k | 0k | 0k | 638k | 159k | 14,2 % |
Capital out, cash back, and the running position. The dashed line is where the LP is whole.
LP IRR at the reporting basis, on the two levers that stay open after the price is agreed. The outlined cell is the base case.
| ADR | 76% | 79% | 82% | 85% | 88% |
|---|---|---|---|---|---|
| 214 € | 14,9 % | 16,1 % | 17,2 % | 18,3 % | 19,3 % |
| 226 € | 16,5 % | 17,7 % | 18,8 % | 19,9 % | 21,0 % |
| 238 € | 18,1 % | 19,2 % | 20,4 % | 21,5 % | 22,6 % |
| 249 € | 19,6 % | 20,8 % | 21,9 % | 23,1 % | 24,2 % |
| 261 € | 21,0 % | 22,2 % | 23,4 % | 24,6 % | 25,7 % |
LP IRR again. A shorter hold raises the rate and lowers the money: the equity multiple beside it falls as this table rises.
| Exit cap rate | Year 2-5 | Year 3-4 | Year 4-3 | Year 5-2 | Year 7 |
|---|---|---|---|---|---|
| 6.00% | 48,7 % | 37,5 % | 30,8 % | 26,9 % | 22,6 % |
| 6.50% | 42,2 % | 33,8 % | 28,3 % | 25,0 % | 21,4 % |
| 7.00% | 36,4 % | 30,4 % | 26,0 % | 23,4 % | 20,4 % |
| 7.50% | 31,2 % | 27,3 % | 23,9 % | 21,8 % | 19,4 % |
| 8.00% | 26,5 % | 24,4 % | 21,9 % | 20,4 % | 18,6 % |
Prepared 20 September 2026 from the current business plan against assumptions template MASTER v2. Every figure in this document is computed from the assumptions printed in the appendix; none is entered by hand.
Projections are not forecasts or guarantees. Returns depend on assumptions that will not all prove correct, and property investment carries the risk of loss including of capital. Prepared for discussion among Marisol and its investors; not an offer, a solicitation, or investment advice.
© 2026 Marisol. All rights reserved.
marks a value set for this deal. Everything else is inherited from the house template, so a change to firm policy carries through.
You are looking as an investor — a prospect the firm admitted, seeing only what was sent to them.