Calculating rate of return with Excel
Not what you're looking for?
Please answer each part of the question using an excel spreadsheet. Enter the proper formulas within the spreadsheet.
Problem 1:
Suppose that at the beginning 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 price of AAPL.
AAPL Stock Prices
Date Price
2006 59.77
2007 121.19
2008 188.75
2009 135.81
2010 256.88
2011 337.41
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?
Purchase this Solution
Solution Summary
The following posting helps calculate the rate of return with excel.
Solution Preview
Hello,
Please see the attachments for the solution. Thank you for asking BrainMass!
Problem 1:
Suppose that at the beginning 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 ...
Education
- B. Sc., University of Nigeria
- M. Sc., London South Bank University
Recent Feedback
- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Learning Lean
This quiz will help you understand the basic concepts of Lean.