BNBCalc Short Term Rental Investment Analysis 500 Walnut St # 6

4 bed • 7 bath • 16 guests • $25,900,000

BNB

Calc

Annual Revenue

$68,439

Profit (Cash Flow)

-$1,700,670

Cap Rate

0.2%

Annual Revenue

$68,439

AirDNA projects $316/night at 88% occupancy ($101,567). Airbtics projects $347/night at 54% occupancy ($68,439). Airbtics predicts this property will perform in the 47% revenue percentile

BNB Calc projects a 54% occupancy rate, $347 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$55,197	$68,211	$77,568	$114,713
Occupancy	43%	53%	70%	75%
Nightly Rate	$240	$302	$435	$479

Seasonality (Profit by Month)

Return Metrics

-28.49% 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,700,670	-$3,401,340	-$5,102,010	-$6,802,680	-$8,503,350	-$17,006,701	-$51,020,103
Revenue Appreciation	$0	$0	$0	$0	$0	$0	$0
Home Equity	$20,720,000	$20,720,000	$20,720,000	$20,720,000	$20,720,000	$20,720,000	$20,720,000
Down Payment	$5,180,000	$5,180,000	$5,180,000	$5,180,000	$5,180,000	$5,180,000	$5,180,000
Property Appreciation	$777,000	$1,577,310	$2,401,629	$3,250,678	$4,125,198	$8,907,434	$36,966,098
Total Return	$24,976,329	$24,075,969	$23,199,618	$22,347,997	$21,521,847	$17,800,732	$11,845,994

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-28.49%

Cap Rate

0.17%

Return on Investment

-11.21%

500 Walnut St Philadelphia, Pennsylvania, 19106

4 bed • 7 bath • 16 guests

Purchase Price

Est. $124,227/mo

Inquire about this property

Contact Agent

$2,260,800

Zestimate

Philadelphia

Guide

Zoning

Market

Guide

Laws

Market Data

$68,439

Annual Revenue

This property is projected to be in the top 47% revenue percentile compared to similar properties nearby.
AirDNA projects $316/night at 88% occupancy ($101,567.05). Airbtics projects $347/night at 54% occupancy ($68,439).

Occupancy Rate

Top 41% of comparables

Avg Daily Rate

Top 41% of comparables

Seasonality

-$1,700,670

Profit

Revenue

$68,439

Operating Expenses

$21,977

Operating Income

$46,462

Mortgage & Taxes

$1,747,132

Profit (Cash Flow)

-$1,700,670

$5,968,750

Cash Investment

Down Payment

$5,180,000

Renos & Furnishing

$11,750

Closing Costs

$777,000

Total

$5,968,750

DSCR Ratio

Weak

0.03

Get a pre-qualification letter

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

-28.49%

Cap Rate

0.17%

Return on Investment

-11.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

$1,229,241

Deductible property tax

$256,410

Your total deduction

$7,207,124

Your adjusted annual income

$150,000 - $7,207,124 = -$7,057,124

Taxes on -$7,057,124 (30%)

-$2,117,137

Your old tax bill

$45,000

Your new tax bill

-$2,117,137

Estimated tax savings

$2,162,137

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:

18,155 sqft

Year built:

2017

Size:

5,700 sqft

Type:

CONDO

Parking:

Heating:

NONE

Sold Comparables

Address	Beds	Baths	Square Feet	$/SqFt	Lot Size	Year Built	Last Sale	Days on Market
815-37 Arch St # 721	3	-	1,142	-	0	2007	$439,900	-
1100 Vine St Apt 709	1	1	592	-	0	1900	$175,000	34
1101 Locust St # 7e	1	1	620	-	0	2007	$270,000	222
306 S 13th St Apt 7	2	2	1,116	-	1,116	1900	$287,500	28
201 N 8th St Unit 414	1	1	1,007	-	0	1970	$295,000	95
1100 Vine St Apt P301	2	1	1,127	-	0	1900	$280,000	154
1100 Vine St Apt 519	2	1	759	-	0	1900	$210,000	62
1100 Vine St Apt 1501	2	1	1,127	-	0	1900	$325,000	47
500 Walnut St Unit 1600	3	4	4,300	-	18,155	2017	$5,000,000	159
500 Walnut St Unit 202	2	2	1,650	-	18,155	2017	$1,775,000	61

Property Details

MLS Status: N/A

Property Use: Condominium

Stories: 1

Lot size: 18,155 sqft

Building area: 5,700 sqft

Garage: No

Heating: None

Pool: No

Fireplaces: 0

Basement: Yes

Cooling: -

View: -

Parking: -

Amenities: -

Price per square foot: -

Lot Info

Zoning: CMX4

Land Use: Residential

Parcel Number: 88-8-5012-16

Flood Zone: No

Tax Info

Year Assessed: 2023

Assessed Value: -

County Est. Land Value: -

Assessed Land Value: -

County Est. Structure Value: -

Market Estimate: $665,936

Schools

High School: Furness Horace High School with 1/10 star rating