What is the compound average annual rate of return

Assignment Help Finance Basics

Reference no: EM131368450

Suppose that at the beginning of May 2006 you purchased shares in Apple, Inc. (Nasdaq: AAPL). It is now five years later and you decide to evaluate your holdings to see if you have done well with this investment. The table below shows the market prices of AAPL.

a. Enter the data, as shown, into a worksheet and format the table as shown.

b. Create a formula to calculate your rate of return for each year. Format the results as percentages with two decimal places.

c. Calculate the total return for the entire holding period. What is the compound average annual rate of return?

d. Create a Line chart showing the stock price from May 2006 to May 2011. Make sure to title the chart and label the axes. Now, create an XY Scatter chart of the same data. What are the differences between
these types of charts? Which type of chart is more appropriate for this data?

e. Experiment with the formatting possibilities of the chart. For example, you might try changing it to a 3-D Line chart and fill the plot area with a marble background. Is there any reason to use this type of chart to display this data? Do the "enhancements" help you to understand the data?

Reference no: EM131368450

Questions Cloud

Write an essay that critiques the given statement : Write an essay that critiques the following statement.- It may include a standard form of the argument, it may identify and address a fallacy, and it may critique a theory. All methods are open for utilization in the critique.

Define the disease and describe all relevant symptoms : Describe all relevant symptoms.List all known causes of the disorder; include any environmental factors that may be involved; list and medications and/or genetics that may cause the disease.Identify any known risk factors; include any age groups, ..

Number of elements equal to the random integer argument : Use a loop to append to the list a number of elements equal to the random integer argument. All new list elements must be random integers ranging from 1 to 100, inclusive. Duplicates are okay.

Discuss what influences ethical decision making : Ethical decision making is a necessary part of doing business. Discuss what influences ethical decision making. What are some practical steps that managers can take to improve ethical decision making?

What is the compound average annual rate of return : Create a Line chart showing the stock price from May 2006 to May 2011. Make sure to title the chart and label the axes.

Write the given paper assignment : Select a contracting subject pertaining to the FAR Sections covered in this class- Research individually the selected topic.

International human resource management : You are the HR Manager of an Australian based airline that operates both domestic and international services and has its headquarters in Melbourne. Your organisation has decided to recruit a manager who has extensive experience in the airline industr..

What is child sexual abuse : What is child sexual abuse (CSA):Perpetrator Risks and Dynamics,Cultural and Ethnic Considerations,Prevention.

What groups or stakeholders benefit from trade in conflict : What groups or stakeholders benefit from the trade in conflict coltan and how? How or how not does the concept of constructive engagement (p. 130) apply in the trade of conflict coltan?

User Account

All Pages