BNBCalc Short Term Rental Investment Analysis 23 Columbia Way

2 bed • 2 bath • 6 guests • $900,000

BNB

Calc

Annual Revenue

$61,843

Profit (Cash Flow)

-$20,588

Cap Rate

4.5%

Annual Revenue

$61,843

AirDNA projects $332/night at 51% occupancy ($61,843). Airbtics projects $311/night at 65% occupancy ($73,834). Airbtics predicts this property will perform in the 48% revenue percentile

BNB Calc projects a 51% occupancy rate, $332 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$37,007	$83,205	$108,076	$144,497
Occupancy	49%	71%	78%	86%
Nightly Rate	$201	$315	$368	$448

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
Plum Royale Jr: Cozy Plum Is. home w/beach access	$70,148	$356	51%	2	1	4	$205	❌	❌	❌	Y / Y	⭐️ 4.8 (46)
My Dream house with views of the marsh and sunset	$53,830	$194	70%	2	1	2	$85	❌	❌	❌	Y / Y	⭐️ 5 (341)
The Upper Boulevard!	$49,357	$182	72%	2	1	5	$125	❌	❌	❌	Y / Y	⭐️ 4.8 (38)
Plum Island renovated cottage	$48,390	$276	45%	2	1	1	$85	❌	❌	❌	Y / Y	⭐️ 4.8 (63)
Moonshadow. A Quaint Beachside Loft near Beach	$49,374	$355	38%	2	1	3	$0	❌	❌	❌	Y / Y	⭐️ 5 (58)
The Lower Boulevard	$57,158	$170	89%	2	1	4	$125	❌	❌	❌	Y / Y	⭐️ 4.8 (39)
The Pearl: Steps to Beach, Wildlife Refuge	$123,033	$372	86%	2	1	3	$151	❌	❌	❌	Y / Y	⭐️ 5 (53)
Come visit beautiful plum island!	$64,410	$224	76%	2	2	5	$150	❌	❌	❌	Y / Y	⭐️ 4.8 (55)
Sunset Bliss a Plum Island Oasis- Beach 3 min walk	$129,700	$437	79%	2	1	5	$120	❌	❌	✅	Y / Y	⭐️ 4.8 (101)
Ocean Front house on Plum Island	$100,105	$551	49%	2	2	2	$150	❌	✅	✅	Y / Y	⭐️ 4.7 (3)

Return Metrics

-9.64% 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)	-$20,587	-$41,175	-$61,762	-$82,350	-$102,938	-$205,876	-$617,629
Revenue Appreciation	$0	$0	$0	$0	$0	$0	$0
Home Equity	$720,000	$720,000	$720,000	$720,000	$720,000	$720,000	$720,000
Down Payment	$180,000	$180,000	$180,000	$180,000	$180,000	$180,000	$180,000
Property Appreciation	$27,000	$54,810	$83,454	$112,957	$143,346	$309,524	$1,284,536
Total Return	$906,412	$913,634	$921,691	$930,607	$940,408	$1,003,648	$1,566,906

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-9.64%

Cap Rate

4.45%

Return on Investment

7.14%

23 Columbia Way Newbury, Massachusetts, 01951-2011

2 bed • 2 bath • 6 guests

Purchase Price

Est. $4,317/mo

Inquire about this property

Contact Agent

$563,700

Zestimate

$61,843

Annual Revenue

This property is projected to be in the top 48% revenue percentile compared to similar properties nearby.
AirDNA projects $332/night at 51% occupancy ($61,843.11). Airbtics projects $311/night at 65% occupancy ($73,834).

Occupancy Rate

Top 61% of comparables

Avg Daily Rate

Top 41% of comparables

Seasonality

10 Airbnb Comparables

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

$74,550

Avg annual revenue

65%

Avg occupancy rate

$311

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

$45k

$75k

$100k

$130k

-$20,588

Profit

Revenue

$61,843

Operating Expenses

$21,720

Operating Income

$40,124

Mortgage & Taxes

$60,711

Profit (Cash Flow)

-$20,588

$213,500

Cash Investment

Down Payment

$180,000

Renos & Furnishing

$6,500

Closing Costs

$27,000

Total

$213,500

DSCR Ratio

Weak

0.66

Get a pre-qualification letter

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

-9.64%

Cap Rate

4.45%

Return on Investment

7.14%

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

$42,715

Deductible property tax

$8,910

Your total deduction

$105,021

Your adjusted annual income

$150,000 - $105,021 = $44,979

Taxes on $44,979 (30%)

$13,494

Your old tax bill

$45,000

Your new tax bill

$13,494

Estimated tax savings

$31,506

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:

3,720 sqft

Year built:

1943

Size:

3,051 sqft

Type:

SFR

Parking:

Heating:

FORCED AIR

Sold Comparables

Address	Beds	Baths	Square Feet	$/SqFt	Lot Size	Year Built	Last Sale	Days on Market
2 Oconnors Ct	2	2	1,362	-	3,598	1981	$764,900	55
4 4th St	2	2	1,566	-	4,639	1940	$1,155,000	-
10 Brock Ave	2	1	3,134	-	7,675	1940	$1,009,000	175
47 Northern Blvd	3	3	3,611	-	12,423	1950	$1,079,000	145
34 Old Point Rd	1	1	700	-	4,901	1960	$830,000	-
12 Annapolis Way	3	2	2,033	-	9,675	1981	$775,000	-
16 Hutchins Rd	3	1	2,406	-	4,552	1925	$0	-
8 Jackson Way	2	1	1,186	-	2,762	1952	$650,000	-
7 Donnas Way	1	1	2,000	-	4,901	1955	$0	-
59 Northern Blvd	3	2	2,533	-	4,569	1875	$0	-

Property Details

MLS Status: property-details-mls-status-sold

Property Use: Single Family Residence

Stories: 2

Lot size: 3,720 sqft

Building area: 3,051 sqft

Garage: No

Heating: Forced air

Pool: No

Fireplaces: 0

Basement: No

Cooling: -

View: -

Parking: -

Amenities: -

Price per square foot: -

Lot Info

Zoning: AR4

Land Use: Residential

Parcel Number: NEWB M:0U02 B:0000 L:00107

Flood Zone: Yes, Zone AREA OF MINIMAL FLOOD HAZARD

Tax Info

Year Assessed: 2024

Assessed Value: $815,900

County Est. Land Value: -

Assessed Land Value: $551,000

County Est. Structure Value: -

Market Estimate: $1,179,516