Please Review My Speedy Property Analyzer

3 Replies

I made this google sheets property analyzer but I have a feeling my equations are wrong and it is driving me up the wall, that I'm not seeing what it is that I am missing.  Help would be greatly appreciated!

iframe src=""/iframe

Thanks for your help!


If you would like to directly edit this test version let me know and I can email you it.  


try this link

I want to know where in America you buy a piece of property for $100K and rent it out for $24,000 per year.  Even if I assume 5% property tax ($5,000) and $1,000 for insurance, that equals $18,000 in net income (assumes no mortgage cost), or a cap rate of 18%.  I know investors in southern CA that would buy those properties by the truck load with cash.  Without seeing how your formulas are calculated, I can't tell you where you're going wrong.  You basically want you want your analysis to mimic the actual real estate transactions.  There are many detailed analyzers, so I wouldn't waste your time developing your own unless you plan on doing something different than the normal investor (which is what I do).  Here is a free one (I have not evaluated it at all):

God Bless You!

Hi Michael, the numbers I put in the spread sheet are not real properties, just easy round numbers, to see where I was going wrong.  Thanks for sending me the link for the other calculators,  Ill compare and them with mine.  I am trying to achieve a fast workflow where as most calculators I see are slow and cumbersome to use, without the ability to compare past properties that I have evaluated.

Thanks again!

Free eBook from BiggerPockets!

Ultimate Beginner's Guide Book Cover

Join BiggerPockets and get The Ultimate Beginner's Guide to Real Estate Investing for FREE - read by more than 100,000 people - AND get exclusive real estate investing tips, tricks and techniques delivered straight to your inbox twice weekly!

  • Actionable advice for getting started,
  • Discover the 10 Most Lucrative Real Estate Niches,
  • Learn how to get started with or without money,
  • Explore Real-Life Strategies for Building Wealth,
  • And a LOT more.

Lock We hate spam just as much as you

Join the Largest Real Estate Investing Community

Basic membership is free, forever.