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.

 AUTONUM  \* Arabic  (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?

 AUTONUM  \* Arabic  (a) Calculate the COVARIANCE and CORRELATION matrix for all pairs. Display your answers in a 4×4 table.

(b) Verify that covariance between the asset and itself is equal to its variance (there may be some rounding error).

(c) Verify that the correlation between all pairs of assets falls in the range [-1,1]. Verify that the correlation with an asset and itself is 1.

     (d) Do all assets move together? Interpret your results.

 AUTONUM  \* Arabic  Graph the Capital Allocation Line for BUD and the risk-free asset. Extend the line past the 100% investment in BUD, i.e. short the risk-free asset. How do you interpret a weight in the risk-free < 0%?

 AUTONUM  \* Arabic  (a) Graph the Efficient Frontier for only 2 assets, AOL and TWA. Use the formula

                    VAR(w₁X + w₂Y) = w₁²VAR(X) + w₂²VAR(Y) +2w₁w₂COV(X,Y).

(b) What is the Minimum Variance portfolio? Identify by weight in each asset to the nearest 0.1%

 AUTONUM  \* Arabic  Verify that the portfolio weights (in Table 2) sum to 1 for EACH of the 50 portfolios.

 AUTONUM  \* Arabic Calculate the Expected Return for each of the 50 portfolios.

 AUTONUM  \* Arabic Calculate the Variance and Standard Deviation for each portfolio. Since the assets are not independent, i.e. COV¹0, you must use following formula:

     VAR (w₁X + w₂Y + w₃Z + w₄W) =

w₁²VAR(X) + w₂²VAR(Y) + w₃²VAR(Z) + w₄²VAR(W) +2 w₁ w₂COV(X,Y) + 2 w₁ w₃COV(X,Z) + 2 w₁ w₄COV(X,W) + 2 w₂ w₃COV(Y,Z) + 2 w₂w₄COV(Y,W) +2 w₃w₄COV(Z,W),

         where w₁, w_2, w₃, and w₄ are arbitrary constants. Note: w₁ + w₂ + w₃ + w₄ = 1.

 AUTONUM  \* Arabic  Plot all the portfolios and identify the Efficient Frontier. List ALL portfolios that lie on the Efficient Frontier.

 AUTONUM  \* Arabic Identify the following portfolios by number:

Equally-weighted portfolio

The single-security portfolios (#1- #4)

The minimum variance portfolio

The “market” portfolio for the 4 securities (ignore the single security portfolios #1-#4). Hint: To identify the market portfolio, use the slope, i.e. Sharpe Ratio

 AUTONUM  \* Arabic             Plot the CAL using the Treasury Bill. For this question, assume the annual T-bill rate is 12% to make the graph easier to read.

Presentation

Answers the questions briefly and to the point. Summarize your answers briefly in word file and email your actual spreadsheet,. Remember to circle or underline your final answers.

Table 1

Monthly closing prices for the AOL, BUD, KO, and TWA from July 1996 through June 1999.

Table 2

Need Help with Your Assignment? Let us Help you

Place Your Order

We guarantee you the following if you order your paper with us

High Quality Papers

All papers are written by ENL (US, UK, AUSTRALIA) writers with vast experience in the field. We perform a quality assessment on all orders before submitting them.

Timely Delivery

Do you have an urgent order?  We have more than enough writers who will ensure that your order is delivered on time. 

100% Original

We provide plagiarism reports for all our custom written papers. All papers are written from scratch.

24/7 Customer Support

Contact us anytime, any day, via any means if you need any help. You can use the Live Chat, email, or our provided phone number anytime.

Confidential and Secure

We will not disclose the nature of our services or any information you provide to a third party.

Stressed? We got you covered

Money-Back Guarantee

Get your money back if your paper is not delivered on time or if your instructions are not followed.

We Guarantee the Best Grades

Get a Professional Answer