BNBCalc Short Term Rental Investment Analysis Calle de Castelló, 117, Madrid, Spain

1 bed • 1 bath • 3 guests • €580,000

BNB

Calc

Annual Revenue

€63,250

Profit (Cash Flow)

€41,662

Cap Rate

7.9%

Annual Revenue

€63,250

AirDNA projects €120/night at 79% occupancy ($34,519). Airbtics projects €143/night at 86% occupancy ($44,851). Airbtics predicts this property will perform in the 47% revenue percentile

BNB Calc projects a 93% occupancy rate, €186 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	€33,357	€40,443	€64,568	€78,277
Occupancy	81%	89%	93%	95%
Nightly Rate	€111	€122	€186	€221

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
General Oraa IX - Darya Living	€92,948	€310	82%	1	2	2	€0	❌	❌	❌	Y / Y	⭐️ 4.8 (93)
Duplex en Guindalera (C)	€23,123	€74	78%	1	2	1	€68	❌	❌	❌	Y / N	⭐️ 4 (2)
Castelló & Diego León: Salamanca, Patio Privado	€30,986	€116	71%	1	1	1	€30	❌	❌	❌	Y / Y	⭐️ 4.6 (98)
Salamanca (Madrid) -1BD 1BTH- Bright and Executive	€76,591	€221	94%	1	1	1	€48	❌	❌	❌	Y / Y	⭐️ 4.6 (117)
City apartment UpTown Madrid	€32,713	€118	75%	1	1	1	€37	❌	❌	❌	Y / Y	⭐️ 4.7 (155)
Well connected apartment on Avenida de America	€25,630	€75	87%	1	1	1	€62	❌	❌	❌	Y / Y	⭐️ 4.8 (12)
Very bright apartment on Avenida de America	€40,726	€117	93%	1	1	1	€62	❌	❌	❌	Y / Y	⭐️ 4.5 (16)
Apartment very well located in Avenida de América	€47,880	€138	92%	1	1	1	€62	❌	❌	❌	Y / Y	⭐️ 4.7 (22)
General Oraá	€83,815	€233	95%	1	1	1	€63	❌	❌	❌	Y / Y	⭐️ 4.7 (80)
Z Diego de Leon	€40,758	€112	98%	1	1	2	€21	❌	❌	❌	Y / Y	⭐️ 4.8 (87)
Exterior. Bº Salamanca. Av. de América	€37,964	€114	89%	1	1	2	€37	❌	❌	❌	Y / Y	⭐️ 4.9 (70)
Fantastic flat next to the IE P.VER	€91,906	€276	90%	1	1	1	€59	❌	❌	❌	Y / Y	⭐️ 4.9 (140)
One bedroom apartment in Avenida de America	€56,089	€161	93%	1	1	1	€62	❌	❌	❌	Y / Y	⭐️ 4.4 (7)
One bedroom apartment in Avenida de América	€39,211	€116	89%	1	1	1	€62	❌	❌	❌	Y / Y	⭐️ 4.8 (26)
Urban Chic Apartment at great location in Madrid	€41,604	€133	83%	1	1	3	€52	❌	❌	❌	Y / Y	⭐️ 5 (26)
Luxury loft in Salamanca, close to I.E.	€58,299	€195	81%	1	1	2	€46	❌	❌	❌	Y / Y	⭐️ 4.8 (73)
Interior apartment with a bright patio view	€24,517	€69	94%	1	1	1	€62	❌	❌	❌	Y / Y	⭐️ 4.8 (40)
Cozy studio - 1Bathroom - Salamanca	€70,910	€202	95%	1	1	1	€48	❌	❌	❌	Y / Y	⭐️ 4.7 (23)
Modern & comfy-1bedroom 1bathroom-Prosperidad	€72,623	€217	91%	1	1	1	€48	❌	❌	❌	Y / Y	⭐️ 4.7 (18)
Fantástico piso vigilancia 24h	€35,376	€100	95%	1	1	2	€21	✅	❌	❌	Y / Y	⭐️ 4.4 (111)
Charming Avenida América - Renovado, Cama King, AC	€40,122	€110	97%	1	1	1	€67	❌	❌	❌	Y / Y	⭐️ 4.9 (32)
Alma	€33,988	€121	77%	1	1	1	€0	❌	❌	❌	Y / Y	⭐️ 4.5 (28)
bonito estudio en B. Salamanca	€31,515	€100	85%	1	1	1	€63	❌	❌	❌	Y / Y	⭐️ 4.8 (22)
Precioso apartamento con patio en el Barrio de Salamanca	€39,909	€116	94%	1	1	2	€21	❌	❌	❌	Y / N	⭐️ 4.9 (97)
Exterior y nuevo en barrio de Salamanca. Una joya.	€49,859	€150	90%	1	1	2	€37	❌	❌	❌	Y / Y	⭐️ 4.8 (63)
1 dormitorio en Barrio Salamanca	€40,617	€132	83%	1	1	1	€46	❌	❌	❌	Y / Y	⭐️ 4.9 (11)
estupendo estudio en B salamanca	€33,274	€123	73%	1	1	1	€52	❌	❌	❌	Y / Y	⭐️ 4.5 (15)
Céntrico Apto. Barrio Salamanca	€32,031	€116	74%	1	1	2	€41	❌	❌	❌	Y / Y	⭐️ 4.7 (35)
Lovely flat close to Av. de América	€72,631	€211	92%	1	1	3	€72	❌	❌	❌	Y / Y	⭐️ 4.7 (85)
Apartamento Principe de Vergara	€45,255	€139	89%	1	1	5	€0	❌	❌	❌	Y / Y	⭐️ 4.6 (6)
Apartamento en Salamanca	€44,541	€230	53%	1	2	30	€281	❌	✅	✅	Y / Y	⭐️ 5 (1)
Small cozy apartment for 2 ( Nuñez de Balboa I )	€51,142	€186	71%	1	1	1	€114	❌	❌	❌	Y / Y	⭐️ 4.3 (14)
NICE Apart. Close to IE in Barrio SALAMANCA	€25,229	€83	83%	1	1	3	€15	❌	❌	❌	Y / N	⭐️ 4.5 (155)
Ático Duplex- Avenida de América-Recién reformado	€43,519	€133	87%	1	1	3	€70	❌	❌	❌	Y / Y	⭐️ 4.9 (33)
At 20' by Metro from the city centre (A)	€13,293	€37	85%	1	1	2	€68	❌	❌	❌	Y / N	⭐️ 4.5 (2)
Balcón con luz natural	€34,727	€103	90%	1	1	2	€21	❌	❌	✅	Y / Y	⭐️ 4.9 (21)
Studio Av de America Madrid	€31,594	€87	97%	1	1	2	€26	❌	❌	❌	N / Y	⭐️ 4.4 (14)
Best Views of Madrid in brand renovated flat	€60,595	€188	88%	1	1	3	€72	❌	❌	✅	Y / Y	⭐️ 4.3 (16)
Penthouse with incredible views and great terrace	€38,907	€118	89%	1	2	2	€68	❌	❌	✅	Y / Y	⭐️ 5 (2)
Modern apartment-1Bedroom 1Bathroom-Av. de America	€50,434	€168	79%	1	1	1	€48	❌	❌	❌	Y / Y	⭐️ 4.6 (13)

