PLEASE SHOW EXCEL FORMULAS OR FINANCIAL CALCULATOR FORMULAS!

I am struggling figuring out how to determine weight and portfolio beta so please show how to get those columns!!

Thank you!

You plan to invest in the Kish Hedge Fund, which has total capital of $500 million invested in five stocks: Stock Investment Stock's Beta Coefficient $160 million 0.4 B 120 million 1.1 80 million 2.2 D 80 million 1.0 E 60 million 1.9 Kish's beta coefficient can be found as a weighted average of its stocks' betas. The risk-free rate is 5%, and you believe the following probability distribution for future market returns is realistic: Probability Market Return 0.1 -26% 0.2 0 0.4 11 0.2 32 0.1 48 a. What is the equation for the Security Market Line (SML)? (Hint: First determine the expected market return.) I. r;= 3.2% + (8.7%)b II. r; = 5.0% + (9.7%)b III. r = 3.6% + (8.0%)bi IV. ri = 3.6% + (9.7%) V. r; = 5.0% + (8.0%); II b. Calculate Kish's required rate of return. Do not round intermediate calculations. Round your answer to two decimal places. 3.32 % C. Suppose Rick Kish, the president, receives a proposal from a company seeking new capital. The amount needed to take a position in the stock is $50 million, it has an expected return of 14%, and its estimated beta is 1.4. Should Kish invest in the new company? The new stock should be purchased. At what expected rate of return should Kish be indifferent to purchasing the stock? Round your answer to two decimal places. %