Create a histogram for the annual percentage return data

Reference no: EM131955871

Question: Choose any publicly traded company that has stock price data from January 1, 2002 - December 31, 2016 and answer the following questions.

Calculate the total dollar return for the stock, using the adjusted close price, if you bought 100 shares of the stock over the past 15 years

What was the total percent return using the information from the preceding question?

Using the adjusted close price, what were the dividend yield and capital gains yield from May 1, 2007 through April 30, 2008, if you had bought 100 shares of stock?

Using the public information, what was your stock's average percent return for the last 15 years?

Using excel, create a histogram for the annual percentage return data.

Using excel, calculate the variance, standard deviation, and geometric average return.

Explain what the variance, standard deviation, and geometric averages tell you about the stock.

Using excel, calculate the simple three-month moving average.

Using theta (F), calculate the primary and secondary support levels using the stock prices on September 15, 2015 and January 15, 2016.

Reference no: EM131955871

Questions Cloud

What is dollar effect of the year-end bad debt adjustment : How accounts receivable would be presented on the balance sheet. What is the dollar effect of the year-end bad debt adjustment on the before-tax income?

Kinetic energy of a nonrelativistic particle : The kinetic energy of a nonrelativistic particle can be written in terms of its momentum as:

How would you describe betty fords leadership : How would you describe Betty Ford's leadership? In what ways could her leadership be described as authentic?

What is the uncertainty in the energy of that state : An excited state in a certain atom has an average lifetime of 5.2 × 10-10 s. What is the uncertainty in the energy of that state?

Create a histogram for the annual percentage return data : Using excel, create a histogram for the annual percentage return data. Using excel, calculate the variance, standard deviation, and geometric average return.

Describe the costs of goods transferred out : Describe the costs of goods transferred out and the ending inventory using the weighted-average method.

Decide between two different investment opportunities : He has $10,000 in the bank now and is trying to decide between two different investment opportunities,

Analyze what is the unit product cost for the month : Analyze What is the unit product cost for the month under variable costing? Prepare an income statement for the month using the variable costing method.

How much money would you need to invest : You have your choice of two investment accounts. Investment A is a 12-year annuity that features end-of-month $1,300 payments and has an interest rate of 7.1.

User Account

All Pages