Rental Property Analysis Spreadsheet
Download REI Grove’s rental property analysis spreadsheet to evaluate purchase price, loan information, rent assumptions, expenses, cash flow, NOI, cap rate, and cash-on-cash return before buying a rental property.
Key Takeaways
- Rental property analysis helps investors evaluate a property’s potential profitability before making an offer.
- Core rental property metrics include cash flow, net operating income, cap rate, cash-on-cash return, and purchase price compared to after repair value.
- By using this spreadsheet, investors can compare a property’s projected income against expenses, debt payments, and target investment criteria.
- REI Grove’s rental property analysis spreadsheet is organized around property information, loan information, assumptions, and other relevant categorizations.
How to Analyze a Rental Property
When purchasing a rental property, investors often find themselves overwhelmed by a complex array of metrics. The answer to whether a rental property is a good purchase lies in the numbers, but it requires some digging to understand. How do you know what a good monthly cash flow is? What net operating income should you aim for? We're here to help you learn how to analyze a potential rental property purchase, why it's important, and why using a rental property analysis calculator or spreadsheet can help.
Rental Property Analysis Spreadsheet at a Glance
| Spreadsheet Section | What It Tracks | Why It Matters |
|---|---|---|
| Section 1: Property Information | Property address, year built, purchase price, ARV, list date, beds, baths, square footage, lot size, and neighborhood/school scores. | Establishes the property profile and baseline investment details. |
| Section 2: Loan Information | APR, down payment, loan amount, closing costs, and initial investment. | Shows how financing affects upfront cash needed and future returns. |
| Section 3: Assumptions | Rent, vacancy, taxes, management, leasing, insurance, repairs, CapEx, and replacement reserves. | Lets investors model expected income and recurring costs. |
| Section 4: Purchase Decision | Discount to ARV, cap rate, cash flow, cash-on-cash return, rent, and target criteria. | Helps compare the deal against investor goals. |
| Section 5: Income | Rent, vacancy factor, and total income. | Shows projected monthly and annual income. |
| Section 6: Expenses & Reserves | Property taxes, property management, leasing fee, insurance, repairs, CapEx reserve, and turn reserves. | Shows recurring operating costs and reserve planning. |
| Section 7: Debt Servicing | Monthly and annual mortgage payments. | Shows how loan payments affect cash flow. |
| Section 8: Cash Flow | Unlevered and levered cash flow. | Shows income before and after debt service. |
| Section 9: Net Operating Income | Monthly and annual NOI. | Shows income after operating expenses before debt service. |
What is Rental Property Analysis?
Rental property analysis is an integral part of any potential deal because it shows the potential profitability and risk for different properties. It's the process of examining a potential real estate deal through a variety of metrics, most notably cash flow and NOI, before making an offer on a property. It helps you understand the current or future state of a rental property — its strengths, weaknesses, and financial potential — so you can make a well-informed decision about how to best leverage it.
As part of analyzing a rental property, you may wish to also conduct a comparative market analysis. This can help you determine the fair market value of rental properties by comparing recent sales, active listings, and unsold properties. However, here we focus solely on the metrics you can glean and cash flow analysis from one property in question.
Cash Flow and Net Operating Income
Two of the most important aspects of rental property analysis are cash flow and net operating income (NOI). Each are core calculations for every investor to know because they serve as a method of calculating your potential monthly income from a property. Calculating your potential income before even purchasing a rental property sets you and your business up for success.
Cash flow is a metric of how much money your properties are earning (the gross monthly rent collected) versus how much of that money you spend on maintaining them each month. This calculation is similar to NOI but focuses on whether the flow of cash into your account is positive or negative. In other words, it measures whether you're making or losing money on an investment. Accurately estimating effective gross rental income is crucial in calculating net annual cash flow, as it directly affects the overall income when subtracting expenses to assess a property's profitability.
Net operating income (NOI), on the other hand, measures the revenue earned from a property after operating expenses like maintenance, utilities, taxes, and insurance. By subtracting these daily expenses from the gross annual rental income generated by a property, you can get a clear picture of a property's monthly earnings.
Note: It's crucial to conservatively determine market rents during the initial analysis of rental properties with both the above metrics. While anticipating high rental income may be tempting, projecting more realistic estimates and exploring various scenarios based on these figures is advisable.
Cash flow and NOI are simple, quick, and effective methods of measuring whether a potential property is a good investment for your business. They go hand in hand with other metrics like cap rate and cash-on-cash return to provide an overview of your potential profitability on a property.
Why is Rental Property Analysis Important?
So, you know what rental property analysis is, but why does it matter?
The real estate market is always fluctuating, so you must be meticulous and pay close attention to detail when deciding whether a property will be a successful addition to your portfolio. Seasoned and new investors alike can find themselves in the middle of a bad deal if they skip the math. Why do the guesswork on a rental property if you can find its pros, cons, and financial potential before you even get to a closing?
Rental property analysis can also help you learn more about yourself as an investor. What criteria matter to you? What are your target goals financially? What types of deals would meet your expectations? Practicing deal analysis can help you answer these questions and look over deals faster and more accurately.
After all, this investment isn't for your own living space — it's a form of income. If an asset is more of an expense and labor than a source of revenue, it may not be the best deal for you and your personal goals. A real estate deal analysis spreadsheet walks you through a property's profitability and risks so you can make smart decisions before you buy.
What Does the Rental Property Analysis Spreadsheet Cover?
REI Grove’s rental property analysis spreadsheet is designed to help investors evaluate a potential rental property purchase with a focus on purchase decision metrics, cash flow, and NOI. The spreadsheet includes input sections for property details, loan information, and assumptions, then uses those inputs to populate income, expenses, debt servicing, cash flow, and net operating income calculations.
This spreadsheet includes:
- Property details
- Loan details
- Assumptions
- Income & expenses
- Debt service
Section 1: Property Information
The property information section records the basic details of the rental property being analyzed. These details help investors understand what they are buying and how the property compares to their criteria.
This section includes:
- Address
- Year built
- Purchase price
- ARV
- Beds and baths
- Square footage
Section 2: Loan Information
The loan information section helps investors estimate the financing side of the deal. These inputs affect the loan amount, down payment, closing costs, initial investment, and later cash-on-cash return.
This section includes:
- APR
- Down payment %
- Loan amount
- Down payment
- Closing costs
- Initial investment
Section 3: Assumptions
The assumptions section lets investors enter expected rent and expense percentages. These numbers shape the income, expense, reserve, and cash flow projections throughout the spreadsheet.
This section includes:
- Rent
- Vacancy
- Taxes
- Management
- Leasing fee
- Additional assumptions
Section 4: Purchase Decision
The purchase decision section compares the property’s projected metrics against target criteria. This gives investors a quick way to see whether the property appears to meet their investment standards.
This section includes:
- Key return metrics like cap rate and cash flow
- Property basics such as price, rent, and size
- Comparison of proforma vs. target criteria
- Overall decision indicators
Section 5: Income
The income section estimates how much rental income the property may generate after accounting for vacancy.
This section includes:
- Monthly rent
- Annual rent
- Vacancy
- Total income
Section 6: Expenses and Reserves
The expenses and reserves section estimates the property’s operating costs and reserve needs. These recurring costs affect both cash flow and NOI.
This section includes:
- Management fees
- CapEx
- Turn reserves
- Total expenses
Section 7: Debt Servicing
The debt servicing section accounts for mortgage payments. Since debt service can determine whether a deal produces positive or negative cash flow, investors should review it alongside income and expenses.
This section includes:
- Monthly payment
- Annual payment
Section 8: Cash Flow
The cash flow section shows how much income remains after expenses and debt service. The spreadsheet separates unlevered cash flow from levered cash flow so investors can see the property before and after financing.
This section includes:
- Unlevered cash flow
- Levered cash flow
- Monthly cash flow
- Annual cash flow
Section 9: Net Operating Income
The net operating income section shows projected income after operating expenses. NOI does not include mortgage debt service, so it can be useful when comparing the operating performance of different properties.
This section includes:
- Monthly NOI
- Annual NOI
How to Do Rental Property Analysis
There are many ways to approach property analysis, and the “right” way depends on your specific goals and criteria for a new rental property. Generally, it will involve calculating important metrics like cash-on-cash return, cap rate, NOI, and ROI, as well as evaluating the overall strength of a deal based on the state of the current housing market and monthly rent trends. It takes research and skill to analyze deals by hand, so rental property analysis calculators are an alternative for these steps.
Mortgage debt service plays a crucial role in your investment's success but is not always factored into the above metrics. Cap rate, for instance, uses your property's net operating income, which is calculated before accounting for mortgage debt service. It's important to factor mortgage payments into your analysis when evaluating the income-generating capability of a property relative to its value.
Analyzing rental property deals may seem daunting, especially if calculating metrics isn't your strong suit. We get it — organizing and reviewing that many numbers can be overwhelming! That's why a rental property analysis spreadsheet that does the work for you can be a great tool for accurately assessing property cash flow. A property investment analysis spreadsheet simplifies complex calculations related to rental property finances, saving time and effort for investors.
REI Grove’s rental property analysis spreadsheet calculates key metrics for a rental property, like cash flow and NOI, and measures whether the property's potential income meets your target numbers. It also adds together totals for income, expenses (like maintenance, property management fees, etc.), and loan payments. It's designed to help you easily make choices about deals based on the provided metrics, giving you confidence in accepting the right deals and walking from the wrong ones.
Conclusion
Rental property analysis can help you become a more experienced real estate investor, and with practice, you can quickly and effectively assess whether a real estate deal meets your personal criteria for your business. A bad deal is much harder to get out of than to get into, so it's important to prepare and educate yourself on rental property deals. That way, you can easily expand your portfolio with successful, profitable properties.
Download REI Grove’s rental property analysis spreadsheet today to get started.
FAQs
What is rental property analysis?
Rental property analysis is the process of reviewing a potential rental property’s income, expenses, financing, cash flow, NOI, and return metrics before deciding whether to buy.
Why is rental property analysis important?
Rental property analysis is important because it helps investors evaluate profitability and risk before making an offer rather than relying on guesswork.
What does REI Grove’s rental property analysis spreadsheet include?
The spreadsheet includes property information, loan information, assumptions, purchase decision metrics, and income.
What is cash flow?
Cash flow is the amount of money left after the property’s rental income, operating expenses, reserves, and mortgage payments are accounted for.
What is NOI?
NOI, or net operating income, is the property’s income after operating expenses but before debt service.
What is cash-on-cash return?
Cash-on-cash return measures annual cash flow vs. initial investment.
Should mortgage payments be included in rental property analysis?
Yes, mortgage payments should be included. Mortgage payments affect whether cash flow is positive or negative.