Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. 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 on .

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!