BNBCalc Short Term Rental Investment Analysis 21 Cedar Rim Trail, Galena, IL

3 bed • 3 bath • 9 guests • $499,900

BNB

Calc

Annual Revenue

$46,203

Profit (Cash Flow)

-$7,205

Cap Rate

5.3%

Annual Revenue

$46,203

AirDNA projects $401/night at 48% occupancy ($70,302). Airbtics projects $253/night at 50% occupancy ($46,203). Airbtics predicts this property will perform in the 45% revenue percentile

BNB Calc projects a 50% occupancy rate, $253 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$33,642	$47,859	$66,430	$81,819
Occupancy	42%	50%	59%	65%
Nightly Rate	$213	$253	$296	$330

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
Cozy Retreat \| Hot Tub \| Firepit \| Dog-friendly	$73,300	$389	50%	3	3	2	$165	✅	✅	✅	Y / Y	⭐️ 5 (124)
Say Hello 2 Spring @ Stargazer's Nook - Enjoy Skee	$45,445	$283	42%	3	3	2	$149	✅	✅	❌	Y / Y	⭐️ 5 (9)
Treehouse: Secluded & Cozy! Firepit & Games!	$83,885	$313	72%	3	3.5	2	$200	✅	❌	✅	Y / Y	⭐️ 5 (66)
Inviting & Bright \| Firepit Sauna Hot Tub & Games!	$50,743	$216	60%	3	2.5	2	$165	✅	✅	✅	Y / Y	⭐️ 5 (68)
Hot tub \| 3BD\|3BA en-suites \| Resort Amenities	$44,769	$226	50%	3	3	2	$189	✅	✅	❌	Y / Y	⭐️ 5 (80)
Gorgeous 3 BR Villa - King Beds! Views! Fireplace!	$29,148	$175	42%	3	2	2	$140	✅	❌	✅	Y / Y	⭐️ 5 (36)
Theatre Room, Air Hockey, Views, Pet Friendly	$38,099	$206	50%	3	2	2	$100	✅	❌	✅	Y / Y	⭐️ 5 (38)
The Getaway Place-Carefree, Fun & Pet Friendly	$57,127	$216	68%	3	2	2	$160	✅	✅	✅	Y / Y	⭐️ 5 (102)
Awesome Lodge in Galena Territory	$63,943	$350	49%	3	3	2	$195	✅	✅	❌	Y / Y	⭐️ 5 (145)
Deerview	$46,616	$264	47%	3	3	2	$200	✅	✅	❌	Y / Y	⭐️ 5 (37)
Serenity Cabins - A rustic, yet upscale cabin!	$38,364	$270	38%	3	2	2	$90	✅	❌	✅	Y / Y	⭐️ 5 (126)
Birds & Blossoms on Cogan Valley ~ Hot Tub, Pool T	$49,363	$246	53%	3	3	2	$149	✅	✅	✅	Y / Y	⭐️ 5 (87)
The Beauty on Belden: Owners' Club access & more!	$47,723	$207	59%	3	3	2	$130	✅	❌	❌	Y / Y	⭐️ 5 (152)
Tranquil Galena Home: Hot Tub, Fireplace, Fire Pit	$45,517	$239	49%	3	3	2	$165	✅	✅	✅	Y / Y	⭐️ 5 (29)
Private 3BR/2BA Home in the Trees \| Stonecrest	$54,288	$171	83%	3	2	2	$129	✅	❌	✅	Y / Y	⭐️ 5 (53)
Longwood Lodge	$61,204	$260	64%	3	3	2	$150	✅	❌	✅	Y / Y	⭐️ 5 (53)
Inviting Home on Golf Course \| Hot Tub & Fire Pit	$52,514	$257	53%	3	3	2	$165	✅	✅	✅	Y / Y	⭐️ 5 (79)
Beautiful Private Wooded Lot, Fireplace, Whirlpool	$55,800	$232	65%	3	4.5	3	$150	❌	❌	❌	Y / Y	⭐️ 5 (166)
Hot Tub-Dog friendly-fire tables-pools	$68,317	$256	67%	3	3.5	2	$167	✅	✅	✅	Y / Y	⭐️ 5 (134)
Picturesque Hillside Home w/Golf Course Views⛳️	$23,202	$142	40%	3	3	2	$150	❌	❌	❌	Y / Y	⭐️ 5 (125)
Charming Galena Getaway	$46,566	$202	58%	3	2	2	$125	✅	❌	❌	Y / Y	⭐️ 5 (30)
Galena Getaway and Game Room II	$66,986	$358	51%	3	4	1	$148	✅	✅	❌	Y / Y	⭐️ 4.7 (18)
111 W. Glen Hollow Rd Galena Territory	$82,282	$369	59%	3	3.5	1	$170	✅	❌	✅	Y / Y	⭐️ 5 (3)
Cozy Illinois Abode w/ Deck & Grill, Near Golfing!	$45,098	$304	39%	3	2	2	$104	✅	❌	❌	Y / Y	⭐️ 5 (3)
Beautiful/Spacious 3bd, 3.5 ba home w/huge yard	$46,049	$296	42%	3	3.5	2	$100	✅	❌	❌	Y / Y	⭐️ 5 (16)
3bdrm home, large yard, arcade game, HOT TUB	$30,437	$298	27%	3	2	2	$100	✅	✅	✅	Y / Y	⭐️ 4.5 (32)
Modern Golf Villa \| 3 Kings \| Views \| Dog-friendly	$35,093	$257	36%	3	2	2	$140	✅	❌	✅	Y / Y	⭐️ 5 (103)
The Galena Chalet- 3bdrm-3 bath	$28,813	$239	32%	3	3	2	$150	✅	❌	❌	Y / Y	⭐️ 5 (16)
Spring Specials! King Beds/Pool Access/Lake Galena	$58,128	$251	60%	3	3	1	$150	✅	❌	❌	Y / Y	⭐️ 5 (60)
Quiet & Peaceful	$48,949	$305	43%	3	3	2	$135	✅	❌	❌	Y / Y	⭐️ 5 (78)
Cedar & Sage House	$31,310	$170	48%	3	3	2	$120	✅	❌	✅	Y / Y	⭐️ 5 (56)
Warm & Cozy 3-Bedroom Cottage - With Hot Tub	$42,574	$231	50%	3	3	2	$150	❌	✅	❌	Y / Y	⭐️ 5 (70)
22 Glen Eagle Dr. The Galena Territory	$42,017	$328	35%	3	2	1	$0	✅	✅	❌	Y / Y	⭐️ 5 (11)
Cozy 3b/3ba, wooded/hot tub/firepit/screened porch	$58,365	$313	50%	3	3	2	$135	✅	✅	✅	Y / Y	⭐️ 4.5 (79)
Cozy Home near Chestnut Mt. \| Lots of Amenities	$39,224	$196	51%	3	2.5	1	$125	✅	❌	✅	Y / Y	⭐️ 5 (86)
Getaway - Indoor Pool, Arcade, Hiking, Skiing	$32,631	$169	50%	3	2	2	$130	✅	❌	✅	Y / Y	⭐️ 5 (58)
Spring Bloom and Game Room! Close to all amenities	$42,621	$179	62%	3	3	2	$99	✅	❌	✅	Y / Y	⭐️ 5 (132)
Fast Wi-Fi \| EV Charger \| Fireplace \| Hot Tub	$49,883	$282	48%	3	3	2	$150	✅	✅	❌	Y / Y	⭐️ 5 (58)
Galena Territory Sun-Drenched TreeHouse w/ Views	$41,536	$270	41%	3	3	2	$150	✅	❌	❌	Y / Y	⭐️ 5 (143)
Beautiful Lake Galena Views - Walk to Stonedrift S	$41,161	$219	50%	3	2	2	$149	✅	❌	❌	Y / Y	⭐️ 5 (13)

