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
Pick markets, find deals, analyze and manage properties. Try BiggerPockets PRO.
x
All Forum Categories
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

All Forum Posts by: Justin Sandall

Justin Sandall has started 9 posts and replied 19 times.

Post: Analysis of SFR foreclosure

Justin SandallPosted
  • Real Estate Investor
  • Wichita, KS
  • Posts 19
  • Votes 3

Eric, 

Thanks for the thoughtful reply! I'll be sure to include those in the future.

Have a good day.

Post: Analysis of SFR foreclosure

Justin SandallPosted
  • Real Estate Investor
  • Wichita, KS
  • Posts 19
  • Votes 3

Hi guys, 

We've found a 3 bed/2 bath, 3 car garage, finished basement, nice yard with sprinkler system and well in a very desirable school district. It has been foreclosed on and just listed for sale at $120,000. I am using this as my purchase price as I don't think there is much room to get more of a discount. Comps in the area run $125,000 -  150,000. 

Revenues Monthly (Year 1)

Rental Income   1,200 (14,400)

Vacancy/Loss Rate  5.0% (5.0%)

Vacancy/Loss Value  (60) (720)

-------------------------------------------

Gross Income   1,140 (13,680)

------------------------------------------

Expenses Monthly (Year 1)

Property Taxes Annual  1,158 (1,158)

Insurance Annual   755 (755)

Maintenance & Repairs Annual   684 (684)

Utilities Annual   0 (0)

Advertising Annual    150 (150)

Administrative Annual   600 (600)

Variable Cost PM (% Income)   0% (0)

Fixed Cost PM Annual    0 (0)

Other 1 Annual      100 (100)

Other 2 Monthly     0 (0)

--------------------------------------------

Total Expenses    3,447

-------------------------------------------

Expenses as % of Gross Income    28.94%

------------------------------------------

Net Operating Income (NOI) 10,233

------------------------------------------

Cash Flow

NOI (Cash Available) 853 (10,233)

Mortgage      479 (5,752)

Total Cash Flow   373 (4,481)

Cash ROI    16.60%

Equity Accrued   1,583

Total Return    6,064

Total ROI   22.46%

Cash Flow / Mortgage Ratio   178%

Loan to Value (LTV) 80%

Rent to Value (RTV) 0.95%

Capitalization Rate 8.5%

I can't for the life of me figure out how to link my spreadsheets I've got on my computer to these posts. 

Thanks for your time.

Post: SFR analysis

Justin SandallPosted
  • Real Estate Investor
  • Wichita, KS
  • Posts 19
  • Votes 3
Originally posted by @J Scott:

