Investor · Sarasota, FL · Member since 2008 · 17k+ posts · 17k+ votes
As another test of the new BP file vault, and to give back to the BP community, attached is the spreadsheet I use to evaluate single family house rentals.
In general, the red colored fields are the inputs you probably want to change, and everything is based on those parameters.
If you have any questions, feel free to post them in this thread, and I'll try to answer them...
Please consider this copyrighted by me, though you are free to use it in any way you wish as long as you don't try to profit from it...
I am new to the site and I apologize if it is right in front of me but I can not find the attachment with the spreadsheet. Can you please inform me of where to look?
Philadelphia, PA · Member since 2013 · 3 posts · 0 votes
13y
Hey J Scott, just downloaded your file and noticed a slight error:
For the expenses as a % of gross income cell, you have the expense % being calculated off of the rental income, not off of the gross income. I don't think it affects any calculations anywhere, but I was messing around with the expense numbers and noticed the issue
Cave Creek, AZ · Member since 2013 · 1 post · 0 votes
13y
Thanks for making your spreadsheet available. When you calculate total ROI, I can see where you capture payments against principal but it doesn't appear that you factor in market appreciation. Did I miss it or is this by design?
Investor · Sarasota, FL · Member since 2008 · 17k+ posts · 17k+ votes
13y
Originally posted by Bryan Hartlen:
Thanks for making your spreadsheet available. When you calculate total ROI, I can see where you capture payments against principal but it doesn't appear that you factor in market appreciation. Did I miss it or is this by design?
I don't factor in appreciation in the spreadsheet as I don't believe it's predictable over any significant period of time...
Bristol , RI · Member since 2013 · 6 posts · 1 vote
12y
I was wondering if this sheet could also be used to evaluate houses with multiple units by changing the monthly rental income to what would come in from all units. I am very new to this site and real estate investing. I would like to thank you for the time you put into this site to make learning easier for someone like me who is just starting out.
I was wondering if this sheet could also be used to evaluate houses with multiple units by changing the monthly rental income to what would come in from all units. I am very new to this site and real estate investing. I would like to thank you for the time you put into this site to make learning easier for someone like me who is just starting out.
Thanks Frank...
Yes, you can certainly use this for multi-unit analysis. You'd just need to aggregate the income and the expenses from all the units...
Bristol , RI · Member since 2013 · 6 posts · 1 vote
12y
Thanks for the clarification. I had a couple of questions if you would take the time to help me out.
I see the monthly maintenance and repairs listed at 1200 per month. This does not look to be a function but rather an input amount. I understand that things like landscaping and cleaning services will be a constant with the occasional larger furnace and roof jobs required. I have a lot of confusion in calculating this number due to the 50% rule and many other % rules I hear about in the forums. In all honesty it confuses me. Could you tell me how you calculate this cell if you were evaluating a property?
Also I am not sure what variable cost pm and fixed rate pm is?
Or maybe you have exceeded the download quota allotted to non-paying members; in that case, you can try again in a few days (there is some small time period that is attached to the download allotment limit).
Singapore, Singapore · Member since 2013 · 40 posts · 2 votes
12y
Thanks a lot for this @J Scott! It's awesome.
Just a question. Can you give an example of Variable Cost PM & Fixed Cost PM?
Again, thanks a lot for this. I did my own excel using your Real Estate Analysis blog post and the results on my excel are very close to yours. Just wondering about those 2 variables and how they fit into the whole picture.