Could you please assist me with all parts of this problem? I am getting conflicting answers from other resources. Please include all of the equations that you used, and if it can be done in excel that would be great.

Thanks!

Portfolio return and beta Jamie Peters invested $100,000 to set up the following portfolio 1 year ago Cost $20,000 35,000 30,000 15,000 Beta at purchase 0.80 0.95 1.50 1.25 Value toda $20,000 36,000 34,500 16,500 Asset earlv income $1,600 1,400 375 a. Calculate the portfolio beta on the basis of the original cost figures b. Calculate the percentage return of each asset in the portfolio for the year c. Calculate the percentage return of the portfolio on the basis of original cost, using income and gains during the year d. At the time Jamie made his investments, investors were estimating that the market return for the coming year would be 10%. The estimate of the risk-free rate of return averaged 4% for the coming year. Calculate an expected rate of return for each stock on the basis of its beta and th e expectations of market and risk-free returns. e. On the basis of the actual results, explain how each stock in the portfolio per formed relative to those CAPM-generated expectations of performance. What factors could explain these differences