Welcome to The Vacay & Co Real Estate – Short Term Rental Cash Flow Spreadsheet
This tool allows investors to quickly and effectively evaluate a potential short term rental investment property.
Thinking of adding a short term rental or Airbnb to your investment portfolio?
Unsure of how to go about analyzing your potential deals? There are many metrics that can be used to analyze whether a particular property will be an ideal short term rental investment.
The three key evaluation metrics are: cash on cash return, cap rate, and net annual cash flow.
In most cases, these metrics will not be provided by sellers. Oftentimes, the only data provided by sellers is the gross annual income and a list of utility costs. This leaves investors to guess on occupancy rate and other potential expenses.
What if the property has never been used as a short term rental? What if it has been underperforming under current management?
What if the seller has not kept comprehensive records of the property’s expenses and rental performance?
This short term rental cash flow calculator can help bridge the gaps to estimate the three major evaluation metrics: cap rate, cash on cash return, and net annual cash flow.
Take control of your short term rental analysis with The Short Term Shop’s Short Term Rental Cash Flow Spreadsheet.
The occupancy rate, capex amount, and maintenance fees are adjustable to accommodate a variety of market conditions, and to allow investors to analyze as conservatively or aggressively as desired.
Enter the data that pertains to your deal into the blank spaces to calculate your potential short term rental’s cash flow, cap rate, and annual cash on cash return.
Rental Property Investments
Are you interested in adding a short term rental property to your investment portfolio? Short term rental investment has changed quite a lot over the years with the advent of Airbnb.
For a real estate investor, short term rentals can offer passive income, but how do you determine if a property will bring you the desired return on investment?
The Short Term Shop’s rental property calculator can help you determine if a short term rental property will generate enough cash flow to be worth it in the long run.
Benefits Of Short Term Investment Properties
Short term properties are advantageous because they offer the opportunity for a higher monthly income, especially with a property address in a popular vacation zip code.
You can earn more than double the monthly rent than what you would earn with a single tenant.Another benefit is that short term properties are generally better maintained. Most property owners have the place cleaned entirely before a new guest arrives.
This frequent turnover can allow property management to find maintenance issues early on.
As a property owner, you are able to adjust the rates often to handle high season renters and tourism.
How To Calculate Rental Income
Our rental property calculator is how you will determine if you stand to make any money from a particular short term rental property.
There are a couple of different methods that can be used to determine if a rental property will bring the desired return on investment.
The main methods are the capitalization rate calculation and the cash on cash return calculation.
Capitalization Rate Calculation
The capitalization rate, or cap rate, is used when a real estate investor pays for the property fully in cash.
The cap rate is determined by the ratio of the net operating income (NOI) and the purchase price of the property.
The net operating income is defined as the rental income minus the operating expenses.
For example, let’s say that you purchased a rental property for $200,000 including closing costs and remodeling.
Let’s say that your tenants $1,200 in monthly rent. That brings your total yearly cash flow to $14,400.
If you want to calculate a more realistic rate of return, then you should subtract about $2,000 for property insurance, property management, and other costs.
Now, to find the cap rate you should divide the yearly return of $12,400 by the purchase price.
‘Then, multiple it by 100%.Cap Rate = ($12,400/$200,000)x100% = 6.1%
Your rental property will have a rate of return of 6.1%.
Cash On Cash Return Calculation
This method of calculation is used when investors take out a loan or mortgage to pay for the property.
The cash on cash return takes the ratio of a rental property’s annual net operating income divided by the total amount of actual investment in the property.
For instance, let’s take the same figures from above for this calculation. Let’s say that you bought took out a mortgage with a 20% down payment for a $200,000 property.
You should also add about $2,000 extra for closing costs since underwriting a mortgage will make them higher.
That means that your initial cash investment is $42,000.
You should keep in mind the monthly mortgage payments and interest rates.
For this example, we will assume that your monthly mortgage payment is $700 and your tenant pays $1,000 in monthly rent.
Your annual cash flow is $3,600.
Now, you can divide your annual rent amount by the total cash actually invested into the property.Cash On Cash Return = ($3,600/$42,000)X100% = 8.6%
So, your cash on cash return rate for that particular rental property is approximately 8.6%.
Does This Rental Property Calculator Also Calculate Cap Rates?
Vacay & Co Real Estate rental property calculator can determine the cash on cash return and the cap rate for a potential investment property.
In many cases, the seller will only provide a short list of operating expenses and earnings, like utilities and gross annual income, for you to look over before you decide to make a deal.
Investors then have to guess other important details or dig further in order to get an accurate picture of the actual potential return on investment.
What’s A Good ROI For A Rental Property?
The typical ROI for a long term rental property is anywhere from 4 to 10%, and anything above 12% is considered well above average.
Short term properties typically yield higher return rates of around 10 to 15%.
There are many different theories as to what is the appropriate return on investment (ROI) for a rental property.
Cap rates vary from city to city and even neighborhood to neighborhood.
The key point should be to compare like against like when shopping for a new property investment opportunity. This method is often called the Sales Comparison Approach (SCA).
It is used by many appraisers and real estate agents.
The SCA method is a simple comparison of homes in the area that have similar features.
For example, if you compare a single-family home with other single-family homes in the neighborhood, then you should make sure that they have the same features.
The number of bedrooms, bathrooms, and square footage is a good place to start.
Getting Income From Rental Properties?
One simple approach to understanding the potential income from an investment property is the gross rent multiplier (GRM).
This method takes the gross annual income from rental payments and divides it by the purchase price.
This method does not take into consideration the net operating income, so it should not be used by itself for calculating possible profit.
The income from rental properties is solely dependent on having tenants in the building. The occupancy rate is the ratio of the total amount of space available and the space that is rented.
A higher occupancy rate will yield a greater rate of return for the investor.
A few of the factors that go into your occupancy rate are guest reviews, location, marketing strategy, and seasonal changes.
Investment Property Analysis: Factors To Consider
Location is still everything when it comes to conducting a property analysis.
You should look for rental properties that are located in areas of high value.
Proximity to the best schools is a huge deciding factor for people with children, which makes the property location value skyrocket.
Other location benefits are proximity to major highways, access to amenities, access to local shopping centers, and scenic views.
You should work up a preliminary valuation sheet of the property in which you are interested.
You can do this by evaluating the neighboring houses or rental properties using the SCA method, which we discussed earlier.
If all of the properties in the nearby area have appreciated and had a high ROI, then it might mean that your investment will do the same.
Expected Cash Flow
Cash flow is the true backbone of what makes a good investment.
You should consider the expected cash flow by evaluating the income after all of the expenses are paid.
You should consider the monthly rental income with added inflation costs.
You should also consider any remodeling costs, longtime appreciation, mortgage rates, and any potential depreciation.
This question is simple, what do you plan to do with your investment property?
You should decide on your purpose and plan accordingly. If you plan to buy and rent the property, then you will need to hire a property management company or handle the property yourself.
If you plan to buy and sell the property, then you have to consider the property value and any additional renovations.
Cash Purchase vs Mortgage Loan
In general, purchasing in cash offers more control to the buyer and greater return rates.
The advantages of a cash purchase include no interest rates, no mortgage payments, and no closing costs.
You won’t have to pay mortgage origination fees and appraisal fees.
You would also own the property outright, so it is much easier to sell. By paying in cash, you are also more attractive to sellers.
If you present a cash offer that is slightly under the asking price versus someone who comes in with a loan offer, then you might get the better deal.
Overall Real Estate Market
One critical component of real estate investing is the overall real estate market.
You should consider if it is a buyer’s, seller’s, or renter’s market before you invest. Ideally, you want to buy low and sell high.
You should evaluate the current loan term, mortgage rates, general property values, home prices, home sales, foreclosures, and new construction.
Start your short term rental investment search in the proven Orlando market today! Contact us: firstname.lastname@example.org for your FREE Consultation today.
What Is A Good Profit Margin On Rental Property?
Before you get started in real estate investing for rental properties, you should consider the profit margin that you could potentially make after factoring in all of the appropriate values. The general rule of thumb is that a potential 2% profit margin is reasonable and would make a rental property a good investment. In simple terms, if your rent is 2% of the purchase price, then you should generate a positive cash flow.
Keep reading to see how we dive into the particulars of this theory.
Does The 2% Rule Make Sense?
If you can charge 2% of your purchase price in rent, then you will make a profit.
That is the very simplistic analysis of the 2% rule.
But, is it actually realistic and feasible to follow that logic?
Many new investors swear by this rule, but let’s find out if it actually makes sense.
Let’s look at a quick example of the 2% rule in action.
If you purchase a property for $200,000, then according to the rule you should be generating $4,000 in monthly cash flow. Now, that seems a little steep to me.
This rule is purely an estimation of numbers that should be calculated exactly when looking at a rental property.
The 2% rule does not factor in location, property taxes, and insurance, so we think it is best used as a guideline.
In the current climate for real estate investment, a new rule has come into play. This rule is called the 1% rule of thumb.
It is similar to the 2% rule but more realistic in terms of other factors. In our opinion, if you hold a property to the 1% rule and it passes, then it might be worth using a rental calculator to crunch the numbers even further.
When To Use A Rental Spreadsheet Calculator
In our opinion, there is never a wrong time to use a rental calculator. It can serve as a guide for actual potential net cash flow.
We do not recommend only relying on a rental calculator since some factors cannot possibly be included, such as location.
Our rental Spreadsheet offers a space for factoring in almost everything else so that you can determine if a property is a sound investment.
You should always ask for multiple opinions when you are considering purchasing a property, however.
At Vacay & Co Real Estate we pride ourselves on our work ethic and the ability to provide resources to Orlando property investors so that they can be armed with all the knowledge they need to make a good investment.
Our rental property calculator provides you with a cash on cash return rate and a cap rate calculator so that you can determine what is best for you and your investment portfolio.
It also allows you to factor in maintenance, property management, monthly operating income, booking fees, utilities, and financing costs.
We hope this information was helpful and that our rental property Spreadsheet helps you determine if owning a rental property is the right move for you.