BNBCalc Short Term Rental Rental Arbitrage Analysis C. Casimiro Mahou Bierhans, Madrid, MD, 28005

2 bed • 2 bath • 4 guests • €0

BNB

Calc

Annual Revenue

€28,789

Profit (Cash Flow)

-€4,904

Cash on Cash Return

-82.9%

Annual Revenue

€28,789

AirDNA projects €129/night at 82% occupancy ($38,638). Airbtics projects €95/night at 83% occupancy ($28,789). Airbtics predicts this property will perform in the 47% revenue percentile

BNB Calc projects a 83% occupancy rate, €95 rate per night.

Revenue Percentile (property's earnings compare to others in the market}

Percentiles	25%	50%	75%	90%
Revenue	€22,095	€28,903	€34,753	€49,498
Occupancy	75%	85%	93%	97%
Nightly Rate	€79	€90	€98	€133

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
Wall & Whale	€30,545	€84	92%	2	1	1	€30	❌	❌	❌	Y / Y	⭐️ 4.4 (168)
Stylish 2-bedroom apartment just by the CENTER	€32,078	€96	90%	2	1	90	€29	❌	❌	❌	Y / Y	⭐️ 4.7 (114)
ROOF TOP 2 ROOM APT. WITH VIEWS	€35,384	€100	96%	2	1	5	€29	❌	❌	✅	Y / Y	⭐️ 4.9 (167)
Tulem La Latina 4 Duplex (2 dorm - 1 baño)	€27,107	€118	58%	2	1	2	€77	❌	❌	❌	Y / Y	⭐️ 4.7 (26)
Palacio Real Madrid Centro, consultar	€38,586	€133	74%	2	1	2	€53	❌	❌	✅	N / Y	⭐️ 4.7 (382)
La Latina para 3 invitados junto a La Paloma	€21,852	€61	98%	2	1	4	€0	❌	❌	❌	Y / Y	⭐️ 4.5 (184)
La Latina. Amplio apartamente 5 pax	€29,753	€85	93%	2	1	1	€48	❌	❌	❌	N / N	⭐️ 4.7 (50)
Acogedor piso en Madrid de dos habitaciones	€26,477	€85	85%	2	1	1	€0	❌	❌	❌	Y / Y	⭐️ 4.5 (157)
La Paloma - Puerta de Toledo	€34,266	€111	82%	2	1	3	€47	❌	❌	❌	N / Y	⭐️ 4.8 (38)
Apartamento acogedor en Madrid	€20,796	€63	86%	2	1	2	€34	❌	❌	❌	Y / Y	⭐️ 4.9 (69)
Charming Puerta de Toledo - Comfort in the Center	€37,055	€103	96%	2	1	1	€74	❌	❌	❌	Y / Y	⭐️ 4.6 (40)
Incredible renovated designer apartment 6ºi-D	€29,425	€90	84%	2	1	1	€63	❌	❌	✅	N / Y	⭐️ 3.6 (16)
Precioso y acogedor apartamento en Madrid	€38,613	€115	92%	2	1	1	€0	❌	❌	❌	Y / Y	⭐️ 5 (172)
APARTAMENTO MADRID CENTRO LAVAPIES 2	€31,170	€88	97%	2	1	1	€0	❌	❌	❌	Y / Y	⭐️ 4.6 (793)
Coqueto Apartamento a 10"andando del centro Madrid	€21,638	€78	75%	2	1	3	€24	❌	❌	❌	Y / Y	⭐️ 4.8 (58)
Bright and centric. Visit Madrid waking. Wifi	€25,479	€73	93%	2	1	2	€39	❌	❌	❌	Y / Y	⭐️ 4.6 (433)
Newly renovated apartment in Madrid Rio!	€18,072	€80	60%	2	1	2	€43	❌	❌	❌	Y / Y	⭐️ 4.9 (98)
Moderno apartamento a 25 minutos de Gran Vía	€22,794	€79	75%	2	1	2	€57	❌	❌	❌	Y / Y	⭐️ 4.8 (59)
Acogedor piso centro de Madrid	€15,988	€56	76%	2	1	2	€24	❌	❌	❌	Y / N	⭐️ 4.6 (62)
Apartamento 2 hab, fácil aparcamiento y A.C.	€17,810	€72	65%	2	1	2	€38	❌	❌	✅	Y / Y	⭐️ 4.8 (243)
Flat next to Madrid Río	€27,843	€90	77%	2	1	3	€97	❌	❌	❌	Y / Y	⭐️ 4.5 (148)
2roomflat+located+wifi+smartTV	€23,275	€70	91%	2	1	1	€0	❌	❌	❌	Y / Y	⭐️ 4.4 (642)
La Latina, apartamento moderno, 2 hab, wifi, a/c	€23,512	€82	77%	2	1	2	€43	❌	❌	❌	Y / N	⭐️ 4.1 (47)
apartamento a estrenar	€26,323	€72	99%	2	1	2	€29	❌	❌	✅	Y / Y	⭐️ 4.8 (98)
Apartamento en Madrid 4 a 6 personas	€42,011	€140	81%	2	1	2	€30	❌	❌	❌	Y / Y	⭐️ 5 (40)
Apartamento Segovia 'Palacio Real'	€33,532	€93	97%	2	1	2	€20	❌	❌	❌	Y / Y	⭐️ 4.5 (88)
Precioso apartamento cerca del Palacio Real	€30,966	€87	96%	2	1	2	€20	❌	❌	❌	Y / Y	⭐️ 4.5 (174)
Apartamento en Madrid Rio con Parking Gratuito	€42,734	€210	55%	2	1	2	€51	❌	❌	✅	Y / N	⭐️ 4.7 (21)
Ático Celestial en Barrio La Latina	€51,405	€157	88%	2	1	3	€97	❌	❌	❌	Y / Y	⭐️ 5 (190)
Historic Center: Palacio- Rastro- Latina, A/C	€24,587	€91	73%	2	1	3	€24	❌	❌	❌	Y / Y	⭐️ 4.3 (54)
Design and amazing apartment 6i-Iz	€29,419	€92	81%	2	1	1	€63	❌	❌	✅	N / Y	⭐️ 4.3 (44)
New bajo Duplex en La Latina/Centro de Madrid	€25,178	€66	94%	2	1	1	€68	❌	❌	❌	Y / Y	⭐️ 4 (8)
Spectacular design apartment with terrace Gl6D	€35,184	€98	92%	2	1	1	€63	❌	❌	✅	N / Y	⭐️ 4.2 (49)
Coqueto apartamento a estrenar junto al centro.	€30,160	€90	90%	2	1	4	€48	❌	❌	✅	Y / Y	⭐️ 4.8 (46)
Piso/wifi: Paseo de las Acacias	€31,060	€85	99%	2	1	5	€29	❌	❌	❌	Y / Y	⭐️ 4.7 (182)
Madrid Río a tus pies	€32,174	€92	92%	2	1	6	€63	❌	❌	✅	Y / Y	⭐️ 4.9 (28)
Design and amazing apartment 5ºi-I	€27,598	€92	75%	2	1	1	€63	❌	❌	✅	N / Y	⭐️ 3.9 (32)
MODERN INDUSTRIAL style apartment (sanitized)	€24,150	€90	71%	2	1	2	€73	❌	❌	✅	Y / Y	⭐️ 4.8 (193)
Charming 2-bedroom apartment by the CITY CENTER	€28,605	€96	80%	2	1	3	€29	❌	❌	❌	Y / Y	⭐️ 4.5 (102)
Excelente oportunidad en el centro de Madrid	€28,504	€147	51%	2	1	2	€30	❌	❌	❌	Y / Y	⭐️ 4.7 (58)

Return Metrics

-82.94% cash on cash return is a poor return over the next 1 year

Cashflow Over Time

	Y1	Y2	Y3	Y4	Y5	Y10	Y30
Profit (Cummulative)	-€4,904	-€9,808	-€14,713	-€19,617	-€24,521	-€49,043	-€147,131
Revenue Appreciation	€0	€0	€0	€0	€0	€0	€0
Home Equity	€0	€0	€0	€0	€0	€0	€0
Down Payment	€0	€0	€0	€0	€0	€0	€0
Property Appreciation	€0	€0	€0	€0	€0	€0	€0
Total Return	-€4,904	-€9,808	-€14,713	-€19,617	-€24,521	-€49,043	-€147,131

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-82.94%

Payback Period Days

Return on Investment

-82.94%

C. Casimiro Mahou Bierhans Madrid, Comunidad de Madrid, 28005

2 bed • 2 bath • 4 guests

Monthly Rent

€28,789

Annual Revenue

This property is projected to be in the top 47% revenue percentile compared to similar properties nearby.
Projected nightly rate is €129/night at 82% occupancy.Projected nightly rate is €95/night at 83% occupancy.

Occupancy Rate

Top 56% of comparables

Avg Daily Rate

Top 31% of comparables

Seasonality

40 Airbnb Comparables

Adjust the filters to identify similar listings to yours. Then adjust your annual revenue estimate accordingly.

€29,327

Avg annual revenue

83%

Avg occupancy rate

€95

Avg nightly rate

🏊‍♂️ Pool

🛁 Hot tub

🐶 Pet friendly

Any type

House

Apartment

Any min stay

Weekly min

Monthly min

4.8+ stars

Revenue per year

€15k

€25k

€40k

€50k

-€4,904

Profit

Revenue

€28,789

Operating Expenses

€14,493

Operating Income

€14,296

Net Effective Rent

€19,200

Profit (Cash Flow)

-€4,904

€5,913

Cash Investment

Renos & Furnishing

€5,823

Setup Costs

€90

Total

€5,913

Investment Value Over Time

Revenue Appreciation

Cash on Cash Return

-82.94%

Payback Period Days