BNBCalc Short Term Rental Investment Analysis 11170 Magdalena Rd Los Altos Hills CA 94024

5 bed • 3.5 bath • 15 guests • $4,747,300

BNB

Calc

Annual Revenue

$118,982

Profit (Cash Flow)

-$229,804

Cap Rate

1.9%

Annual Revenue

$118,982

AirDNA projects $766/night at 65% occupancy ($181,854). Airbtics projects $509/night at 64% occupancy ($118,981). Airbtics predicts this property will perform in the 48% revenue percentile

BNB Calc projects a 64% occupancy rate, $509 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$103,852	$110,197	$140,192	$173,431
Occupancy	49%	64%	80%	94%
Nightly Rate	$399	$462	$612	$755

Seasonality (Profit by Month)

Return Metrics

-20.8% 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)	-$229,803	-$459,607	-$689,410	-$919,214	-$1,149,018	-$2,298,036	-$6,894,109
Revenue Appreciation	$0	$0	$0	$0	$0	$0	$0
Home Equity	$46,637	$96,152	$148,720	$204,531	$263,784	$619,590	$3,797,840
Down Payment	$949,460	$949,460	$949,460	$949,460	$949,460	$949,460	$949,460
Property Appreciation	$142,419	$289,110	$440,202	$595,827	$756,121	$1,632,674	$6,775,643
Total Return	$908,713	$875,115	$848,972	$830,604	$820,347	$903,687	$4,628,833

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-20.8%

Cap Rate

1.9%

Return on Investment

-3.68%

11170 Magdalena Los Altos Hills, CA, 94024

5 bed • 3.5 bath • 15 guests

Purchase Price

Est. $22,770/mo

Inquire about this property

Contact Agent

$4,747,300

Zestimate

$118,982

Annual Revenue

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

Occupancy Rate

Top 51% of comparables

Avg Daily Rate

Top 31% of comparables

Seasonality

-$229,804

Profit

Revenue

$118,982

Operating Expenses

$28,548

Operating Income

$90,434

Mortgage & Taxes

$320,238

Profit (Cash Flow)

-$229,804

$1,104,754

Cash Investment

Down Payment

$949,460

Renos & Furnishing

$12,875

Closing Costs

$142,419

Total

$1,104,754

DSCR Ratio

Weak

0.28

Get a pre-qualification letter

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

-20.8%

Cap Rate

1.9%

Return on Investment

-3.68%

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

$225,312

Deductible property tax

$46,998

Your total deduction

$701,887

Your adjusted annual income

$150,000 - $701,887 = -$551,887

Taxes on -$551,887 (30%)

-$165,566

Your old tax bill

$45,000

Your new tax bill

-$165,566

Estimated tax savings

$210,566

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:

44,750 sqft

Year built:

1953

Size:

3,531 sqft

Type:

SFR

Parking:

Heating:

NONE

Sold Comparables

Address	Beds	Baths	Square Feet	$/SqFt	Lot Size	Year Built	Last Sale	Days on Market
12250 Edgecliff Pl	3	3	2,724	-	48,891	1957	$3,585,000	25
23225 Ravensbury Ave	6	4	3,161	-	36,000	1951	$5,500,000	-
24301 Elise Ct	5	6	5,469	-	131,115	2005	$16,250,500	-
12181 Winton Way	3	3	4,139	-	40,222	1966	$4,000,000	48
10703 Magdalena Rd	3	4	4,657	-	63,597	1998	$7,789,000	13
24837 Olive Tree Ln	3	3	2,891	-	43,560	1965	$4,800,000	42
25601 Fernhill Dr	6	5	3,695	-	83,635	1986	$6,100,000	42
11035 Magdalena Rd	4	4	2,565	-	43,560	1957	$6,600,000	-
24011 Jabil Ln	4	3	2,694	-	54,933	1964	$3,900,000	75
25215 La Loma Dr	4	4	2,865	-	43,754	1965	$3,900,000	-

Property Details

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

Property Use: Single Family Residence

Stories: 2

Lot size: 44,750 sqft

Building area: 3,531 sqft

Garage: Yes

Heating: None

Pool: No

Fireplaces: 1

Basement: Yes

Cooling: -

View: -

Parking: -

Amenities: -

Price per square foot: -

Lot Info

Zoning: RA

Land Use: Residential

Parcel Number: 336-40-083

Flood Zone: Yes, Zone 0.2

Tax Info

Year Assessed: 2023

Assessed Value: $228,672

County Est. Land Value: -

Assessed Land Value: $68,365

County Est. Structure Value: -

Market Estimate: $6,939,987

Sale history

Date	Sale Price	% Financed	Buyer
02/24/23	$4,431,000	56%	Rajiv Taori, Anar Taori
07/14/21	$0	0%	Mircea Dragomir, The Morrison Family Living Trust
05/24/10	$0	0%	Morrison Family Living Trust

Ownership

Name: Rajiv Taori

Owner Occupied: No

Owner Mailing Address: 11170 Magdalena Rd, Los Altos Hills, Ca 94024

Years Owned: 9

Home Equity: $1,486,000

Mortgage Balance Remaining: $2,500,000

Financed amount: -

Owner Type: Individual

Lien: No

Inherited: No

Foreclosure: No