How long do you ride the wave? ROE vs ROI

[Jaron Walling]

After reading, researching, and adding information for ROE calculations I realized the % goes down every year. ROE is opposite to ROI, year over year. I based my calculations conservatively for a rental property we own using a 3% rental growth, and 4% appreciation (obviously it's higher) year over year. In a ideal world at year 7 of my spreadsheet the ROI is 15.3%, and ROE is 14.98%. It crosses. I've owned the property for 4 years... would you sell/1031 the property at year 7 to buy something else?

If I adjust the appreciation (closer to 9% last year) the ROE drops significantly leading me to believe "holding" this investment doesn't make sense. Any thoughts?