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?

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 ...

Solution Summary

The following posting helps calculate the rate of return with excel.

... We use the NPV function in excel to calculate the NPV of a ... The solutions explains about IRR and NPV calculations and shows how to calculate NPV and IRR ...

... stock amou $133,100 Step 2: Find the Present Value of the amount you calculated in $100,000. Step 3: Calculate the Present Value of the lease obligations. ...

... The solution explains how to calculate the internal rate of ... The required return can be calculated using the ... required since we want to calculate the required ...

... D. Interest rate quoted by banks. ... for the asset XYZ is as shown below: Return Probability - 0.1 ... 0.30 0.20 What is the standard deviation for the XYZ returns? ...

... 4. Calculating Project Cash Flows and NPV. ...Calculate the payback period, NPV, and IRR. ... State of Economy Probability of State of Economy Stock a Rate of Return...

... Currently the bonds are selling for $872. a) If your require rate of return is 11% for bond in the risk class, what is the highest price you would be ...

... e. After calculating this rate of return, how would you ... It can be read from tables or calculated using the ... To calculate the rate of return, we use the fact ...