I was reading over an old blog post by J. Scott

[Paul Honen]

Hey everyone,

I was reading this blog post by J. Scott: 

https://www.biggerpockets.com/blog/2010-06-30-introduction-to-real-estate-analysis-investing

And it outlined some calculations for multifamily homes (COC, NOI, Cap Rate, ect.) and I decided to make an excel sheet that would give them to you if you provide the inputs. I know BP has some calculators that help out, but I don't think they calculate these directly (or maybe they do, I don't really know).

Anyway, I thought it might be useful for newbies trying to get some analytics on some trial house deals. Of course you would need to know what all the metrics mean, but that is in the blog post.

https://drive.google.com/file/...

As I'm also a newbie, take the calculations with a grain of salt. Let me know if there is anyway to improve this sheet, or if it is unavailable as I might need to make a new link.

Thank you everyone,

Paul