Question: Solve this problems in words within 2 pages. Detail instructions of your project: 1. You have 1000000Tk to invest. You will be given a excel

Solve this problems in words within 2 pages.

Solve this problems in words within 2 pages.
Detail instructions of your project: 1. You have 1000000Tk to invest. You will be given a excel file where each group has to select minimum three stocks to invest and create you portfolio. 2. Try to spread your investment over different industry. 3. You may select the stocks based on the industry stability, low P/E ratio and previous company dividend payout trend of different stocks. Also try to use your general knowledge and tools like "Top down" or bottom up investment approach for creating the portfolio. You can also have the data of each stocks performance from DSE library to enrich your analysis to evaluate each stock. 4. For each stock: a. Calculate the average month return of each stock of your portfolio and risk from 01/07/2014 to 30/06/2020) b. Calculate the average weekly return for DSE index and risk (for the same period) c. Calculate the covariance and correlation between each pair of stock d. Calculate beta for each stock. Show the decomposition of risk: Systematic risk vs Non-Systematic risk 5. Form a variance-covariance matrix 6. For Portfolio: a. Calculate the risk and return of your portfolio b. Derive an efficient frontier (the most important!)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!