Suppose that, in early February 2016, you bought shares of Apple (AAPL). This was five years ago
Fantastic news! We've Found the answer you've been seeking!
Question:
Suppose that, in early February 2016, you bought shares of Apple (AAPL). This was five years ago and now you decide to evaluate them to see if you have done well with this investment. The table below shows the market prices of AAPL.
AAPL Stock Prices | |
Date | Price |
2016 | 823.48 |
2017 | 1,450.89 |
2018 | 1,718.73 |
2019 | 2,008.72 |
2020 | 3,206.20 |
2021 | 3,293.97 |
Develop a formula to calculate your rate of return for each year. Format the results as percentages with two decimal places.
On the same worksheet, calculate the total return for the entire period of the stock.
Related Book For
Financial Analysis with Microsoft Excel
ISBN: 978-1285432274
7th edition
Authors: Timothy R. Mayes, Todd M. Shank
Posted Date: