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. Select the stocks of three publicly traded companies from different industries. State the criteria for selecting those securities.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 portfolio’s mean monthly return, variance, and standard deviation.7. Assuming your portfolio return follows a normal distribution, calculate the chance that your portfolio loses 10% of its value during any month?8. Assuming you have invested $100,000 in your portfolio, what is value at risk (VaR) of your portfolio at any particular month at 99% confidence level?9. Now randomly change your portfolio’s weights 100 times (note total weights should always be 100%), for each weight combination calculate the mean and standard deviation of your portfolio, and then draw the efficient frontier.10. For each item mentioned above explain your rationale and cite peer-reviewed and/or seminal sources.Note: Please provide detailed calculations and formula in excel and its explanation in word.No Plagiarism.Thanks.

Choose one of the following two topics for your final project. It must be submitted in a Word or .pdf document, should be at least four pages, double spaced.Topic 1: See the "Opinion Shopping" case on page 483 of the text and fully answer the questions.Topic 2: See the "Tax Return Complications" case on page 491 and fully answer the questions.In either case, use the information and perspectives you have been exposed to in the course and discuss all sides of critical issues.Topic 1: See the "Opinion Shopping" case on page 483 of the text and fully answer the questions.The textbook is attached below.

For this course project assignment, design the goal(s), objectives, and delivery method for your training project. Make sure your objectives follow Bloom's taxonomy. Develop at least 3 goals for your training. Then develop 3-5 objectives of your training for each of your goals. Remember, the objectives should: Have a specific and measurable outcome.Have a specific deadline.Be relevant to the participants' job.Be relevant to the overall goals of the organization.Example Objective: The participants of this sales training will be able to utilize 5 different closing techniques by the last day of this training. Example Objective: One hundred percent of the nursing staff will perfectly implement the new kidney dialysis procedure by June 30, 20xx. While more than one delivery method often works for a training project, pick the training method that is best suited to the tasks, objectives, and learners. Detail why you selected this delivery method.