BNBCalc Short Term Rental Investment Analysis 45-270 Lilipuna Rd, , ,

6 bed • 4 bath • 18 guests • $1,524,300

BNB

Calc

Annual Revenue

$283,575

Profit (Cash Flow)

$130,206

Cap Rate

15.3%

Annual Revenue

$283,575

AirDNA projects $780/night at 67% occupancy ($190,876). Airbtics projects $1,294/night at 60% occupancy ($283,575). Airbtics predicts this property will perform in the 49% revenue percentile

BNB Calc projects a 60% occupancy rate, $1,294 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$137,038	$247,140	$415,955	$654,222
Occupancy	45%	60%	67%	93%
Nightly Rate	$813	$1,099	$1,670	$1,902

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
DESIGNER VILLA - PANORAMIC OCEAN VIEW	$127,653	$1,099	30%	6	4	1	$580	✅	❌	❌	Y / Y	⭐️ 5 (12)
Le Serenity - 7 BD Breathtaking Oceanfront Estate	$433,110	$1,849	64%	7	7	30	$1,062	✅	✅	❌	Y / N	⭐️ 5 (2)
Le Serenity - Breathtaking Oceanfront Estate	$331,815	$1,511	60%	6	6	30	$975	✅	✅	❌	Y / Y	⭐️ 4.9 (11)
Experience Oceanfront Paradise on O'ahu	$404,532	$2,512	44%	6	6.5	30	$900	✅	✅	❌	Y / Y	⭐️ 5 (27)
Island Adventure: Minivan Rental, Contact Us	$289,418	$1,492	53%	7	6	30	$799	✅	✅	✅	Y / Y	⭐️ 5 (19)
Large updated Kailua home, pool, AC, mins to beach	$197,442	$999	54%	7	4	30	$495	✅	❌	❌	Y / Y	⭐️ 4.5 (7)
Beachfront Kailua Hale Kahakai by Gather w/ Views	$255,900	$813	86%	6	5	30	$845	❌	❌	❌	Y / Y	⭐️ 5 (3)
Villa Luana: Summer Special! Massive Price Drop!	$102,377	$518	54%	6	6	1	$1,020	✅	❌	❌	Y / Y	⭐️ 5 (3)
Hale Halai	$347,968	$1,419	67%	7	5	30	$700	✅	❌	❌	Y / Y	⭐️ 5 (98)
The Pool House in Kailua with 3,200 sf, 6bed/4bath	$338,361	$1,284	72%	6	4	29	$450	✅	❌	❌	Y / Y	⭐️ 5 (6)
Beachfront Oasis Retreat	$366,732	$1,670	60%	6	4	29	$800	✅	❌	❌	Y / Y	⭐️ 0 (1)
HOUSE,300/Feet to the Beach, 7/Aircon/ Bedrooms	$167,241	$682	67%	7	3	30	$450	❌	❌	❌	Y / Y	⭐️ 4.5 (13)
Kekela Nui Beachfront -Steps to beach+AC!	$432,510	$1,906	62%	6	4	30	$700	✅	❌	❌	Y / Y	⭐️ 0 (1)
Big house just off awesome beach	$221,796	$1,515	40%	6	5.5	29	$0	✅	✅	❌	Y / N	⭐️ 0 (1)
Panoramic Ocean View, Near Costco, Patio Deck, 16+	$170,065	$480	96%	7	4	3	$475	❌	❌	✅	Y / Y	⭐️ 4.7 (91)
Island Adventure: Minivan Rental, Contact Us for S	$491,135	$1,890	71%	7	5	30	$799	✅	✅	✅	Y / Y	⭐️ 4.4 (12)
Palione Papalani by AvantStay \| Steps from Kailua Beach w/ Private Pool & Hot Tub	$474,435	$2,679	45%	6	6	30	$1,769	✅	✅	❌	Y / Y	⭐️ 4.3 (6)
3800sf 7 rooms 4 Baths House Waimanalo Beach	$66,978	$305	60%	7	4	29	$600	❌	❌	❌	Y / Y	⭐️ 0 (1)
Hale Oahu Estate by AvantStay \| Beachfront Estate	$369,258	$1,062	95%	6	4	1	$0	❌	❌	❌	Y / Y	⭐️ 5 (8)
Hawaii Kai 7-Bedroom Pool Home with Views!	$121,424	$754	44%	7	5	30	$0	✅	✅	❌	Y / Y	⭐️ 4.5 (12)
Paradise Promised! Exclusive, Private AC	$285,941	$898	87%	6	4	30	$575	✅	❌	❌	Y / Y	⭐️ 5 (54)
Kahala Luxury - Exclusive, Large Family Hideaway.	$223,203	$1,848	33%	6	7	30	$800	✅	✅	❌	Y / Y	⭐️ 0 (0)
Maunalua Sunset: Oceanfront Estate w/Pool/Spa & AC	$112,522	$854	36%	6	6.5	30	$1,545	✅	✅	❌	Y / Y	⭐️ 5 (4)
Two Homes across the beach.	$170,190	$750	62%	6	4	30	$300	❌	❌	❌	Y / Y	⭐️ 5 (9)
Hale Kalio by AvantStay \| 20 steps to Kailua Beach	$119,682	$327	100%	6	4	31	$650	❌	❌	❌	Y / Y	⭐️ 0 (0)
Big Kailua Beach Home! Great space close to beach!	$290,534	$1,890	42%	6	4	1	$0	❌	❌	❌	Y / Y	⭐️ 4.8 (4)
Six bedroom home in Hauula!	$158,507	$802	54%	6	4	30	$700	❌	❌	❌	Y / Y	⭐️ 0 (0)
Oahu Grand Paradise w/ View, Pool, Courts & More	$327,334	$1,542	58%	6	4.5	29	$0	✅	✅	✅	Y / Y	⭐️ 0 (0)
Kahala 6BR/6.5BA, Pool, Spa, A/C, Walk to Beach	$217,404	$900	66%	6	7	30	$800	✅	✅	❌	Y / Y	⭐️ 4.9 (18)
6-BD The Heart of Coveted Kahala	$290,680	$836	95%	6	6	3	$0	✅	✅	✅	Y / Y	⭐️ 0 (0)
Paradise rental w/private Pool&Spa - 30 day Min	$137,377	$816	46%	6	4.5	30	$800	✅	✅	❌	Y / Y	⭐️ 5 (8)
Oceanfront Estate \| 2 Private homes for 16+ guests	$298,656	$1,600	51%	6	2	5	$1,000	❌	❌	❌	Y / Y	⭐️ 0 (0)

