I already have my education in finance but I enjoy crafting retirement calculators to keep my skills sharp. The ONE area that has eluded me has been MC analysis and you are the first person to present it in a clear, easy to understand format! Also, a tip I came across from my work is using CTRL+SHIFT+Down Arrow will automatically select all your data and nothing more. CTRL+D will fill the selected formula all the way to the bottom. Here's hoping someone gets a little use out of it!
Can you do another one with showing examples of distributions. Not just accumulations. Thank you for the excel. I have been trying to create this for awhile.
Thanks for the video! Just wondering, how do you handle the occasional simulated return of less than -100%? particularly for assets that might have higher standard deviations? Occasionally, I'm getting a simulation trial where a year's return just flips the sign of the total portfolio. I feel like the portfolio shouldn't be able to lose more than 100% of it's value.
Enjoyable video for Monte Carlo Sim example. For savings growth, wouldn't you need an interest rate model rather than a normal distribution assumption?
This is very insightful and helpful. Could you explain whether the future value in this example would more likely be the average (around $5.7 million) or the median ($4.6 million +/-) and why?
I have come across a research paper in which they have developed regression models using past data (uptil 2016). The pdfs of variables were already known from literature review. For 2017 onwards, they utilized the forecasted values as the mean of the distribution and took 10% of that mean as standard deviation for each year, and performed MCS to calculate annual uncertainty. Is there any relation or basis for taking 10% of mean as SD for future uncertainty analysis? I have analyzed the past data as well SD is nowhere near 10% of the mean value.
Using a normal distribution to estimate stock returns is from wjat I hear a bad idea, amd results in am overly optimistic result. A different distribution is mkre accurate
excellent lecture 👍 this video actually helped me finally understand monte carlo now, whereas before I never really understood it when going through the CFA L1 or Mark Meldrum content i really like the retirement savings example you used too 😃
I already have my education in finance but I enjoy crafting retirement calculators to keep my skills sharp. The ONE area that has eluded me has been MC analysis and you are the first person to present it in a clear, easy to understand format!
Also, a tip I came across from my work is using CTRL+SHIFT+Down Arrow will automatically select all your data and nothing more. CTRL+D will fill the selected formula all the way to the bottom. Here's hoping someone gets a little use out of it!
Thanks for the tip!
Very well explained with great clarity. Really respect your work 😊
fantastic tutorial! very useful and applicable to everyone.
Excellent video. Thanks for sharing 👍
Very helpful video, thank you so much for your time and effort!
I love this guy! Great tutorial.
Can you do another one with showing examples of distributions. Not just accumulations. Thank you for the excel. I have been trying to create this for awhile.
Thanks for the video! Just wondering, how do you handle the occasional simulated return of less than -100%? particularly for assets that might have higher standard deviations? Occasionally, I'm getting a simulation trial where a year's return just flips the sign of the total portfolio. I feel like the portfolio shouldn't be able to lose more than 100% of it's value.
Great video
Very useful. Thank you!
loved this video
Enjoyable video for Monte Carlo Sim example. For savings growth, wouldn't you need an interest rate model rather than a normal distribution assumption?
What is the relationship between the standard deviation of ave return (originally 12%) and the standard deviation of the final end value?
Thank you! 😊
This is very insightful and helpful. Could you explain whether the future value in this example would more likely be the average (around $5.7 million) or the median ($4.6 million +/-) and why?
I have come across a research paper in which they have developed regression models using past data (uptil 2016). The pdfs of variables were already known from literature review. For 2017 onwards, they utilized the forecasted values as the mean of the distribution and took 10% of that mean as standard deviation for each year, and performed MCS to calculate annual uncertainty. Is there any relation or basis for taking 10% of mean as SD for future uncertainty analysis? I have analyzed the past data as well SD is nowhere near 10% of the mean value.
Thank you!
Sir,
How to Simulate to identified Trading Drawdown values for knowing Risk
Using a normal distribution to estimate stock returns is from wjat I hear a bad idea, amd results in am overly optimistic result. A different distribution is mkre accurate
excellent lecture 👍 this video actually helped me finally understand monte carlo now, whereas before I never really understood it when going through the CFA L1 or Mark Meldrum content
i really like the retirement savings example you used too 😃
Nice exaplanation. Guess the standard deviation should be 2% since it's assumed to hovering anywhere around +/-2% std deviation of 10%.