Quote from @Greg Scott:
I've seen a half dozen different spreadsheets like this but the key is knowing how they are set up because they will behave slightly differently based on the formulas and assumptions baked into the sheet.
She said about 5 times, the best way is to join a mentorship program. I agree. A mentorship program can provide you a spreadsheet and show you how to use their version.
Hey Victor! I agree with Greg—there are many different variations that exist with slightly differing formulas, modeling, and assumptions. They also heavily depend on the type of MF investing/underwriting. Are you referring to residential MF or commercial MF? If it’s residential, you could use the BP tools or as Jeff referenced, DealCheck (free); however if you’re inquiring about the commercial space then the level of underwriting should be something geared towards that. My suggestions:
1) Join a mentorship program
2) Search on Udemy for a course on CRE MF underwriting — they can work with you on building out a spreadsheet and is very cost effective (and you can learn the foundational pieces of the modeling).
3) I like Hayden Crabtree’s underwriting program—and, it’s very reasonably priced!
Send me a message if you want to discuss more.
Enjoy!