Please answer the below questions; the formula to be shown, in an Excel spreadsheet

Q-5:

Security Market Line

Based on the data below, Calculate the portfolio's return and beta.

Data

Stock % of Portfolio Beta Expected Return

1 0.5 0.85 0.12

2 0.3 0.75 0.11

3 0.35 2 0.15

Risk-free rate 005

Market rate 0.1

Q-6:

Required Rate of Return (CAPM)

Calculate the required rate of return by using (CAPM) Based on the data below.

Data

Risk-free rate 0.04

Market Risk Premium 0.10

Beta 1.2

Q-7:

Expected Return, Standard Deviation

Calculate Adidas' and S&P 500 Index's average rate of returns and standard deviation, Based on the data below.

Data

Months Adidas Stock Prices S&P 500 Index

Jan-19 52.9 2368.45

Feb-19 67.16 2363.64

Mar-19 68.73 2362.72

Apr-19 65.41 2384.2

May-19 62.99 2411.8

Jun-19 70.1 2423.41

Jul-19 69.05 2470.3

Aug-19 62.81 2471.65

Sep-19 61.85 2519.36

Oct-19 64.99 2575.26

Nov-19 70.42 2647.58

Dec-19 72.55 2673.61