BNBCalc Short Term Rental Investment Analysis 5648 North Keystone Avenue, Indianapolis, IN

2 bed • 1 bath • 6 guests • $214,900

BNB

Calc

Report by:

Lauren Perry

13175201321

leasing@helix-company.com

www.hautepropertyco.com

Annual Revenue

$28,489

Profit (Cash Flow)

-$3,391

Cap Rate

5.2%

Annual Revenue

$28,489

AirDNA projects $162/night at 56% occupancy ($33,134). Airbtics projects $120/night at 65% occupancy ($28,489). Airbtics predicts this property will perform in the 44% revenue percentile

BNB Calc projects a 65% occupancy rate, $120 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$21,254	$30,282	$41,053	$49,458
Occupancy	59%	68%	77%	82%
Nightly Rate	$95	$116	$138	$156

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
Charming 2 Bedroom SoBro Bungalow	$20,969	$129	43%	2	1	2	$95	❌	❌	❌	Y / Y	⭐️ 5 (97)
Indy Retreat near Broad Ripple~Walk to Restaurants	$26,888	$115	58%	2	1	2	$130	❌	❌	❌	Y / Y	⭐️ 5 (47)
The Burlington Bungalow	$39,669	$130	78%	2	1	2	$85	❌	❌	✅	Y / Y	⭐️ 5 (130)
Bungalo in BR! - Walkable everywhere! Go Explore!	$35,826	$138	67%	2	2	2	$110	❌	❌	❌	Y / Y	⭐️ 5 (236)
Reclaimed Treasure, 2 bd Broadripple Bungalow	$34,785	$144	66%	2	2	2	$0	❌	❌	❌	Y / Y	⭐️ 5 (400)
South Broad Ripple Cozy Retreat: Red Cottage Charm	$29,768	$103	75%	2	1	1	$115	❌	❌	❌	Y / Y	⭐️ 4.9 (15)
Beautiful Broad Ripple Home, All to Yourself!	$19,435	$122	41%	2	1	1	$75	❌	❌	✅	Y / Y	⭐️ 5 (183)
Cozy & Quiet Home Away from Home	$23,214	$83	68%	2	1	1	$50	❌	❌	✅	Y / Y	⭐️ 5 (63)
Hillside Home close to downtown	$18,500	$75	63%	2	1	10	$75	❌	❌	❌	Y / Y	⭐️ 5 (46)
Cottage living in the heart of Broad Ripple	$41,708	$157	71%	2	1	2	$75	❌	❌	❌	Y / Y	⭐️ 5 (167)
Cozy 2-bedroom house in Broad Ripple	$31,379	$129	65%	2	1.5	1	$40	❌	❌	✅	Y / Y	⭐️ 5 (70)
Broad Ripple Bungalow- dogs ok!	$44,159	$142	84%	2	1	2	$50	❌	❌	✅	Y / Y	⭐️ 5 (70)
Spacious 2BR in Meridian Kessler by CozySuites	$23,540	$91	62%	2	2	2	$95	❌	❌	✅	Y / Y	⭐️ 5 (76)
CozySuites \| Spacious 2BR at Meridian Kessler	$29,036	$95	78%	2	2	2	$95	❌	❌	✅	Y / Y	⭐️ 4.5 (28)
Broad Ripple Beauty-Convenient-Stylish-Superhosts	$27,887	$86	84%	2	1	2	$90	❌	❌	❌	Y / Y	⭐️ 5 (74)
Cozy Broadripple Bungalow	$29,536	$103	77%	2	1	2	$100	❌	❌	❌	Y / Y	⭐️ 5 (96)
The Broad Ripple Bulldog Bungalow	$49,640	$156	82%	2	1	2	$115	❌	✅	✅	Y / Y	⭐️ 5 (140)
Luxurious 2BR Broad Ripple	$29,541	$108	69%	2	2	2	$117	❌	❌	❌	Y / Y	⭐️ 4.5 (46)
Pet Friendly \| Broad Ripple Bungalow	$23,584	$114	50%	2	1	2	$120	❌	❌	✅	Y / Y	⭐️ 4.5 (13)
Broad Ripple Treetop Lodge on the Park	$30,035	$116	69%	2	1	2	$40	❌	❌	❌	Y / Y	⭐️ 5 (322)
Class Act in Broad Ripple	$40,994	$143	77%	2	1	2	$75	❌	❌	✅	Y / Y	⭐️ 5 (135)
Your Cozy Nest - Broad Ripple Centre	$25,314	$81	83%	2	1	2	$50	❌	❌	❌	N / Y	⭐️ 4.5 (32)
Broad Ripple Bliss: Vintage & Modern Mix	$14,042	$95	36%	2	1	2	$140	❌	❌	❌	Y / N	⭐️ 4.8 (12)
CozySuites Upscale Modern 2BR Broad Ripple	$30,986	$109	73%	2	2	2	$95	❌	❌	✅	Y / Y	⭐️ 5 (15)
Charming Broad Ripple bungalow	$22,344	$75	79%	2	1	2	$100	❌	❌	❌	Y / Y	⭐️ 5 (173)
Pets Welcome \| Central Broad Ripple Charm	$35,100	$116	78%	2	1	2	$150	❌	❌	✅	Y / Y	⭐️ 5 (14)
Cozy SoBro Home	$19,565	$222	23%	2	2	2	$80	❌	❌	✅	Y / Y	⭐️ 4.5 (16)
Cottage w/ ~Solarium~ in heart of Broad Ripple!	$31,441	$104	75%	2	1	1	$120	❌	❌	❌	Y / Y	⭐️ 5 (58)
CozySuites \| Stylish 2BR at Meridian Kessler	$25,693	$92	67%	2	2	2	$95	❌	❌	✅	Y / Y	⭐️ 4.5 (24)
Comfortable Apartment in Broad Ripple	$23,599	$139	46%	2	1	1	$30	❌	❌	❌	Y / Y	⭐️ 5 (115)
Cozy Sobro Bungalow	$28,570	$119	62%	2	1	2	$75	❌	❌	❌	Y / Y	⭐️ 5 (95)
Charming Home w/ Patio, Stay for Gen Con	$13,810	$77	49%	2	1	2	$0	❌	❌	✅	N / Y	⭐️ 4.6 (39)
King Bed+Game Room+Parking+Broadripple+Restaurants	$32,287	$90	94%	2	1	3	$30	❌	❌	✅	Y / Y	⭐️ 5 (310)
Designer 2 bedroom, 1 acre retreat in the city.	$49,670	$194	68%	2	1.5	2	$115	❌	❌	❌	Y / Y	⭐️ 5 (81)
Broad Ripple's Best Kept Secret 2BR w/ FreeParking	$32,135	$138	60%	2	2	2	$130	❌	❌	❌	Y / Y	⭐️ 5 (50)
Warfleigh Cottage	$36,923	$133	74%	2	1.5	2	$99	❌	❌	✅	Y / Y	⭐️ 5 (44)
Charming Bungalow Near Broad Ripple & Indy Hotspot	$31,307	$154	53%	2	2.5	2	$155	❌	❌	✅	Y / Y	⭐️ 5 (57)
Pet Friendly \| SoBro Bungalow in Indy	$40,250	$159	66%	2	1	2	$140	❌	❌	✅	Y / Y	⭐️ 4.5 (16)
Cozy 2BD Near Downtown \| Discounted Longer Stays	$33,539	$123	73%	2	1	1	$140	❌	❌	✅	Y / Y	⭐️ 5 (71)
2 bedroom 1 bath w K/Q/T bed on Monon by Butler.	$17,931	$105	40%	2	1	1	$100	❌	❌	❌	Y / Y	⭐️ 5 (74)

