Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Corporate Finance Expert

Data Case:

Today is April 30, 2012, and you have just started your new job with a financial planning firm. In addition to studying for all your license exams, you have been asked to review a portion of a client’s stock portfolio to find out the risk/return profiles of 12 stocks in the portfolio. Unfortunately, your small firm could not afford the expensive databases that will provide all this information with a few simple keystrokes, but that’s why they hired you. Specially, you have been asked to find the monthly average returns and standard deviations for the 12 stocks for the past five years. The stocks (with their symbols in parentheses) are:

Archer Daniels Midland (ADM)            International Business Machines Corporation (IBM)
Boeing (BA)                                   JP Morgan Chase & Co. (JPM)
Caterpillar (CAT)                             Microsoft (MSFT)
Deere & Co. (DE)                            Procter and Gamble (PG)
Google Inc. (GOOG)                        Hershey (HSY)
Wal-Mart (WMT)

1. Collect price information for each stock from Yahoo! Finance (finance.yahoo.com).

2. Convert these prices to monthly returns as the percentage change in the monthly prices (Hint: Create a separate worksheet within the Excel file.) Note that to compute a return for each month, you need a beginning and an ending price, so you will not be able to compute the return for the first month.

3. find out the mean monthly returns and standard deviations for the monthly returns of each of the stocks. Convert the monthly statistics to annual statistics for easier interpretation (multiply the mean monthly return by 12, and multiply the monthly standard deviation by √12).

4. Add the column in your Excel worksheet with average return across stocks for each monthly. This is the monthly return to an equally weighted portfolio of these 12 stocks. find out the mean and standard deviation of monthly returns for the equally weighted portfolio. Double check that the average return on this equally weighted portfolio is equal to the average return of all of the individual stocks. Convert these monthly statistics to annual statistics (as described in Step 3) for interpretation.

5. Using annual statistics, create an Excel plot with standard deviation (volatility) on the x-axis and average return on the y-axis as follows:

a. Create three columns on your spreadsheet with the statistics you created in problem 3 and 4 for each of the individual stocks and the equally weighted portfolio. First column would have the ticket, the second would have annual standard deviation, and the third will have annual mean return.

b. Highlight the data in last two columns (standard deviation and mean), select Insert>Chart>XY Scatter Plot. Complete chart wizard to finish the plot.

6. What do you notice about average of the volatilities of the individual stocks, compared to the volatility of the equally weighted portfolio?

Corporate Finance, Finance

  • Category:- Corporate Finance
  • Reference No.:- M91704

Have any Question? 


Related Questions in Corporate Finance

Verizon vs atampt financial analysisthe specific objective

Verizon vs AT&T Financial Analysis The specific objective of this graded written research exercise is to prepare an "executive level financial report" to the Chief Financial Officer (CFO) of a mythical company in which y ...

Request alumni organization membership informationwhether

Request alumni organization membership information. Whether you're graduating this year or a few years from now, you may want to join a local alumni organization. Write an email to the head of the alumni association in t ...

You are considering purchasing the preferred stock of a

You are considering purchasing the preferred stock of a firm but you're also concerned about its capacity to pay the dividend. To help you feel more confident, you compute the times-preferred-dividend-earned ratio for th ...

Assessment 1instructions for studentsplease read the

ASSESSMENT 1 Instructions for Students Please read the following instructions carefully - This assessment is to be completed according to the instructions given by your assessor. - Students are allowed to take this asses ...

A developer plans to start construction of a building in

A developer plans to start construction of a building in one year if at that point rent levels make construction feasible. At that time the building will cost $1,000,000 to construct. During the first year after construc ...

Fundamentals of corporate finance1 suppose that you own

Fundamentals of Corporate Finance 1. Suppose that you own 2,200 shares of Nocash Corp. and the company is about to pay a 25% stock dividend. The stock currently sells at $100 per share. a. What will be the number of shar ...

Financial assignmentread the following case studyprecision

Financial Assignment Read the following case study: Precision Machines is preparing a financial plan for the next six months to determine the financial needs of the company. The historical analysis of the company's sales ...

Why do some developed countries have high levels of equity

Why do some developed countries have high levels of equity market capitalization to GDP while other developed countries have low levels? How do you suppose the adoption of the European single currency, the euro, has affe ...

You are the director of capital acquisitions for

You are the director of capital acquisitions for Morningside Hotel Company. One of the projects you are deliberating is the acquisition of Monroe Hospitality, a company that owns and operates a chain of bed-and- breakfas ...

Create an online reacutesumeacute-transform your

Create an online résumé:- Transform your résumé to an online version. Upload files, for example, relevant reports and presentations you have completed. Include links to companies and organizations with which you have bee ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro