The Money Mustache Community

Learning, Sharing, and Teaching => Real Estate and Landlording => Topic started by: jeromedawg on May 18, 2017, 10:19:12 PM

Title: 250yr loan?!
Post by: jeromedawg on May 18, 2017, 10:19:12 PM
Is there such a thing as a 250 year loan? I was just reviewing a prospectus/offer detail from a syndicator I was looking at a couple months ago, just to 'practice' analysis and I noticed a 250yr term listed in the existing financials portion. Is this a normal thing that syndicators do and qualify for?

The intent with this property is to reposition and rehab all units while occupied. The leases for existing tenants would run out within the year and they would go in and rehab the unoccupied units asap and bring new tenants in. I guess the strategy is to reduce the vacancy as much as possible but ultimately they intend to add value via rehab and raising rents and are valuing the property at almost 70% more than what it currently is worth within 5-7 years, based on market research. At that time they hope to cash out on the property. I was running some of the numbers again and it didn't really make a lot of sense to me in terms of the returns they're promising.
Title: Re: 250yr loan?!
Post by: Thedudeabides on May 18, 2017, 10:58:00 PM
The 250 year loan seems weird. Maybe they meant month?

I haven't reviewed the deal in detail, but it could happen. It's only 7.6% a year raise. With a 3% raise each year for inflation and a 4.6% through forced appreciation (value add and raising rents) then it doesn't seem too out of line.

I would recommend doing a little more research on the deal. If market rents are rising in the market and the current apartments are below market rent, then it would make sense.


Sent from my iPhone using Tapatalk
Title: Re: 250yr loan?!
Post by: jeromedawg on May 18, 2017, 11:16:06 PM
The 250 year loan seems weird. Maybe they meant month?

I haven't reviewed the deal in detail, but it could happen. It's only 7.6% a year raise. With a 3% raise each year for inflation and a 4.6% through forced appreciation (value add and raising rents) then it doesn't seem too out of line.

I would recommend doing a little more research on the deal. If market rents are rising in the market and the current apartments are below market rent, then it would make sense.


Sent from my iPhone using Tapatalk

No I'm pretty sure it's 250yrs. Loan amount is $2.7m with an interest rate of 4.72%. Payment per period (12 a year) comes out to $10,620.08 which, per year, is $127,441. $127,441 is listed in their financials as "Annual Debt Service" so the numbers match up. Seems pretty weird to me though regarding the 250yr loan... not sure where it originated from.

But yea, this is in the Phoenix area - they're anticipating job growth and their projected rents are like 60% more than current rents.
Title: Re: 250yr loan?!
Post by: Thedudeabides on May 19, 2017, 08:46:59 AM
The 250 year loan seems weird. Maybe they meant month?

I haven't reviewed the deal in detail, but it could happen. It's only 7.6% a year raise. With a 3% raise each year for inflation and a 4.6% through forced appreciation (value add and raising rents) then it doesn't seem too out of line.

I would recommend doing a little more research on the deal. If market rents are rising in the market and the current apartments are below market rent, then it would make sense.


Sent from my iPhone using Tapatalk

No I'm pretty sure it's 250yrs. Loan amount is $2.7m with an interest rate of 4.72%. Payment per period (12 a year) comes out to $10,620.08 which, per year, is $127,441. $127,441 is listed in their financials as "Annual Debt Service" so the numbers match up. Seems pretty weird to me though regarding the 250yr loan... not sure where it originated from.

But yea, this is in the Phoenix area - they're anticipating job growth and their projected rents are like 60% more than current rents.

At that rate and payment, it's a 15 year loan which sounds more accurate.

If the rents are 60% more, then that's 6/7 of the forced appreciation right there. Inflation and market rising rents should take care of the rest.

But, do due diligence. I like to refer to proformas as "this is how we lie to you documents" lol. But if you can look at comps in the area for rent and can validate the rents, then go for it, sounds like a great deal. However, if their numbers are coming from cap rate compression, i.e. They are buying at a 7 cap and selling at a 3 cap when market cap rates for fully stabilized remodeled units are 5 caps, then you should be skeptical of the exit assumptions.
Title: Re: 250yr loan?!
Post by: jeromedawg on May 19, 2017, 09:23:05 AM
The 250 year loan seems weird. Maybe they meant month?

I haven't reviewed the deal in detail, but it could happen. It's only 7.6% a year raise. With a 3% raise each year for inflation and a 4.6% through forced appreciation (value add and raising rents) then it doesn't seem too out of line.

I would recommend doing a little more research on the deal. If market rents are rising in the market and the current apartments are below market rent, then it would make sense.


Sent from my iPhone using Tapatalk

