BNBCalc Short Term Rental Investment Analysis 2947 W 74th Ave, Merrillville, IN 46410

3 bed • 1 bath • 9 guests • $184,500

BNB

Calc

Annual Revenue

$28,759

Profit (Cash Flow)

-$1,105

Cap Rate

6.1%

Annual Revenue

$28,759

AirDNA projects $254/night at 31% occupancy ($28,759). Airbtics projects $218/night at 52% occupancy ($41,404). Airbtics predicts this property will perform in the 44% revenue percentile

BNB Calc projects a 31% occupancy rate, $254 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$26,311	$42,403	$66,381	$97,956
Occupancy	42%	55%	67%	75%
Nightly Rate	$159	$195	$255	$338

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
3Bedroom “Designer Den” Entire Home Sleeps 7	$28,369	$252	21%	3	3	1	$200	❌	❌	❌	Y / Y	⭐️ 5 (5)
Cheerful, Lake Home with amazing backyard!	$68,479	$393	46%	3	3	3	$175	✅	❌	❌	Y / Y	⭐️ 4.8 (38)
Cozy three bedroom home in Munster , Indiana.	$45,469	$190	61%	3	1	2	$125	❌	❌	✅	N / Y	⭐️ 5 (76)
Dunes Escape	$40,566	$154	63%	3	1	1	$160	❌	❌	❌	Y / Y	⭐️ 4.9 (52)
Huge yard w/ hot tub and firepit, dog friendly!	$36,550	$188	45%	3	1	2	$199	❌	✅	✅	Y / Y	⭐️ 4.3 (34)
Little Pink House Downtown	$51,332	$187	75%	3	1	2	$0	✅	❌	❌	Y / Y	⭐️ 5 (37)
Home Theatre +Fire Pit+Enclosed Porch +	$56,463	$174	77%	3	1	2	$250	❌	❌	✅	Y / Y	⭐️ 4.7 (99)
Midcentury Cottage 3bd IN Dunes Natl Park, Lake MI	$41,028	$137	75%	3	1	1	$150	❌	❌	✅	Y / Y	⭐️ 4.8 (170)
Urban Home near 80/94 and more!	$30,025	$155	48%	3	1	2	$150	❌	❌	❌	Y / Y	⭐️ 5 (18)
Luxury Cottage nestled in nature, close to beach	$25,381	$137	46%	3	1	3	$150	❌	❌	✅	Y / Y	⭐️ 4.9 (64)
Collins Lakeview Retreat	$59,335	$223	70%	3	3	3	$90	❌	✅	❌	Y / Y	⭐️ 5 (15)
3rooms large pool ,large back yard, deck,garage	$23,361	$277	22%	3	1	1	$25	✅	❌	✅	N / Y	⭐️ 4.2 (9)
Cheerful Stylist place near restaurants & Shopping	$29,976	$275	27%	3	2	1	$140	❌	❌	✅	Y / Y	⭐️ 4.8 (48)
Miller Beach Cozy Cottage with indoor fireplace	$31,482	$152	49%	3	1	2	$160	❌	❌	❌	Y / Y	⭐️ 5 (38)
The Cottage at Twin Creeks Farm	$23,058	$210	30%	3	4	2	$0	❌	❌	❌	Y / Y	⭐️ 4.9 (56)
Warm and comfortable inviting Suburban home !	$16,997	$67	65%	3	1	2	$40	❌	❌	❌	N / N	⭐️ 4.8 (176)
Melissa and Doug Place	$15,820	$172	17%	3	1	3	$150	❌	❌	❌	N / Y	⭐️ 4 (1)
Melissa and Doug place	$14,917	$155	17%	3	1	3	$150	❌	❌	❌	N / N	⭐️ 0 (0)
Warm and cheerful 3 bedroom home in Chicago!	$44,826	$193	57%	3	1	2	$200	❌	❌	✅	Y / Y	⭐️ 4.5 (72)
Party Porch Place in Miller Beach, Indiana Dunes	$77,680	$274	74%	3	3	2	$75	❌	❌	❌	Y / Y	⭐️ 4.9 (50)
Steps from the beach and a mile from National Park	$102,501	$540	50%	3	3	2	$150	❌	❌	✅	Y / Y	⭐️ 5 (64)
Lakefront Family Retreat w/ Grill: Steps to Beach!	$115,286	$436	70%	3	3	3	$186	❌	❌	❌	Y / Y	⭐️ 4.9 (38)
Secluded 3400sq ft home jet tub close to amenities	$44,668	$150	78%	3	3	2	$100	❌	❌	✅	Y / Y	⭐️ 5 (45)
King bed comfy 3 BR Entire home in Suburban Area	$45,865	$173	67%	3	1	3	$150	❌	❌	✅	Y / Y	⭐️ 5 (50)
Lakefront Portage Home: 3 Mi to Lake Michigan!	$70,237	$338	55%	3	3	2	$155	❌	❌	❌	Y / Y	⭐️ 4.5 (32)
Fun~Loft~Beach~Grill~Indiana Dunes National Park	$62,930	$245	66%	3	1	1	$200	❌	❌	❌	Y / Y	⭐️ 4.8 (23)
Hamstrom Hideaway	$36,270	$163	59%	3	1	2	$75	❌	❌	✅	Y / Y	⭐️ 4.8 (36)
Luxurious South Suburban Villa	$63,230	$216	77%	3	3	3	$150	✅	❌	❌	Y / Y	⭐️ 4.6 (31)
Doug place	$22,052	$167	30%	3	1	3	$150	❌	❌	❌	N / Y	⭐️ 1 (1)
16 Sandals	$31,441	$242	33%	3	1	2	$275	❌	❌	✅	Y / Y	⭐️ 4.8 (8)
Comfy Remodeled Home Close to Chicago/Indiana	$25,251	$83	71%	3	1	2	$120	❌	❌	❌	Y / Y	⭐️ 4.7 (88)
Woodland & Beach FairyForest Theme+ Screen’d Porch	$45,934	$216	56%	3	1	2	$90	❌	❌	✅	N / Y	⭐️ 4.8 (61)
Cozy Log Cabin Near Indiana Dunes & Lake Michigan!	$73,963	$266	72%	3	4	2	$160	✅	❌	❌	Y / Y	⭐️ 5 (83)
Miller Beach Cottage by the Lake	$22,111	$198	27%	3	1	2	$110	❌	✅	✅	Y / Y	⭐️ 4.9 (11)
The Refinery- 2nd Floor	$23,571	$229	27%	3	1	1	$60	❌	❌	❌	Y / Y	⭐️ 5 (48)
Chateau Cassandra	$74,903	$279	67%	3	3	3	$225	❌	❌	✅	Y / Y	⭐️ 4.8 (36)
Cabin on the Lake	$63,318	$346	50%	3	2	1	$0	❌	❌	✅	Y / Y	⭐️ 5 (54)
The Young’s - Northern Indiana	$21,868	$99	56%	3	1	2	$149	❌	❌	❌	Y / Y	⭐️ 4.9 (11)
CHEERFUL 3 BEDROOM HOME IN A QUIET AREA!	$31,577	$161	47%	3	2	2	$175	❌	❌	❌	N / Y	⭐️ 4.5 (54)
Peaceful Getaway in Miller Beach	$48,153	$213	55%	3	2	2	$225	❌	❌	❌	Y / Y	⭐️ 4.8 (31)

