馃攳
Geometric average annual return - YouTube
Channel: unknown
[1]
Let's look at an example of a problem which
asks to calculate the "geometric" average
[9]
annual return.
[10]
So, let's say we're given the following returns.
[16]
Let me just make something up.
[18]
Let's say, we have a 10% return, then we have
a negative 15% return, and the third one is
[28]
20%.
[29]
Okay.
[30]
So, this is what we are given.
[32]
And now, how are we going to calculate their
geometric average?
[40]
Let me pick the blue color...
[41]
So, here's...
[42]
So, there are two ways how you can do it.
[44]
One - you can do it by hand using the following
formula: you open parentheses where you have
[50]
the product of three things which are linked
to these three returns that are given for
[56]
each year.
[57]
So, 1 plus the first return.
[60]
Let's do it in decimals.
[62]
0.1.
[63]
Multiplied by 1 plus the second return.
[66]
However, because it's negative, we use the
"minus" sign.
[70]
So, -0.15.
[73]
And then we multiply it by the third term,
which is 1 plus the third return.
[81]
In decimals that's plus 0.2.
[85]
And then, the whole thing, the whole product
of these three terms, is taken to the power
[91]
"one third", where 3 is always the number
of the returns that are given to you.
[100]
And then you subtract 1.
[101]
So, if you do the math this way, you'll get
3.91%.
[108]
3.91%.
[111]
This is the answer.
[113]
But there's a second way of doing it using
the financial calculator!
[119]
So, let's, let's do the following.
[123]
We have Year 0, Year 1, Year 2, and Year 3.
[133]
Right?
[134]
So, let's make something up for Year 0!
[138]
You just make it up.
[139]
Make up some dollar amount.
[140]
And the meaning of it will be - because we're
talking about returns on stock investment,
[147]
for example, the meaning of Year 0 dollar
amount would be how much you pay to buy, let's
[153]
say, one share of stock.
[154]
So, let's make it $100.
[156]
Right?
[157]
And I'm gonna, you know, add this note here:
"make it up!"
[164]
Right?
[165]
So, you completely make it up.
[167]
It's completely up to you if it's $100 or
$1 or $5 or anything else.
[175]
Okay.
[176]
So, if it's $100 that you're paying today
to buy one share of stock, then after 1 year
[183]
what will be the price per share, if the return
is 10%?
[188]
Well, it's gonna be 10% higher price.
[190]
So, we can do it in the financial calculator
by using $100 from Year 0 as our Present Value,
[199]
and we would want to make it negative, then
N=1 because we're doing it after just one
[207]
year, and I/Y, the interest rate, is what's
given for the first year, 10%.
[214]
And we're computing the Future Value.
[217]
So, let me bring up the financial calculator.
[219]
Let's turn it on.
[223]
100...
[224]
Negative...
[225]
Is our Present Value...
[226]
1 is our N...
[229]
10 is our I/Y...
[231]
And we are computing...
[235]
Compute...
[236]
Future Value.
[237]
110!
[238]
Just like we expected.
[240]
Okay.
[241]
So, 110.
[243]
Then, the second year calculations of stock
price in dollars are done the same way.
[249]
So, now the price is 110.
[252]
That's the PV, right?
[253]
And you make it negative again.
[255]
110.
[256]
Again, we want to see what the price will
be 1 year later.
[260]
So, the N is still 1.
[262]
It's not 2, but it's still 1.
[263]
We're doing everything in one-year increments.
[267]
I/Y, the return on this stock investment,
right? during the second year - that's a negative
[274]
15% return.
[275]
So, that's my I/Y.
[278]
And I'm computing the Future Value.
[281]
Okay.
[282]
Financial calculator again.
[284]
We can actually leave the answer on the display,
change the sign of it to negative, and then
[291]
save it as PV.
[292]
So, now we're beginning the Year 2 calculations.
[296]
N=1.
[297]
So, I press "1", "N".
[300]
15, negative.
[302]
I'm doing "15", then "plus minus", then "I/Y".
[306]
And I am computing Future Value.
[310]
And, as expected, because of the negative
return the price should be less than $110.
[317]
It's now $93.50.
[319]
Okay.
[321]
$93 and 50 cents is the new price.
[326]
And then we repeat the same thing one last
time for Year 3!
[332]
So, PV is -93.5.
[336]
N is again 1, because we're looking at the
change in stock price over 1 extra year.
[346]
I/Y is the third return that's given, which
is 20%.
[350]
Okay.
[351]
So, I put 20.
[352]
And I'm again computing the Future Value.
[355]
Let's see what's that... what that's going
to be.
[358]
Okay.
[359]
So this becomes my Present Value, and I need
to make it negative first.
[363]
Negative ("+/-"), "PV"... "1", "N"... "20",
"I/Y"...
[370]
Compute ("CPT"), Future Value ("FV")...
[373]
112.20.
[374]
Right?
[376]
$112 and 20 cents.
[380]
So, $112 and 20 cents.
[385]
And the last step is the following.
[390]
So, here is the last step: the last step is
- we are taking this price from Year 0, our
[402]
starting point, and the price that we calculated
for end of Year 3.
[409]
And now we are doing the following.
[412]
Present Value is $100 from Year 0, then Future
Value is the last price that we found, 112.20,
[425]
they are 3 years apart, and we want to compute
the implied interest rate, or growth, that
[436]
allows the $100 price per share to sort of
gradually grow over the 3 years to $112.20.
[449]
Compute I/Y.
[450]
Okay.
[451]
Let's try that!
[452]
So, this is my Future Value.
[454]
I'm hitting "FV" again to save it.
[457]
Then, 100 - and I'm making this one negative
- was my original Present Value.
[464]
"3", "N".
[466]
They are three years apart.
[469]
And I'm computing I/Y. 3.91, just like in
the calculation I did first using this long
[478]
formula!
[480]
So, 3.91%.
[483]
3.91%.
[485]
Again, exactly the same answer.
[489]
So, it's up to you if you're comfortable with
this complicated formula with double parentheses,
[498]
and the power which is a fraction, and so
on.
[501]
If you know the order of operations and are
sure you can do it right, then you can go
[505]
ahead and do it all in one step.
[507]
Or, you can do it and then just double-check
your math using the financial calculator steps.
[515]
Now, let me give you one more explanation
for the geometric average return.
[520]
So, we're basically saying that... so, this
is "time", right?
[526]
So, we have "Year 0", 1, 2, and 3.
[533]
And so, we, we, let's say we're talking about
buying shares of stock of some company.
[538]
So, instead of saying that... so, we start
somewhere here...
[543]
I just randomly picked this point...
[545]
And then the price grows by 10%, right?
[550]
Over the first year.
[551]
So, this is +10%.
[554]
Then, what we are given is a 15% drop.
[559]
So, something like this, right?
[563]
It's -15%.
[567]
And then we have a 20% jump.
[570]
So, something like this, right?
[574]
So, +20%.
[576]
So, what we're doing now is - with the 3.91%
geometric average we are kind of allowing
[589]
the price to slowly grow from the starting
point, whatever that is, and we decided that
[598]
it's gonna be $100, for example, to something
at the end of three years, which in our example
[606]
is $112.20.
[607]
Right?
[608]
So, we have +3.91% per year, and I'm gonna
add something clarifying: "compounded annually".
[620]
Right?
[621]
And so the way we interpret the geometric
average is - we would say something like this.
[632]
If you invest your money for 3 years (you're
not saying 1 year, right?), for 3 years, the
[638]
entire investment period that we are given,
then the money will be growing on average
[645]
by 3.91% per year, comma compounded annually.
[651]
With the arithmetic average you instead say
that the return you earn on average every
[660]
year is so-and-so percent when the money is
invested for just 1 year.
[665]
So, with the geometric average it's not a
1-year investment, it's a multi-year investment.
[672]
In our problem, it's a 3-year investment.
Most Recent Videos:
You can go back to the homepage right here: Homepage





