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!
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 😃
Enjoyable video for Monte Carlo Sim example. For savings growth, wouldn't you need an interest rate model rather than a normal distribution assumption?
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.
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?
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.
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
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 😊
Excellent video. Thanks for sharing 👍
Very helpful video, thank you so much for your time and effort!
fantastic tutorial! very useful and applicable to everyone.
I love this guy! Great tutorial.
Very useful. Thank you!
Great video
loved this video
This is full of great excel tips, but I am not sure of the applicability to retirement planning.
Thank you! 😊
Thank you!
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 😃
Enjoyable video for Monte Carlo Sim example. For savings growth, wouldn't you need an interest rate model rather than a normal distribution assumption?
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.
Nice exaplanation. Guess the standard deviation should be 2% since it's assumed to hovering anywhere around +/-2% std deviation of 10%.
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?
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.
What is the relationship between the standard deviation of ave return (originally 12%) and the standard deviation of the final end value?
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
Sir,
How to Simulate to identified Trading Drawdown values for knowing Risk