Offer price calculator/estimator

[Andrew Angerer]

Hey everyone, I am a huge excel/google sheets nerd and I have made a few spreadsheets for myself, partially to help teach myself how certain rules and variables of REI work, partially to streamline looking at deals.

I have recently built one, for the purpose of deciding on what could be a good offer price for a multifamily unit. I borrow the wisdom from the book ABC's of Real estate investing  by Ken McElroy (Rich dad). Specifically in chapter 7 he explains that after verifying ACTUAL income and expenses, that to find how much the property is actually worth, divide the NOI by the CAP rate and this will give you the number you should offer.

I understand that bigger pockets has many helpful calculators, but I thought that there wasn't one that quite fit what I was looking for, especially if you do not know the ARV.  Plus, this is a super simple calculator to use to funnel out bad properties.

I am looking for feedback as to what you all think! If you like it, feel free to use it.

https://docs.google.com/spreadsheets/d/1CAIJQ1bBFa...

[Account Closed]

@Andrew Angerer Good start! Feel free to steal some of the formulas and fields to mine if for properties where you're itemizing the expenses a bit more! It's pretty easy to use and I keep it open all day as I have deals come through our pipeline to figure out what I want to buy it for, and what I can sell it to my investors for in order to meet ROI criteria.

https://docs.google.com/spreadsheets/d/1TNfoOYJWE-A3DVtzav_V5oYWM_IQhUbsfZZ6U1W5vDE/edit#gid=0