Question: FIN 132 - Efficient Frontier (Risk and Return) Professor A. Spieler The following table (Table 1) represents CLOSING prices for America Online (AOL), Anheuser Busch

FIN 132 - Efficient Frontier (Risk and Return)

Professor A. Spieler

The following table (Table 1) represents CLOSING prices for America Online (AOL), Anheuser Busch (BUD), Coca-Cola (KO), and TransWorld Airlines (TWA). Assume the return on a Treasury Bill is 4% per year (.33% per month). Clearly indicate your answers by underlining or putting them in a box.

The data in Tables 1 and 2 can be downloaded in spreadsheet form from the class Blackboard site.

1. (a) Calculate the MONTHLY returns for each asset (AOL, BUD, KO, TWA).

(b) Calculate the variance and standard deviation of RETURNS for each asset (AOL, BUD, KO, TWA) over the 36-month period from 7/96-6/99.

(c) Comment on the difference between expected return and realized return.

(d) Find the total return over the 36-month period for each stock. Which stock had the highest and lowest returns? Was this expected? Are these results consistent with the general risk-return relationship?

(e) Are these the actual closing prices or prices adjusted for changes in capitalization, i.e. stock splits, etc.? How do you know?

FIN 132 - Efficient Frontier (Risk and Return)FIN 132 - Efficient Frontier (Risk and Return)
\fDATE AOL BUD KO TWA Jun-99 115.375 71.125 61.563 4.938 May-99 119.250 73.063 68.500 5.188 Apr-99 142.750 73.125 68.063 5.438 Mar-99 147.000 76.125 61.375 5.188 Feb-99 88.938 76.688 63.875 5.938 Jan-99 87.875 70.688 65.313 4.750 Dec-98 77.563 65.625 67.000 4.875 Nov-98 43.781 60.625 70.063 5.125 Oct-98 31.844 59.500 67.563 5.000 Sep-98 27.906 54.000 57.625 5.688 Aug-98 20.484 46.750 65.125 6.625 Jul-98 29.281 51.813 80.500 8.313 Jun-98 26.281 47.188 85.500 10.375 May-98 20.828 45.938 78.375 10.375 Apr-98 19.984 45.813 75.875 9.688 Mar-98 17.078 46.250 77.438 12.313 Feb-98 15.172 46.875 68.625 13.063 Jan-98 11.953 44.938 64.750 11.625 Dec-97 11.313 44.000 66.688 10.063 Nov-97 9.375 43.188 62.500 7.563 Oct-97 9.625 39.938 56.625 7.438 Sep-97 9.430 45.125 61.000 7.875 Aug-97 8.063 42.625 57.313 7.313 Jul-97 8.438 42.938 69.125 6.938 Jun-97 6.953 41.938 68.000 8.563 May-97 6.891 42.875 68.500 8.688 Apr-97 5.641 42.875 63.625 7.250 Mar-97 5.313 41.250 55.750 6.938 Feb-97 4.688 44.500 61.000 5.875 Jan-97 4.625 42.500 57.875 6.438 Dec-96 4.156 40.000 52.625 6.563 Nov-96 4.406 42.375 51.125 7.750 Oct-96 3.391 38.500 50.500 8.000 Sep-96 4.438 37.750 50.875 9.625 Aug-96 3.781 37.875 50.000 13.250 Jul-96 3.813 37.375 46.875 10.750

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!