ROE calculation on Excel

[Fran Arti]

Hi, mates:

Hope you and your loved ones are safe and healthy. And your businesses thrive!

I have been doing some calculations about exit strategies for multifamily property investments and dont know how to use excel to display a graphic (only numbers will be awesome too), that, when I fill in the spreadsheet with all the data for one of the planned alternatives, to see when the best time to refinance/sell because of the ROE.

Can you guys shed some light about this?

Thanks!