La calculadora de propiedades de alquiler definitiva

Este artículo contiene una calculadora de propiedades de alquiler simple y avanzada que le permitirá modelar cualquier acuerdo para pronosticar rápidamente los rendimientos potenciales con confianza.

En los últimos años, he aumentado mi cartera de bienes raíces desde un pequeño complejo de 4 viviendas que pirateé hasta 22 apartamentos con un valor de más de $ 1.6 millones de dólares.

Mientras aumentaba mi cartera, miré cientos, si no miles de negocios, y una cosa quedó muy clara: invertir en bienes raíces es un juego de números y el flujo de caja es el rey.

Si puede proyectar el rendimiento de una propiedad de alquiler y puede comprender exactamente cuánto flujo de efectivo tendrá después de su hipoteca y gastos, puede crear una cartera exitosa.

Sin embargo, comprender cómo se comportará una propiedad de inversión puede ser muy difícil sin las herramientas adecuadas.

Las propiedades que se ven bien y parecen ser un buen negocio a menudo terminan siendo malas inversiones que le harían perder dinero cada año si cometiera el error de comprarlas.

Una excelente calculadora de propiedades de alquiler elimina las conjeturas al pronosticar su flujo de efectivo y hace que sea mucho más fácil hacer crecer una cartera rentable.

En este artículo, le daré una de las herramientas más importantes en la caja de herramientas de cualquier inversionista de bienes raíces: un modelo financiero para propiedades de alquiler que pueda respaldar.

Rental Property Calculator

Advanced Rental Property Calculator (free)

The calculator above is a great resource to quickly check if a rental property has the potential to be a good investment, but is still missing some important information you’d want if you’re seriously evaluating a property for purchase.

If you’re interested in taking a deeper dive on a property, I built a more advanced calculator that also shows you:

• A breakdown of expenses by category
• Purchase and Pro-forma cap rates
• Income-to-Expense Ratio (the 1% rule)
• Gross Rent Multiplier
• Debt-Service-Coverage Ratio
• Charts that show projected income, expenses, and cash flow projections for the next 30 years
• The ability to add in leasing fees
• The ability to add in additional income (laundry, RUBS, etc)

Here is what the output of this tool looks like.

You can get this tool for free by entering your email address in the form below, and a link will appear that takes you to a Google Sheet with this calculator. Simply make a copy of it, and you have an incredible resource to model investment properties!

If you’re a new investor and are a bit nervous about understanding how to make sense of this tool — don’t worry! I’ve included a video tutorial in which I walk you through exactly how to use this calculator to model a real property,
and talk through all of the inputs and outputs on the calculator.

Video Walkthrough — Modeling An Actual Deal

In this video I use the advanced calculator to model a real deal I found on Zillow, and talk through how I estimate expenses using just listing photos, and decide whether a deal is worth further diligence.

What Is a Good Return for a Rental Property?

When it comes to investing in real estate, a “good” return can be very different based on each individual investor and their goals.

Some investors are looking for cash flow, while others are simply looking to break even on cash flow and make their money through appreciation in value and tax write-offs.

My partner and I invest in the St. Louis market and our strategy is to mostly buy properties on “the fringe” — areas that have good cash flow
with a lot of potential for appreciation in the next five or so years.

For these properties we’re aiming for above a 15% cash-on-cash return, and we’re looking for deals that we can refinance and pull out all of our capital once we finish renovations and leasing (the BRRRR Strategy).

However, when hunting for deals in nicer areas, I generally look for properties that meet the 1% rule, where monthly rents are 1% or greater than the purchase price of the property, and cash-on-cash returns are above 8.5%.

It’s worth noting that the 1% rule is just a guide and doesn’t apply to all markets. In fact, you should ignore it completely for anything that rents for less than $700, as you would want closer to a 1.5% or 2% number for a deal with lower rents to pencil out.

How Do Expenses Change On Bigger Properties? (Don’t make this mistake)

One the most common mistakes new investors make is not accurately modeling expenses for their properties. I think a lot of this comes from some of the advice out there that recommends simply modeling certain percentages of rent for repairs and capital expenditures.

This is an incredibly dangerous way to model your rental properties and will almost always be wrong.

For example, a 1,000-square-foot house in Seattle and a 1,000-square-foot house in St. Louis are going to have similar expenses for maintenance (roof, sewer, painting, etc), but drastically different rents.

One property might rent for $2,500 and the other for only $700. If we were to do a “standard” 10% for repairs, our Seattle house would have a yearly escrow of $3,000 for repairs, and our St. Louis house would only have $840 set aside for repairs.

With this in mind, one of the most important things you need to learn to use this model successfully is how to accurately predict expenses. When I was a new investor, this was one of the hardest things for me to learn.

With time, you will be able to look at pictures of a listing online and analyze the condition of a property, along with what repairs it will likely need in the future — and add that into the model.

You can see this in action in the graphic above and view some related articles on how to accurately forecast renovations and repair expenses below.

Cash-on-Cash Return vs Capitalization Rate

Real estate investors will often debate which metric is more important: Cash-on-cash return or cap rate.

They are both very important, but for different reasons. Depending on the goals for your investment, one metric will be more important than the other.

Cash-on-cash return is a great metric for investors that are looking for cash flow, as it’s easy to understand that a 20% cash-on-cash return of a $100,000 investment yields $20,000 per year.

It’s also easy to compare to the stock market, although this can be a bit misleading, as real estate income is generally tax advantaged compared to dividends earned in the stock market, and doesn’t take appreciation into account.

However, more experienced investors often focus on cap rate, as it allows them to make a larger amount of money faster. One simple way to think about cap rate is the amount an investor will pay today for a future revenue stream.

If you buy a property that trades at an 8% cap rate, then raise the net operating income of the property by $5,000, you can divide that by the 8% cap rate. You’ve just generated $62,500 in value!

Good investors that are able to increase net operating income (NOI) are often able to achieve several years of cash flow in value created through forced appreciation.

Personally, I look for properties that cash flow when I buy them, but have tons of room to increase income, so I can benefit from forced appreciation and capture that equity through a refinance in the future.

Glossary Of Key Rental Property Terms

Term	Definition
Cap Rate	Capitalization rate, or cap rate for short, is the annual yield of a property – What percentage of the purchase price would it return every year if you purchased it in cash
Net Operating Income (NOI)	How much income does the property generate after all non mortgage expenses
Debt Service Coverage Ratio	How much free cash is available to pay debt obligations.
Gross Rent Multiplier (GRM)	Gross Rent Multiplier is the number of years it takes for a property’s gross rents to equal the purchase price.
Amortization Term	The total length of time it takes to payoff a loan
Vacancy Rate	What percentage of the time is your property vacant

Related Articles