Return Metrics

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

Investment Value Over Time

	Y1	Y2	Y3	Y4	Y5	Y10	Y30
Profit (Cummulative)	-$7,204	-$14,409	-$21,614	-$28,819	-$36,023	-$72,047	-$216,142
Revenue Appreciation	$0	$0	$0	$0	$0	$0	$0
Home Equity	$4,911	$10,125	$15,660	$21,537	$27,777	$65,244	$399,920
Down Payment	$99,980	$99,980	$99,980	$99,980	$99,980	$99,980	$99,980
Property Appreciation	$14,997	$30,443	$46,354	$62,741	$79,621	$171,923	$713,488
Total Return	$112,683	$126,139	$140,380	$155,440	$171,354	$265,100	$997,245

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-5.82%

Cap Rate

5.3%

Return on Investment

10.26%

21 Cedar Rim Trail Galena, Illinois, 61036

3 bed • 3 bath • 9 guests

Purchase Price

Est. $2,398/mo

Inquire about this property

Contact Agent

-11

Airbnb Investor Score

-$7,204

Annual Profit

5.3%

Cap Rate

-5.8%

Cash on Cash

$46,203

Annual Revenue

BNBCalc predicts this property will get $253 per night with 50% occupancy, putting it in the top 45% revenue percentile compared to similar properties nearby.

