BNBCalc.com Investment Analysis Report of 309 S Colorado St

5 bed • 3 bath • 10 guests • $1,131,800

BNB

Calc

Return Metrics

-13.27% cash on cash return is a poor return over the next 1 year

Investment Value Over Time

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-13.27%

Cap Rate

3.54%

Return on Investment

3.22%

Annual Revenue

$61,796

AirDNA projects $371/night at 44% occupancy ($59,622). Airbtics projects $419/night at 54% occupancy ($82,640). Airbtics predicts this property will perform in the 48% revenue percentile

Revenue Percentile

Percentiles	25%	50%	75%	90%
Revenue	$50,179	$75,664	$116,018	$170,545
Occupancy	45%	53%	59%	73%
Nightly Rate	$295	$378	$516	$616

Seasonality (Profits By Month)

Airbnb Comparables

Airbnb name	Revenue	Rate Per Night	Occupancy	Beds	Baths	Guests	Night	Cleaning	Pool	H.Tub	Pets	W/D	Reviews	Host
A Spacious Ranch Style Home w/ Cinema Room	$62,397	$286	51%	5	4	14	1	$410	❌	❌	✅	N / Y	⭐️ 4.7 (29)	Profile
B The Frisco Greek Villa \| POOL \| Sleeps 16-18	$94,281	$539	46%	5	2	16	2	$235	✅	❌	✅	N / Y	⭐️ 5 (27)	Profile
C Super Clean 5 BR HomeGreat 4 FamiliesADA Access	$124,440	$425	80%	5	4	12	2	$0	❌	❌	❌	N / Y	⭐️ 5 (129)	Profile
D The Frisco Sass in Grayhawk	$61,691	$380	42%	5	4	10	1	$250	❌	❌	❌	N / Y	⭐️ 4.8 (6)	Profile
E Pool & hot SPA, 5 Bed 3.5 Bath sleeps 16 people~	$60,393	$224	71%	5	4	15	1	$200	✅	✅	✅	N / Y	⭐️ 4.9 (33)	Profile

Operating Expenses

Monthly Expenses

$1,809

Annual Expenses

$21,713

Utilities

$440

Internet + TV

$100

Water/Sewer

$70

Garbage

$50

Electric

$115

Gas

$55

Other

$50

Maintenance

$1,215

Property Insurance

$150

HOA

Landscaping

$150

Ongoing Repairs

$150

Supplies

$150

Software

$50

Pest Control

$50

Permits

Other

Cleaning Cost

$515

Management & Platform Fees

$154

Platform Fee (i.e. Airbnb)

$154

Property Manager Fee

Mortgage & Taxes

Monthly Mortgage & Tax

$6,362

Annual Mortgage & Tax

$76,344

Downpayment

Purchase Price

$1,131,800

Percent Down

20%

Total Downpayment

$226,360

Total Loan Amount

$905,440

Monthly Loan Payment

Mortgage Length

30 years

Interest Rate

Monthly Loan Payment

$5,429

Property Tax Yearly

0.99%

Property Tax Monthly

$934

Mortgage Insurance (PMI)

Property Details

General Info

Lot size:

28,998 sqft

Year built:

1914

Size:

5,090 sqft

Type:

SFR

Parking:

Heating:

Central

Sold Comparables

Address	Beds	Baths	Square Feet	Lot Size	Year Built	Last Sale
718 W Elm St	-	NaN	0	7,248		$0
201 W Ash St	3	2	1,400	8,276	1960	$0
308 E Main St	1	1	672	7,305	1930	$0
522 S Arizona Dr	2	2	1,150	21,832	1959	$0
612 W Sycamore St	3	2	1,686	11,326	1965	$0
569 S Utah St	4	3	2,775	13,504	2023	$0
551 Tolleson Dr	4	2	2,265	10,202	2008	$0
251 Stefhanie Dr	3	2	1,312	10,071	2001	$0
401 Badlands Trl	4	2	2,212	10,803	2017	$0
307 S Louisiana St	3	2	1,277	5,820	1940	$0

Property Details

MLS Status: N/A

Property Use: Single Family Residence

Stories: 2

Lot size:28,998 sqft

Building area: 5,090 sqft

Garage: -

Heating: Central

Pool: No

Fireplaces:

Basement: No basement

Lot Info

Zoning: -

Land Use: Residential

Parcel Number: R-1023-023-0070-1

Flood Zone: Yes, Zone AREA OF MINIMAL FLOOD HAZARD

Tax Info

Year Assessed: 2023

Assessed Value: $638,427

County Est. Land Value: $210,000

Assessed Land Value: $210,000

County Est. Structure Value: $428,427

Market Estimate: -

Ownership

Name: James Mcilroy

Owner Occupied: Yes

Owner Mailing Address: 309 S Colorado St, Celina, TX 75009

Years Owned: 0

Home Equity: -

Mortgage Balance Remaining: $0

Financed amount: -

Owner Type: Individual

Lien: N/A

Inherited: N/A

Foreclosure: No

Tax Calculator (USA)

Tax Calculator (US Only)

Example Income

$150,000

Example Income Tax Rate

30%

Taxes paid on $150,000

$45,000

If you buy this investment property, your est deduction will be...

Deductible mortgage interest

$53,716

Deductible property tax

$11,205

Est. Depreciation Value

$507,086

Profit on this property

$40,083

Your total deduction

$531,925

So, your new taxable income is your previous income minus your total deduction ($150,000 - $531,925)

-$381,925

Your old tax bill

$45,000

Your new tax bill

-$114,578

Estimated tax savings

$159,578

309 S Colorado St Celina, Texas, 75009

5 bed • 3 bath • 10 guests

Purchase Price

Est. $5,429/mo

Inquire about this property

Contact Agent

$1,131,800

Zestimate

$61,796

Annual Revenue

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

Occupancy Rate

Top 101% of comparables

Avg Daily Rate

Top 101% of comparables

40 Airbnb Comparables

Identify properties similar to yours in terms of amenities and interior design. Then adjust your Occupancy Rate and Average Daily Rate to match.

Revenue per year

$0k

$100k

$195k

$300k

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

-13.27%

Cap Rate

3.54%

Return on Investment

3.22%

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

$53,716

Deductible property tax

$11,205

Your total deduction

$186,492

Your adjusted annual income

$150,000 - $186,492 = -$36,492

Taxes on -$36,492 (30%)

-$10,948

Your old tax bill

$45,000

Your new tax bill

-$10,948

Estimated tax savings

$55,948

Maximize the depreciation value on your tax returns. Get $50 off cost segregation reports with code BNBCALC at DIYCostSeg.com