Please show all your work/steps. Thank you. Calculate the mean, variance, and standard deviation of returns...

Please show all your work/steps. Thank you.

Calculate the mean, variance, and standard deviation of returns for:

(a) CAT & PG individually, and

(b) an equally-weighted portfolio of the two stocks.

For the portfolio, 1st compute the monthly returns.

Then, compute the mean, variance, and standard deviation calculations with Excel’s Data Analysis “Descriptive Statistics” function, “Summary Statistics” (in the function dialogue box).

Compare the return and risk of the three assets.

Monthly Stock Returns
Year	Month	S&P 500	CAT	PG
2010	Jan	0.02851	0.09223	0.02822
	Feb	0.05880	0.10163	(0.00017)
	Mar	0.01476	0.09005	(0.01001)
	Apr	(0.08198)	(0.10765)	(0.01726)
	May	(0.05388)	(0.01133)	(0.01810)
	Jun	0.06878	0.16893	0.02765
	Jul	(0.04745)	(0.06577)	(0.02444)
	Aug	0.08755	0.20749	0.00505
	Sep	0.03686	0.00441	0.06815
	Oct	(0.00229)	0.07642	(0.03929)
	Nov	0.06530	0.10699	0.05330
	Dec	0.02265	0.04067	(0.01128)
2011	Jan	0.03196	0.06098	(0.00134)
	Feb	(0.00105)	0.08187	(0.02302)
	Mar	0.02850	0.04078	0.06244
	Apr	(0.01350)	(0.08331)	0.03238
	May	(0.01826)	0.00627	(0.05128)
	Jun	(0.02147)	(0.06810)	(0.02479)
	Jul	(0.05679)	(0.07893)	0.03559
	Aug	(0.07176)	(0.18854)	(0.00786)
	Sep	0.10772	0.28633	0.02112
	Oct	(0.00506)	0.03621	0.00905
	Nov	0.00853	(0.07440)	0.03314
	Dec	0.04358	0.20986	(0.04742)
2012	Jan	0.04059	0.04667	0.07256
	Feb	0.03133	(0.06733)	(0.00607)
	Mar	(0.00750)	(0.03120)	(0.04502)
	Apr	(0.06265)	(0.14734)	(0.02125)
	May	0.03955	(0.03103)	(0.01665)
	Jun	0.01260	(0.00180)	0.06276
	Jul	0.01976	0.01322	0.04109
	Aug	0.02424	0.00830	0.03241
	Sep	(0.01979)	(0.00835)	0.00640
	Oct	0.00285	0.00510	0.00852
	Nov	0.00707	0.05735	(0.02778)
	Dec	0.02171	0.04899	0.00913

Expert Solution

Monthly Stock Returns						Portfolio Return
Year	Month	S&P 500	CAT	*Monthly return CAT = (current month closing price-previous month closing price)100 Jan 2010 is base Year**	*Monthly return PG = (current month closing price-previous month closing price)100 Jan 2010 is base Year**	Monthly return PG	Year	Month	Monthly return CAT	Monthly return PG	Portfolio return = (weight of CAT stock* CAT monthly)+(Weigth of OF PG *PG monthly return)
2010	Jan	0.02851	0.09223		0.02822		2010	Jan
	Feb	0.0588	0.10163	10.19%	-0.00017	-100.60%		Feb	10.19%	-100.60%	-0.45205
	Mar	0.01476	0.09005	-11.39%	-0.01001	5788.24%		Mar	-11.39%	5788.24%	28.88421
	Apr	-0.08198	-0.10765	-219.54%	-0.01726	72.43%		Apr	-219.54%	72.43%	-0.73559
	May	-0.05388	-0.01133	-89.48%	-0.0181	4.87%		May	-89.48%	4.87%	-0.42304
	Jun	0.06878	0.16893	-1591.00%	0.02765	-252.76%		Jun	-1591.00%	-252.76%	-9.2188
	Jul	-0.04745	-0.06577	-138.93%	-0.02444	-188.39%		Jul	-138.93%	-188.39%	-1.63662
	Aug	0.08755	0.20749	-415.48%	0.00505	-120.66%		Aug	-415.48%	-120.66%	-2.68071
	Sep	0.03686	0.00441	-97.87%	0.06815	1249.50%		Sep	-97.87%	1249.50%	5.758152
	Oct	-0.00229	0.07642	1632.88%	-0.03929	-157.65%		Oct	1632.88%	-157.65%	7.376138
	Nov	0.0653	0.10699	40.00%	0.0533	-235.66%		Nov	40.00%	-235.66%	-0.97828
	Dec	0.02265	0.04067	-61.99%	-0.01128	-121.16%		Dec	-61.99%	-121.16%	-0.91575
