Skip to main content

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

submitted by /u/Some-Whole-4636
[link] [comments]

source https://www.reddit.com/r/RealEstate/comments/1vcipqj/i_built_a_rental_property_analyzer_in_excel_with/
Labels:

Comments

Post a Comment

Popular posts from this blog

North Carolina – “One to Buy; Two to Sell”

I realize I will likely have to contact a real estate attorney but also hoping to hear insights and experiences from others! I have a house in NC that I bought by myself in 2009, and paid off, in full, in 2022. I got married in 2023. My spouse and I have not lived in the house as our "marital residence". We have maintained separate residences even after we got married. (That a separate topic!). I am now selling this house. Realtors have told us that my husband has to sign the deed at time of transfer but I am not convinced since the house has not been our marital residence. The realtors like to use the phrase "one to buy; two to sell", which seems like a broad-stroke statement which is not applicable under all circumstances. And of course, the realtors don’t realize the details of my specific circumstances: I purchased and paid for the house in full prior to marriage Only my name is on the deed And most importantly, we have never lived in the house as a marit...
Post a Comment
Read more

Looking for Prospective Opportunities to Utilize Floor Plan Redraw Skills

"Hey HomeOwners & Investors , I have a team of 10 professionals who are trained in redrawing/redesign floor plans in both 2D and 3D interior& exterior using floorplanner.com/3ds Max and TruView point cloud. We're looking for prospective opportunities to utilize our skills. Are there any companies or individuals in need of accurate floor plans and measurement reports ? Any suggestions for where to start looking? Thanks in advance for your help!" submitted by /u/mangojuicelife [link] [comments] source https://www.reddit.com/r/RealEstate/comments/119uoh0/looking_for_prospective_opportunities_to_utilize/
Post a Comment
Read more

Question With Tricon "Pending ID".....

My wife and i, along with 2 other peopl applied to rent a house, and our application says "Approved, Pending ID". Anyone else know what that means? Do we pretty much have the place or are we missing something? submitted by /u/Itskrueger [link] [comments] source https://www.reddit.com/r/RealEstate/comments/1orixqj/question_with_tricon_pending_id/
Post a Comment
Read more