Loading
You are looking as the firm — the desk at Marisol Patrimonio, where deals are worked.
28 serviced apartments in Lavapiés, a corner building that was a pension until 2019 and is empty now. Why it is available: the operator went under in 2020 and the owner, a bank, has held it on the books since (The seller needs out). What we do: fit out as studios and one-beds with a desk and a laundry, run by the night and by the month, sell in year five to a hotel group. What has to be true: · Madrid's centre keeps issuing aparthotel licences for buildings that already held a hospitality use. · Studios hold 128 EUR at 72 % across the year. · The corner local lets as a café at 4.200 EUR.
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 |
|---|---|---|---|---|---|
| Studio · serviced | STR | 34 | 128 € | 25 € | — |
| 1-bed · serviced | STR | 52 | 158 € | 30 € | — |
| 2-bed · serviced | STR | 70 | 196 € | 35 € | — |
| Corner local | Local | 110 | — | — | 4.200 € |
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 | Total |
|---|---|---|---|---|---|---|
| Occupancy | 76 % | 79 % | 82 % | 82 % | 82 % | 82 % |
| Blended ADR incl. IVA | 136 | 144 | 146 | 149 | 152 | — |
| Blended ADR ex-IVA | 124 | 131 | 133 | 136 | 139 | — |
| Accommodation | 963k | 1054k | 1116k | 1138k | 1161k | 5431k |
| Cleaning fees | 68k | 71k | 74k | 74k | 74k | 360k |
| Ancillary income | 50k | 50k | 51k | 52k | 53k | 258k |
| Total operating revenue | 1082k | 1175k | 1241k | 1264k | 1288k | 6049k |
| Platform commission | -175k | -191k | -202k | -206k | -210k | -984k |
| Cleaning | -55k | -59k | -62k | -63k | -65k | -304k |
| Linen | -14k | -14k | -15k | -16k | -16k | -75k |
| Amenities | -8k | -9k | -9k | -9k | -10k | -45k |
| Departmental expenses | -252k | -273k | -289k | -294k | -300k | -1408k |
| Admin / accounting | -2k | -2k | -2k | -3k | -3k | -12k |
| Utilities + community | -46k | -47k | -48k | -49k | -50k | -240k |
| Maintenance | -13k | -14k | -15k | -15k | -15k | -73k |
| IT / tech | -13k | -14k | -14k | -14k | -15k | -70k |
| Building manager | -15k | -15k | -16k | -16k | -16k | -78k |
| Extended appliance warranty | -1k | -1k | -1k | -1k | -1k | -7k |
| Undistributed expenses | -91k | -94k | -96k | -98k | -100k | -480k |
| GOP | 738k | 808k | 856k | 872k | 888k | 4162k |
| GOP margin | 68 % | 69 % | 69 % | 69 % | 69 % | 69 % |
| Management fee — 15,5 % of total operating revenue | -168k | -182k | -192k | -196k | -200k | -938k |
| Management fees | -168k | -182k | -192k | -196k | -200k | -938k |
| Income before non-operating | 570k | 626k | 663k | 676k | 688k | 3224k |
| Property tax (IBI) | -14k | -15k | -15k | -15k | -16k | -75k |
| Insurance | -5k | -5k | -5k | -5k | -5k | -26k |
| Non-operating | -20k | -20k | -20k | -21k | -21k | -102k |
| EBITDA | 551k | 606k | 643k | 655k | 667k | 3122k |
| FF&E reserve | -27k | -29k | -31k | -32k | -32k | -151k |
| NOI | 524k | 577k | 612k | 623k | 635k | 2971k |
| NOI margin | 48 % | 49 % | 49 % | 49 % | 49 % | 49 % |
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 € | — | — | — | 7.648.131 € | 6.118.505 € | 10,06 % | 1,53× |
| 50% LTV | 50 % | 3.863.087 € | 2,75 % | 314.589 € | 1,95 | 3.950.380 € | 3.160.304 € | 13,99 % | 1,82× |
| 60% LTV | 60 % | 4.635.704 € | 2,75 % | 377.507 € | 1,62 | 3.193.601 € | 2.554.881 € | 15,63 % | 1,96× |
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 | Total |
|---|---|---|---|---|---|---|
| NOI | 524k | 577k | 612k | 623k | 635k | 2971k |
| Loan interest | -104k | -98k | -92k | -85k | -79k | -458k |
| Principal repaid | -211k | -217k | -223k | -229k | -236k | -1115k |
| Cash after debt service | 209k | 262k | 297k | 309k | 320k | 1398k |
| DSCR | 1,67 | 1,83 | 1,95 | 1,98 | 2,02 | — |
| Cumulative cash | 209k | 472k | 769k | 1078k | 1398k | — |
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 | 209k | 209k | 0k | 0k | 167k | 42k | 5,3 % |
| Y2 | 262k | 262k | 0k | 0k | 210k | 52k | 6,6 % |
| Y3 | 297k | 297k | 0k | 0k | 238k | 59k | 7,5 % |
| Y4 | 309k | 309k | 0k | 0k | 247k | 62k | 7,8 % |
| Y5 | 320k | 320k | 0k | 0k | 256k | 64k | 8,1 % |
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% |
|---|---|---|---|---|---|
| 129 € | 6,2 % | 8,1 % | 9,8 % | 11,3 % | 12,7 % |
| 136 € | 8,8 % | 10,5 % | 12,1 % | 13,4 % | 14,7 % |
| 144 € | 11,0 % | 12,6 % | 14,0 % | 15,3 % | 16,6 % |
| 151 € | 13,0 % | 14,4 % | 15,8 % | 17,2 % | 18,5 % |
| 158 € | 14,7 % | 16,2 % | 17,6 % | 19,0 % | 20,3 % |
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 1-4 | Year 2-3 | Year 3-2 | Year 5 |
|---|---|---|---|---|
| 6.00% | 24,7 % | 24,2 % | 21,8 % | 17,4 % |
| 6.50% | 12,2 % | 18,4 % | 18,2 % | 15,6 % |
| 7.00% | -1,5 % | 13,2 % | 15,0 % | 14,0 % |
| 7.50% | -13,9 % | 7,8 % | 12,1 % | 12,5 % |
| 8.00% | -24,7 % | 2,0 % | 8,9 % | 10,9 % |
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.