Welcome to City-Data.com Forum!
U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Economics > Personal Finance
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
Reply Start New Thread
 
Old 03-26-2015, 04:13 PM
 
18,549 posts, read 15,608,581 times
Reputation: 16235

Advertisements

Quote:
Originally Posted by Lowexpectations View Post
A couple things what they s&p is up is somewhat meaningless one because you can't directly invest in it and two investors normally don't even come close to the performance of the s&p
If you go into an S&P 500 index fund, the expense ratio is usually very low especially one of the big ones like Vanguard's 500 index fund, so how does this not count?
Reply With Quote Quick reply to this message

 
Old 03-26-2015, 04:17 PM
 
26,194 posts, read 21,621,745 times
Reputation: 22772
Quote:
Originally Posted by ncole1 View Post
If you go into an S&P 500 index fund, the expense ratio is usually very low especially one of the big ones like Vanguard's 500 index fund, so how does this not count?

What do you mean how does it not count? VOO/spy typically doesn't outperform the index and then compound that problem by the fact that the average investor doesn't even come close
Reply With Quote Quick reply to this message
 
Old 03-26-2015, 04:18 PM
 
2,401 posts, read 3,259,416 times
Reputation: 1837
Quote:
Originally Posted by mizzourah2006 View Post
Oh that's an unsecured loan then. Of course it will be difficult to get an unsecured loan @ 3% or less.
Sigh...

That's why I'm puzzled when people refuse to borrow even at 2%. If nicole1 can borrow at 2%, I'll borrow from him at 3%.
Reply With Quote Quick reply to this message
 
Old 03-26-2015, 04:27 PM
 
18,549 posts, read 15,608,581 times
Reputation: 16235
Quote:
Originally Posted by AmFest View Post
Sigh...

That's why I'm puzzled when people refuse to borrow even at 2%. If nicole1 can borrow at 2%, I'll borrow from him at 3%.
Assuming I could borrow at 2% - which would only apply to collateralized debt such as against my savings or investments, and maybe not even then. I could probably get a passbook loan under 2% if I borrowed a small amount against a CD at the same bank, but I haven't asked.

At any rate WHY would I loan you money at 3% with no collateral? How will you convince me that I'll get paid back even if things go south?

If there were a magic way for you to guarantee me zero credit risk with no additional costs on my part, I would happily lend you $20k of my own money at 3%.

Unfortunately, there ins't, because from my perspective you could always just choose to run off and not pay. The only way to eliminate this credit risk, from my perspective, would be to put up collateral. If you had $80k in stocks you wanted to put up I might consider making the loan - although without me having a brokerage license it's doubtfully even legal.

Sorry.
Reply With Quote Quick reply to this message
 
Old 03-26-2015, 04:29 PM
 
18,549 posts, read 15,608,581 times
Reputation: 16235
Quote:
Originally Posted by Lowexpectations View Post
What do you mean how does it not count? VOO/spy typically doesn't outperform the index and then compound that problem by the fact that the average investor doesn't even come close
Just that the index fund comes close, that's all.
Reply With Quote Quick reply to this message
 
Old 03-26-2015, 04:31 PM
 
Location: Vallejo
21,879 posts, read 25,195,050 times
Reputation: 19105
Quote:
Originally Posted by ncole1 View Post
Ok, let me break it down for you.

Imagine a relative offers you a $1000 loan, to be fully repaid one year from today, but no payments due before then. You take the loan and invest in an S&P 500 index fund. You then sell at year end to repay the loan.

Is the NPV positive or negative?

It should be obvious that the answer is - if the return during the year was greater than the loan interest, then NPV > 0. Otherwise not.
Yup. As long as the discount rate (annualized rate of return) is greater than the interest rate you're paying, it is positive. That's not how NPV is calculated but I'm with you.


Quote:
Now let's say, instead, the offer is a 2-year loan instead, again no payments due until maturity. What now?

Similarly, NPV > 0 if the 2-year compounded growth rate, expressed as an annualized figure, exceeds loan interest. It's just like in the first case, except the period is 2 years, not one. Similar answer for the same reason.