Return Metrics

-2.18% 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)	-$1,105	-$2,210	-$3,315	-$4,420	-$5,525	-$11,051	-$33,155
Revenue Appreciation	$0	$0	$0	$0	$0	$0	$0
Home Equity	$147,600	$147,600	$147,600	$147,600	$147,600	$147,600	$147,600
Down Payment	$36,900	$36,900	$36,900	$36,900	$36,900	$36,900	$36,900
Property Appreciation	$5,535	$11,236	$17,108	$23,156	$29,386	$63,452	$263,329
Total Return	$188,929	$193,525	$198,292	$203,235	$208,360	$236,900	$414,674

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-2.18%

Cap Rate

6.14%

Return on Investment

12.31%

2947 W 74th Ave Merrillville, IN, 46410

3 bed • 1 bath • 9 guests

Purchase Price

Est. $885/mo

This property is for sale!

Contact Agent

Airbnb Investor Score

-$1,105

Annual Profit

6.1%

Cap Rate

-2.2%

Cash on Cash

$28,759

Annual Revenue

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

Occupancy Rate

Top 81% 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.

$44,656

Avg annual revenue

52%

Avg occupancy rate

$218

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

$45k

$80k

$115k

-$1,105

Profit

Revenue

$28,759

Operating Expenses

$17,419

Operating Income

$11,341

Mortgage & Taxes

$12,446

Profit (Cash Flow)

-$1,105

$50,685

Cash Investment

Down Payment

$36,900

Renos & Furnishing

$8,250

Closing Costs

$5,535

Total

$50,685

DSCR Ratio

Weak

0.91

Get a pre-qualification letter

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

-2.18%

Cap Rate

6.14%

Return on Investment

12.31%

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

$8,757

Deductible property tax

$1,827

Your total deduction

$20,522

Your adjusted annual income

$150,000 - $20,522 = $129,478

Taxes on $129,478 (30%)

$38,843

Your old tax bill

$45,000

Your new tax bill

$38,843

Estimated tax savings

$6,157

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:

Year built:

Size:

Type:

SFR

Parking:

Heating:

Sold Comparables

Property Details

MLS Status: Active

Property Use: SFR

Stories: -

Lot size: -

Building area: -

Garage: Yes

Heating:

Pool: No

Fireplaces: -

Basement: No

Cooling: -

View: -

Parking: -

Amenities: -

Price per square foot: -

Lot Info

Zoning: -

Land Use: -

Parcel Number: -

Flood Zone: No

Tax Info

Year Assessed:

Assessed Value: -

County Est. Land Value: -

Assessed Land Value: -

County Est. Structure Value: -

Market Estimate: -