kindly give me answer iam waiting for 24 horus no one is giving me answer. and iam wasting my attempts i have paid for chegg but there is no expert who give me answer third class service from chegg account totally waste of money

SPRING-21 | Financial Management & Application Project of Diversified Portfolio Construction

You are a portfolio manager and willing to develop a diversified portfolio for your cliental who is risk averse. He wants to investment 5 million in Pakistan equity market. Your job to find out potential investment companies which are having lower risk and satisfying the clients investment objectives. Following are the steps are required to make this diversified portfolio.

1. Select listed companies from Pakistan Stock Exchange. www.dps.psx.com.pk
2. Extract daily price of selected companies from 1^st January 2017 to till-date. www.ksestocks.com
3. Transform daily prices into returns and calculate Average daily return, standard deviation and Co-efficient of variation and then calculate annualized return as discussed in class.
4. Construction Covariance & Correlation metrics as taught in class.
5. Select weak or negative correlated stocks for portfolio of 5 companies.
6. Allocation of funds with optimal weights which reduces the overall portfolio standard deviation which is better for client objectives. (Hint: use excel solver function).

Further your submission should be in the form of Excel file with complete working where formulas are showing.