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 calculations work. If anyone wants a Reddit discount, I can drop a code in the comments.