Are you with me so far? (#2)
Same caveat. That's now how NPV is calculated but NPV would be positive if the annualized rate of return over the two-year period is greater than the annualized interest rate.

Quote:
But there is an alternate way of viewing this. Put together, you have a single $2000 loan, with two payments due - one after 1 year and the second after another year (2 years from origination).
No, you have two loans, not one. That's important because the discount rate would be different.

Quote:
The NPV of this two year loan is the sum of two terms - NPV(1) and NPV(2). The first term depends on the 1-year return of your S&P 500. The second term depends on the two-year return of the S&P.
Incorrect.

A basic example:
Assume 0% interest rate, no inflation
Year 1 -50% return
Year 2 +100% return
NPV 1 is -$500 (your 1-year loan)
NPV 2 is 0 (your 2-year loan)

If you want to talk about a third loan that's structured with the same payments, a two-year loan with 50% due at the end of year 1 and 50% due at year 2, that's a third loan, NPV3. It would have the same discount rate as NPV2, the two-year loan since like NPV2 it's dependent on the annualized discount rate over two-years. NPV3 would be 0. -$500 + 0 is not 0. NPV3 is not NPV 1 + NPV2.

If you're trying to make payments out of the investment, you'd have a problem. That's not NPV however.
NPV would be normally you'd contribute $1,000 a year but now are making your loan payments instead and foregoing your contribution.

Situation A:
$2000 in investment account. Pay cash.
Contribute 1000 at end of year 1, => $2,000
Contribute 1000 at end of year 2, => $3000.

Situation B:
Leave $2000 investment, forgo contributions.
$2000 => $1000 => $2000.

The timing benefits you since you lose 50% of nothing. On the flip side,
Year 1 100% return (NPV1 = $1000)
year 2 -50% return (NPV2 = 0)

Situation A:
$2000 investment. Pay cash
Contribute 1000 at the end of year 1 => 500
Contribute 1000 at end of year 2 => $1,500

Situation B:
Leave the $2000 investment, forgo contributions.
$2,000 => $4,000 => $2000.

As expected, regardless of what happens in any given period you end up with the same amount, $2000, the expected resulted with a NPV of 0. NPV3 is, once again, not NPV1 + NPV2. It's NPV3.



Quote:
So the NPV of the $2000 loan is positive or negative depending on not only the two-year return of the S&P, but also the 1-year return, because that 1-year return appears explicitly in Equation 1.
Incorrect. See above.


Quote:
There is of course no limit to how many payments we can add. If we have a loan with 1 payment due in 1 month, another payment due in 2 months, and another in 3 months, etc. all the way to 60 months (as the car loan example), then your NPV is a sum of 60 terms. The first term depends on the 1-month return of the S&P, the second term on the 2-month return, etc.

Thus the mere fact that the 60-month CAGR exceeds the loan rate is not sufficient for NPV > 0 for the whole loan.

Hence your 88% figure is not the correct value.
And see above again.

Last edited by Malloric; 03-26-2015 at 04:45 PM..
Reply With Quote Quick reply to this message
 
Old 03-26-2015, 04:42 PM
 
18,549 posts, read 15,608,581 times
Reputation: 16235
Quote:
Originally Posted by Malloric View Post
Yup. As long as the discount rate (annualized rate of return) is greater than the interest rate you're paying, it is positive. That's not how NPV is calculated but I'm with you.



Same caveat. That's now how NPV is calculated but NPV would be positive if the annualized rate of return over the two-year period is greater than the annualized interest rate.


No, you have two loans, not one. That's important because the discount rate would be different.


Incorrect.

A basic example:
Assume 0% interest rate, no inflation, $2000 loan
Year 1 -50% return
Year 2 +100% return
NPV 1 is -$500
NPV 2 is 0

If you want to talk about a third loan that's structured with the same payments, a two-year loan with 50% due at the end of year 1 and 50% due at year 2, that's a third loan, NPV3. It would have the same discount rate as NPV2, the two-year loan since like NPV2 it's dependent on the annualized discount rate over two-years. NPV3 would be 0.

If you're trying to make payments out of the investment, you'd have a problem. That's not NPV however.
NPV would be normally you'd contribute $1,000 a year but now are making your loan payments instead and foregoing your contribution.

Situation A:
$2000 in investment account. Pay cash.
Contribute 1000 at end of year 1, => $2,000
Contribute 1000 at end of year 2, => $3000.

Situation B:
Leave $2000 investment, forgo contributions.
$2000 => $1000 => $2000.

The timing benefits you since you lose 50% of nothing. On the flip side,
Year 1 100% return
year 2 -50% return

Situation A:
$2000 investment. Pay cash
Contribute 1000 at the end of year 1 => 500
Contribute 1000 at end of year 2 => $1,500

Situation B:
Leave the $2000 investment, forgo contributions.
$2,000 => $4,400 => $2000.
Ok. So the loan makes you $1000 poorer in the first case ($3000 total NPV paying cash, rather than $2000 NPV having loan). In the second case the loan makes you $500 richer ($1500 NPV paying cash vs. $2000 taking loan).

In both cases the 2-year CAGR is 0%.

Yet the impact of the loan depends on what happens during the interim, not the CAGR alone. Both cases have the same CAGR yet the financial impact of the loan, relative to paying cash, depends on what happens during the 2 years.

Same with the car loan. Whether you are better off with the loan than you are without it, or vice versa, depends not only on the 5 year CAGR, but also on the returns during the intervening time.

And this is exactly what I was getting at earlier. Your 88% statistic applies only to the 5-year CAGR, but that is not sufficient to tell you whether the NPV of the loan is higher or lower than without the loan.

So the risk that the loan makes you worse than you would be had you paid cash, is not 12%. It's more than that.
Reply With Quote Quick reply to this message
 
Old 03-26-2015, 05:15 PM
 
Location: Vallejo
21,879 posts, read 25,195,050 times
Reputation: 19105
Quote:
Originally Posted by ncole1 View Post
Ok. So the loan makes you $1000 poorer in the first case ($3000 total NPV paying cash, rather than $2000 NPV having loan). In the second case the loan makes you $500 richer ($1500 NPV paying cash vs. $2000 taking loan).
No. The NPV is the NPV. Again, you don't seem to understand what NPV is. NPV is "Net Present Value."
Notice how in either case where you take the loan with an NPV of 0 you end up exactly where you started?
That's because it just doesn't matter what it does in this month or that month or this year or that year. The only thing that matters is the discount rate, which if you're investing in the S&P should be the CAGR adjusted for dividends and inflation. The loan in the first cast makes you $0 poorer. $2000 is $2000. The loan in the second case makes you $0 richer. $2000 is $2000. That's all NPV tells you.

What you're arguing is market timing. And that's great and all, but I don't do it. My crystal ball is sadly broken in that way. If you did, you could make a ton of money off of negative NPV!

Example:
10% simple interest, no inflation.
year 1 market goes up 100%
year 2 market goes down 50%.

Borrow money at the beginning of year 1. Invest it. Profit. Sell. Sit on proceeds.
NPV is -20%. Borrow $100, pay back $120. Come out $80 ahead.
Reply With Quote Quick reply to this message
 
Old 03-26-2015, 05:23 PM
 
2,401 posts, read 3,259,416 times
Reputation: 1837
Quote:
Originally Posted by ncole1 View Post
Assuming I could borrow at 2% - which would only apply to collateralized debt such as against my savings or investments, and maybe not even then. I could probably get a passbook loan under 2% if I borrowed a small amount against a CD at the same bank, but I haven't asked.

At any rate WHY would I loan you money at 3% with no collateral? How will you convince me that I'll get paid back even if things go south?

If there were a magic way for you to guarantee me zero credit risk with no additional costs on my part, I would happily lend you $20k of my own money at 3%.

Unfortunately, there ins't, because from my perspective you could always just choose to run off and not pay. The only way to eliminate this credit risk, from my perspective, would be to put up collateral. If you had $80k in stocks you wanted to put up I might consider making the loan - although without me having a brokerage license it's doubtfully even legal.

Sorry.
The point is, you take a 2% auto loan (because the entire discussion has been about auto loans), and let me borrow just that amount.
Reply With Quote Quick reply to this message
 
Old 03-27-2015, 08:58 AM
 
18,549 posts, read 15,608,581 times
Reputation: 16235
Quote:
Originally Posted by Malloric View Post
No. The NPV is the NPV. Again, you don't seem to understand what NPV is. NPV is "Net Present Value."
Notice how in either case where you take the loan with an NPV of 0 you end up exactly where you started?
That's because it just doesn't matter what it does in this month or that month or this year or that year. The only thing that matters is the discount rate, which if you're investing in the S&P should be the CAGR adjusted for dividends and inflation. The loan in the first cast makes you $0 poorer. $2000 is $2000. The loan in the second case makes you $0 richer. $2000 is $2000. That's all NPV tells you.
You are completely misconstruing what I am saying. When I say "the loan makes you $x richer", what I mean is that "If you take the loan, your NPV is $x higher than it would be if you paid cash".

Please go back and re-read my comment in that light.
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:


Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Economics > Personal Finance

All times are GMT -6. The time now is 10:47 AM.

© 2005-2024, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Contact Us - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37 - Top