10. Portfolio Optimization using five stocks in excel: MINIMIZING RISK & MAXIMIZING RETURN

Portfolio Optimization using five stocks in excel: MINIMIZING RISK & MAXIMIZING RETURN
Portfolio Investment
A portfolio investment is an investment in a combination of securities. Markowitz (1948-52) explained the concept of portfolio investment and guided how investors can maximize the returns on their portfolios. The basic concept is to invest in diversified assets. Investment in diversified assets will increase the returns while resulting in a decrease in risk.
For finance students and practitioners, it is a challenging task to evaluate the risk and return on portfolios having multiple assets. The most challenging task is to allocate optimal weights that maximize returns while minimizing risk.
The whole process of portfolio optimization can be very easy if we use Microsoft Excel. I have tried to explain this concept in Microsoft Excel.
In this video, a portfolio of 5 securities is created with optimal weights.
For further, You can contact us:
Dr. Saif Ullah
[phone]
[e-mail]
www. SAIFULLAH271
/ saifullah271
Other Related Videos
0. HOW TO SELECT STOCK BROKER? |PSX |
• 0. HOW TO SELECT STOCK...
1. HOW to Find Historical Share Prices (PSX)? || Accessing stock market data
• 1. HOW To Find Histori...
2. Calculating Stock Risk and Return (Manually)
• 2. Calculating Stock R...
3. Calculating Stock Risk and Return (Excel)
• 3. Calculating Stock R...
4. HOW to Calculate Risk and Return Of A Stock? #Computing #Returns
• 4. HOW To Calculate Ri...
4.1 Why we use LN Returns in Finance?
• 4.1 Why we use LN Retu...
5. HOW To Calculate Risk And Return Of A Stock? #Computing Risk
• 5. HOW To Calculate Ri...
6. CALCULATING DOWNSIDE RISK IN EXCEL #VAR #Semi variance
• 6. CALCULATING DOWNSID...
6.1 Calculating the Downside Risk for Your Portfolio
• 6.1. Calculating the D...
7. Two Asset Portfolio: Calculating Covariance and Weights of Securities
• 7. Two Asset Portfolio...
8. Two Asset Portfolio: Calculating Portfolio RISK AND RETURN
• 5. HOW To Calculate Ri...
9. Three Asset Portfolio: Calculating Portfolio RISK AND RETURN
• 8. Three Asset Portfol...
10. Portfolio Optimization using five stocks in excel: CALCULATING COVARIANCE MATRIX • 9. Portfolio Optimizat...
11. Portfolio Optimization using five stocks in excel: MINIMIZING RISK & MAXIMIZING RETURN
• 10. Portfolio Optimiza...
12. EFFICIENT FRONTIER FOR A TWO STOCK PORTFOLIO #Investments
• 12. EFFICIENT FRONTIER...
13. Graphing the efficient frontier for Multiple Stock portfolio in Excel
• 13. Graphing the effic...
14. Computing Systematic and Unsystematic Risk in Excel
• 14. Computing Systemat...
14.1 CALCULATING THE SYSTEMATIC RISK OF A PORTFOLIO
• 14.1 CALCULATING THE S...
15. Capital Asset Pricing Model, Undervalued/Overvalued Stocks and SML
• 15. Capital Asset Pric...
16. PORTFOLIO PERFORMANCE EVALUATION
• 16. PORTFOLIO PERFORMA...
To Subscribe Channel:
/ @saifullah271

[@aamirsajjad4289]

Mashallah, excellent thanks

[@SaifUllah271]

Thanks