馃攳
Risky Finance Part 2 Utility function excel example - YouTube
Channel: unknown
[0]
- So I'm going to go ahead now
[2]
and do a little
numerical example
[4]
with a utility function here.
[6]
So I've got a utility function,
[9]
and it's a pretty simple one.
[10]
There are lots of ways
in which economists
[12]
model utility function.
[14]
In this one,
the person's utility is just
[18]
their consumption raised
to whatever number
[22]
I've put in this cell here,
[23]
so I'm calling this thing Theta.
[24]
That's the name
of the coefficient.
[26]
So when this person has zero
consumption,
[30]
they get zero raised
to the 0.4 power.
[34]
When they have $1,000
of consumption,
[36]
they get $1,000 raised
to the 0.4 power
[39]
and so on and so forth.
[41]
And just because this is ugly
to have so many decimal places,
[45]
let me go ahead and decrease
the number of decimal places
[55]
to make it a little
bit less ugly.
[57]
Okay, so you can see we
also have the concept
[62]
of what is called
marginal utility.
[67]
So another way
of saying people are risk averse
[70]
is that they have decreasing
marginal utility.
[73]
So the first $1,000
[75]
of consumption gets this person
15.84 units of utility.
[86]
Ah, you won't let me do that.
Okay.
[88]
Let's go ahead--
[90]
let's highlight all of this.
[100]
So the first $1,000 worth
[102]
of income gets this person 15.8
units of utility,
[106]
and don't worry too much about
exactly what the units are.
[109]
And the second
$1,000 gets them 5.1, the third
[112]
$1,000 gets them 3.7. So
what I keep on doing here
[115]
to calculate this is I take
the new value
[119]
and subtract off
the previous value.
[122]
And if we wanted to look
at these things graphically,
[126]
this curve right here is how
their total utility changes
[130]
as their income changes.
[132]
This income--
[133]
this curve over here is how
their marginal utility changes.
[136]
Another way of saying
[138]
that is the marginal utility is
the slope of that curve there.
[142]
So this is all good
and nice and everything,
[145]
and we can see how marginal
utility gets smaller
[148]
and smaller and smaller
as we go up to higher
[150]
and higher levels
of consumption.
[153]
Two things to illustrate.
[154]
One is I talked previously
[156]
about we could think
about what level of consumption
[161]
would be equivalent to the risk
that they're bearing.
[166]
So if this person was at $5,000
worth of consumption,
[171]
and they faced a 50/50 chance
of either being $5,000 poorer,
[178]
which would give them
$0 consumption,
[181]
or $5,000 richer, which would
be $10,000 consumption.
[187]
Then what level
of utility would they get?
[190]
Well, we would think normally
[192]
that they would have a 50%
chance of having a low level
[195]
of utility up here
and a 50% chance
[199]
of having that high level
of utility there.
[202]
So this calculation takes each
of those numbers in D4 and D14,
[208]
multiplies by 0.5
because you have a 50% chance
[211]
of ending up
in each of those categories
[214]
and then figures out what level
of utility that would give you,
[218]
and it gives you 19.9.
And you can see 19.9
[224]
is equivalent to being somewhere
between $1,000 and $2,000.
[228]
In particular,
we can take that 19.9
[232]
and raise it to 1/this Theta
[236]
and get back to the level of
income that would be consistent.
[241]
So this person would
rather receive $1,767
[249]
with 100% certainty than face
this gamble of, well,
[253]
I could end up $5,000 better off
[256]
or I could end up $5,000 worse
off and get nothing at all.
[261]
So obviously,
they are quite anxious
[263]
to avoid having nothing at all.
[267]
Another way to look
at this kind of thing
[268]
is how would people react
to different bets here.
[273]
And so what I'm thinking
of now is a bet
[276]
where heads they win $150,
tails they lose $50.
[282]
So obviously, on average,
this is a winning bet.
[285]
And in particular,
[286]
you can see that well,
on average,
[289]
they're going to go ahead
and win about $50.
[293]
So this particular person,
if they face that bet--
[298]
don't worry too much
about the exact math here--
[300]
this person would
have higher utility
[303]
if they have the opportunity
to take this bet.
[306]
And you can see that kind
of relative to the level
[309]
of income they already have,
[311]
this prospect of like worst-case
scenario is I lose $50.
[315]
Well, that's not too bad.
[317]
And there is
a considerable upside.
[320]
What if we go ahead
[321]
and look at a case where it's
the same expected gain?
[326]
Notice the good scenario is $100
higher than the bad scenario.
[331]
But the swing around
is much bigger.
[333]
Instead of -50 versus
+150 we have -500 versus +600.
[341]
And yes, this person still
benefits from taking that bet,
[345]
on average, but not by as much.
[348]
An even more uncertain bet,
same expected outcome,
[351]
the average winnings are
still the same,
[354]
but the level of uncertainty is
much greater with Bet Number 3,
[357]
and this person would reject
that bet because essentially,
[361]
the downside pain
of losing $1,000 is so big
[365]
compared to the average
expected gain of $50.
[369]
And they're definitely
going to reject Number 4.
[373]
So at a higher level of income,
[375]
this person's attitudes
towards those bets changes.
[379]
The first two bets,
they were acceptable before.
[381]
Now, the third bet is also
acceptable for this person
[384]
who has $15,000 worth
of consumption.
[387]
The fourth bet is still
unacceptable to them.
[391]
And then finally,
if we go down to someone
[394]
who has an even higher
level of consumption,
[396]
someone who is already
[398]
at $35,000, they're going
to find all of these bets
[401]
as potentially
rewarding for them.
[404]
So notice someone's level
[407]
of current income or current
consumption is going to affect
[411]
how risk averse they are.
[413]
Also, just some people have
a different psychology.
[415]
It might be
that this Theta here,
[418]
which is going
to tell us something
[419]
about their risk aversion,
[421]
is just going to be different
for different people.
[423]
And the way I've written this,
[425]
this Theta essentially measures
how risk tolerant someone is.
[430]
If they have a Theta of 1,
[433]
they're completely
risk tolerant.
[434]
If they have a Theta of,
like,
[436]
0.01, then they're going
to be pretty risk intolerant.
[443]
So just people
[444]
may have different
psychological predispositions.
[448]
Some people are sort of very
anxious and risk avoidant.
[451]
Other people are a little bit
[452]
more optimistic
and risk tolerant,
[455]
and people are just going to end
up making different decisions
[457]
because of that in addition
to differences
[460]
in their level of income.
Most Recent Videos:
You can go back to the homepage right here: Homepage





