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

... c) Calculate the total return for the entire holding period. ... ompound average annual rate of return is calculated by taking the nth root total percentage ...

Calculating the standard deviation,expected return,PV & PMT. ... D. Interest rate quoted by banks. ... for the asset XYZ is as shown below: Return Probability - 0.1 ...

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

... Interest rates for similar risk securities might have decreased. ... Solution describes the steps to calculate the current price and return of the given ...

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

Capital Budgeting. ... Discount rate=r=12%. ... IRR= 7.26% =IRR(B29:B32). Solution describes the steps to calculate NPV and IRR of given investment proposal. ...