2011	Jan	0.03196	0.06098	49.94%	-0.00134	-88.12%	2011	Jan	49.94%	-88.12%	-0.19091
	Feb	-0.00105	0.08187	34.26%	-0.02302	1617.91%		Feb	34.26%	1617.91%	8.260838
	Mar	0.0285	0.04078	-50.19%	0.06244	-371.24%		Mar	-50.19%	-371.24%	-2.10716
	Apr	-0.0135	-0.08331	-304.29%	0.03238	-48.14%		Apr	-304.29%	-48.14%	-1.76217
	May	-0.01826	0.00627	-107.53%	-0.05128	-258.37%		May	-107.53%	-258.37%	-1.82948
	Jun	-0.02147	-0.0681	-1186.12%	-0.02479	-51.66%		Jun	-1186.12%	-51.66%	-6.18891
	Jul	-0.05679	-0.07893	15.90%	0.03559	-243.57%		Jul	15.90%	-243.57%	-1.13831
	Aug	-0.07176	-0.18854	138.87%	-0.00786	-122.08%		Aug	138.87%	-122.08%	0.083925
	Sep	0.10772	0.28633	-251.87%	0.02112	-368.70%		Sep	-251.87%	-368.70%	-3.10285
	Oct	-0.00506	0.03621	-87.35%	0.00905	-57.15%		Oct	-87.35%	-57.15%	-0.72252
	Nov	0.00853	-0.0744	-305.47%	0.03314	266.19%		Nov	-305.47%	266.19%	-0.1964
	Dec	0.04358	0.20986	-382.07%	-0.04742	-243.09%		Dec	-382.07%	-243.09%	-3.1258
2012	Jan	0.04059	0.04667	-77.76%	0.07256	-253.02%	2012	Jan	-77.76%	-253.02%	-1.65388
	Feb	0.03133	-0.06733	-244.27%	-0.00607	-108.37%		Feb	-244.27%	-108.37%	-1.76317
	Mar	-0.0075	-0.0312	-53.66%	-0.04502	641.68%		Mar	-53.66%	641.68%	2.940097
	Apr	-0.06265	-0.14734	372.24%	-0.02125	-52.80%		Apr	372.24%	-52.80%	1.597224
	May	0.03955	-0.03103	-78.94%	-0.01665	-21.65%		May	-78.94%	-21.65%	-0.50293
	Jun	0.0126	-0.0018	-94.20%	0.06276	-476.94%		Jun	-94.20%	-476.94%	-2.85568
	Jul	0.01976	0.01322	-834.44%	0.04109	-34.53%		Jul	-834.44%	-34.53%	-4.34486
	Aug	0.02424	0.0083	-37.22%	0.03241	-21.12%		Aug	-37.22%	-21.12%	-0.2917
	Sep	-0.01979	-0.00835	-200.60%	0.0064	-80.25%		Sep	-200.60%	-80.25%	-1.40428
	Oct	0.00285	0.0051	-161.08%	0.00852	33.13%		Oct	-161.08%	33.13%	-0.63976
	Nov	0.00707	0.05735	1024.51%	-0.02778	-426.06%		Nov	1024.51%	-426.06%	2.992267
	Dec	0.02171	0.04899	-14.58%	0.00913	-132.87%		Dec	-14.58%	-132.87%	-0.73721
		Average return	Using average function in MS excel	-107.96%		143.92%			Average return	Using average function in MS excel	0.179829
		variance		2553.18%		11048.36%			variance		3466.64%
		standard deviation = standard deviation using STDEVP function in MS excel		5.05		10.51			standard deviation = standard deviation using STDEVP function in MS excel		5.89

jeff jeffy answered 1 year ago

Calculate the mean daily return, variance and standard deviation for both stocks show your work?

AAPLBABA-0.0148-0.00640.012538-0.001550.0061780.0129080.015207-0.001890.0082810.0048470.004060.002824-0.007440.024519-0.000650.0508420.0023160.0706110.012017-0.01099-0.00091-0.00525-0.001460.003517-0.0012800.002567-0.00144-0.00777-0.012490.0031330.001464-0.00753-0.01994-0.004260.000639-0.005860.011922-0.00112-0.00189-0.007680.0118040.0009430.0123960.0059380.0023660.0093690.018785-0.000280.0456420.006128-0.01407-0.026210.002443-0.02265-0.028760.0223990.0118450.023805-0.005160.0353870.0211410.0339980.020019-0.005620.001819-0.01166-0.01539-8.8E-05-0.01621-0.000180.0457770.0094230.031698-0.01666-0.015090.001508-0.01690.001860.0223820.0076050.004526-0.01553-0.029430.0077550.002274-0.00469-0.003880.0042660.0006640.0004430.014320.007430.0011220.001493-0.010090.0174470.0227360.002154-0.029330.008942-0.0153-0.00307-0.014190.005556-0.00294-0.000680.00972-0.000680.004862-0.002980.005709-0.00051-0.00077-0.003930.0008670.0090050.0053880.0051-0.00268-0.02249-0.01382-0.0096-0.00389-0.00664-0.0044-0.00158-0.00235Calculate the mean daily return, variance and standard deviation for both stocks show your work?

You are to calculate the mean and standard deviation for the rate of returns for IBM...

