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.

If you had to make an investment decision right now, such as whether to put $1,000 into one of three companies, it would be helpful if you could rely on more than your personal feelings or sentiments toward a company. As illustrated in this week’s Learning Resources, financial statements help provide that additional insight into a company’s financial health. These statements will not be useful to you, however, if you do not know how to interpret them and understand the implications of what the numbers represent. Interpreting financial statements can be as much of an art as a science because analysts may interpret the data differently depending on their goals and outlook. In this Discussion, you will locate a publicly traded company, review its financial statements, and determine if investing in the company is a good or bad decision.To prepare for this Discussion:Visit the Nasdaq Company List at http://www.nasdaq.com/screening/company-list.aspx and locate a public company of your choosing. Select the company’s page and scroll down to the Fundamentals section of the navigation menu. Click on Income Statement. Review the company’s Income Statement, Balance Sheet, and Operating Cash Flow for the periods listed.Take note of any trends, whether positive or negative. Year over year, has the company performed well? Do you note any risks or areas for concern?Review the Academic Writing Expectations for 2000/3000-Level Courses, provided in this week’s Learning Resources.By Day 3Post a 75- to 150-word (1- to 2-paragraph) description of your selected public company’s financial outlook based on the financial statements you reviewed. In your description, include the following:A link to the company’s NASDAQ page, as well as the name and stock symbolA brief explanation of whether you would invest in the company based on the financial trends you observed (Note: You do not need to provide detailed financial data in your response; focus instead on overall trends year over year for the periods listed.)To support your response, be sure to reference at least one properly cited scholarly source.

Effective Compensation Plans In this assignment, you will use your textbook and the independent research you conduct to determine the components of an effective compensation plan, one that includes more than just base salary. Specifically, you will write a 4–6 page paper in which you: Research the components of an effective compensation plan.Determine the most beneficial ratio of internally consistent and market consistent compensation systems. Be sure your narrative is in your own words. Research the methods companies use to assess employee satisfaction with their pay structure.Outline how companies determine whether their employer-sponsored retirement plans and health insurance programs are competitive.Recommend two high value discretionary benefits to employees. Be sure to include your rationale for selecting these high value discretionary benefits as opposed to others. Integrate at least three quality resources using in-text citations and a reference page in your assignment. Note: Wikipedia and similar websites do not qualify as quality resources.The previous week's assignment preparation activity provides some suggested resources to help you begin your research. It also provides resources on avoiding plagiarism, appropriately integrating sources into your assignment, and using the Strayer Writing Standards. Format your assignment according to the following formatting requirements: This course requires the use of Strayer Writing Standards (SWS). For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course.The preferred method is for your paper to be typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides.Include a cover page containing the assignment title, your name, your professor's name, the course title, and the date. The cover page is not included in the required page length.Include a source list page. Citations and references must follow SWS format. The source list page is not included in the required page length. The specific course learning outcome associated with this assignment is: Determine the components of an effective compensation plan, including discretionary benefits. By submitting this paper, you agree: (1) that you are submitting your paper to be used and stored as part of the SafeAssign™ services in accordance with the Blackboard Privacy Policy; (2) that your institution may use your paper in accordance with your institution's policies; and (3) that your use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates.