Hard times trying to wrap my head around payment schedule options

[Chris Luksha]

Hi All,

Thanks again to all the great contributors here on BP.  I am still sucking in info but really need to jump in with action.  To that end I am looking at a potential duplex purchase using private money to fund the downpayment while using a 75% purchase and rehab loan from my local credit union.

I would like to ask a friend to fund $25k for the downpayment combined with a $75k, 25 year purchase & rehab loan at 5.5%. (Total purchase $100k Including $55 purchase and $35 rehab on a potential ARV of $160k)

The options I was thinking of that could benefit both my friend and me in the deal are:

1. Loan the $25k based solely on an 8% balloon payoff in 12-14 months after refinancing. This of course depends solely on the bank or credit union agreeing to refinance once the property has been rehabbed and lived in for 6 months.
2. Loan $27k interest only payments for 14 months at 8% interest. Again - same success or failure based on banks refinance.
3. Loan $25k at 6% for 10 year term, monthly P&I plus 25% of the cash flow for same term.

I have four questions

The first question I have is:  Does anyone think these are outrageous in one direction or another? e.g. Am I stiffing my friend or stiffing myself? Or does one or the other seem reasonable.

The second question I have is: How in the world do I calculate the balloon payment on number 1?  I have looked around for an online calculator but could not find what I was looking for.

The third question is:  What do you base amortization on an interest only or balloon payment short term loan? I keep hearing people on BP refer to taking an interest only loan for 14 months or a balloon payment loan for 12 or 14 months at n%.  What is the n% based on?  Is it on 12 months? 30 years? etc. If you are basing it on 12 months but the lender is amicable to going an extra six months because you need to, how did that extra six months get calculated into the initial 12 month amortization? Maybe this one should be a post in and of itself ;)

The forth question is: What would be the best way to calculate the third option? To date I have created two rental reports on the BP Rental Property Calculator, one for $25k and one for $75k, then I simply took all the expenses from one report, and manually added the P&I from the other report in order to come up with the true monthly expenses.  Is there a BP calc that I am missing that will allow me to put in two mortgages?

Thanks all!

God Bless,

Chris

[Adrien C.]

I wouldn't do #4- you're giving up too much. What you pay your friend depends partly on his expectations and where he's getting the money. If it's coming from some place where he's getting 10-12% returns or he's a seasoned investor, you'll pay more to borrow the money. If it's coming from a simple savings where he's getting 0.3% interest, he'll jump at 5-6%. I'm generous with with I pay my private lenders but the property still has to make sense for my profit as well. 

The simplest way to do it is to have an interest only loan with a balloon payment in 15-18 months. There is no amortization to worry about with interest only as the principle balance is fixed throughout the duration of the loan (question 3). I would write it out longer like i did above just in case something comes up and you can't refi out as soon as you expect. $25K at 8% is $166/month. You pay that interest each month and the principle is the same. 

I wouldn't do the 4th option because in that situation, the loan is amortized and the lender is getting a boat load of interest on the front end. You can google an amortization calculator and put in your own numbers to get a payment. Add the payments for both loans plus the insurance plus the taxes and that's your total PITI. I'd take off top 25% of your gross rent to factor in vacancies, property management, repairs, CapEx, etc. With the remaining amount- subtract the combination of PITI. That's your net rent. Feel free to give him a quarter of that if you work for free. The payoff amounts are actually very similar between interest only at 8% and amortized at 6%. I'd keep it simple and go with interest only.

Is your friend okay being in 2nd position? Should you default, the bank gets paid off before your friend. Are you sharp enough or experienced enough to play with $25K that is not your money? If crap hits that fan- are you able to repay them quickly as to maintain the relationship and not screw them over? It's easy to calculate numbers and such but you can't calculate the emotions involved when borrowing from friends and family.