@Don Konipol Noted. Agree to view it now as a separate investment. When you say you would do it for $200k off the balance, do you mean $200k in place of his $25k, so a total of $300k off the balance (the $100k we're giving him now plus the $200k extra)?
@Chris Seveney I love where you're going with this, and the IRR, but I'm not sure I followed your spitball, but I'm trying to recreate what you said below with a calculator. :)
Ok, here's what I've got so far based on everyone's observations.
- Best way to view this is to compare the returns to if we invested $100k in a property. And to view it as a completely separate investment from the property itself.
- Since it's a separate investment, we'd continue paying monthly loan payments for the term of the loan on the property (i.e. there is no pause in loan payments even if we advance him the $100k).
- The deal should include an agreement to put the extra 3 year extension into effect at the same current monthly payments of $2k/ month. That gives a total of 7 years left on the term (instead of 4).
- If we invested $100k in a property at a 10% annual cash on cash return (or ROE, whatever you call it), that would be $10k per year in cash flow. Over 7 years, that's a $70k return.
- At first pass, this makes you think asking for a $70k return instead of a $25k return would make this an acceptable agreement. But it doesn't:
- First, it doesn't have any tax benefits of a real estate investment (cost seg, interest, etc.). I'm spit-balling those at an extra $5k per year in returns. So $15k / yr x 7 years = $105k. So now we're up to asking for a $105k additional reduction of principal instead of $70k or $25k.
- But that isn't a correct comparison either, because with this deal, we'd be waiting 7 years to get the $105k instead of getting $15k per year with a real estate investment. With the real estate investment, we could then take that $15k each year and reinvest it as well, making a 10% return on those cash flows.
- I think the right way to fix the above is an IRR calculation. (What @Chris Seveney was saying, I think?).
If I take the IRR of the real estate investment with $100k investment in year 0, and $15k per year cash flows with a return of equity in year 7 (assuming 0% appreciation I might add), I get a 15% IRR.
Conversely, with this arrangement, if I assume a $100k investment in year 0, $0 cash flows for 7 years, and a return of $X in year 7 and I set the IRR to be 15%, then $X needs to be about $270k.
Conclusion: That means I need a $170k return on my $100k, instead of a $25k return. To say it another way, I would offer him $100k now, if he reduces the principal balance by $270k in 7 years. That's a big gap.
Does this analysis sound correct?