Now let’s get to the good stuff. We can get to the good stuff (making money with investments) because we’ve covered the bad stuff (paying money in interest.) If you avoid paying $20,000 in interest on your credit cards, you can invest that $20,000 and maybe turn it into $100,000. Remember: compound interest!
Here’s the key to investing. Look at the following sentence, read it a few times, and ponder it for a minute.
In general, the higher the risk you take in an investment, the higher your return will be.
Think for a minute, and then read on.
Ready? Does that make sense? Suppose you have $100, and a choice of only two places to put it. First, you can put it in a savings account. Or, you can invest it in the stock market.
The stock market investment is risky. When coronavirus hit, you would have lost 30% or so of your money. No one would ever invest in the stock market if the expected return wasn’t higher. So yes, the sentence above makes sense. Higher risk needs to come with higher return.
But wait … does that really make sense? The riskier investment has, well, risk! I just told you you would have lost 30% in early 2020! How can the return be higher?
The key is in those wiggle words I stuck at the beginning of the sentence: “In general.” The riskier investment might beat the less risky investment 75% of the time. Not every time, but most of the time. And on average, the riskier investment returns more.
Let’s take a look at some actual data. Here’s a spreadsheet; I hope you are able to click and download it:
That’s an Excel file. If you’re using Excel, just download it, find the file, and open it in Excel. If you’re using Google Sheets, download the spreadsheet open Google Sheets and click on the “file picker.” It looks like a folder on the right side of the screen:

This shows historical investment performance data from an NYU professor. I just included 4 assets:
- The S&P 500 index. This is an index of 500 large stocks, so this is our proxy for investing in the stock market
- 3-month T.Bill. T Bills are short-term bonds you buy from the United States Government. In other words, you loan the government money and they will pay you back in 3 months, with a little bit of interest. This is our proxy for cash. The government can print money, and so this is a really safe investment. A good savings or money market account should yield roughly the same rate.
- Treasury Bonds. These are the same as Treasury Bills, except Treasury Bonds don’t return your money to you until 5 or 10 or 30 years later.
- Baa corporate bonds. Baa makes it sounds like a sheep. But that’s a credit rating. Baa is pretty good, but not as good as, say Aaa. It’s kind of like school but with more grades. Here you are lending to a company, not the government. The risk of a company going out of business is still low, but not as low as the government going out of business. Higher risk leads to higher returns, long-term.
Don’t worry– you don’t need to understand all of this now. We’ll look at each of these in more detail in the next few lessons. For now I just want you to play with the risk and returns.

First let’s freeze the pane so the top labels (which investment) and the side labels (which year) always stay on the screen. Above I clicked on cell B6 and then clicked View–> Freeze Panes.
Now you can scroll to the bottom, to the most recent data. I held down the Control key (Command on a Mac) and pressed the down arrow. This will take you to the bottom of a column of data.
Then I used the average function and the stdev function. There’s something weird about my spreadsheet; when I tried to highlight only the cells in Column B, Excel highlighted everything in column B plus columns D, E, and F. That’s why I started with column D and copied backwards.
Average is of course the average of all of the data, and stdev is the standard deviation. We’re not going to get into too much of the math here. But the Standard Deviation is a measure of how much the numbers vary– how much they deviate from that average.
Roughly 68% of the values should fall within a range defined by the following 2 points:
The average PLUS the standard deviation
The average MINUS the standard deviation.
There’s a whole lot of assumptions you need to make for that 68% to be true. You can argue that the stock market return data is not what is called normally distributed; there tend to be more extreme years than you would expect from a normal distribution. But for our purposes, the standard deviation at least lets us see differences in the returns of the various asset classes.
Take a look at the data you calculated:

The average return of the stock market is 11.57% per year, with a standard deviation of 19.6% per year. So you would expect 68% of years to fall above a return of -8.01% but below a return of 31.16%.
It’s kind of crazy to think that nearly a third of the time, stocks will fall more than 8% or rise more than 31%. That’s some serious volatility!
Compare those numbers to the other investments. The other investments have lower average returns, but also lower volatility. Note that the higher the investment, the higher the volatility that comes with it. (Instead of using the word “volatility” here, I could easily use the word “risk” instead.) That’s not 100% true, since corporate bonds have a higher return and a slightly lower risk than the US Treasury Bonds. Still, higher returns generally come with higher risk.
Scroll back up the top and look at the S&P 500 returns from 1929-1932:

The sum will hopefully be displayed at the bottom of your screen. (If not, just use the SUM function.)The sum of those 4 years equals -85.90%! Now, you wouldn’t lose that much money; negative compounding works in yoru favor here. The second year you lose fewer dollars since you already lost some last year.
Let’s see what your actual loss was, assuming you started with $100 invested at the end of 1928. We’ll conveniently leave off the 43.81% return you would have gotten in 1928, and you’ll invest right at the start of the Great Depression:

Your $100 is now worth just $35.23. If you copy the formula down further, you will see that you get back to your original $100 4 years later. Still, when you invest you can’t see the future; sitting there with your $35.23 would be very painful! That’s the potential pain of higher risk.
Let’s do one last thing and see that $100 invested in all of these investments would have yielded over the entire period. get rid of our little $100 experiment above and start with the $100 before 1928:

The numbers get big, so you’ll need to resize the columns. You can double click on the divider between columns one at a time, or highlight multiple columns and do them all at once. I do both here, so the second one doesn’t do anything for me:

Take a guess as to how much our $100 would be worth at the end of 2019. Remember that this is a 90+ year investment! Then scroll to the bottom to see what happened to your $100.

The $100 you (well, someone else) invested in the S&P 500 at the end of 1927 is now worth over half a million dollars! That seems crazy. But, remember a couple of things:
- $100 was worth a whole lot more back then than it is today. You could buy a ready-assemble-house for $1,200 back then!
- Today, you can buy a fund that tracks the S&P 500 very closely. But you couldn’t in 1928. It was much more common to buy individual stocks. Some would have done much better than the index data here (Coca Cola), but some would have done much worse (Studebaker).
Still, it’s clear that you’re taking on more risk with stocks, but also getting a much better return. We’ll look more closely at stocks in the next lesson.


























