BNBCalc Short Term Rental Investment Analysis 338 Sherwood Way, Madera, California 93638

2 bed • 2 bath • 2 guests • $10,764,900

BNB

Calc

Annual Revenue

$28,230

Profit (Cash Flow)

-$715,286

Cap Rate

0.1%

Annual Revenue

$28,230

AirDNA projects $124/night at 50% occupancy ($22,645). Airbtics projects $131/night at 59% occupancy ($28,229). Airbtics predicts this property will perform in the 44% revenue percentile

BNB Calc projects a 59% occupancy rate, $131 rate per night.

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

Percentiles	25%	50%	75%	90%
Revenue	$20,792	$29,187	$39,969	$55,788
Occupancy	48%	63%	71%	79%
Nightly Rate	$114	$121	$145	$184

Seasonality (Profit by Month)

Airbnb Comparables

Airbnb name	Revenue	Rate/night	Occupancy	Beds	Baths	Night	Cleaning	Pool	Tub	Pets	W/D	Reviews
Private 2 bedroom, 1 bath studio	$21,875	$134	43%	2	1	3	$85	❌	❌	✅	Y / Y	⭐️ 4.5 (11)
WHouse: 1950sCharm, 2Bdrms, FullyFenced, ShadyBack	$30,560	$166	49%	2	1	2	$99	❌	❌	✅	Y / Y	⭐️ 5 (23)
JHouse: 2Bbdrm/2BATHS, ShadyBackYard w/Pavillion	$25,316	$183	37%	2	2	2	$99	❌	❌	❌	Y / Y	⭐️ 5 (34)
Private 2 bedroom/1 bath, office	$22,340	$166	36%	2	1	3	$90	❌	❌	✅	Y / Y	⭐️ 5 (11)
Luxurious Country Home	$37,936	$210	48%	2	2	2	$80	✅	❌	❌	Y / Y	⭐️ 5 (119)
Charming Fig Garden Spanish style home!	$34,990	$125	71%	2	1	1	$100	❌	❌	❌	N / Y	⭐️ 5 (77)
Beautiful Spanish-Style Home	$24,823	$104	63%	2	1	1	$30	❌	❌	✅	Y / Y	⭐️ 5 (50)
Cozy 2B/1Bth w Spacious Parking inside Fence	$34,321	$117	74%	2	1	1	$75	❌	❌	✅	Y / Y	⭐️ 5 (138)
Modern clean and conveniently located Home.	$25,418	$109	59%	2	1	3	$85	❌	❌	❌	N / Y	⭐️ 5 (150)
Yosemite Home Two Bedroom with King Beds	$26,645	$91	80%	2	1	5	$0	❌	❌	❌	Y / Y	⭐️ 5 (78)
Relaxing home away from home.	$33,347	$125	71%	2	2	2	$39	✅	❌	❌	Y / Y	⭐️ 5 (148)
Central Fresno \| Cozy 2BR/1 \| Full Kitchen\|Parking	$33,663	$121	66%	2	1	1	$129	❌	❌	❌	Y / Y	⭐️ 5 (161)
The House On Farris	$26,144	$135	48%	2	2	2	$100	❌	❌	✅	Y / N	⭐️ 5 (60)
Charming Midcentury on Historical Van Ness Blvd	$33,114	$136	65%	2	1	2	$75	❌	❌	❌	Y / Y	⭐️ 5 (110)
Unique Charming Tudor Home with Spa Hot Tub	$27,318	$144	49%	2	1.5	1	$45	❌	✅	❌	N / Y	⭐️ 5 (1108)
Roomy/Comfy 2B/1Bth w Dining Room	$35,779	$115	78%	2	1	1	$75	❌	❌	✅	Y / Y	⭐️ 5 (101)
2 Bedroom home in Central Fresno CA	$21,376	$73	76%	2	1	5	$75	❌	❌	❌	N / Y	⭐️ 5 (241)
Relaxing Modern Bungalow - Central to Everything	$36,805	$121	82%	2	1	2	$30	❌	❌	✅	Y / Y	⭐️ 5 (300)
Private Farmhouse Apartment near Yosemite & Fresno	$12,865	$95	37%	2	1	2	$0	❌	❌	❌	Y / Y	⭐️ 5 (372)
The Carriage House	$25,040	$96	69%	2	1	3	$110	❌	❌	❌	Y / Y	⭐️ 5 (118)
Vintage 2 Bdrm Close to All Freeways	$33,512	$95	91%	2	1	1	$50	❌	❌	✅	N / Y	⭐️ 5 (786)
Robertson Villa 2BR Cozy Cottage with Full Kitchen	$24,935	$128	48%	2	1	1	$98	❌	❌	❌	N / Y	⭐️ 5 (243)
The Clementine 3BR-Modern Scandi-Hip Designer Home	$30,166	$119	66%	2	2	1	$100	❌	❌	❌	N / Y	⭐️ 5 (111)
Cozy Modern 2 BR Home Pet Friendly	$27,994	$158	43%	2	2	2	$120	❌	❌	✅	Y / Y	⭐️ 4.5 (109)
Bright & Cozy Home \| Best Tower District Spot	$33,696	$119	71%	2	2	1	$94	❌	❌	❌	Y / Y	⭐️ 5 (22)
Bright & Cozy Best Tower District Location	$31,892	$117	68%	2	2	1	$94	❌	❌	❌	Y / Y	⭐️ 5 (148)
Remodeled Unit in Historical Tower District	$31,573	$133	62%	2	1	1	$75	❌	❌	❌	Y / Y	⭐️ 5 (94)
Charming Mid-Century Entire Home.	$43,904	$149	79%	2	1	2	$75	❌	❌	✅	Y / Y	⭐️ 5 (182)
Cozy 2B/1Bth on Peaceful Street	$30,181	$114	68%	2	1	1	$75	❌	❌	✅	Y / Y	⭐️ 5 (49)
Designer Hip University Historic HM Fresno High	$27,567	$111	63%	2	1	1	$100	❌	❌	❌	Y / Y	⭐️ 5 (187)
The Village Condos	$22,014	$92	62%	2	1	2	$135	❌	❌	❌	Y / Y	⭐️ 4.5 (46)
Gated 2/1 mobile home with off-road parking	$31,153	$132	63%	2	1	1	$85	❌	❌	❌	N / N	⭐️ 4.5 (25)
Cozy House 2BR/1BA, Near Historic Tower District	$31,361	$119	69%	2	2	2	$90	❌	❌	❌	Y / Y	⭐️ 5 (102)
Sweet Escape at Fresno \| Pool	$37,706	$202	51%	2	2	2	$0	✅	❌	✅	Y / N	⭐️ 4.5 (17)
Cozy Fully Renovated Home	$37,513	$118	79%	2	1	1	$150	❌	❌	✅	Y / Y	⭐️ 5 (92)
Fig Garden Casita A- Trendy 2 Bedroom	$40,268	$161	64%	2	2	2	$160	❌	❌	✅	Y / Y	⭐️ 4.5 (19)
Beautiful 2 Bedroom Condo In North Fig Garden	$27,189	$117	59%	2	1	2	$130	❌	❌	❌	Y / Y	⭐️ 4.5 (36)

