Question

In: Finance

Q1 (100%): Using data below, do the following: 1) Create the efficient frontier; 2) Calculate the...

Q1 (100%): Using data below, do the following:
1) Create the efficient frontier;
2) Calculate the optimal portfolio;
3) Draw the Capital Market Line. Note the line must be based on data, not your fine art skills.
Security A Security B Portfolio
Mean 0.09 0.15
Standard Deviation 0.20 0.33
Variance 0.04 0.11
Covariance 0.0095
Risk-free rate

5.20%

please attach the exal work so i can downlond it

Solutions

Expert Solution


Related Solutions

Q1: what does the efficient frontier represents? Q2: how do we estimate the return and standard...
Q1: what does the efficient frontier represents? Q2: how do we estimate the return and standard deviation of a newly built portfolio from analyzing the stocks in that portfolio? Q3: in the regression equation, what is meant by a regression that has an R-square with 0.95 and how does it compare with a regression with a R-square of 0.30? Q4: why do we use adjusted beta? Q5: what is the information ratio and why do we use it?
Q1: what does the efficient frontier represents? Q2: how do we estimate the return and standard...
Q1: what does the efficient frontier represents? Q2: how do we estimate the return and standard deviation of a newly built portfolio from analyzing the stocks in that portfolio? Q3: in the regression equation, what is meant by a regression that has an R-square with 0.95 and how does it compare with a regression with a R-square of 0.30? Q4: why do we use adjusted beta? Q5: what is the information ratio and why do we use it?
1.) a. Create a graph of the data below, then calculate the slope to find the...
1.) a. Create a graph of the data below, then calculate the slope to find the spring constant 'k'. b. Describe the functional relationship between all of this data (in other words, how does all of this connect?) c. Calculate the gravitational potential energy and the spring potential energy of the 0.2, 0.4, 0.6, 0.8, and 1.0 kg masses. d. Are there any patterns between these two types of potential energy? Why or why not? Mass (kg) m * g...
1. Using the Data Set, create and calculate the following in Excel®: Determine the range of...
1. Using the Data Set, create and calculate the following in Excel®: Determine the range of values in which you would expect to find the average weekly sales for the entire sales force in your company 90% of the time, and calculate the following: A. The impact of increasing the confidence level to 95% B. The impact of increasing the sample size to 150, assuming the same mean and standard deviation, but allowing the confidence level to remain at 90%...
Using the financial data below calculate the following ratios: 1) Gross Profit Margin; 2) Net Profit...
Using the financial data below calculate the following ratios: 1) Gross Profit Margin; 2) Net Profit Margin; 3) Return on Assets; 4) Days Sales Outstanding; 5) Quick Ratio. For EACH of these five ratios do the following: 1) calculate the value and 2) interpret the value in about one sentence.  TO RECEIVE ANY CREDIT YOU MUST SHOW YOUR WORK, WITHIN THE PROVIDED WORK SPACE. FINAL ANSWERS ONLY WILL NOT CUT IT!         Balance Sheet         ASSETS                                                                                               LIABILITIES                     Cash: $1,160,000                                                                          Current Liabilities: $173,000 A/R: 335,000                                                                                 Non-current...
Create 4 Weibull distributions using the data below. Distribution Alpha Beta 1                 1       0.5 2     &nbsp
Create 4 Weibull distributions using the data below. Distribution Alpha Beta 1                 1       0.5 2                 1        1 3                 1         2 4                 4.5     6.2 Please show how to plot the four graphs and all excel commands Thank you!
How do I create a histogram for the following set of data? Legend: Result (1-100) Age...
How do I create a histogram for the following set of data? Legend: Result (1-100) Age and gender are self explanatory Relationship (are you in a romantic relationship?) Medu (Mothers highest lvl of education. 1= year 10; 2= year 12; 3=bachelor; 4= post grad Lectures (how many lectures missed) Tutorials (How many tutorials missed) RESULT Gender Age Medu Relationship Lectures Tutorials 55 F 20 4 NO 4 3 55 F 19 1 NO 2 3 65 M 18 4 NO...
Calculate the breakeven point using the following data. Create a table and graph with the answer...
Calculate the breakeven point using the following data. Create a table and graph with the answer you get. Fixed Costs: App Development Costs: $150,000 Marketing Costs: $72,000 Variable Costs: Average Cost Per Install (CPI) – $2.89 / install Cost Per Action (CPA): Register – $4.58 / install CPA: Register: In-app purchase – $102 / install CPA: Purchase – $40 / install CPA: Subscribe – $87 / install Sales Price: App membership subscription: $10 per person or $5 per student
Using the data below, calculate the appropriate test. Do this manually and show all steps.   The...
Using the data below, calculate the appropriate test. Do this manually and show all steps.   The data reflects word retention for older adults with early onset Alzheimer's before a memory game was played and after the game was played. Before the Memory Game After the Memory Game 4 8 5 9 2 6 5 7 6 9 5 9 3 6 4 6 3 7 5 9 8 9 7 6 6 9 5 10 7 9 6 7 9...
Answer IN R CODE to get the following. Using the data below, Create a scatterplot of...
Answer IN R CODE to get the following. Using the data below, Create a scatterplot of y vs x Fit a simple linear regression model using y as the response and plot the regression line (with the data) Test whether x is a significant predictor and create a 95% CI around the slope coefficient. Report and interpret the coefficient of determination. For x=20, create a CI for E(Y|X=20). For x=150, can you use the model to estimate E(Y|X=150)? Discuss. Does...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT