Рет қаралды 21,305
Delve into the world of portfolio optimization with our step-by-step guide on 'Efficient Frontier Explained in Excel: Plotting a 3-Security Portfolio.' Learn to calculate expected returns and standard deviation for individual securities, assign random weights, and effectively use the Sharpe Ratio and Covariance Matrix for risk management. We conclude with plotting the Efficient Frontier using Monte Carlo Simulation, helping you identify the optimal portfolio.
💾 Purchase the file created in this video here: ryanoconnellfi...
🎓 Tutor With Me: 1-On-1 Video Call Sessions Available
► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/
👨💼 My Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs: ryanoconnellfinance.com/freelance-finance-services/
Chapters:
0:00 - Intro to "Efficient Frontier Explained"
0:41 - Calculate Expected Returns: Individual Securities
3:30 - Calculate Standard Deviation: Individual Securities
4:31 - Assign Random Weights
5:40 - Calculate Total Portfolio Expected Return
6:13 - Create Covariance Matrix
8:31 - Calculate Total Portfolio Standard Deviation
9:29 - Calculate Sharpe Ratio
10:42 - Plot Efficient Frontier Using Monte Carlo Simulation
12:17 - Find the Optimal Portfolio: Portfolio Optimization
*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