No I'm pretty sure it's 250yrs. Loan amount is $2.7m with an interest rate of 4.72%. Payment per period (12 a year) comes out to $10,620.08 which, per year, is $127,441. $127,441 is listed in their financials as "Annual Debt Service" so the numbers match up. Seems pretty weird to me though regarding the 250yr loan... not sure where it originated from.

But yea, this is in the Phoenix area - they're anticipating job growth and their projected rents are like 60% more than current rents.

At that rate and payment, it's a 15 year loan which sounds more accurate.

If the rents are 60% more, then that's 6/7 of the forced appreciation right there. Inflation and market rising rents should take care of the rest.

But, do due diligence. I like to refer to proformas as "this is how we lie to you documents" lol. But if you can look at comps in the area for rent and can validate the rents, then go for it, sounds like a great deal. However, if their numbers are coming from cap rate compression, i.e. They are buying at a 7 cap and selling at a 3 cap when market cap rates for fully stabilized remodeled units are 5 caps, then you should be skeptical of the exit assumptions.

How does that work in terms of it actually being a 15yr loan?

Good point on the comps - I haven't really checked around for comps in that area. What's interesting about this syndication is that they were supposed to close the investing round back in March or April. I keep getting emails from them about this where they've now pushed the latest round back to June. This syndication has been particularly aggressive with repositioning apartments in the Phoenix area - it sounds like they've done some already. But I'm not clear on the details of what these "rounds" are actually for (is it per apt complex they acquire?). Furthermore, they're referring to the overall investment as a "fund" which comes off sounding a little odd. Are all these buzzwords *normal* for a syndicator to be using? Or is it just marketing lingo they use to make their company sound more professional when they don't really have to?
Title: Re: 250yr loan?!
Post by: Thedudeabides on May 19, 2017, 06:41:02 PM
The 250 year loan seems weird. Maybe they meant month?

I haven't reviewed the deal in detail, but it could happen. It's only 7.6% a year raise. With a 3% raise each year for inflation and a 4.6% through forced appreciation (value add and raising rents) then it doesn't seem too out of line.

I would recommend doing a little more research on the deal. If market rents are rising in the market and the current apartments are below market rent, then it would make sense.


Sent from my iPhone using Tapatalk

No I'm pretty sure it's 250yrs. Loan amount is $2.7m with an interest rate of 4.72%. Payment per period (12 a year) comes out to $10,620.08 which, per year, is $127,441. $127,441 is listed in their financials as "Annual Debt Service" so the numbers match up. Seems pretty weird to me though regarding the 250yr loan... not sure where it originated from.

But yea, this is in the Phoenix area - they're anticipating job growth and their projected rents are like 60% more than current rents.

At that rate and payment, it's a 15 year loan which sounds more accurate.

If the rents are 60% more, then that's 6/7 of the forced appreciation right there. Inflation and market rising rents should take care of the rest.

But, do due diligence. I like to refer to proformas as "this is how we lie to you documents" lol. But if you can look at comps in the area for rent and can validate the rents, then go for it, sounds like a great deal. However, if their numbers are coming from cap rate compression, i.e. They are buying at a 7 cap and selling at a 3 cap when market cap rates for fully stabilized remodeled units are 5 caps, then you should be skeptical of the exit assumptions.

How does that work in terms of it actually being a 15yr loan?

Good point on the comps - I haven't really checked around for comps in that area. What's interesting about this syndication is that they were supposed to close the investing round back in March or April. I keep getting emails from them about this where they've now pushed the latest round back to June. This syndication has been particularly aggressive with repositioning apartments in the Phoenix area - it sounds like they've done some already. But I'm not clear on the details of what these "rounds" are actually for (is it per apt complex they acquire?). Furthermore, they're referring to the overall investment as a "fund" which comes off sounding a little odd. Are all these buzzwords *normal* for a syndicator to be using? Or is it just marketing lingo they use to make their company sound more professional when they don't really have to?

With the balance, payment and number of payments provided by your data, I used a financial calculator to calculate the term given those parameters and it worked out to just under 15 years.

Hmm, most funds I know of invest in more than one property. However, I believe if someone is advertising a fund, then it would be subject to SEC filing. I've looked at several funds I invest in and they are all registered with the SEC.

Funds can be structured differently, but sometimes they have capital calls when they need money. The way this works is that if you invest in a fund, and let's say the fund opens, but hasn't acquired anything yet, you may be asked to commit to a certain level, say $50-100k, but they might not ask for it right away. They may instead do capital calls when they need the funds. I suspect this is what's happening, but you should be able to find out if you read the private placement memorandum.
Title: Re: 250yr loan?!
Post by: WerKater on May 19, 2017, 11:33:25 PM
The 250 year loan seems weird. Maybe they meant month?

