CAN YOU PLEASE SHARE THE EXCEL SHEET? I need to know how you obtained those values.
@george-mattgrounder-bentle90195 жыл бұрын
This was extremely helpful, when looking just at formulas it can be very confusing, but with your explanation I do not need to memorise any formulas as I now understand it. My University exam is tomorrow lol.
@bionicturtle5 жыл бұрын
We are happy to hear that this was so helpful. Good luck on your exam!
@Loserbethy14 жыл бұрын
Thank you! You've saved me. My exam is tomorrow and I can work through these problems now.
@bionicturtle12 жыл бұрын
What's interesting to me is the general inverse correlation between certainty of correction and accuracy. When somebody is certain ("must"), those are never correct. Uncertain fixes are more reliable. Most reliable are questions that assume I am correct and viewer is incorrect; those are highly predictive of actual mistake !!??
@samvitsaroj47576 жыл бұрын
How do we get u and d?
@HARSHBENIWAL235 жыл бұрын
Simple, to the point explanation. 👍
@bionicturtle5 жыл бұрын
Thank you for watching!
@krishnaKumar-zi6ct5 жыл бұрын
Thanks for the clear and visual explanation !!
@bionicturtle12 жыл бұрын
Discounting directly, to my knowledge, is not invalid and is logical. However, the above merely illustrates a standard binomial tree with so-called backward induction. The 0.5 nodes are discounted to the two 0.25 nodes, which in turn (backwards), are discounted to the one PV. Just as the tree builds forward one branch, so too the discounting in reverse. Thanks
@bionicturtle12 жыл бұрын
Nope, this tree makes the (typical) assumption that price is lognormal (i.e., Cox Ross such that is intervals reduce, you've got the Black-Sholes). So it recombines flat: ud = exp(volatility*SQRT[t])*exp(-volatility*SQRT[t]) = 1.0.
@tower199011 жыл бұрын
thank you so much for the help, your explanation is very clear!!! If every lecturer is as half good as you do, we humanity will advance much quicker...haha
@JohnJohn-yz3fi2 жыл бұрын
Did I miss something or he didn't take into account the dividend at all?
@SteveBiko20175 жыл бұрын
Would you kindly highlight how you derived the probability of the up jump...
@tibordeak5703 жыл бұрын
The formula is (exp((r-q)dt)-d)/(u-d). But his explanation totally misses the point.
@zubair14245 жыл бұрын
7:25 to 8:56 is horrendous FYI
@zF15z12 жыл бұрын
surely the 500 that is on the 3rd node is incorrect. If a stock were to go up 10% from 100 to 110, then fall by 10%, the value is 99. Therefore that 500 must be incorrect?
@nelsonng70268 жыл бұрын
can you given me the equation of discounting them back? because i cannot get $84.23
@jr200uk8 жыл бұрын
+Nelson Ng =(174.93*0.488)/(1+0.05*0.25)
@andrigilang16 жыл бұрын
thanks for the tutorial, its easy to understand
@samkaz32114 жыл бұрын
David..You Rock Man!! My FRM Guru :)
@rishabhtiwaari63787 жыл бұрын
how to calculate p??
@NuggetPotatoe7 жыл бұрын
P= (e^rt-d)\(u-d)
@limonadepacific637 жыл бұрын
p=(a-d)/(u-d)
@JiewKwang14 жыл бұрын
@humayunrali i guess its just a rounding up error.
@littlejupiter8913 жыл бұрын
doing this right now!!! in exam on Thursday......
@Staryu9912 жыл бұрын
Thanks a lot on your great explanation
@srpollaa15 жыл бұрын
hi... good one... can you kindly upload the xls file as well
@chung279210 жыл бұрын
Thanks a lot!
@bionicturtle10 жыл бұрын
You're welcome James Day! Thanks for watching!
@ArunKumar-yb2jn4 жыл бұрын
You are using Excel only as a JPEG image. The formula bar isn't visible and the video is quite verbose. This is so simple that it should have been live-solved and recorded. Saves tons of explanations.
@passenger6116 жыл бұрын
Thank you
@shankarthapa00112 жыл бұрын
thanks - it was very helpful
@n336714 жыл бұрын
god bless you, david! :)
@glr47647 жыл бұрын
How do you find P? It is the only part I don't get because it isn't shown or explained :(
@limonadepacific637 жыл бұрын
p=(a-d)/(u-d)
@bionicturtle11 жыл бұрын
thank you, very kind!
@EArtVideos8 жыл бұрын
Good evening! i have 2 questions unsolved: 1) how should i input the dividend yields in my calculations 2) why you use p and (1-p), and not the risk neutral probabilities??