newbie in need of help - 3bed/1.5bath property for $139,900

newbie in need of help - 3bed/1.5bath property for $139,900

New to Real Estate · Newtown, PA · Member since 2020 · 1 post · 0 votes

Hi there! My name's Alexa and my family has been buying rental properties for about 7 years now. I'm in college and recently have been learning more about rental properties and everything it takes to run them, find deals, etc. I found another property near the ones we own and wanted to analyze it using an excel spreadsheet. I found a few different templates on the internet but settled on a semi-simplistic one that I think (emphasis on think) I've filled out correctly. I wanted to see if the deal was good before bringing it to my father, but I just reconstructed the spreadsheet, and the questions I asked confused him a bit which confused me. He tends to group insurance and taxes into escrow(?) but I placed them in an expense/cost section along with water/sewer, trash, heat, electric, vacancy, management, maintenance, and capex. Here is the information I entered on the property: 

Purchase Price $139,900.00
Closing Costs $8,000.00 (number came from my father - i originally put 3,000 but apparently 8k was his average closing cost for past properties)
Rehab Costs $2,000.00 (really nice property, I just added this in as a buffer but im also inexperienced in estimating rehab costs...:/)
Down Payment $27,980.00 (20%)
Total Investment $37,980.00
Amount Borrowed $111,920.00
Unit 1 (3 bed/1.5 bath) $525.00 (rent we charge for our other properties) 3 $1,575.00

there's also a garage that I didn't know how to work into the numbers, or if it even should be worked in

Total Investment Loan Investment Interest Rate(%) # of Payments Monthly Payment Notes
$37,980.00 $111,920.00 4.88% 360 (30 yrs) ($592.29) Amortized Loan
Total $671.25 (month) $8,055.00 (annual)
Water/Sewer $40.00 $480.00
Trash $62.50 $750.00 every 6 months (750/2)
Taxes (iffy on these #s) $267.50 $3,210.00
Insurance (iffy here too) $65.00 $780.00
Heat $- $- tenants pay
Electric $- $- tenants pay
Vacancy  $78.75 $945.00 (5% of Income)
Management (we manage) $- $- (10% of income)
Maintenance $78.75 $945.00 5% of Income
Capex (roof, etc.) $78.75 $945.00 5% of Income
Income Expense Mortgage Monthly Cashflow Yearly Cashflow ROI
$1,575.00 $671.25 $(592.29) $311.46 $3,737.52 9.84%

This ROI seems low. In some bigger pockets videos I've heard it should be above 10% and some will only move forward if the percentage is up near 20. I'm hoping all my numbers are right. It was difficult figuring out the property tax and insurance - there were different numbers listed so I got confused. I'd be super grateful for any help on this, or just someone to confirm I ran my numbers correctly or am headed in the right direction:)

0Reply
37 views

1 Reply

Jump to latestLatest
  • Investor · Downers Grove, IL · Member since 2015 · 1k+ posts · 955 votes
    6y

    I would leverage your dad for his expertise in the area. As long as both of you are including insurance + taxes in your calculation, it shouldn't matter whether you escrow or not.

    Double check with your county on the property taxes, and ask your current insurance agent for a more accurate estimate on the insurance.

    In your area, is the landlord responsible for paying trash? if not, then push it on the tenant.

    By the way, what is the ARV, and the approximate age of the major components of the house? if they're older, you may want to set aside more for your CAPEX.

Join the conversationCreate a free account to reply, vote on answers and follow this thread.