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!

https://docs.google.com/spreadsheets/d/1TVjRWaD6nsnJxrTPuNOBA9alBH0oop9AMucX5ZDcBhE/pubhtml

iframe src="https://docs.google.com/spreadsheets/d/1TVjRWaD6nsnJxrTPuNOBA9alBH0oop9AMucX5ZDcBhE/pubhtml?widget=true&headers=false"/iframe

Thanks for your help!

Konrad

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

Thanks

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): http://www.realestateanalysisfree.com/.

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