BNBCalc Short Term Rental Investment Analysis 50 Bismarckstraße, Köln, NRW, 50672

3 bed • 1.5 bath • 1 guests • €750,000

BNB

Calc

Annual Revenue

€116,795

Profit (Cash Flow)

€53,582

Cap Rate

12.5%

Annual Revenue

€116,795

AirDNA projects €396/night at 71% occupancy ($102,684). Airbtics projects €324/night at 63% occupancy ($74,548). Airbtics predicts this property will perform in the 46% revenue percentile

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

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

Percentiles	25%	50%	75%	90%
Revenue	€40,139	€71,856	€118,207	€191,224
Occupancy	45%	65%	83%	98%
Nightly Rate	€242	€300	€385	€529

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
B49 - Luxus City Apartment	€76,417	€209	98%	3	2	1	€126	❌	❌	❌	Y / Y	⭐️ 5 (35)
whole flat in the middle of cologne - many extras	€31,575	€93	92%	3	1	2	€63	❌	❌	✅	Y / Y	⭐️ 4.8 (544)
Unique 107m² Loft Apartment - Downtown	€42,555	€191	59%	3	3	1	€79	❌	❌	❌	Y / Y	⭐️ 4.8 (336)
K68 Dorya am Ring	€68,344	€324	57%	3	1	4	€98	❌	❌	❌	Y / Y	⭐️ 4.5 (14)
Appartment "DaHeim V56" in Köln für 3-9 Pers.	€67,301	€262	70%	3	2	2	€84	❌	❌	❌	Y / Y	⭐️ 4.8 (303)
Cozy 2-3 Zimmer Apartment in Bestlage mit Balkon	€38,184	€108	96%	3	1	1	€18	❌	❌	✅	N / Y	⭐️ 4.8 (72)
RoyalDeluxe Penthouse by Keyvani	€66,289	€348	52%	3	3	1	€0	❌	❌	❌	Y / Y	⭐️ 4.8 (227)
DOMBLICK! Wunderschöne Wohnung super zentral	€74,698	€295	69%	3	2	2	€84	❌	❌	❌	N / Y	⭐️ 4.9 (153)
Zentral Wohnen in Köln Ehrenfeld	€30,360	€90	92%	3	1	3	€37	❌	❌	❌	Y / Y	⭐️ 4.7 (171)
Villa Ehrenfeld #2	€22,589	€168	36%	3	2	2	€42	❌	❌	✅	Y / Y	⭐️ 4.8 (185)
Luxurious Apartment mit Sauna	€60,366	€373	43%	3	2	1	€53	❌	❌	❌	Y / Y	⭐️ 4.5 (47)
Stylish, cosy flat close to Cologne City Center	€126,398	€440	78%	3	2	2	€79	❌	❌	❌	Y / Y	⭐️ 5 (36)
Cologne center - apartment for up to 8 people	€168,548	€633	72%	3	2	2	€74	❌	❌	❌	Y / Y	⭐️ 5 (4)
Stylische Wohnung in Top-Lage im Herzen Kölns	€105,547	€423	68%	3	1	2	€38	❌	❌	❌	Y / Y	⭐️ 4.8 (45)
Schöne Altbauwohnung zentral in Köln Nippes	€55,752	€299	51%	3	2	3	€0	❌	❌	❌	Y / Y	⭐️ 5 (3)
Spacious +120 m², 4 Rooms, Couch, Kitchen, Dining	€55,121	€251	60%	3	1	1	€0	❌	❌	❌	Y / Y	⭐️ 5 (30)
Paradise apartment 4 rooms with terasse and garden	€38,007	€137	74%	3	1	1	€63	❌	❌	✅	Y / Y	⭐️ 4.7 (272)
Gesamte Wohnung Köln Zentrum	€92,546	€550	46%	3	1	1	€0	❌	❌	❌	Y / Y	⭐️ 4.8 (6)
Luxury design apt. with Dom view	€178,695	€678	72%	3	2	2	€0	❌	❌	❌	Y / Y	⭐️ 4.9 (20)
Luxury design house right next to Köln Cathedral.	€96,554	€563	46%	3	5	2	€52	❌	❌	✅	Y / Y	⭐️ 4.3 (11)
Villa Ehrenfeld #1	€52,958	€200	72%	3	2	2	€42	❌	❌	✅	Y / Y	⭐️ 4.5 (15)
Wunderschöne Altbauwohnung nahe Messe und Dom	€111,801	€301	100%	3	3	4	€84	❌	❌	❌	Y / Y	⭐️ 5 (1)
130qm in the Center of Cologne	€38,745	€271	39%	3	1	1	€0	❌	❌	❌	N / N	⭐️ 5 (13)
feel good cozy 3BR home in charming cologne center	€78,353	€229	93%	3	2	2	€73	❌	✅	❌	Y / Y	⭐️ 5 (58)
Studio im Herzen von Köln	€46,848	€291	44%	3	1	1	€0	❌	❌	✅	Y / Y	⭐️ 0 (3)
Trendy Apartment in the Heart of Cologne	€78,688	€247	87%	3	2	1	€0	❌	❌	❌	Y / Y	⭐️ 0 (15)
Beautiful Art Nouveau flat in the heart of Cologne	€136,379	€373	100%	3	2	2	€0	❌	❌	❌	Y / Y	⭐️ 4.9 (69)
Traumhafte Maisonette mit Terrasse	€56,791	€337	45%	3	1	2	€42	❌	❌	✅	Y / Y	⭐️ 5 (3)
Wohnung Altstadt Süd beste Lage, 3Z, 6 Personen	€95,181	€482	54%	3	1	1	€0	❌	❌	❌	N / N	⭐️ 5 (2)
Central 3 Bedroom Apartment, Cologne (Friesenstr.)	€97,566	€267	100%	3	2	1	€0	❌	❌	❌	N / Y	⭐️ 0 (2)
K68 großes 4 Zimmer Penthouse Apartment am Friesenplatz im Herzen Kölns mit Rundumterrasse, Boxsprin	€36,320	€198	50%	3	2	4	€0	❌	❌	❌	Y / Y	⭐️ 0 (0)
Spacious 3-Bedroom Apartment in Central Cologne	€111,097	€304	100%	3	3	1	€0	❌	❌	❌	Y / Y	⭐️ 0 (5)
Nice and large appartment near stadium	€96,255	€424	62%	3	2	2	€0	❌	❌	❌	Y / Y	⭐️ 5 (13)
Luxurious apt. with Dom view	€155,920	€520	82%	3	2	1	€0	❌	❌	❌	Y / Y	⭐️ 0 (10)
160 sqm Kingsize City Appartment	€140,885	€527	73%	3	3	1	€0	❌	❌	❌	Y / Y	⭐️ 5 (30)

