אקסל מעניין שהכין חבר בפורום הנדל”ן של Reddit לחישוב החזרים על השקעתו. מה דעתכם?
אקסל מעניין שהכין חבר בפורום הנדל”ן של Reddit לחישוב החזרים על השקעתו. מה דעתכם?
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 that closing costs when buying could range from 2-5%.
I doubled it to account for costs when I eventually 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 looked 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, whether
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, is that a
reasonable expectation for real estate?
submitted by /u/MattyAyOh
[visit reddit]
[comments]
——————————————————————
Fri, 01 Mar 2019 10:51:33 +0000
קבוצות דיון נדלן מארצות הברית – פוסט מתורגם אוטומטית – גרסא אנגלית
לפרסום שאלות בנושא נדל”ן בארצות הברית הצטרפו עכשיו לקבוצת נדל”ן ולעניין – פורום נדל”ן ארצות הברית:
https://www.facebook.com/groups/ForumNadlanUSA/
——————————————————————
את התגובות המקוריות לפוסט ניתן לקרוא בתחתית דף הפוסט הנוכחי באתר או בקישור לפוסט בפייסבוק וכמובן שאתם מוזמנים להצטרף לדיון
Responses