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.
Starting Out
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 about 9 years ago,

Account Closed
  • San Francisco, CA
1
Votes |
11
Posts

Feedback Request: Practicing Property Assessment

Account Closed
  • San Francisco, CA
Posted

Since I'm super new to REI I figured it would be a good idea to start going on Trulia, finding example properties and playing around with numbers in a spreadsheet so I could get some feedback from the community to see what I missed, how far off my assumptions are, and to ask some questions (at the bottom of the post). Constructive feedback is greatly appreciated!

DISCLAIMER: I have no intention of actually buying this property, and anyone looking at this post should take this as a face-value exercise that I did for my own education. 

Here's a link to the spreadsheet: https://docs.google.com/spreadsheets/d/1p1_bi0JjtR...

Property Info

Address: 418 Melvenia St, Indianapolis IN 42619

Assessment From 2015: $47,200

Asking Price: $52,500

Gross Operating Income:

Monthly Rent: $650/mo

Vacancy: -$65/mo (10% of rent)

Total GOI: $585/mo

Operating Expenses:

Real Estate Taxes: -$47/mo (taken from Trulia)

Insurance: -$13/mo (taken from Trulia)

Property Management: -$58.50 (10% of GOI)

Repair Fund: -$58.50 (10% of GOI)

Utilities: $0.00 (utilities in tenant's name)

HVAC Maintenance: -$8.33 ($100 annually)

Accounting / Legal: -41.67 ($500 annually)

Misc: -$12.50 ($150 annually)

Total Operating Expenses: -$239.50/mo

Net Operating Income

$585 GOI - $239.50 Operating Expenses = $345.50/mo

Mortgage

Downpayment: $10,500 (assuming the asking price $52,500 is the purchase price)

Mortgage: $42,000 30 year fixed

Interest Rate: 5% (mortgage calculators default to 3.92% so I bumped it up)

Monthly Payment: -$228/mo

Monthly Profit 

NOI - Mortgage = $117.50 (NOI - Mortgage)

Cap Rate (NOI / Purchase Price)

$4146 Annual NOI / $52,500 Purchase Price = 7.9%

Cash on Cash (Profit / Investment)

$1,410 Annual Profit / $10,500 Downpayment = 13.43%

Questions:

  • General feedback? Did I calculate anything incorrectly?
  • Where can I find tax info if it's not in the assessor's property card?
  • Is there a good way to estimate insurance costs? Are Trulia's estimates reliable?
  • How much do you stick aside for repairs? I'll be rolling all of my real estate income back into more investments, but I don't want to be left with too few funds...
  • Do you do HVAC maintenance or do you offload that to your tenants? I assume I do so tenants don't forget...
  • In Indianapolis is there a need for regular pest control? In FL we used to spray bi-monthly for ants. Again, I assume I would pay for this so the tenant doesn't forget?
  • I pulled the accounting / legal number out of thin air; how do you estimate this? I assume this number won't up a lot with every additional property?

Loading replies...