Syndication VS Rental Property Calculator?

[Bruno Araujo]

Has anybody out there seen a nuts and bolts spreadsheet or calculator comparing investing in syndications versus owning a rental property over the long term?  Before I spend a week creating it, I'm hoping to get a head start.

It would need to include all of the assumptions and inputs pertaining to each including:

1) Loan details

2) Appreciation rate

3) Rental growth rate

4) Capex rate

5) Market rental rates

6) Reinvestment rate

It would have to include the amortization schedule of the loan, and include the 3 ways of making money on a rental including the principal paydown, cash flow and appreciation.  Including taxes would be great too.  All of the inputs/assumptions would be plugged in then compared to the return of a syndication.

Hoping to spit out a graph showing an easy comparison between the two. My hunch is that over the long term, the syndication is going to far outpace the rental property, especially when you consider the long term appreciation rate of the SFH. Anyway, thanks in advance for any responses!