Return Metrics

-28.81% 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)	-$715,286	-$1,430,572	-$2,145,859	-$2,861,145	-$3,576,432	-$7,152,864	-$21,458,592
Revenue Appreciation	$0	$0	$0	$0	$0	$0	$0
Home Equity	$8,611,920	$8,611,920	$8,611,920	$8,611,920	$8,611,920	$8,611,920	$8,611,920
Down Payment	$2,152,980	$2,152,980	$2,152,980	$2,152,980	$2,152,980	$2,152,980	$2,152,980
Property Appreciation	$322,947	$655,582	$998,196	$1,351,089	$1,714,569	$3,702,225	$15,364,337
Total Return	$10,372,560	$9,989,909	$9,617,237	$9,254,844	$8,903,037	$7,314,261	$4,670,645

Property Appreciation:

Revenue Appreciation:

Cash on Cash Return

-28.81%

Cap Rate

0.1%

Return on Investment

-11.54%

338 Sherwood Way Madera, California, 93638

2 bed • 2 bath • 2 guests

Purchase Price

Est. $51,633/mo

Inquire about this property

Contact Agent

$10,764,900

Zestimate

-120

Airbnb Investor Score

-$715,286

Annual Profit

0.1%

Cap Rate

-28.8%

Cash on Cash

$28,230

Annual Revenue

This property is projected to be in the top 44% revenue percentile compared to similar properties nearby.
Projected nightly rate is $124/night at 50% occupancy.Projected nightly rate is $131/night at 59% occupancy.

Occupancy Rate

Top 63% of comparables

Avg Daily Rate

Top 38% of comparables

Seasonality

40 Airbnb Comparables

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

$29,075

Avg annual revenue

59%

Avg occupancy rate

$131

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

$10k

$20k

$35k

$45k

-$715,286

Profit

Revenue

$28,230

Operating Expenses

$17,350

Operating Income

$10,880

Mortgage & Taxes

$726,166

Profit (Cash Flow)

-$715,286

$2,482,427

Cash Investment

Down Payment

$2,152,980

Renos & Furnishing

$6,500

Closing Costs

$322,947

Total

$2,482,427

DSCR Ratio

Weak

0.01

<0>Get a pre-qualification letter</0>

Investment Value Over Time

Property Appreciation

Revenue Appreciation

Cash on Cash Return

-28.81%

Cap Rate

0.1%

Return on Investment

-11.54%

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

$510,913

Deductible property tax

$106,573

Your total deduction

$1,782,644

Your adjusted annual income

$150,000 - $1,782,644 = -$1,632,644

Taxes on -$1,632,644 (30%)

-$489,793

Your old tax bill

$45,000

Your new tax bill

-$489,793

Estimated tax savings

$534,793

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:

4.14 sqft

Year built:

2004

Size:

87,739 sqft

Type:

SINGLE_FAMILY

Parking:

Heating:

Other

Sold Comparables

Property Details

MLS Status: N/A

Property Use: SINGLE_FAMILY

Stories: -

Lot size: 4.14 sqft

Building area: 87,739 sqft

Garage: No

Heating: Other

Pool: No

Fireplaces: -

Basement: No

Cooling: Central

View: -

Parking: -

Amenities: -

Price per square foot: $122

Lot Info

Zoning: -

Land Use: -

Parcel Number: 003160025000

Flood Zone: No

Tax Info

Year Assessed: 2024

Assessed Value: $11,083,841

County Est. Land Value: -

Assessed Land Value: -

County Est. Structure Value: -

Market Estimate: $10,764,900

Schools

High School: Matilda Torres High with 6/10 star rating