I haven't reviewed the deal in detail, but it could happen. It's only 7.6% a year raise. With a 3% raise each year for inflation and a 4.6% through forced appreciation (value add and raising rents) then it doesn't seem too out of line.

I would recommend doing a little more research on the deal. If market rents are rising in the market and the current apartments are below market rent, then it would make sense.


Sent from my iPhone using Tapatalk

No I'm pretty sure it's 250yrs. Loan amount is $2.7m with an interest rate of 4.72%. Payment per period (12 a year) comes out to $10,620.08 which, per year, is $127,441. $127,441 is listed in their financials as "Annual Debt Service" so the numbers match up. Seems pretty weird to me though regarding the 250yr loan... not sure where it originated from.

But yea, this is in the Phoenix area - they're anticipating job growth and their projected rents are like 60% more than current rents.

At that rate and payment, it's a 15 year loan which sounds more accurate.

If the rents are 60% more, then that's 6/7 of the forced appreciation right there. Inflation and market rising rents should take care of the rest.

But, do due diligence. I like to refer to proformas as "this is how we lie to you documents" lol. But if you can look at comps in the area for rent and can validate the rents, then go for it, sounds like a great deal. However, if their numbers are coming from cap rate compression, i.e. They are buying at a 7 cap and selling at a 3 cap when market cap rates for fully stabilized remodeled units are 5 caps, then you should be skeptical of the exit assumptions.

How does that work in terms of it actually being a 15yr loan?

Good point on the comps - I haven't really checked around for comps in that area. What's interesting about this syndication is that they were supposed to close the investing round back in March or April. I keep getting emails from them about this where they've now pushed the latest round back to June. This syndication has been particularly aggressive with repositioning apartments in the Phoenix area - it sounds like they've done some already. But I'm not clear on the details of what these "rounds" are actually for (is it per apt complex they acquire?). Furthermore, they're referring to the overall investment as a "fund" which comes off sounding a little odd. Are all these buzzwords *normal* for a syndicator to be using? Or is it just marketing lingo they use to make their company sound more professional when they don't really have to?

With the balance, payment and number of payments provided by your data, I used a financial calculator to calculate the term given those parameters and it worked out to just under 15 years.
That's not correct. What calculator was that?

2 700 000 * 4.72%/12 = 10620.00

So this is almost an interest-only loan. However: If I put it in an annuity calculator using the rate 10620.08 it does in fact come out to be paid off after 250.41 years. That seems counter-intuitive, and it looks funny: after the first 100 years, the loan has been reduced by less than 3000$.
But it's correct. Put 1$ per year in savings with 4.72% interest and it comes out to about 2.7m after 250 years. Also, the one dollar from the first year is now over 100k$.

Why anyone would do this? I have no real idea, but maybe someone was offered an interest-only loan and said "oh well, I can scrounge up one additional dollar each year. Then it will at least be paid off in ten generations".
Title: Re: 250yr loan?!
Post by: jeromedawg on May 20, 2017, 01:41:09 AM
The 250 year loan seems weird. Maybe they meant month?

I haven't reviewed the deal in detail, but it could happen. It's only 7.6% a year raise. With a 3% raise each year for inflation and a 4.6% through forced appreciation (value add and raising rents) then it doesn't seem too out of line.

I would recommend doing a little more research on the deal. If market rents are rising in the market and the current apartments are below market rent, then it would make sense.


Sent from my iPhone using Tapatalk

No I'm pretty sure it's 250yrs. Loan amount is $2.7m with an interest rate of 4.72%. Payment per period (12 a year) comes out to $10,620.08 which, per year, is $127,441. $127,441 is listed in their financials as "Annual Debt Service" so the numbers match up. Seems pretty weird to me though regarding the 250yr loan... not sure where it originated from.

But yea, this is in the Phoenix area - they're anticipating job growth and their projected rents are like 60% more than current rents.

At that rate and payment, it's a 15 year loan which sounds more accurate.

If the rents are 60% more, then that's 6/7 of the forced appreciation right there. Inflation and market rising rents should take care of the rest.

But, do due diligence. I like to refer to proformas as "this is how we lie to you documents" lol. But if you can look at comps in the area for rent and can validate the rents, then go for it, sounds like a great deal. However, if their numbers are coming from cap rate compression, i.e. They are buying at a 7 cap and selling at a 3 cap when market cap rates for fully stabilized remodeled units are 5 caps, then you should be skeptical of the exit assumptions.

How does that work in terms of it actually being a 15yr loan?

Good point on the comps - I haven't really checked around for comps in that area. What's interesting about this syndication is that they were supposed to close the investing round back in March or April. I keep getting emails from them about this where they've now pushed the latest round back to June. This syndication has been particularly aggressive with repositioning apartments in the Phoenix area - it sounds like they've done some already. But I'm not clear on the details of what these "rounds" are actually for (is it per apt complex they acquire?). Furthermore, they're referring to the overall investment as a "fund" which comes off sounding a little odd. Are all these buzzwords *normal* for a syndicator to be using? Or is it just marketing lingo they use to make their company sound more professional when they don't really have to?

