Please refer to the attachment below to see the questions. All of the answers are to be documented on the excel sheet provided. Also, all the calculations are to be included within a word or an excel document. Thank you.

QUESTION 1 Problem 1 Indexes (33 points) Consider the three stocks in the following table. P t represents the price at the end of period t and Qt is the number of shares outstanding. Stock C splits 3:1 during period 2. A B C P0 $ $ $ Q0 122.00 150.00 65.00 400.00 32.00 200.00 P1 $ $ $ 115.00 73.00 42.00 Q1 150.00 400.00 200.00 P2 $ 125.00 $ 76.00 $ 18.00 Q2 150.00 400.00 600.00 1.1 Calculate the price-weighted index of the three stocks for each period (4 points). What is the divisor for each period (4 points)? Does it change in the last period (2 points)? Why or why not (2 points)? 1.2 Calculate the price-weighted index returns for the periods ending in 1 and 2 (7 points). 1.3 Calculate the value-weighted index returns for the periods ending in 1 and 2 (7 points). 1.4 Calculate the equal-weighted index returns for the periods ending in 1 and 2 (7 points). 1. Problem 2 Margin (34 Points) 2.A. The current market price for XYZ is $48 per share. Initial margin is 50%, maintenance margin is 35% and margin interest is 1.50% per year. 2.A.1) You believe the stock price will increase over the next year and wish to trade exactly one round lot. What trade should you make (2 points)? How much margin would you have to post to your account (4 points)? At what price would you receive a margin call (7 points)? 2.A.2) Suppose you are correct and the stock rises to $57 per share at the end of the year. What is your percentage return on equity for this trade (4 points)? 2.B. The current market price for ABC is $75 per share. Initial margin is 50%, maintenance margin is 35% and there is no margin interest. 2.B.1) You believe the stock price will decrease over the next year and wish to trade exactly one round lot. What trade should you make (2 points)? How much margin would you have to post to your account (4 points)? At what price would you receive a margin call (7 points)? 2.B.2) Suppose you are correct and the stock falls to $67 per share at the end of the year. What is your percentage return on equity for this trade (4 points)? Problem 3 Scenario Analysis (33 points) Use the following scenario analysis for stocks X and Y to answer the questions. Round to the nearest 1/100 of 1% (i.e., 15.07%). Probability Stock X Stock Y Bear Market 35.00% -17.00% -19.00% Normal Market 55.00% 9.00% 14.00% Bull Market 10.00% 19.00% 49.00% 3.a) What are the expected rates of return for stocks X and Y (9 points)? 3.b) What are the standard deviations for of returns for stocks X and Y (8 points)? 3.c) If the risk-free rate of return is 2.50%, what are the Sharpe Ratios for stocks X and Y (8 points)? (Please assume that the standard deviations of the excess returns are the same as the standard deviations of returns calculated in part b.) 3.d) Assume you have a $150,000 portfolio and you invest $50,000 in stock X and the remainder in stock Y. What is the expected return for this portfolio (8 points)? FIN 5550 - WB2 - Jack De Jong: Quantitative Problem Set #1: Due: Monday, September 11, 2017 by 11:59 PM: Name: Problem: Points Questions Your Answers: Period 0 Period 1 1.1 (4) PWI (4) Divisor (2) Change? (2) Why? 1.2 (7) PWI Ret. 1.3 (7) VWI Ret. 1.4 (7) EWI Ret. 2A.1 (2) (4) (7) 2A.2 (4) Trade Margin MC Price Return 2B.1 (2) (4) (7) 2B.2 (4) Trade Margin MC Price Return 3A (9) E(X) E(Y) SD(X) SD(Y) Sharpe X Sharpe Y Port. Ret. 3B (8) 3C (8) 3D (8) Period 2