# Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X’s beta coefficient

“3.7a. Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X’s beta coefficient.b. Determine the arithmetic average rates of return for Stock X and the NYSE over the period given. Calculate the standard deviations of returns for both Stock X and the NYSE.c. Assuming (1) that the situation during Years 1 to 7 is expected to hold true in the future (that is, rX = rX rM = rM; and both oX and bX in the future will equal their past values), and (2) that Stock X is in equilibrium (that is, it plots on the Security Market Line), what is the risk-free rate?d. Plot the Security Market Line.e. Suppose you hold a large, well-diversified portfolio and are considering adding to the portfolio either Stock X or another stock, Stock Y, that has the same beta as Stock X but a higher standard deviation of returns. Stocks X and Y have the same expected returns; that is rX = rY = 10.6%. Which stock should you choose?Year NYSE Stock C(26.5%) (14.0%)37.2 23.023.8 17.5(7.2) 2.06.6 8.120.5 19.4 30.6 18.2

Don't use plagiarized sources. Get Your Custom Essay on
Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X’s beta coefficient
Just from \$13/Page
Pages (275 words)
Standard price: \$0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back