General Landlording & Rental Properties
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,
ROI 1st Time Calculation Help, Check Out My Spreadsheet Please
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!