A manager buys three shares of stock today, and then sells one of those shares each year for the next 3 years. His actions and the price history of the stock are summarized below. The stock pays no dividends. Time 0 1 2 3 Price $ 200 220 220 220 Geometric average return Action Buy 3 shares Sell 1 share a. Calculate the time-weighted geometric average return on this "portfolio." (Do not round intermediate calculations. Round your answer to 2 decimal places.) Sell 1 share Sell 1 share Arithmetic average return % b. Calculate the time-weighted arithmetic average return on this portfolio. (Do not round intermediate calculations. Round your answer to 2 decimal places.) %

You buy 100 shares of stock at a price of $51.37, using 30% initial margin. Some time later, the stock is trading at $49.07, and you sell it and repay the loan. What is your return on this position? Assume no dividends were paid and no interest was accrued on the broker's loan. Enter answer in percents, to two decimal places.

EXCEL PROJECT AND EXCEL SOLUTION Consider the following stocks, all of which will pay a liquidating dividend in a year and nothing in the interim: Stock A Stock B Stock с Stock D Market Capitalization (5 million) 800 750 950 900 Expected Liquidating Dividend ($ million) 1000 1000 1000 1000 Beta PLEASE SHOW SOLUTIONS IN EXCEL 0.77 1.46 1.25 1.07 a. Calculate the expected return of each stock. b. What is the sign of correlation between the expected return and market capitalization of the stocks? In Problem 20, assume the risk-free rate is 3% and the market risk premium is 7%. a. What does the CAPM predict the expected return for each stock should be? b. Clearly, the CAPM predictions are not equal to the actual expected returns, so the CAPM does not hold. You decide to investigate this further. To see what kind of mistakes the CAPM is making, you decide to regress the actual expected return onto the expected return predicted by the CAPM.49 What is the intercept and slope coefficient of…

XYZ's stock price and dividend history are as follows: Year Beginning-of-Year Price 2019 2020 2021 2022 $88 108 78 88 Dividend Paid at Year-End $4 An investor buys three shares of XYZ at the beginning of 2019, buys another two shares at the beginning of 2020, sells one share at the beginning of 2021, and sells all four remaining shares at the beginning of 2022 Arithmetic average rate of return Geometric average rate of return Required: a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of return and final answers to 2 decimal places. Do not round other calculations.) Dollar-weighted rate of return 4 4 4 % % b. What is the dollar-weighted rate of return? (Hint Carefully prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2019, to January 1, 2022. If your calculator cannot calculate IRR, you will have to use trial and error or a spreadsheet program.) (Round your…