Comparing Apples and Oranges -Syndications vs. SFR/Duplex

[Cj Powderhorn]

Hi! I know some of you are calculator and spreadsheet gurus! Has anyone developed or have a comparison tool that they use for taking a set amount ($100K) and looking at the benefits of each. I assume I'd use a 5-7 year term. Right now I primarily invest in the Memphis area and have had great cash flow but not so much appreciation so I wouldn't factor that into the equation. Thanks very much for any suggestions or ideas. I saw some posts covering Syndications vs JV vs REITs and SF vs MF but I didn't see anyone asking this! Thanks! :)