Portfolio Return 1. One year ago, you bought a stock for $36.48 a share. You recently received a dividend of $1.62 per share and sold the stock today for $40.18 a share. What is the dollar return, dividend yield, capital gains yield, and percentage return on this investment? 2. One year ago, you bought 480 shares of ABC Company for $28.32 a share. You recently received a dividend of $0.75 per share and sold the stock today for $35 a share. What is the dollar return, dividend yield, capital gains yield, and percentage return on this investment? Also upload your excel files showing your work. Portfolio Return and Portfolio Beta Assume that your portfolio comprises of Stocks A, B, and C. Based on the following information, calculate the portfolio expected return and portfolio beta. Security Value Return Beta Stock A $10,000 10% 1.1 Stock B $20,000 5% 0.2 Stock C $30,000 15% 2.1 Also upload your excel files showing your work.