You are to calculate the mean and standard deviation for the rate of returns for IBM and GE. Use monthly values for the period August 1, 2007 through August 1, 2018 Q10.You are to calculate the mean and standard deviation for the rate of returns for IBM and GE. Use monthly values for the periodAugust 1, 2007 through August 1, 2018. Data can be obtained from the WWW as follows 1.Go to http:www.yahoo.com. Select the Finance option 2.Enter your stock's...

PLEASE SHOW WORK A.What is the standard deviation of returns for Stocks A and B?RA =...

PLEASE SHOW WORK A.What is the standard deviation of returns for Stocks A and B?RA = 23.5% RB = 14.6% σA = 13.05% σB = 4.98% State Probability Expected Return Stock A Stock B Expansion 30% 40% 22% Normal 60% 20% 12% Recession 10% -5% 8% B.What is the covariance of returns between stocks A and B?σA,B = 60.9 %2 C.What is the correlation coefficient?ρA,B = 0.94

Please answer all parts, thank you, and please type your answer and show all work including...

Please answer all parts, thank you, and please type your answer and show all work including excel formulas Exercise 15-15 The following data were taken from the balance sheet accounts of Shamrock Corporation on December 31, 2016. Current assets $554,000 Debt investments 596,000 Common stock (par value $10) 455,000 Paid-in capital in excess of par 148,000 Retained earnings 800,000 Prepare the required journal entries for the following unrelated items. (Credit account titles are automatically indented when amount is entered. Do...

Please solve in Excel and show your work. Thank you. Calculate the value of Apples’ stocks...

Please solve in Excel and show your work. Thank you. Calculate the value of Apples’ stocks given These following inputs are from Yahoo finance to see how close the model will match the current mkt price. These are 2019 figures: FCF’s = 60 billion growth= 5% wacc = 7.5% Treasury securities = 51 billion debt = 92 billion #shares= 4.6 billion Assume the growth rate listed is for the first 4 years and then FCF’s will grow at 3.5% thereafter....

calculate the mean daily return, Variance and standard deviation for each stock?

BAFB-0.01209-0.009810.002052-0.00471-0.0050.0151010.0039630.0063530.0034920.0008790.003253-0.00160.005702-0.001440.0054430.000160.000752-0.000160.01172-0.007850.002525-0.00484-0.002070.0086780.002078-0.0037-0.00415-0.002820.0040910.004775-0.00630.001772-0.00634-0.00716-0.002330.00332-0.005640.0086370.0050670.012644-0.01573-0.00553-0.01040.0022250.0034760.0003960.00970.0026950.0139520.025452-0.002630.0101750.00196-0.00595-0.03288-0.024330.0123710.01251-0.01045-0.0115-0.008470.0044020.0007830.004539-0.008370.005610.006156-0.003250.002432-7.8E-050.0216760.0101060.0100340.001077-0.00068-0.0163-0.00918-0.005080.0057440.010840.006930.004196-0.00908-0.008820.0054190.0014050.0048580.003898-0.00098-0.00450.0182230.002184-0.001780.002102-0.004240.0019420.0148670.009691-0.01546-0.01044-0.004340.0013190.001652-0.009530.00090.0004690.003745-0.002660.0082090.0080760.0079940.011978-0.0025-0.00085-0.001550.0159230.0134190.0091620.011422-0.007430.0469-0.00945-0.01532-0.0103-0.002090.012337-0.00406-0.00228calculate the mean daily return, Variance and standard deviation for each stock?

Calculate the descriptive statistics BY HAND (showing your work) (variance , standard deviation, range, average, dispersion,...

Calculate the descriptive statistics BY HAND (showing your work) (variance , standard deviation, range, average, dispersion, median, mode)that we've covered in class for the two following variables: Variable X Variable Y 4 40 2 36 8 49 6 38 10 56 5 58 3 39 9 53 10 34 9 47

Please answer all parts of the question. Please show all work and all steps. 1a.) Show...

Please answer all parts of the question. Please show all work and all steps. 1a.) Show that the solutions of x' = arc tan (x) + t cannot have maxima 1b.) Find the value of a such that the existence and uniqueness theorem applies to the ivp x' = (3/2)((|x|)^(1/3)), x(0) = a. 1c.) Find the limits, as t approaches both positive infinity and negative infinity, of the solution Φ(t) of the ivp x' = (x+2)(1-x^4), x(0) = 0

Problem 01: Calculate individual stock average, standard deviation, variance, portfolio variance Given are the daily returns...

Problem 01: Calculate individual stock average, standard deviation, variance, portfolio variance Given are the daily returns for two stocks X and Y for five business days in last week. If you have 1000 dollars to invest and you are considering to invest 600 dollars in stock X and 400 dollars in stock Y. Calculate the following A. average stock return for individual stocks B. variance and standard deviations for the individual stocks C. calculate the covariance and correlation between the...

Calculate the mean, the variance, and the standard deviation of the following discrete probability distribution. (Negative...

Calculate the mean, the variance, and the standard deviation of the following discrete probability distribution. (Negative values should be indicated by a minus sign. Round intermediate calculations to at least 4 decimal places. Round your final answers to 2 decimal places.) x −32 −20 −10 −5 P(X = x) 0.46 0.24 0.18 0.12

Question