Real Estate Deal Analysis & Advice
Market News & Data
General Info
Real Estate Strategies
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/hospitable-deef083b895516ce26951b0ca48cf8f170861d742d4a4cb6cf5d19396b5eaac6.png)
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_trust-2bcce80d03411a9e99a3cbcf4201c034562e18a3fc6eecd3fd22ecd5350c3aa5.avif)
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_1031_exchange-96bbcda3f8ad2d724c0ac759709c7e295979badd52e428240d6eaad5c8eff385.avif)
Real Estate Classifieds
Reviews & Feedback
Updated 12 months ago on . Most recent reply
![Omosalewa Aderonmu's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/1278935/1621510924-avatar-omosalewa.jpg?twic=v1/output=image/cover=128x128&v=2)
Google Sheet Rental Property Calculator
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
Most Popular Reply
![Jon Crosby's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/473772/1721868449-avatar-jcsacto.jpg?twic=v1/output=image/crop=914x914@0x20/cover=128x128&v=2)
Nice job @Omosalewa Aderonmu! I like your prototype so far.
CoCROI should just be: (total yearly cash flow)/(total cash to acquire). So in your example above something like: (4820)/(12000) = 40% (Year 1). Some people don't include the repairs in the first year Cash on Cash return however, not sure what the BP one does.
You can look at your 'stabilized' cash on cash as well using ProForma numbers and estimating the rent and expense growth over the next X number of years.
I personally don't like pay too much attention to ProForma as I can't predict the future so I usually just like to know if cash flow is good AND more importantly if I'm financing, if the DSCR (debt service coverage ratio) is high enough to safely qualify for financing (usually above 1.2).
Best of luck and keep up the innovation and learning!