Please show work on excel with equations. Thank you
Homework Answers
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
FORMULA IS ALSO GIVEN.
CELL REFERENCES ARE ALSO GIVEN
Add Answer to:
Please show work on excel with equations. Thank you
16 #5 Expected 17 Stock 18 Correlation...
Use the table for the question(s) below. Consider the following expected returns, volatilities, and correlations: Stock...
Use the table for the question(s) below. Consider the following expected returns, volatilities, and correlations: Stock Expected Return Standard Deviation Correlation with Duke Energy Correlation with Microsoft Correlation with Wal-Mart Duke Energy 14% 6% 1.0 -1.0 0.0 Microsoft 44% 24% -1.0 1.0 0.7 Wal-Mart 23% 14% 0.0 0.7 1.0 The volatility of a portfolio that is equally invested in Duke Energy and Microsoft is closest to:
efficient fronteir and portfolio choice
Problem 5 (Efficient frontier and portfolio choice)Consider the following expected returns, volatilities, and correlations:StockExpected returnStandard deviationCorrelation with Duke EnergyCorrelation with MicrosoftCorrelation with Wal-MartDuke Energy14%6%1-10Microsoft44%24%-110.7Wal-Mart23%14%00.71(a) Consider a portfolio consisting of only Duke Energy and Microsoft. The percentage of your investment (portfolio weights) that you would place in Microsoftstock to achieve a risk-free investment should be closest to:(1) 15%(2) 4%(3) 23%(4) 10%(b) The expected return of a portfolio that is equally-invested in Duke Energy and Microsoft is closest to:(1) 28%(2) 29%(3) 24%(4)...
Use the table for the question(s) below. Consider the following expected returns, volatilities, and correlations: Stock...
Use the table for the question(s) below. Consider the following expected returns, volatilities, and correlations: Stock Expected Return Standard Deviation Correlation with Duke Energy Correlation with Microsoft Correlation with Wal-Mart Duke Energy 14% 6% 1.0 -1.0 0.0 Microsoft 44% 24% -1.0 1.0 0.7 Wal-Mart 23% 14% 0.0 0.7 1.0 The expected return of a portfolio that consists of a long position of $10,000 in Wal-Mart and a short position of $2000 in Microsoft is closest to: a.12% b.27% c.18% d.21%
Please show work and all steps! The realized returns for stock A and stock B from...
Please show work and all steps!
The realized returns for stock A and stock B from 2004-2009 are provided in the table below Year 2004 2005 2006 2007 2008 2009 Stock A -8% 22% 7% -3% 4% 11% Stock B 20% 6% 29% -4% -9% 24% Suppose you create a portfolio that is 60% invested in stock A and 40% invested in stock B. The correlation between the returns of the two stocks is 6.27% (a) Calculate the expected return...
The realized returns for stock A and stock B from 2004-2009 are provided in the table...
The realized returns for stock A and stock B from 2004-2009 are provided in the table below Year 2004 2005 2006 2007 2008 2009 Stock A -9% 21% 6% -4% 3% 10% Stock B 23% 9% 32% -1% -6% 27% (a) Calculate the expected returns (as percents) over the next year for the stocks assuming the average annual realized returns and past volatility from 2004-2009 are unbiased estimators of expected returns and future volatility. stock A 4.5 stock B 14...
Please show work using excel with equations ДА В С D E The following spreadsheet contains...
Please show work using excel with equations
ДА В С D E The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2010. (You do NOT need to fill out the 1 empty cells here again). Realized Returns Date Cola Co Gas Co. Portfolio of 55% Cola and 45% Gas Jan -10.84% -6.00% Feb 2.36% 1.28% Mar 6.60% -1.86% 2.01% -1.90% 18.36% 7.40% -1.22% -0.26% 2.25% 8.36% -6.89% -2.46% -6.04% -2.00% 13.61% 0.00% Nov 3.51% 4.68% 0.54%...
Please use only Minitab or Excel. Thank you Please use only Minitab or Excel. Thank you...
Please use only Minitab or
Excel. Thank you
Please use only Minitab or
Excel. Thank you
Please use only Minitab or
Excel.
Please use only Minitab or
Excel.
Thank you
Two different tire compound formulas are tested for tire wear in thousandths of inches. Everything else that might vary is held at a pre-determined constant value to the best of the experimenter's ability. The following are the samples randomly selected from the tires made by the different compound formulas (assume...
Please show me the work and formulas in the assigned cells. Thank you. C D E...
Please show me the work and formulas in the assigned cells.
Thank you.
C D E On the cell B5 enter your PV, on cell B6 the annual retum rate on cell B7 the months of the year, and on the cell B9 calculate the monthly rate. On column C have the years, on column D the months of the year and on column E the periods. Calculate on column F the amount that you will have in your account...
please show all the work. if you use excel please show the screenshots. Thank you !...
please show all the work. if you use excel please show the
screenshots. Thank you !
Question 5 (25pts) Suppose the athletic director at a university would like to develop a regression model to predict the point differential for games played by the men's basketball team. A point differential is the difference between the final points scored by two competing teams. A positive differential is a win, and a negative differential is a loss. For a random sample of games,...
hi i need help worh this problem. can you show your work in excel please File...
hi i need help worh this problem. can you show your work in
excel please
File Home Insert Formulas Data Review View Help Open in Desh brovs Calibri V 11 V B A1 fx I 1 A B С D E F G H 14. Present Values. What is the present value of the following cash-flow stream if the interest rate is 6%? (LO5-2) 2 3 Year 4 5 Cash Flow $200 400 300 2 3 dar 6 7 8...
Please show work and all steps!
The realized returns for stock A and stock B from 2004-2009 are provided in the table below Year 2004 2005 2006 2007 2008 2009 Stock A -8% 22% 7% -3% 4% 11% Stock B 20% 6% 29% -4% -9% 24% Suppose you create a portfolio that is 60% invested in stock A and 40% invested in stock B. The correlation between the returns of the two stocks is 6.27% (a) Calculate the expected return...
The realized returns for stock A and stock B from 2004-2009 are provided in the table below Year 2004 2005 2006 2007 2008 2009 Stock A -9% 21% 6% -4% 3% 10% Stock B 23% 9% 32% -1% -6% 27% (a) Calculate the expected returns (as percents) over the next year for the stocks assuming the average annual realized returns and past volatility from 2004-2009 are unbiased estimators of expected returns and future volatility. stock A 4.5 stock B 14...
Please show work using excel with equations
ДА В С D E The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2010. (You do NOT need to fill out the 1 empty cells here again). Realized Returns Date Cola Co Gas Co. Portfolio of 55% Cola and 45% Gas Jan -10.84% -6.00% Feb 2.36% 1.28% Mar 6.60% -1.86% 2.01% -1.90% 18.36% 7.40% -1.22% -0.26% 2.25% 8.36% -6.89% -2.46% -6.04% -2.00% 13.61% 0.00% Nov 3.51% 4.68% 0.54%...
Please use only Minitab or
Excel. Thank you
Please use only Minitab or
Excel. Thank you
Please use only Minitab or
Excel.
Please use only Minitab or
Excel.
Thank you
Two different tire compound formulas are tested for tire wear in thousandths of inches. Everything else that might vary is held at a pre-determined constant value to the best of the experimenter's ability. The following are the samples randomly selected from the tires made by the different compound formulas (assume...
Please show me the work and formulas in the assigned cells.
Thank you.
C D E On the cell B5 enter your PV, on cell B6 the annual retum rate on cell B7 the months of the year, and on the cell B9 calculate the monthly rate. On column C have the years, on column D the months of the year and on column E the periods. Calculate on column F the amount that you will have in your account...
please show all the work. if you use excel please show the
screenshots. Thank you !
Question 5 (25pts) Suppose the athletic director at a university would like to develop a regression model to predict the point differential for games played by the men's basketball team. A point differential is the difference between the final points scored by two competing teams. A positive differential is a win, and a negative differential is a loss. For a random sample of games,...
hi i need help worh this problem. can you show your work in
excel please
File Home Insert Formulas Data Review View Help Open in Desh brovs Calibri V 11 V B A1 fx I 1 A B С D E F G H 14. Present Values. What is the present value of the following cash-flow stream if the interest rate is 6%? (LO5-2) 2 3 Year 4 5 Cash Flow $200 400 300 2 3 dar 6 7 8...
Most questions answered within 3 hours.
-
The table to the right lists probabilities for the corresponding
numbers of girls in three births....
asked 4 minutes ago -
The inverse demand function for good X is P = 5−0.05Q. The
firm’s cost curve is...
asked 2 minutes ago -
The Fresh Connection is really pushing the new line of juice
products. Given that it takes...
asked 8 minutes ago -
An acute decrease in mean arterial pressure (by getting up very
quickly, for instance) will cause...
asked 7 minutes ago -
Is the pH of solutions important when using the Fluoride ISE? If
so, why?
asked 11 minutes ago -
Producer surplus is:
a.
always equal to consumer surplus.
b.
the amount paid to sellers above...
asked 12 minutes ago -
In 2005, Derrek Lee led the National Baseball League with a
0.335 batting average, meaning that...
asked 31 minutes ago -
Write a recursive function moreFactors(a,b,fact) that does the
following:
1. Takes as an input 3 positive...
asked 30 minutes ago -
In order for corporations to behave ethically, they must,
ultimately, give up the profit motive.
...
asked 31 minutes ago -
Blue Spruce Corp. owns equipment that cost $63,400 when
purchased on January 1, 2017. It has...
asked 51 minutes ago -
A lottery exists where balls numbered 1 to 17 are placed in an
urn. To win,...
asked 2 hours ago -
Please explain steps:
An 80 kg swimmer steps off a platform 10 m above the water...
asked 1 hour ago