10-K Diver Profile picture
Jul 18, 2020 25 tweets 6 min read Read on X
1/

Get a cup of coffee.

(Or, as the wise @JohnLegere says, get many cups of coffee!)

In this thread, I'll show you how to do CAGR calculations.

For those unfamiliar, CAGR = Compounded Annual Growth Rate. It's also called IRR (Internal Rate of Return).

2/

Imagine that you bought 100 shares of Google ($GOOG) on Dec 31, 2015 (about 4.5 years ago).

At that time, $GOOG was trading at $758.88 per share. Today, it's at $1,515.55.

Assuming you're still holding on to your 100 shares, what's your rate of return on this investment?
3/

Well, your initial investment was $75,888 (100 shares times $758.88 per share).

That $75,888 has now grown to $151,555 (100 shares times $1,515.55 per share).

This growth has happened between 2015-Dec-31 and 2020-Jul-17 -- a period of 1,660 days.
4/

So you just plug these numbers into the standard compound interest formula:
5/

And if you rearrange the terms in the formula, you get your CAGR.

In this case, your CAGR works out to about 16.43%.
6/

Essentially, what this 16.43% CAGR means is:

Suppose you found a bank that paid 16.43% interest annually.

And suppose you deposited $75,888 into that bank on 2015-Dec-31.

Then, your money would have grown to $151,555 by 2020-Jul-17 -- same as your $GOOG investment.
7/

But you don't usually just buy a stock once and hold on forever.

You add to your position over time. Sometimes, you trim your position.

How do you calculate your CAGR in such cases?
8/

Let's take an example.

Say you bought 100 shares of $GOOG on 2015-Dec-31.

Then, on 2017-Apr-25, say you bought 50 more shares.

Then, on 2018-Jul-27, say you sold 70 shares.

This left you with 100 + 50 - 70 = 80 shares, which we'll assume you're still holding today:
9/

As the table above shows, your actions result in some cash inflows and outflows over time.

Every time you buy stock, there's a cash outflow. And every time you sell, there's a cash inflow.

Here they are, marked on $GOOG's stock chart:
10/

You can create a "cash flow timeline" that neatly captures these inflows and outflows. Like so:
11/

Going back to the bank analogy: every cash *outflow* is like a *deposit* you make into a hypothetical bank account that's compounding your money.

And similarly, every cash *inflow* is like a withdrawal you make from the same bank account.
12/

Imagine what would happen if you actually made these deposits and withdrawals.

Each deposit will give you a "benefit" that compounds over time, and each withdrawal will negate some of the benefit created by the deposits.
13/

For example, buying 100 shares of $GOOG on 2015-Dec-31 gives you the benefit of $75,888 compounding for 1,660 days.

And selling 70 shares on 2018-Jul-27 erases the benefit of $86,695 compounding for 721 days.

This all follows from the "cash flow timeline" above.
14/

These compounding benefits and negations all ultimately add up to your end balance ($121,244 in this case).

To capture this, we write a "CAGR equation".

The left side (LHS) of the equation takes care of all the compounding. The right side (RHS) is your end balance.

Pic:
15/

All that remains is to solve this equation to find R (our CAGR).

But this equation is *not* like the earlier equation we solved.

In the earlier equation, we could just rearrange the terms to solve for R.

But here, that's not possible. We need more powerful techniques.
16/

Graphing the LHS and the RHS is a good way to solve this equation.

You take R on the X-axis.

And on the Y-axis, you graph both the LHS and the RHS.

Wherever the LHS and RHS meet, that R is your CAGR.

Like so:
17/

There's also another way to solve the CAGR equation.

You start with a "guess" for R.

Say, R = 10%.

If R was really 10%, what would your end balance (on 2020-Jul-17) be after the compounding effect of all the deposits and withdrawals?
18/

Easy. This is just your LHS evaluated at R = 10%. In this case, it works out to $32,808.

This is *lower* than your real end balance: $121,244 (the RHS).

So your CAGR has got to be better than 10%.
19/

OK. Let's try 20% then.

Now, the LHS works out to $128,209.67.

This is *higher* than your end balance of $121,244.

So your CAGR can't possibly be as high as 20%.

That means your CAGR lies somewhere between 10% and 20%.
20/

OK. What about 15%?

Turns out the LHS for R = 15% is only about $97,534 -- also *lower* than your end balance.

So your CAGR has to be higher than 15% but lower than 20%.

Carrying on this way, you can narrow down your CAGR into a very tight range.
21/

This is called "the bisection method" of solving the CAGR equation.

You start with a CAGR guess. At the beginning, this guess may be wide off the mark. But you keep iterating and improving upon it. Pretty soon, you're really close to the right answer.
22/

Here's the bisection method in action for this particular example. As you can see, bisection finds the same answer as the graphical method (CAGR = 18.94%), but with much higher precision.
23/

Dividends can complicate the picture a little. But don't worry: the principle is the same.

Just treat each dividend as a cash inflow on its pay date. Add these inflows to the cash flow timeline. Then use the same procedure (graphical or bisection) to calculate CAGR.
24/

