Historical rental property performance (buy and hold)

[Demjan Van Der Kach]

Hello All! 

I would like to "learn real estate math"... :) and would appreciate some advice regarding historical performance of the rental in terms of good metrics (cap rate, cash on cash, IRR et cetera, before and after tax). I bought REALdata software (express version) from Frank Gallinelli after reading his book and presently testing it. It seems to be a decent software for future evaluation.

How about historical evaluation by plugging in 3 -5 years of data. Would be great to see the real performance. If anybody is able to share some spreadsheets or advice that would be wonderful. I am not god at MS Excel yet to program it myself. 

Thank you.