Question: (Solving a comprehensive problem) Use the end-of-year stock price data in the popup window, LOADING... , to answer the following questions for the Harris and
(Solving a comprehensive problem) Use the end-of-year stock price data in the popup window,
LOADING...
, to answer the following questions for the Harris and Pinwheel companies.
a. Compute the annual rates of return for each time period and for both firms.
b. Calculate both the arithmetic and the geometric mean rates of return for the entire three-year period using your annual rates of return from part
a.
(Note: you may assume that neither firm pays any dividends.)
c. Compute a three-year rate of return spanning the entire period (i.e., using the ending price for period 1 and ending price for period 4).
d. Since the rate of return calculated in part c is a three-year rate of return, convert it to an annual rate of return by using the following equation:
left parenthesis 1 plus Start 2 By 1 Matrix 1st Row 1st Column Three dash Year 2nd Row 1st Column Rate of Return EndMatrix right parenthesis equals left parenthesis 1 plus Start 2 By 1 Matrix 1st Row 1st Column Annual Rate 2nd Row 1st Column of Return EndMatrix right parenthesis cubed1+
| Three-Year |
| Rate of Return |
=1+
| Annual Rate |
| of Return |
3
e. How is the annual rate of return calculated in part d related to the geometric rate of return? When you are evaluating the performance of an investment that has been held for several years, what type of average rate of return (arithmetic orgeometric) should you use? Why?
a. Enter the annual rate of return for each year for Harris in the table below.(Round to two decimal places.)
| Time | Value of Harris Stock | Annual Rate of Return | Value of Pinwheel Stock | Annual Rate of Return | ||||
| 1 | $12 | $21 | ||||||
| 2 | 6 |
| % | 32 | ||||
| 3 | 11 |
| % | 29 | ||||
| 4 | 17 |
| % | 24 | ||||
Enter the annual rate of return for each year for Pinwheel in the table below.(Round to two decimal places.)
| Time | Value of Harris Stock | Annual Rate of Return | Value of Pinwheel Stock | Annual Rate of Return | ||||
| 1 | $12 | $21 | ||||||
| 2 | 6 | 50.00 | % | 32 | nothing | % | ||
| 3 | 11 | 83.33 | % | 29 | nothing | % | ||
| 4 | 17 | 54.55 | % | 24 | nothing | % | ||
b. The arithmetic average rate of return earned by investing in Harris stock over this period is %.
(Round to two decimal places.)The arithmetic average rate of return earned by investing in Pinwheel stock over this period is %.
(Round to two decimal places.)The geometric average rate of return earned by investing in Harris stock over this period is %.
(Round to two decimal places.)The geometric average rate of return earned by investing in Pinwheel stock over this period is %.
(Round to two decimal places.)
c. The three-year rate of return spanning the entire period for Harris is %.
(Round to two decimal places.)The three-year rate of return spanning the entire period for Pinwheel is %.
(Round to two decimal places.)
d. The annual rate of return converted from the three-year rate in part c for Harris is %.
(Round to two decimal places.)The annual rate of return converted from the three-year rate in part c for Pinwheel is %.
(Round to two decimal places.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
