FIN345 University of Missouri Security & Historical Returns Excel Worksheet need someone to solve 2 Finance problem questions on ExellI attached the Questi

FIN345 University of Missouri Security & Historical Returns Excel Worksheet need someone to solve 2 Finance problem questions on ExellI attached the Questions that need to solve(showing the process when i click it) Project #3
FIN 345
Build a spreadsheet to answer the following questions. Use a separate worksheet for
each of the 2 questions.
1. Use the security returns below, to answer the following questions. Assume that each
return is equally likely to occur.
Security A Returns (%)
17
11.3
10
7.8
6.2
4.7
Security B Returns (%)
9
8
7
6
5
-2.5
a.
What is the correlation between these securities?
b.
Assuming that an investor can only choose between two securities, A or B,
generate a model that will calculate the expected returns and the portfolio
standard deviations for each of the following weights in security A: 0%, 10%,
25%, 50%, 75%, 90%, 100%.
c.
Plot the expected the returns and standard deviations for the portfolios above and
tell which ones are efficient (you can write on your graph (a scatterplot is fine)).
d.
Find the expected return and portfolio standard deviation for the minimum
variance portfolio.
2. Given the following historical returns on XYZ and the market:
XYZ
8%
15%
2%
10%
13%
Market
5%
10%
7%
8%
10%
a.
Calculate beta manually.
b.
Calculate beta using regression techniques. (show your regression output)

Purchase answer to see full
attachment