Last year my mom died suddenly and I inherited her home in SE Raleigh, NC. It’s a 3 bed 2.5 bath in the Biltmore Hills neighborhood, built in 1960. I live in a different state. Unfortunately when my mom passed, she had a scumbag boyfriend living with her. After she died, he refused to leave, even though he had zero legal claim to the home. It took 9 months and thousands upon thousands of dollars to finally get him out. When we were able to get inside, we found he had completely wrecked the place. He didn’t take a sledgehammer to the walls or anything like that, but it appears that he was some kind of hoarder. There are a dozen bicycles, half a dozen grills, piles and piles of clothes, and tons of random junk everywhere. The whole house smells like poop, but we haven’t seen any waste anywhere inside. There are large dark stains on the carpet and smears of stuff on the walls. There is a wooden back deck where he evidently kept his dog. It has trash strewn about and some piles of dog po...
I built a rental property analyzer in Excel (with a full 18-page guide) and put it on Etsy. Here is exactly what it does.
I couldn't find a rental analysis spreadsheet that didn't feel like it was built in 2003, so I made one that actually looks professional and covers everything I wanted in one place. What it is: One INPUTS sheet where you drop in the property numbers Automatic loan amortization over 30 years Dashboard with monthly cash flow, cap rate, cash-on-cash, DSCR, GRM, 1% rule, break-even occupancy 10-year projection with IRR and equity multiple at exit Sensitivity tables for purchase price vs. rent, and interest rate vs. rent Comes with an 18-page PDF quick-start guide explaining every metric If you're the kind of person who wants to see every number before making an offer, this is built for you. If you'd rather build your own, the formulas are standard — I just did the formatting and integration so you don't have to. The link is : https://www.etsy.com/listing/4547352337/rental-property-analyzer-excel-template Happy to answer questions about how any of the calcula...