Return Metrics

-6.09% 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)	-$3,391	-$6,782	-$10,173	-$13,564	-$16,955	-$33,910	-$101,730
Revenue Appreciation	$0	$0	$0	$0	$0	$0	$0
Home Equity	$171,920	$171,920	$171,920	$171,920	$171,920	$171,920	$171,920
Down Payment	$42,980	$42,980	$42,980	$42,980	$42,980	$42,980	$42,980
Property Appreciation	$6,447	$13,087	$19,927	$26,971	$34,227	$73,907	$306,718
Total Return	$217,955	$221,205	$224,653	$228,307	$232,172	$254,897	$419,888

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-6.09%

Cap Rate

5.16%

Return on Investment

9.28%

5648 N Keystone Ave Indianapolis, Indiana, 46220

2 bed • 1 bath • 6 guests

Purchase Price

Est. $1,031/mo

Inquire about this property

Contact Lauren

Indianapolis

Guide

Zoning

Market

Guide

Laws

Market Data

-13

Airbnb Investor Score

-$3,391

Annual Profit

5.2%

Cap Rate

-6.1%

Cash on Cash

$28,489

Annual Revenue

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

Occupancy Rate

Top 63% of comparables

Avg Daily Rate

Top 46% of comparables

Seasonality

40 Airbnb Comparables

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

$29,864

Avg annual revenue

65%

Avg occupancy rate

$120

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

$35k

$50k

-$3,391

Profit

Revenue

$28,489

Operating Expenses

$17,384

Operating Income

$11,105

Mortgage & Taxes

$14,496

Profit (Cash Flow)

-$3,391

$55,677

Cash Investment

Down Payment

$42,980

Renos & Furnishing

$6,250

Closing Costs

$6,447

Total

$55,677

DSCR Ratio

Weak

0.77

Get a pre-qualification letter

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

-6.09%

Cap Rate

5.16%

Return on Investment

9.28%

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

$10,199

Deductible property tax

$2,128

Your total deduction

$25,543

Your adjusted annual income

$150,000 - $25,543 = $124,457

Taxes on $124,457 (30%)

$37,337

Your old tax bill

$45,000

Your new tax bill

$37,337

Estimated tax savings

$7,663

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:

6,969 sqft

Year built:

1942

Size:

1,152 sqft

Type:

SINGLE_FAMILY

Parking:

Heating:

Forced Air

Sold Comparables

Property Details

MLS Status: N/A

Property Use: SINGLE_FAMILY

Stories: 1

Lot size: 6,969 sqft

Building area: 1,152 sqft

Garage: Yes

Heating: Forced air

Pool: No

Fireplaces: 0

Basement: Yes

Cooling: -

View: -

Parking: Attached

Amenities: Dryer, Electric Oven, Refrigerator, Washer

Price per square foot: $186

Lot Info

Zoning: -

Land Use: -

Parcel Number: 490706127199000801

Flood Zone: No

Tax Info

Year Assessed: 2024

Assessed Value: $145,600

County Est. Land Value: -

Assessed Land Value: -

County Est. Structure Value: -

Market Estimate: -

Schools

High School: Shortridge High School with 2/10 star rating