This is complete write up of your portfolio formation in a Word file, with calculations copied and pasted in it from your Excel file. 1. Stocks of Five publicly traded companies from different industries which constitute the Nifty 50 industry has been distributed randomly to participants in the attached excel. List the LTP, EPS and BV based on last quarter. Calculate the P/E and P/B for those companies. 2. Retrieve monthly data on adjusted closing prices of your securities from Yahoo Finance for the past 10 years and calculate the monthly rate of return of the stocks for every month. 3. Calculate the mean, variance, and standard deviation of the stocks monthly returns. 4. Calculate the correlation coefficient between every possible pair of stocks returns. 5. Decide what percentage of your money (weights) you want to invest in each stock and state the criteria you used to select those weights. 6. Now calculate your portfolios mean monthly return, variance, and standard deviation. 7. Assuming your portfolio return follows a normal distribution, calculate the chance that our portfolio loses 10% of its value during any month? 8. Assuming you have invested $100,000 in your portfolio, what is the value at risk (VaR) of your portfolio at any particular month at 99% confidence level?