Return Metrics

14.21% cash on cash return is a good return over the next 1 year

Investment Value Over Time

	Y1	Y2	Y3	Y4	Y5	Y10	Y30
Profit (Cummulative)	€41,661	€83,323	€124,984	€166,646	€208,308	€416,616	€1,249,848
Revenue Appreciation	€0	€0	€0	€0	€0	€0	€0
Home Equity	€307,400	€307,400	€307,400	€307,400	€307,400	€307,400	€307,400
Down Payment	€272,600	€272,600	€272,600	€272,600	€272,600	€272,600	€272,600
Property Appreciation	€17,400	€35,322	€53,781	€72,795	€92,378	€199,471	€827,812
Total Return	€639,061	€698,645	€758,766	€819,441	€880,686	€1,196,087	€2,657,660

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

14.21%

Cap Rate

7.93%

Return on Investment

22.58%

117 Calle de Castelló Madrid, Comunidad de Madrid, 28006

1 bed • 1 bath • 3 guests

Purchase Price

Airbnb Investor Score

€25,421

Annual Profit

7.9%

Cap Rate

14.2%

Cash on Cash

€63,250

Annual Revenue

This property is projected to be in the top 47% revenue percentile compared to similar properties nearby.
Projected nightly rate is €120/night at 79% occupancy.Projected nightly rate is €143/night at 86% occupancy.

Occupancy Rate

Top 26% of comparables

Avg Daily Rate

Top 26% of comparables

Seasonality

40 Airbnb Comparables

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

€45,921

Avg annual revenue

86%

Avg occupancy rate

€143

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

€10k

€40k

€65k

€95k

€41,662

Profit

Revenue

€63,250

Operating Expenses

€17,238

Operating Income

€46,012

Mortgage & Taxes

€4,350

Profit (Cash Flow)

€41,662

€275,676

Cash Investment

Down Payment

€272,600

Renos & Furnishing

€3,076

Total

€275,676

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

14.21%

Cap Rate

7.93%

Return on Investment

22.58%