Attempt all questions in excel sheet. And please search for all information from the sources given in question.
You are a Fund manager and trying to make a diversified portfolio for your client after analyzing all the parameters. You have 1 million rupees for an investment, keep in mind your client behavior is classified under "Risk Averse" category. Few steps for developing a well- diversified portfolio. You are allowed to invest only 5 stocks in your client's portfolio. 1. Select at least 10 companies which are listed in the Pakistan Stock Exchange from different sectors. 2. You can select maximum two companies from each sector. You must mention reason of selection of company from each sector. Reason may be future growth forecast, dividend payout, liquidity or strong business group etc. It means you need to justify why you select a particular company. 3. Extract ONE year monthly closing prices. (Hint: Price should be last working day of the month) Price you can start from January 2019 till June 30" 2020 as you feel comfortable to get data. 4. Extract ONE-year months closing points of KSE-100 Index. Index can start from January 2019 till June 30" 2020 as you feel comfortable to get data. 5. Calculate the average return from historical prices which you extracted in step 2 and 3. Take care that return will be calculated for all companies you selected as well as KSE-100 Index. 6. Calculate the Standard deviation of historical (Monthly Closing) prices and KSE-100 index. 7. Calculate the Co-efficient of variation of each company to figure out which company is bearing lower per unit of risk. 8. Select 5 companies with the help of CV in your portfolio in order to minimize the overall portfolio risk. 9. Calculate the required return through CAPM, your risk-free rate should be KIBOR one-year rate. Beta (Using formula of Covariance of Stock, Market divide by Variance of Market), and Market return assumed to be 15% You can take help from this video link to calculate Beta. https://youtu.be/JCyapYizUM 10. Develop a well-diversified portfolio by optimizing the weights (Percentage of investment) to attain objective of lower risk in terms of overall portfolio. Data Sources: www.psx.com.pk, www.dos.psx.com.pk, www.scstrade.com, www.sbp.org.pk Marking Scheme: Marks will be in the range as described below depending on how much you are meeting project requirements. 60-67 68-73 74-80 #1 plus Group once made Three changes Two changes One change No change and then not changed/add/remove members Selection of company | Not meeting Meeting but Meeting and Good selection meeting project criteria unable to justify | justify in report and justification criteria in writing Calculation Not presented Poor Presented but Good properly presentation lacking in presentation of appropriateness project working Beta calculation Not presented Poor Presented but Good properly presentation lacking in presentation of explanation Beta Portfolio selection as Not done Poor selection Good portfolio Very good required in Point 10 properly of companies plan portfolio of project for portfolio making based on CV Overall presentation Not good Good Very good Impressive of Project meeting all 10 points of Project