Return Metrics

29.99% cash on cash return is a excellent return over the next 1 year

Investment Value Over Time

	Y1	Y2	Y3	Y4	Y5	Y10	Y30
Profit (Cummulative)	€53,581	€107,163	€160,744	€214,326	€267,907	€535,815	€1,607,445
Revenue Appreciation	€0	€0	€0	€0	€0	€0	€0
Home Equity	€599,999	€599,999	€599,999	€599,999	€599,999	€599,999	€599,999
Down Payment	€150,000	€150,000	€150,000	€150,000	€150,000	€150,000	€150,000
Property Appreciation	€22,500	€45,675	€69,545	€94,131	€119,455	€257,937	€1,070,446
Total Return	€826,081	€902,838	€980,289	€1,058,457	€1,137,363	€1,543,752	€3,427,891

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

29.99%

Cap Rate

12.47%

Return on Investment

48.51%

50 Bismarckstraße Köln, Nordrhein-Westfalen, 50672

3 bed • 1.5 bath • 1 guests

Purchase Price

159

Airbnb Investor Score

€53,581

Annual Profit

12.5%

Cap Rate

30.0%

Cash on Cash

€116,795

Annual Revenue

This property is projected to be in the top 46% revenue percentile compared to similar properties nearby.
Projected nightly rate is €396/night at 71% occupancy.Projected nightly rate is €324/night at 63% occupancy.

Occupancy Rate

Top 26% of comparables

Avg Daily Rate

Top 28% of comparables

Seasonality

40 Airbnb Comparables

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

€74,325

Avg annual revenue

63%

Avg occupancy rate

€324

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

€20k

€75k

€125k

€180k

€53,582

Profit

Revenue

€116,795

Operating Expenses

€23,215

Operating Income

€93,580

Mortgage & Taxes

€39,999

Profit (Cash Flow)

€53,582

€178,612

Cash Investment

Down Payment

€150,000

Renos & Furnishing

€6,112

Closing Costs

€22,500

Total

€178,612

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

29.99%

Cap Rate

12.47%

Return on Investment

48.51%