Complete the requirements of following two companies
1- Gandhara Industries Limited Pakistan
2- Kohinoor Mills Limited Pakistan

 

2. Dowload their historical data of stock price for one year from yahoo finance. (5) 3. Using Excel Sheet, compute the following as we did in the last class: (9x10) i. Chnage in Stock Price on each date ii. Rate of Return on on each date iii. Average Rate of Return for the whole year iv. Deviation from Average Rate of Return on each date v. Squared Deviation on each date vi. Sum of the Squared Deviation vii. Standard Deviation viii. Relative Return for a given level of risk ix. Relative Risk for a given level of Return 4. Based on your computations in last part, make a decision which company would you like to invest and explain why? (5)