**Please answer all questions** and show work out in excel, thank you

1) Stock R has a beta of 2.4, Stock S has a beta of 0.9, the expected rate of return on an average stock is 11%, and the risk-free rate of return is 7%. By how much does the required return on the riskier stock exceed the required return on the less risky stock? Round your answer to two decimal places.

2) An 8% semiannual coupon bond matures in 5 years. The bond has a face value of $1,000 and a current yield of 8.3832%.What is the bond's YTM?

3)Suppose you are the money manager of a $3.82 million investment fund. The fund consists of 4 stocks with the following investments and betas:

Stock	Investment	Beta
A	$ 500,000	1.50
B	380,000	- 0.50
C	1,140,000	1.25
D	1,800,000	0.75

If the market's required rate of return is 11% and the risk-free rate is 5%, what is the fund's required rate of return?