Stock Portfolio Monte Carlo Simulation In Excel
YouTube Viewers YouTube Viewers
28K subscribers
21,183 views
0

 Published On May 3, 2022

Ryan O'Connell, CFA, FRM shows how to build a Stock Portfolio Monte Carlo Simulation In Excel.

👨‍💼 Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs: ryanoconnellfinance.com/freelance-finance-services/

🎓 Tutor With Me: 1-On-1 Video Call Sessions Available
► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/

💾 Download Free Excel File:
► Grab the file from this video here: https://ryanoconnellfinance.com/produ...

Chapters:
0:00 - Define Assumptions About S&P 500 Index
0:50 - Calculate the Ending Value of the Portfolio
2:30 - Create Monte Carlo Simulation Using Data Table in Excel
4:06 - Calculate Stock Portfolio Summary Statistics
6:28 - Create a Histogram of the Monte Carlo Simulation Results

*Disclosure: This is not financial advice and should not be taken as such. The information contained in this video is an opinion. Some of the information could be wrong. This channel is owned and operated by Portfolio Constructs LLC

show more

Share/Embed