Get our free rental property analysis spreadsheet for reviewing rental properties
and buy & hold investments like a pro
Try our Light Version, completely Free!
Our pre-built spreadsheet is easy to use and beginner-friendly. With it, you’ll be able to analyze any property in less than two minutes so you can review lots of potential deals very quickly
Our calculator will run them for you and will immediately tell you if a deal is worth negotiating for or if it is a non-starter
Our template includes all the most relevant measures and indicators used by professional real estate investors
As a real estate investor, you will have to look at tens or hundreds of deals before finding the one that works for you. So you need to be able to quickly identify opportunities and tailor your offer to each situation in order to get a shot against other seasoned investors
With our rental property analysis spreadsheet, analyze rental investments in less than a minute and get a detailed assessment of a property’s potential
Analyze both Single Family Houses and Multi-Family Properties
Rental income, Operating expenses, Net Operating Income, Debt service, Capex, Cash Flow…
Perform complex profitability analysis using more than 15 key financial indicators (IRR, MIRR, EMx, CoC, Cap Rate, etc.)
Automatically review the impact of multiple parameters on your profitability
Identify the maximum offering price to achieve your profitability target
Optimize your total return by selling your property at the right time
4 reports included: Summary Overview, Operating Expenses, Financing, and Debt Amortization Schedule
Tailor our template to your specific needs with our additional fully customizable sheet. You can also add your logo to our reports
Get access to an online knowledge database to help you source all the information you need
Up to 30-year operational and financial projections, with flexible drivers and multiple parameters.
Calculate Rental Income, Operating Expenses and Cash Flows over the life of your investment
Check your profitability using industry standards such as Cash on Cash Return, Cap Rate, Internal Rate of Return, etc.
Our model will let you know how to optimize your profit by selling at the right time
Track down your debt repayment on a monthly or yearly basis, over the life of your project
Determine how much goes towards principal repayment vs. interest
Know exactly how much your financing strategy is costing over the life of your investment
These mandatory ratios for lenders and financial partners (Loan To Value, Interest Coverage, etc…)
Easily print and share professional reports with investors, lenders, business partners and other professionals and get instant credibility as you advance in your real estate journey.
With all key assumptions, indicators and results
Snapshot of financing terms and lending ratios, a must-have for business partners and lenders
Detailed overview of your yearly operating costs, summarized in a clear and concise way
Get an overview of your deal and identify key takeaways in a second. Our graphs are easy to understand and easy to share:
Understand the transition from rent to cash flow
Check your property’s value and its built-in equity year after year
Visualize the value creation through Cash Flow, Property Appreciation and Principal Repayment
Let our spreadsheet guide you in the negotiation process by estimating the maximum purchase price you can offer in order to achieve your desired profitability, using multiple financial indicators:
Easily review large multi-family properties and apartment buildings with our Pro Version
Review buildings of all sizes with unlimited units and up to 10 different types of unit
Individual operating assumptions for greater customization and additional flexibility
Get a comprehensive overview of your portfolio with detailed data about all your units
Purchase it once, and keep it forever! No membership, no hidden fee or additional charge! We pride ourselves to be one of the most affordable solutions for investors
You have a question about the spreadsheet or you are facing a technical difficulty? Get in touch and we will assist you in no time!
We update our spreadsheets frequently based on users’ feedback & requests. All future updates come free of charge for our customers
Don’t take our words, check what our customers say.
Great tool! Building it myself would have taken so much time so it made sense to get it. And it’s clearly more detailed than other tools and templates I’ve used in the past.
A big thank you for the spreadsheet. I have limited knowledge of excel and I was afraid I would struggle with this one but it is actually very easy to use, even for true beginners
As a real estate agent and investor myself, I’ve been recommending it to my clients. It’s a great tool to review deals online and it saves me a lot of time on a daily basis
A very practical tool that is easy to use, even when you’re not familiar with excel and financial models in general. It’s the ultimate resource to become a successful investor
This is an amazing spreadsheet. I’ve been using it when looking at properties and get a feel for potential investments and this calculator has been helping me a lot. Highly recommend for anyone interested in real estate investing.
I’m by no means an excel guy, even less a math guy but after trying the spreadsheet, I knew it would be a great investment. And for the price, it’s an invaluable resource for any serious investor. On top of it, Nick has always been helpful when I had questions or needed guidance
I can’t imagine the hours spent to build this template and I’m thankful I won’t have to do it myself. This spreadsheet is well thought and provides great flexibility thanks to the custom sheet. Love it!
Try out our Light Version or super charge your analysis skills with the premium features of our Advanced Version
Hi there, I’m Nick Peters. Investment Banker during the day, I’m passionate about real estate and financial modeling so I decided to combine both interests and create RealEstateSpreadsheets.com to help people find better real estate deals. This free rental property analysis spreadsheet is the result of countless hours of work, and will help you make well-informed decisions before pulling the trigger on a property.
In Real Estate, money is made when you buy, not when you sell so it is important that you do the math before you close the deal. This spreadsheet is all about that: running numbers for you so you can efficiently distinguish great deals from non-performing assets.
It has been built with everything you need to analyze potential deals very quickly so I hope it will be as useful to you as it has been to me for several years now!