I have small project and I need your help with it, below the steps and information:
The project idea is based upon how to form a portfolio applying theory with practical approach.
Follow the steps suggested below;
1. Select any 8 securities from the stock market. Among these 4 should be Sock securities and 4 should be Debt securities. These securities of stock should be from Qatar market and debt securities from any International stock market.
2. Form the 4 separate portfolios; two securities in each portfolio, [One stock + One debt security in each] see the flow chart.
3. Select the observations of securities prices from the respective stock exchanges sites for last Three months of periods starting from the date of 01/09/2012 to 30/11/2012
4. Once selected the securities and uploaded the prices for the period; apply the Weight for each two securities in each portfolio.
A. Expected Returns for each security
B. Variance for each security
C. Standard Deviation of each security
D. Standard Deviation of each portfolio
E. Covariance for each group
F. Coefficient Correlation for each group
G. Select the best portfolio among the four options
H. State the reasons of selection
6. Show up every calculations along with all formulas.
7. Show all tables and sub tables.
8. Use excel as software.
9. Attach all documents with references.
10. Use 12 font size and Times New Romans.
Thank you in advance!