Google Sheet Rental Property Calculator

[Omosalewa Aderonmu]

BP Family!

Thanks for your help in advance and thanks to the BP team for providing this platform.

Just on the course of getting to understand how well my investment is going to work well for me and give me a good ROI.

So today, I decided to create a rental property calculator from scratch in google sheet or to be sincere, I'm yet to save all up for the PRO member fee. Smile.

Is it a good deal? Is it a good cash flow? What is a good round number? Still some unanswered questions.

I think I'm beginning crunch the numbers; to understand these numbers, but got stuck on calculating the Cash-on-Cash ROI percentage for this listing. Need help with the values/numbers for these metrics for this listing. Cash on Cash ROI, Pro Forma Cap Rate and Purchase Cap Rate.

GOOD DEAL is only based on Monthly Cashflow greater than $200 but I really want to factor in the Cash on Cash ROI metric. Help!

Thanks for your help!

~Steazy