Occupancy Rate

Top 56% of comparables

Avg Daily Rate

Top 51% of comparables

Seasonality

40 Airbnb Comparables

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

$48,477

Avg annual revenue

50%

Avg occupancy rate

$253

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

$45k

$65k

$85k

-$7,205

Profit

Revenue

$46,203

Operating Expenses

$19,686

Operating Income

$26,517

Mortgage & Taxes

$33,722

Profit (Cash Flow)

-$7,205

$123,727

Cash Investment

Down Payment

$99,980

Renos & Furnishing

$8,750

Closing Costs

$14,997

Total

$123,727

DSCR Ratio

Weak

0.79

Get a pre-qualification letter

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

-5.82%

Cap Rate

5.3%

Return on Investment

10.26%

STR Tax Calculator (USA)

On purchasing a large business asset, you can subtract the depreciation value from your taxable income in order to pay less income tax. Use this calculator to find out how much you can save. Read tax guide.

Your current annual income

Your income tax rate

Taxes paid on $150,000

$45,000

If you buy this investment property, your est deduction will be...

Deductible mortgage interest

$23,726

Deductible property tax

$4,949

Your total deduction

$57,936

Your adjusted annual income

$150,000 - $57,936 = $92,064

Taxes on $92,064 (30%)

$27,619

Your old tax bill

$45,000

Your new tax bill

$27,619

Estimated tax savings

$17,381

Maximize the depreciation value on your tax returns. Get $50 off cost segregation reports with code BNBCALC at DIYCostSeg.com

Property Overview

View property info, current ownership, recently sold comps, school zone ratings, area rents, and more.

Lot size:

1.58 sqft

Year built:

1994

Size:

2,503 sqft

Type:

SINGLE_FAMILY

Parking:

Heating:

Forced Air, Propane

Sold Comparables

Property Details

MLS Status: N/A

Property Use: SINGLE_FAMILY

Stories: -

Lot size: 1.58 sqft

Building area: 2,503 sqft

Garage: Yes

Heating: Forced air, propane

Pool: No

Fireplaces: -

Basement: Yes

Cooling: Central Air

View: -

Parking: Asphalt, Attached, Garage Door Opener

Amenities: Dishwasher, Dryer, Microwave, Refrigerator, Stove/Cooktop, Washer, Water Softener, LP Gas Tank, LP Gas Water Heater

Price per square foot: $199

Lot Info

Zoning: -

Land Use: -

Parcel Number: 0811403800

Flood Zone: No

Tax Info

Year Assessed:

Assessed Value: -

County Est. Land Value: -

Assessed Land Value: -

County Est. Structure Value: -

Market Estimate: -

Schools

Elementary School: River Ridge Elementary School with 6/10 star rating
Middle School: River Ridge Middle School with 8/10 star rating
High School: River Ridge High School with 7/10 star rating