Hard to read it, but some thoughts (if I'm reading correctly):

- Your NOI is about 64% of your gross income. That seems high to me, especially if you're using a PM.

- You don't seem to have included capex in your analysis

- You have over $4K per year in appreciation...where is that coming from?  Seems weird that you would include appreciation, but not inflation.

 Thanks for the reply. I'm sorry about the formatting. I've got another one to post that I'll try to make easier to analyze.

Post: SFR analysis

Justin SandallPosted
  • Real Estate Investor
  • Wichita, KS
  • Posts 19
  • Votes 3
This didn't post in the same format as it showed yesterday. I apologize for the mess!

Post: SFR analysis

Justin SandallPosted
  • Real Estate Investor
  • Wichita, KS
  • Posts 19
  • Votes 3
This didn't post in the same format as it showed yesterday. I apologize for the mess!

Post: SFR analysis

Justin SandallPosted
  • Real Estate Investor
  • Wichita, KS
  • Posts 19
  • Votes 3

Hey guys,

Was wondering what you think of this analysis:

SFR - 3 bed, 1.5 bath, 1200 sq ft, detached garage & carport, large fenced yard, all hardwood floors. Will need minimal cosmetic touch-ups before listing for rent.




List Price $93,899
Fair Market Value $94,723
Discount (%,$) 15.00% $14,208
Purchase Price (Max Offer Price) $80,000 $80,515
Percent Down 20%
Down Payment Amount $16,000
Amount Financed $64,000
Interest Rate 4.38%



Length of Mortgage (Years) 30
Payment Monthly Annual
Monthly Mortgage Payment $319.54 $3,834.51
Rental Income Monthly Annual
Unit A $800.00 $9,600.00 Zestimate = $902/mo, rentometer.com average $900/mo
Unit B $- $-
Unit C $- $-

Unit D $- $-
Gross Rental Income $800.00 $9,600.00
Vacancy Rate 5%
Net Rental Income $760.00 $9,120.00
Expenses Monthly Annual
Property Management Fees $- $- 0.0%
Leasing Costs $33.33 $400.00 50% of 1 mo rent
Maintenance Reserve $38.00 $456.00 5% of NRI
Utilities $- $-
PropertyTaxes $96.45 $1,157.40 2% of FMV
Insurance $62.92 $755.00 0.5% of FMV
Other (HOA fees, Lawn Care, Trash, etc) $20.83 $250.00
Total Expenses $251.53 $3,018.40
$3,498
Net Operating Income $508.47 $6,101.60
Mortgage Payment $319.54 $3,834.51
Total Cash In (Down payment + Repairs) $16,000.00
Net Cash Flow $188.92 $2,267.09
Investment Analysis
Annual Dept Pay Down $1,100.00
Annual Cash Flow $2,267.09
Annual Appreciation $4,167.81
Total Return $7,534.90
Rate of Return on Cash Flow (Cash-on-Cash) 14%

Rate of Return on Debt Pay Down 7%

Rate of Return on Appreciation 26%

Rate of Return on Total 47%

Loan to Value (LTV) 68%
Rent to Value (RTV) 0.80%
Capitalization Rate 6.4%

So with a very conservative rent estimate and (what I feel are) reasonable expense estimates, we'd be cash flowing ~$200/month. We'll be able to rent fairly easy. The appreciation stuff is estimated fluff, we aren't banking on any of that at all.

Any thoughts?

Post: 15 vs. 30 year terms

Justin SandallPosted
  • Real Estate Investor
  • Wichita, KS
  • Posts 19
  • Votes 3

Hey guys,

I have been having a philosophical debate with my partner and wanted your opinions. Our first property has worked out really well as we have cash flowed since day one, have a great renter and were able to buy a property at a discount that had pretty much all the major stuff in great condition.

On that property, we did a 15 year term mortgage to minimize the interest costs during the life of the loan recognizing that our cash flow would be less. We made sure to run our analytics to ensure positive cash flow in this scenario prior to buying.

As we prepare to purchase our 2nd property, I have been opining for a 30 year mortgage to generate improved cash flow. My position is that the increased cash flow will create a bigger/better buffer should any major CapEx befall us as well as allow for the ability to pay out income vs. have increased savings to be put to the next property. In addition, if we don't incur significant expenses, we could always pay extra on the mortgage.

In short, I feel like there are more options with the 30 year term, especially since we are buy and hold investors.

Any thoughts or opinions one way or another? 

Thanks for your time.

Post: Tracking returns, tax related indices on rentals

Justin SandallPosted
  • Real Estate Investor
  • Wichita, KS
  • Posts 19
  • Votes 3

Shane, 

Thanks for the thoughtful reply.

Did you essentially just label every transaction on Quicken with the property it was associated with? Funds for my properties will be deposited to and debited from the same business checking account. 

Just wondering how you kept track of the 4 different properties in the Quicken register.

Thanks again!

Post: Tracking returns, tax related indices on rentals

Justin SandallPosted
  • Real Estate Investor
  • Wichita, KS
  • Posts 19
  • Votes 3

My first rental property is doing great, cash flow positive from day one with a great renter.

It's easy to keep track of income/expenses etc. on Quicken for Mac right now, but soon we will be looking to investing in another rental. I anticipate that keeping track of everything I need to for tax purposes will be more complicated. Do you have any recommendations on how to best do accounting for multiple properties (i.e. a particular program or speadsheet that can be purchased).

Also, do you know of any sources or programs I can use to help keep track of returns and other indices an investor would be interested in? I'm not exactly sure what all those would be or how to calculate them.