All
Members
Companies
Blog
Forums
Podcast
Webinars
    User Log in  /  Sign up
  • Forums
    Newest Posts Trending Discussions Followed Forums Real Estate News & Current Events General Landlording & Rental Properties Buying & Selling Real Estate Deal Analysis See All
  • Education

    Read

    BiggerPockets Blog BPInsights: Expert Analysis Guides Glossary Reviews Member Blogs

    Watch

    Webinars Video Library Financial Independence Blueprint Intro to Real Estate: Rentals

    Listen

    BiggerPockets Real Estate Podcast BiggerPockets Money Podcast BiggerPockets Business Podcast Real Estate Rookie Podcast Daily Podcast (Audio Blog)

    Topics

    Business Operations Finance Finding Deals Property Management Property Types Strategy
  • Network

    Recommended Vendors

    Real Estate Agents Mortgage Lenders Companies Hard Money Lenders Contractors Investment Companies

    Search

    Members Events Jobs
  • Tools

    Calculators

    Rental Property Fix and Flip BRRRR Rehab Estimator
    Wholesaling Mortgage Payment 70% Rule Airbnb

    Services

    BPInsights: Property Insights Tenant Screening Property Management Lease Agreement Packages

    New Feature

    BPInsights (beta)

    Quickly analyze a property address or ZIP Code to compare your rent in your neighborhood.

    Analyze a property
  • Find Deals
    Real Estate Listings Find Foreclosures External Link Ads, Jobs, and Other
  • Bookstore

    Real Estate Books

    Profit Like The Pros Bidding to Buy See all books

    Featured Book

    BiggerPockets Wealth Magazine book cover
    BiggerPockets Wealth Magazine

    Written by financial journalists and data scientists, get 60+ pages of newsworthy content, expert-driven advice, and data-backed research written in a clear way to help you navigate your tough investment decisions in an ever-changing financial climate! Subscribe today and get the Oct/Nov issue delivered to your door!

    Get the Magazine
  • Pricing
Log In Sign up
User
Quick search links
Podcast Hard Money Lenders Books Washington
ForumsArrowShort-Term and Vacation Rental DiscussionArrowAnalyzing STR using spreadsheet
  • Newest Posts
    • Newest Posts
    • Unanswered Discussions
  • Trending
    • Top Discussions
    • Trending Discussions
  • Browse Forums
Search Nova
Create post

Analyzing STR using spreadsheet

10 Replies

  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subject:
Team
  • Posts 54
  • Votes 11

Katharine Gonzalez
Investor from Goshen, NY

posted 16 days ago

In the market for another STR and wondering if anyone has a spreadsheet that calculates STR deals? Or, how do you decide whether or not to purchase a STR?

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subjects:
Rentals, Flipping, and Managing Tenants
  • Posts 167
  • Votes 125

Tom Wagner
Investor from Boston, MA

replied 16 days ago

Great question, and I am also looking for a good STR calculator. Might just build one myself, so if anyone has an awesome one please quote this message and let me know!

In terms of inputs I would look at occupancy, seasonality and average daily rates. In the Northeast there are lots of areas with year round interest - hiking and outdoors in the summer, skiing in the winter.

Rotate Log in or sign up to reply
user profile avatar
  • Posts 17
  • Votes 10

Nancy Bender
Investor from South Carolina

replied 16 days ago

On the Vrolio website you can find a very good one

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subjects:
Team and Residential
  • Posts 683
  • Votes 345

Nancy Bachety
Rental Property Investor from Sag Harbor, NY

replied 16 days ago

Here you go. Someone posted this a while ago. I find it quite useful, maybe you will too. 
https://docs.google.com/spread...


Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subject:
Team
  • Posts 54
  • Votes 11

Katharine Gonzalez
Investor from Goshen, NY

replied 16 days ago

Came across this video 

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subject:
Team
  • Posts 54
  • Votes 11

Katharine Gonzalez
Investor from Goshen, NY

replied 16 days ago

Just discovered this on Evolve, just not sure how accurate/useful it may be...

https://evolvevacationrental.c...

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subject:
Team
  • Posts 54
  • Votes 11

Katharine Gonzalez
Investor from Goshen, NY

replied 16 days ago

