@Stephanie Soltero; Got it through a wholesaler. You're not alone, that is a difficult aspect to analyzing deals. Many of the larger wholesalers will provide an ARV and a rehab estimate, which is generally in the ballpark. I use that to quickly do a "Screening"-if I find something that stands out. Here's how I approached it:
Phases of Screening:
1. "Sniff Test": Ballpark rehab, ARV, and rents. Soon you will be able to do this without a spreadsheet. (5-10 minutes) Should be able to look through and scan dozens in a couple of hours.
2. Phase I: More detail, ask an agent for comps, ballpark rehab, get property tax from assessor, 20-30 mins
3. Diligence: Evaluate area, schools, other factors in purchasing investment
4. Offer: Visit house and verify rehab is what is estimated, make offer, put down deposit.
Stephanie, this is how I approached it. It's not easy, but hopefully, it gets you evaluating many properties in order to be able to move quickly when the opportunity is right.