Advice/feedback on what a great NOI/CapRate sheet looks like

[Cheryl Faber]

Long time creeper first time poster here! I’m a new realtor listing my first property, one of my personal investment properties from the 6 SFHs I currently manage in Boise, ID. I want to give potential investors all of the information they would like at a glance and I’ve made a spreadsheet I’d love to get some seasoned vet feedback on! If I can post an Excel spreadsheet on here I’m not sure how so if I could email it to you I’d super appreciate any advice! Otherwise some bullet points on the “must includes” would be wonderful!!

Thanks in advance!!

[Mitch Messer]

Hi @Cheryl Faber this is a great question, and one I wish more agents listing investment property would ask!

For me, it would help tremendously to see:

• Fair market rent
• Annually property taxes
• Estimated property insurance
• Fair market value
• Other operating expenses
• Net operating income
• Projected cash flow
• Projected cash-on-cash return

For the record, capitalization rate ("cap rate") is a measure of a particular real estate market, so it isn't helpful for analyzing a single-family deal. This post does a great job of explaining why: https://www.biggerpockets.com/...