Skip to content
×
PRO
Pro Members Get Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. Cancel anytime
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
General Landlording & Rental Properties
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated over 8 years ago,

Account Closed
  • Financial Advisor
  • dallas, TX
17
Votes |
19
Posts

ROI 1st Time Calculation Help, Check Out My Spreadsheet Please

Account Closed
  • Financial Advisor
  • dallas, TX
Posted

I am considering buying a unit to rent out in the Fort Lee, NJ area to own for 30 years and then sell. I am looking for advice on my ROI calculations and if this is overall a good investment. There are approximately 100 identical units in my development, so I am using Zillow to figure out what it would cost to own, and how much rent is. The unit goes as high as $96,000 for a great condition interior, and rents for $1200/month with hot water included. The HOA fee of $350 per month pays for property taxes, hot water, and maintenance of everything outside of the house, some or all of which would be tax deductible to me if I owned the unit. Please comment on my ROI calculations and let me know if I did anything wrong. Specifically, I think I may have bad calculations for taxes and tax savings. Here is a link to the spreadsheet I made:

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

This is what I did to come up with the spreadsheet:

Home Value= $96,000

Up Front Costs

20% Down= $19,200

Land Transfer Tax 1% = $960

Appraisal = $300

Inspection = $100

Legal Fees = $900

Lock Charges = $250

Loan Origination Fee (1% of 96,000-19,200) = $768

Coop Application Fee: $300

Commission 3% = $2880

Title Search, Title Insurance= $875

TOTAL UP FRONT COST = $26,533

Recurring Monthly Costs

Property Tax = Covered in HOA Fee

Homeowners Insurance = $28

Maitenance (1% per year) = $80

30 year loan @ 3.45% = $343

HOA Maitenance Fee = $350

Tax Deductions = (Interest+HOA Fee)* 31 percent marginal tax rate = $174 (Savings)

TOTAL MONTHLY COST FIRST YEAR= $626

Assumptions: vacant 8% of the time, 2.3% housing price increase per year, 2.3% inflation, 2.3% rent increase per year.  I'm not planning on making money from the place appreciating in value.  

FIRST YEAR INCOME: $1200 * (1-.08) = $1104

Monthly Cash Flow Year 1= 1104-626 = $478

I then did a discounted cash flow analysis by adding 2.3% to the rent every year for 30 years and added 2.3% to all of the costs except for the loan for 30 years, and then assumed that I am selling the house in 30 years with 100% equity and the home value going up 2.3% every year for 30 years, and assumed that I'm getting charged a 31% tax on my net income each year. I then used the IRR function and it came out with a 19% return.

Thanks for the help!