An interesting Excel prepared by a member of the Reddit real estate forum for calculating the return on his investment. what do you think?
An interesting Excel prepared by a member of the Reddit real estate forum for calculating the return on his investment. what do you think?
Looking at buying a home to rent out, did research and built a spreadsheet to help me figure out investment returns. What do you guys think?
First, here's the link to my spreadsheet
I may have gotten a lot wrong, I have no idea, but I'm just
curious what you guys think about it.
Context: Looking to buy a 270-282K house, 3,000 Sq Ft.
Agent says I can get 2200-2400 a month from rent for it. Zenstimate
says 2000. So on the sheet, I used 2000 and 2400 for worst and best
CASE
I guessed closing costs when buying could range from 2-5%.
I doubled it to account for costs when I ever sell, as well
as agent costs? So my worst case cost is looking like 10%, and
that's what I use as my baseline cost of investment
I think looking at the monthly costs, calculating against a 3.5%
and 4% interest rate. I looked at how much of my mortgage payments
would go to principal, and used that principal as "revenue"
On the bottom left are my final profit / investment tables
Are there any variables that I am missing, or that I have gotten
wrong?
Some things I already thought of:
What will happen to the value of the house over time, wherever
that goes up or down it's hard for me to say
missing months of rent, in between finding tenants, probably on
average one month a year without rent?
I used the "1% rule" that 1% of the house should be set aside
every year for fixing it up. This came to 225 a month. Not sure if
this is accurate
Bold numbers are the numbers that can be changed on the sheet,
the rest is computed from those cells
I am looking for a return on investment after 5 years, that is a
reasonable anticipation for real estate?
submitted by / u / MattyAyOh
[visit reddit]
[comments]
----------------------
Fri, 01 March 2019 10: 51: 33 + 0000
Real estate newsgroups from the United States - post automatically translated - English version
To post questions about real estate in the United States now join the Real Estate Group and interest - United States Real Estate Forum:
https://www.facebook.com/groups/ForumNadlanUSA/
----------------------
The original responses to the post can be read at the bottom of the current post page on the site or in the link to a post on Facebook and of course you are invited to join the discussion
Responses