@Nancy Bachety thanks going to check it out.

Rotate Log in or sign up to reply
user profile avatar
  • Posts 37
  • Votes 16

Frank Luna
Real Estate Coach from Riverside, CA

replied 16 days ago

@Katharine Gonzalez @Katharine Gonzalez I think the best approach is to first make sure it make sense first as a regular rental property especially with all the rules governing what the city bans them and you need to convert to a regular rental.

https://www.airdna.co/airbnb-calculator

Rotate Log in or sign up to reply
user profile avatar
  • Posts 37
  • Votes 16

Frank Luna
Real Estate Coach from Riverside, CA

replied 16 days ago
I would be sure the STR would work as a regular rental as well due to all the regulations being imposed. I've seen people acquire a STR and then the city shut em down due to changes made.

@Katharine Gonzalez https://www.airdna.co/airbnb-c...

Rotate Log in or sign up to reply
user profile avatar
  • Posts 37
  • Votes 16

Frank Luna
Real Estate Coach from Riverside, CA

replied 16 days ago

@Katharine Gonzalez

https://www.airdna.co/airbnb-calculator

Rotate Log in or sign up to reply
user profile avatar
Check Rosette Top Subject:
Team
  • Posts 54
  • Votes 11

Katharine Gonzalez
Investor from Goshen, NY

replied 16 days ago

@Frank Luna excellent point, thanks!

Rotate Log in or sign up to reply
  • 1
Related Resources Short-Term and Vacation Rental Discussion
5 Questions to Ask Yourself If You’re Considering DIY Property Maintenance
How Much to Charge for Rent in 2021: A Landlord’s Guide
The Ultimate Guide to Lease Renewals
Landlords Should Require Renters Insurance—Here’s Why
Have Top-Notch Tenants? Here’s How to Keep Them
Resources Read, see, and learn more!
Link Real Estate Investment Calculators
Link BiggerPockets Blog
Link Path to Purchase
Link Mortgage Loans
Link Find a Contractor
Link Real Estate Agents
Link Hard Money Lenders
Link Real Estate Listings

Top Contributors

Michael Elefante
Michael Elefante
Nashville, TN
9.43
Score
John Underwood
John Underwood
Greer, SC
4.32
Score
Paul Sandhu
Paul Sandhu
The worst town to live in, KS
3.76
Score
Luke Carl
Luke Carl
Tennessee Florida
3.65
Score
David Stokley
David Stokley
Cleveland, OH
1.65
Score

Short-Term and Vacation Rental Discussion Trending Discussions

  • Air Bnb in a not So Great Neighborhood
    11 Replies
  • Must have to drive revenue for AirBnB/VRBO?
    10 Replies
  • What ROI you expect on Airbnb
    8 Replies
  • Just outside of Gatlinburg, Sevierville, and Pigeon Forge
    4 Replies
  • Airbnb in Naples, FL
    4 Replies
Log in Sign up

Log in

Forgot password?

If you signed up for BiggerPockets via Facebook, you can log in with just one click!

Log in with Facebook

Or
btn_google_dark_normal_ios Created with Sketch. Continue with Google

Let's get started

We just need a few details to get you set up and ready to go!

Use your real name

Use at least 8 characters. Using a phrase of random words (like: paper Dog team blue) is secure and easy to remember.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.

Or
btn_google_dark_normal_ios Created with Sketch. Continue with Google

Why create an account?

Receive a free digital download of The Ultimate Beginner's Guide to Real Estate Investing.

Connect with 1,000,000+ real estate investors!

Find local real estate meetups and events in your area.

Start analyzing real estate properties, we do the math for you.

It's free!

Explore

  • Membership
  • Community
  • Education
  • Marketplace
  • Tools
  • FilePlace
  • REI Resources
  • Perks
  • Glossary
  • Reviews
  • iOS App
  • Android App

Company

  • About Us
  • Press
  • Advertising
  • Careers
  • Stats
  • Contact Us

Important

  • Editorial Guidelines
  • Terms of Use
  • Rules
  • Privacy
  • FAQ

Social

  • Facebook
  • Twitter
  • YouTube
  • Instagram
© 2004-2021 BiggerPockets, LLC. All Rights Reserved.