User Account

All Pages

Calculate the arithmeticmean of the monthly hprs

Assignment Help Science
Reference no: EM13292809

Complete calculation in the spreadsheet based on the IBM Excel Data.

The purpose of this exercise is to provide experience in locating, understanding, and analyzing basic stock price data. The ultimate objective is to translate this data into standard measures of risk and return.

The accompanying Excel file provides you with monthly price and dividend data for IBM (Ticker symbol: IBM) from Yahoo Finance.

(If you want to see where the data came from, go to Yahoo Finance.

Type in the ticker, IBM. Then, click historical prices.)Expand the spreadsheet and compute monthly HPRs for each of the 24 months using the HPR formula in Lesson 1 (RoR Attachment).

Make sure to include the dividends.

Calculate the arithmeticmean of the monthly HPRs for IBM.

Calculate the geometric mean of the monthly HPRs for IBM.

Expand the spreadsheet to calculate the standard deviation of the monthly HPRs using an approach similar to the one illustrated in the Measuring Risk section of Lesson 1(RoR Attachment).

Calculate the annualized version of your answers from parts 3 and 4.

(Your answers should be the annualized versions of only the final answers of parts 3 and 4, not annualized versions of each monthly HPR.) Report your final answersfor parts 2, 3 and 4 in the yellow cells in column E of the spreadsheet.

 


Attachment:- Assignment.rar

Reference no: EM13292809

Questions Cloud

Compute the effective cost of not taking the cash discount : Compute the effective cost of not taking the cash discount under the following trade credit terms.
What fraction of the total pressure on the container wall : A container encloses 4.0 mol of an ideal gas that has molar mass M1 and 1.5 mol of a second ideal gas that has molar mass M2 = 3M1
Identify one aspect of the law : After reading about HIPPA, identify one aspect of the law that you believe would be relatively simple for a provider to comply with and one aspect of the law that might be challenging for a provider to comply with.  Support your position with reasons..
Compute the period of oscillation of the system : A very light rigid rod with a length of 0.692 m extends straight out from one end of a meter stick. Determine the period of oscillation of the system
Calculate the arithmeticmean of the monthly hprs : Calculate the arithmeticmean of the monthly HPRs for IBM and calculate the geometric mean of the monthly HPRs for IBM.
Compute the magnitude of the force on the barge : Two canal workers pull a barge along the narrow waterway at a constant speed. One worker pulls with a force of 105 N at an angle of 28 degrees with respect to the forward motion of the barge, What is the magnitude of the force on the barge from the..
Healthcare practitioners to be exceedingly complex : Medicare billing guidelines are believed by many healthcare practitioners to be exceedingly complex.  Based upon your review of the guidelines, do you believe they serve any good purpose?
Explain hydrogen peroxide h2o2 with the alkene : Draw the structure resulting from a reaction of osmium tetroxide (OsO4) and hydrogen peroxide (H2O2) with the following alkene.
What is the current share price draw a timeline : If the required return is 13% and the company just paid a $1.80 dividend, what is the current share price Draw a timeline.

Reviews

Write a Review

Science Questions & Answers

  The mixture of gases in the venusian atmosphere

The Venusian atmosphere consists of 95% CO2 and 5% N2. Determine the apparent molecular weight for the mixture of gases in the Venusian atmosphere? Find the specific gas constant for the atmopshere of Venus?

  Human development

I have chosen the topic of: Why do we have a need to belong (to affiliate with others)? Examine various theories of human development, describing relevant terminology, and addressing how the theory assists in the understanding of issues involved in t..

  After taking a random

After taking a random start between 1 and 20 and then taking every 20th element from the sampling frame, Smith learned that 40% of the sample believed the company's president was doing a good job. The calculated standard error was 3 percent. What was..

  Cynthia was offered her dream job-business decision

Cynthia was offered her dream job from the competitor to her current company, she is in the middle of a project and would leave them in a bind if she left.

  Is it ever morally permissible to lie to someone

Is it ever morally permissible to lie to someone? Describe a circumstance in which it seems that lying might make more people happy than telling the truth.

  Compute number of plants with genotypic constitution

A plant having genotype AaBbCcDd is selfed producing 256 offsprings. compute Number of plants with genotypic constitution AABbCCDd.

  Write about with four articles correctly cited

Select a topic for your term paper and submit it for instructor's approval. Due by the end of this module. See below to learn more about your term paper. Your proposal must include: 1) a one paragraph description of the topic you wish to writ..

  An inability to control things

Do you think that people conform easier due to an inability to control things and the feeling of helplessness that usually accompany it?

  Objective questions

The Milesians and Heraclitus interpreted experience as, Positivism states that our descriptions and explanations of phenomena must be anchored in sense experience.

  Two parasites ctenocephalides canis and ancylostoma caninum

Do a quick search for the natural history of the following two parasites  Ctenocephalidaes canis  and  Ancylostoma caninum.  What is one main difference in their lifestyle? Mention one advantage and one disadvantage of their parasitic strategy.

  Training opportunities

Training opportunities with theft/loss prevention. I/O develops a training program to discuss with employees what the theft/loss prevention policy is at the shipping company, what the consequences are, how to identify theft/loss.

  The force of attraction

Two equal magnetic poles placed 5cm in air attract each other with a force of 14.4 *10^-4 N. How far from each other should they be placed so that the force of attraction will be 1.6*10^-4 N?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd