I'm looking for a pro forma or analysis tool that would help with this project.

As a seller, you just include it in the text description. 

Text me 2816622451

Then, out of the blue, my father in law sends me a text asking if we had any ventures to invest in, with nearly the same amount needed.

If you talk to more than a handful of active investors you'll probably see a rough consensus of what returns they are looking for, and from that you just have to be accurate in your analysis of a property.

You haven't included a property manager's fee (likely 10-12%) into this analysis, which implies you're planning on managing the property yourself. 

My background in AI is in the real estate industry specifically in market analytics and property analysis.

Your analysis is pretty optimistic, @Craig Mutz.

@Richie Thomas thank you for your feedback and analysis.

Since Summer of last year, I've been heavily invested in learning real estate (Podcasts, Forums, Books, Youtube, you name it), however, like many, I've had analysis paralysis for quite some time now.