Hello @Zeina Awad,As others in this thread have stated, where to invest depends on your financial goals.

What I'm hoping for is an Excel or spreadsheet template that allows me to play around with these variables and, most importantly, calculates the IRR and TIR for each scenario.Does anyone have a board or Excel sheet they use for this kind of investment simulation?

I am pretty sure you can not do a 1031 and use the proceeds to do anything to a primary residence.

A 5000+ sqf Triplex located in the Tremont Area of Cleveland.

An appraiser will try to choose properties nearby that have sold in the past 6 months. 

What I am looking for at my age, is properties that will flow in the future to fund retirement travel, and MTR is where I am headed.But the reason for this post is I now need a structure(s) for what had been a concept. 

NOT a good idea to have one PMC managing a property and another trying to sell it.Human nature is to comete, so they will do so by fighting and trying to make the other look bad.

I’m looking into purchasing a property at auction.

I have a 2.5% interest rate on the balance of the mortgage. 

At this point, they are doing most likely what others here didn't think was possible, and probably something they failed at.