Here's a picture summarizing the 3 steps of a CAGR calculation:

1) Prepare a cash flow timeline,
2) Write down the CAGR equation, and
3) Solve this equation either graphically or via bisection.
25/

CAGR is a key metric we investors use to judge the performance of individual investments, portfolios, funds, and even fellow investors.

It's super important to know how to calculate CAGRs correctly. I hope this thread helps.

Thanks for reading. Enjoy your weekend!

/End

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with 10-K Diver

10-K Diver Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @10kdiver

Jan 1, 2023
1/

Get a cup of coffee.

In this thread, I'll walk you through "Gambler's Ruin".

This is a classic exercise in probability theory.

But going beyond the math, this exercise can teach us a lot about life, business, and investing.
2/

In my mind, Gambler's Ruin is the math of "David vs Goliath" ("Skill vs Size") type situations.

Here, David is a "small" player. He only has limited resources. But he's very skilled.

Pitted against David is Goliath -- a "big" player who has MORE resources but LESS skill.
3/

The battle between David and Goliath rages on for several "rounds".

Each round has a "winner" -- either David or Goliath.

David -- because of his superior skill -- has a higher probability of winning any individual round. That's David's advantage over Goliath.
Read 32 tweets
Dec 11, 2022
1/

Get a cup of coffee.

In this thread, we'll explore the question:

As investors, how often should we check stock prices?

To answer this, we'll draw on key ideas and concepts from many different fields -- probability, information theory, psychology, etc.
2/

Imagine we have a stock: ABC, Inc.

Every day that the market is open, our stock either:

- Goes UP 1%, or
- Goes DOWN 1%.

For simplicity, let's say these are the only 2 possible outcomes on any given trading day.
3/

Suppose we think ABC is a "good" investment.

That is, the company has a wide moat, good returns on capital, decent growth prospects, etc. And the stock trades at a reasonable price.

So, we buy the stock -- expecting to make a very good return on it. Say, ~15% per year.
Read 40 tweets
Oct 23, 2022
1/

Get a cup of coffee.

In this thread, I'll walk you through 2 key portfolio diversification principles:

(i) Minimizing correlations, and
(ii) Re-balancing intelligently.

You don't need Markowitz's portfolio theory or the Kelly Criterion to understand these concepts. Image
2/

Imagine we have a stock: ABC Inc. Ticker: $ABC.

The good thing about ABC is: in 4 out of 5 years (ie, with probability 80%), the stock goes UP 30%.

But the *rest* of the time -- ie, with probability 20%, or in 1 out of 5 years -- the stock goes DOWN 50%.
3/

We have no way to predict in advance which years will be good and which will be bad.

So, let's say we just buy and hold ABC stock for a long time -- like 25 years.

The question is: what return are we most likely to get from ABC over these 25 years?
Read 23 tweets
Sep 11, 2022
1/

Get a cup of coffee.

In this thread, I'll walk you through the P/E Ratio.

Why do some companies trade at 5x earnings and others trade at 50x earnings?

When I first started investing, this was hard for me to understand.

So, let me break it down for you.
2/

Imagine we have 2 companies, A and B.

Let's say both companies will earn $1 per share next year.

And both companies will also GROW their earnings at the SAME rate: 10% per year. Every year. Forever.
3/

Suppose A trades at a (forward) P/E Ratio of 10. So, each share of A costs $10.

And B trades at a P/E Ratio of 15. So, each share of B costs $15.

Which is the better long term investment: A or B?
Read 31 tweets
Sep 4, 2022
1/

Get a cup of coffee.

In this thread, I'll walk you through a fundamental business concept that may be counter-intuitive to some of you:

Just because a business has made $1 of PROFIT, it does NOT mean the business's owners have $1 of CASH to pocket.
2/

To understand why, let's start with how PROFIT is defined.

PROFIT = SALES - COSTS

That is, we take all sales (or revenues) the company made during a quarter or year.

We back out all costs incurred during this period.

That leaves us with profits.

Seems straightforward.
3/

Here's the problem:

The way a "lay person" understands words like SALES and COSTS is completely different from the way an *accountant* uses these same words.

These discrepancies can create enormous confusion.
Read 20 tweets
Aug 28, 2022
1/

Get a cup of coffee.

In this thread, I'll walk you through a framework that I call "Lindy vs Turkey".

This is a super-useful set of ideas for investors.

Time and again, these ideas have helped me think more clearly about the LONGEVITY of the companies in my portfolio.
2/

Imagine we're buying shares in a company -- ABC Inc.

ABC is a very simple company. It earns $1 per share every year. These earnings don't grow over time.

And ABC returns all its earnings back to its owners -- by issuing a $1/share dividend at the end of each year.
3/

Suppose we buy ABC shares for $5 a share.

That's a P/E ratio of 5.

We know we get back $1/year as a dividend.

So, for us to NOT lose money, ABC should survive AT LEAST 5 more years.

If something happens and ABC DIES before then, we'll likely lose money.
Read 32 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(