Return Metrics

35.61% 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)	$130,206	$260,412	$390,618	$520,824	$651,030	$1,302,061	$3,906,184
Revenue Appreciation	$0	$0	$0	$0	$0	$0	$0
Home Equity	$1,219,440	$1,219,440	$1,219,440	$1,219,440	$1,219,440	$1,219,440	$1,219,440
Down Payment	$304,860	$304,860	$304,860	$304,860	$304,860	$304,860	$304,860
Property Appreciation	$45,729	$92,829	$141,343	$191,313	$242,781	$524,231	$2,175,576
Total Return	$1,700,235	$1,877,542	$2,056,262	$2,236,437	$2,418,112	$3,350,593	$7,606,060

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

35.61%

Cap Rate

15.28%

Return on Investment

52.21%

45-270 Lilipuna Rd

6 bed • 4 bath • 18 guests

Purchase Price

Est. $7,311/mo

Inquire about this property

Contact Agent

$1,524,300

Zestimate

190

Airbnb Investor Score

$130,206

Annual Profit

15.3%

Cap Rate

35.6%

Cash on Cash

$283,575

Annual Revenue

This property is projected to be in the top 49% revenue percentile compared to similar properties nearby.
Projected nightly rate is $780/night at 67% occupancy.Projected nightly rate is $1,294/night at 60% occupancy.

Occupancy Rate

Top 49% of comparables

Avg Daily Rate

Top 46% of comparables

Seasonality

33 Airbnb Comparables

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

$262,052

Avg annual revenue

60%

Avg occupancy rate

$1,294

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

$65k

$205k

$345k

$490k

$130,206

Profit

Revenue

$283,575

Operating Expenses

$50,545

Operating Income

$233,031

Mortgage & Taxes

$102,824

Profit (Cash Flow)

$130,206

$365,589

Cash Investment

Down Payment

$304,860

Renos & Furnishing

$15,000

Closing Costs

$45,729

Total

$365,589

DSCR Ratio

Strong

2.27

Get a pre-qualification letter

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

35.61%

Cap Rate

15.28%

Return on Investment

52.21%

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

$72,345

Deductible property tax

$15,091

Your total deduction

$22,874

Your adjusted annual income

$150,000 - $22,874 = $127,126

Taxes on $127,126 (30%)

$38,138

Your old tax bill

$45,000

Your new tax bill

$38,138

Estimated tax savings

$6,862

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:

1967

Size:

2,392 sqft

Type:

SINGLE_FAMILY

Parking:

Heating:

Sold Comparables

Property Details

MLS Status: N/A

Property Use: SINGLE_FAMILY

Stories: 2

Lot size: -

Building area: 2,392 sqft

Garage: Yes

Heating:

Pool: No

Fireplaces: -

Basement: No

Cooling: -

View: Garden, Mountain(s), Ocean

Parking: Carport, Driveway, Two Car Garage, Two Spaces, Three or more Spaces

Amenities: -

Price per square foot: $637

Lot Info

Zoning: -

Land Use: -

Parcel Number: 1450130820000

Flood Zone: No

Tax Info

Year Assessed: 2024

Assessed Value: $1,077,100

County Est. Land Value: -

Assessed Land Value: -

County Est. Structure Value: -

Market Estimate: $1,524,300

Schools

High School: Castle High School with 4/10 star rating