by Matt Kastner One of the most important things every investor needs to do before purchasing a property is a profitability analysis. At first glance, many deals seem great, but upon further review turn out to be anything but ideal. You just can’t tell for sure until you do the numbers. That’s where this spreadsheet might come in handy.
If you have Microsoft Excel (or OpenOffice), this financial spreadsheet is a good example of the kind of analysis you can perform. It’s particularly useful when scrutinizing deals as you can quickly determine if a property is worth further research by plugging in a few numbers. Simply enter the rents, expenses and financing and it figures out how profitable the investment will be.
Of course, this is a very simplified spreadsheet. It does not account for major repairs, appreciation or tax benefits. However, it should give you a realistic snapshot of an investments potential.
I like to pay particular attention to both return on investment (ROI), which considers real-world financing scenarios, and the always popular cap rate. The percentage ROI return tells you how much money you will get back in a given year for the money you put it, while the cap rate is the yearly return assuming the property was purchased with cash.
You can download this spreadsheet for yourself by clicking on this link: Rental Property Analysis. Hope it comes in handy. Please notee that this spreadsheet is an example only. It is notIf you have any questions or comments of the spreadsheet, please contact me.