With the balance, payment and number of payments provided by your data, I used a financial calculator to calculate the term given those parameters and it worked out to just under 15 years.
That's not correct. What calculator was that?

2 700 000 * 4.72%/12 = 10620.00

So this is almost an interest-only loan. However: If I put it in an annuity calculator using the rate 10620.08 it does in fact come out to be paid off after 250.41 years. That seems counter-intuitive, and it looks funny: after the first 100 years, the loan has been reduced by less than 3000$.
But it's correct. Put 1$ per year in savings with 4.72% interest and it comes out to about 2.7m after 250 years. Also, the one dollar from the first year is now over 100k$.

Why anyone would do this? I have no real idea, but maybe someone was offered an interest-only loan and said "oh well, I can scrounge up one additional dollar each year. Then it will at least be paid off in ten generations".

Did they figure it doesn't matter how long of a loan they take because their exit plan/strategy is to get out in under 10 years regardless? Maybe the strategy this way is to take the longest loan possible to reduce monthly/annual overhead and increase/maximize cashflow? "Creative financing" - that seems like a super unrealistic loan term though. And why would anyone ever agree to something like that? It just seems a little fishy...
Title: Re: 250yr loan?!
Post by: Thedudeabides on May 20, 2017, 02:44:34 AM
The 250 year loan seems weird. Maybe they meant month?

I haven't reviewed the deal in detail, but it could happen. It's only 7.6% a year raise. With a 3% raise each year for inflation and a 4.6% through forced appreciation (value add and raising rents) then it doesn't seem too out of line.

I would recommend doing a little more research on the deal. If market rents are rising in the market and the current apartments are below market rent, then it would make sense.


Sent from my iPhone using Tapatalk

No I'm pretty sure it's 250yrs. Loan amount is $2.7m with an interest rate of 4.72%. Payment per period (12 a year) comes out to $10,620.08 which, per year, is $127,441. $127,441 is listed in their financials as "Annual Debt Service" so the numbers match up. Seems pretty weird to me though regarding the 250yr loan... not sure where it originated from.

But yea, this is in the Phoenix area - they're anticipating job growth and their projected rents are like 60% more than current rents.

At that rate and payment, it's a 15 year loan which sounds more accurate.

If the rents are 60% more, then that's 6/7 of the forced appreciation right there. Inflation and market rising rents should take care of the rest.

But, do due diligence. I like to refer to proformas as "this is how we lie to you documents" lol. But if you can look at comps in the area for rent and can validate the rents, then go for it, sounds like a great deal. However, if their numbers are coming from cap rate compression, i.e. They are buying at a 7 cap and selling at a 3 cap when market cap rates for fully stabilized remodeled units are 5 caps, then you should be skeptical of the exit assumptions.

How does that work in terms of it actually being a 15yr loan?

Good point on the comps - I haven't really checked around for comps in that area. What's interesting about this syndication is that they were supposed to close the investing round back in March or April. I keep getting emails from them about this where they've now pushed the latest round back to June. This syndication has been particularly aggressive with repositioning apartments in the Phoenix area - it sounds like they've done some already. But I'm not clear on the details of what these "rounds" are actually for (is it per apt complex they acquire?). Furthermore, they're referring to the overall investment as a "fund" which comes off sounding a little odd. Are all these buzzwords *normal* for a syndicator to be using? Or is it just marketing lingo they use to make their company sound more professional when they don't really have to?

With the balance, payment and number of payments provided by your data, I used a financial calculator to calculate the term given those parameters and it worked out to just under 15 years.
That's not correct. What calculator was that?

2 700 000 * 4.72%/12 = 10620.00

So this is almost an interest-only loan. However: If I put it in an annuity calculator using the rate 10620.08 it does in fact come out to be paid off after 250.41 years. That seems counter-intuitive, and it looks funny: after the first 100 years, the loan has been reduced by less than 3000$.
But it's correct. Put 1$ per year in savings with 4.72% interest and it comes out to about 2.7m after 250 years. Also, the one dollar from the first year is now over 100k$.

Why anyone would do this? I have no real idea, but maybe someone was offered an interest-only loan and said "oh well, I can scrounge up one additional dollar each year. Then it will at least be paid off in ten generations".

Yeah, you are right. I used the wrong sign in the PMT field (positive instead of negative).

Looks like a commercial interest only loan. I'm guessing there is a balloon payment at some point? So, 5-7 years interest only with a balloon payment of $2.7MM at the end of the period?

A perpetual interest only with no balloon would be odd.