Calculate the monthly returns for 08/01/2015 – 08/31/2019 period for (iii) Chevron: Date Adj Close 8/1/2015...

Calculate the monthly returns for 08/01/2015 – 08/31/2019 period for

(iii) Chevron:

Date	Adj Close
8/1/2015	67.98351
9/1/2015	67.04664
########	77.24643
########	77.62042
########	77.39832
1/1/2016	74.39566
2/1/2016	71.78875
3/1/2016	83.11975
4/1/2016	89.02702
5/1/2016	87.99893
6/1/2016	92.30142
7/1/2016	90.23226
8/1/2016	88.55934
9/1/2016	91.57452
########	93.20279
########	99.26207
########	105.7736
1/1/2017	100.0671
2/1/2017	101.1006
3/1/2017	97.41397
4/1/2017	96.80608
5/1/2017	93.88468
6/1/2017	95.61873
7/1/2017	100.0729
8/1/2017	98.63402
9/1/2017	108.7711
########	107.2807
########	110.1504
########	116.9746
1/1/2018	117.1241
2/1/2018	104.5755
3/1/2018	107.6171
4/1/2018	118.0636
5/1/2018	117.2992
6/1/2018	120.3496
7/1/2018	120.1973
8/1/2018	112.7629
9/1/2018	117.5152
########	107.2994
########	114.3053
########	105.5726
1/1/2019	111.2593
2/1/2019	116.0435
3/1/2019	120.7387
4/1/2019	117.6805
5/1/2019	111.5936
6/1/2019	123.1738
7/1/2019	121.8573
8/1/2019	116.5222

(iv) Intel:

Date	Adj Close
8/1/2015	25.32108
9/1/2015	26.96275
########	30.29062
########	31.10468
########	31.03551
1/1/2016	27.94547
2/1/2016	26.65721
3/1/2016	29.40016
4/1/2016	27.51891
5/1/2016	28.70946
6/1/2016	30.06661
7/1/2016	31.95494
8/1/2016	32.89911
9/1/2016	34.86641
########	32.2064
########	32.04939
########	33.7531
1/1/2017	34.26493
2/1/2017	33.68795
3/1/2017	33.80661
4/1/2017	33.88159
5/1/2017	33.8441
6/1/2017	31.85807
7/1/2017	33.49157
8/1/2017	33.11388
9/1/2017	36.22591
########	43.27512
########	42.65676
########	44.17273
1/1/2018	46.06749
2/1/2018	47.16798
3/1/2018	50.17598
4/1/2018	49.73279
5/1/2018	53.18191
6/1/2018	48.16903
7/1/2018	46.60894
8/1/2018	46.92871
9/1/2018	46.10273
########	45.70302
########	48.07202
########	46.0397
1/1/2019	46.22609
2/1/2019	51.9553
3/1/2019	53.01519
4/1/2019	50.38911
5/1/2019	43.47838
6/1/2019	47.54896
7/1/2019	50.21099
8/1/2019	47.09205

(v) Tesla:

Date	Adj Close
8/1/2015	249.06
9/1/2015	248.4
########	206.93
########	230.26
########	240.01
1/1/2016	191.2
2/1/2016	191.93
3/1/2016	229.77
4/1/2016	240.76
5/1/2016	223.23
6/1/2016	212.28
7/1/2016	234.79
8/1/2016	212.01
9/1/2016	204.03
########	197.73
########	189.4
########	213.69
1/1/2017	251.93
2/1/2017	249.99
3/1/2017	278.3
4/1/2017	314.07
5/1/2017	341.01
6/1/2017	361.61
7/1/2017	323.47
8/1/2017	355.9
9/1/2017	341.1
########	331.53
########	308.85
########	311.35
1/1/2018	354.31
2/1/2018	343.06
3/1/2018	266.13
4/1/2018	293.9
5/1/2018	284.73
6/1/2018	342.95
7/1/2018	298.14
8/1/2018	301.66
9/1/2018	264.77
########	337.32
########	350.48
########	332.8
1/1/2019	307.02
2/1/2019	319.88
3/1/2019	279.86
4/1/2019	238.69
5/1/2019	185.16
6/1/2019	223.46
7/1/2019	241.61
8/1/2019	225.61

Expert Solution

(iii) Chevron:
Date	Adj Close	Monthly return
8/1/2015	67.98351
9/1/2015	67.04664	-1.38%
10/1/2015	77.24643	15.21%
11/1/2015	77.62042	0.48%
12/1/2015	77.39832	-0.29%
1/1/2016	74.39566	-3.88%
2/1/2016	71.78875	-3.50%
3/1/2016	83.11975	15.78%
4/1/2016	89.02702	7.11%
5/1/2016	87.99893	-1.15%
6/1/2016	92.30142	4.89%
7/1/2016	90.23226	-2.24%
8/1/2016	88.55934	-1.85%
9/1/2016	91.57452	3.40%
10/1/2016	93.20279	1.78%
11/1/2016	99.26207	6.50%
12/1/2016	105.7736	6.56%
1/1/2017	100.0671	-5.40%
2/1/2017	101.1006	1.03%
3/1/2017	97.41397	-3.65%
4/1/2017	96.80608	-0.62%
5/1/2017	93.88468	-3.02%
6/1/2017	95.61873	1.85%
7/1/2017	100.0729	4.66%
8/1/2017	98.63402	-1.44%
9/1/2017	108.7711	10.28%
10/1/2017	107.2807	-1.37%
11/1/2017	110.1504	2.67%
12/1/2017	116.9746	6.20%
1/1/2018	117.1241	0.13%
2/1/2018	104.5755	-10.71%
3/1/2018	107.6171	2.91%
4/1/2018	118.0636	9.71%
5/1/2018	117.2992	-0.65%
6/1/2018	120.3496	2.60%
7/1/2018	120.1973	-0.13%
8/1/2018	112.7629	-6.19%
9/1/2018	117.5152	4.21%
10/1/2018	107.2994	-8.69%
11/1/2018	114.3053	6.53%
12/1/2018	105.5726	-7.64%
1/1/2019	111.2593	5.39%
2/1/2019	116.0435	4.30%
3/1/2019	120.7387	4.05%
4/1/2019	117.6805	-2.53%
5/1/2019	111.5936	-5.17%
6/1/2019	123.1738	10.38%
7/1/2019	121.8573	-1.07%
8/1/2019	116.5222	-4.38%

(iv) Intel:
Date	Adj Close
8/1/2015	25.32108
9/1/2015	26.96275	6.48%
10/1/2015	30.29062	12.34%
11/1/2015	31.10468	2.69%
12/1/2015	31.03551	-0.22%
1/1/2016	27.94547	-9.96%
2/1/2016	26.65721	-4.61%
3/1/2016	29.40016	10.29%
4/1/2016	27.51891	-6.40%
5/1/2016	28.70946	4.33%
6/1/2016	30.06661	4.73%
7/1/2016	31.95494	6.28%
8/1/2016	32.89911	2.95%
9/1/2016	34.86641	5.98%
10/1/2016	32.2064	-7.63%
11/1/2016	32.04939	-0.49%
12/1/2016	33.7531	5.32%
1/1/2017	34.26493	1.52%
2/1/2017	33.68795	-1.68%
3/1/2017	33.80661	0.35%
4/1/2017	33.88159	0.22%
5/1/2017	33.8441	-0.11%
6/1/2017	31.85807	-5.87%
7/1/2017	33.49157	5.13%
8/1/2017	33.11388	-1.13%
9/1/2017	36.22591	9.40%
10/1/2017	43.27512	19.46%
11/1/2017	42.65676	-1.43%
12/1/2017	44.17273	3.55%
1/1/2018	46.06749	4.29%
2/1/2018	47.16798	2.39%
3/1/2018	50.17598	6.38%
4/1/2018	49.73279	-0.88%
5/1/2018	53.18191	6.94%
6/1/2018	48.16903	-9.43%
7/1/2018	46.60894	-3.24%
8/1/2018	46.92871	0.69%
9/1/2018	46.10273	-1.76%
10/1/2018	45.70302	-0.87%
11/1/2018	48.07202	5.18%
12/1/2018	46.0397	-4.23%
1/1/2019	46.22609	0.40%
2/1/2019	51.9553	12.39%
3/1/2019	53.01519	2.04%
4/1/2019	50.38911	-4.95%
5/1/2019	43.47838	-13.71%
6/1/2019	47.54896	9.36%
7/1/2019	50.21099	5.60%
8/1/2019	47.09205	-6.21%

(v) Tesla:
Date	Adj Close
8/1/2015	249.06
9/1/2015	248.4	-0.26%
10/1/2015	206.93	-16.69%
11/1/2015	230.26	11.27%
12/1/2015	240.01	4.23%
1/1/2016	191.2	-20.34%
2/1/2016	191.93	0.38%
3/1/2016	229.77	19.72%
4/1/2016	240.76	4.78%
5/1/2016	223.23	-7.28%
6/1/2016	212.28	-4.91%
7/1/2016	234.79	10.60%
8/1/2016	212.01	-9.70%
9/1/2016	204.03	-3.76%
10/1/2016	197.73	-3.09%
11/1/2016	189.4	-4.21%
12/1/2016	213.69	12.82%
1/1/2017	251.93	17.90%
2/1/2017	249.99	-0.77%
3/1/2017	278.3	11.32%
4/1/2017	314.07	12.85%
5/1/2017	341.01	8.58%
6/1/2017	361.61	6.04%
7/1/2017	323.47	-10.55%
8/1/2017	355.9	10.03%
9/1/2017	341.1	-4.16%
10/1/2017	331.53	-2.81%
11/1/2017	308.85	-6.84%
12/1/2017	311.35	0.81%
1/1/2018	354.31	13.80%
2/1/2018	343.06	-3.18%
3/1/2018	266.13	-22.42%
4/1/2018	293.9	10.43%
5/1/2018	284.73	-3.12%
6/1/2018	342.95	20.45%
7/1/2018	298.14	-13.07%
8/1/2018	301.66	1.18%
9/1/2018	264.77	-12.23%
10/1/2018	337.32	27.40%
11/1/2018	350.48	3.90%
12/1/2018	332.8	-5.04%
1/1/2019	307.02	-7.75%
2/1/2019	319.88	4.19%
3/1/2019	279.86	-12.51%
4/1/2019	238.69	-14.71%
5/1/2019	185.16	-22.43%
6/1/2019	223.46	20.68%
7/1/2019	241.61	8.12%
8/1/2019	225.61	-6.62%

WORKINGS formula for reference

jeff jeffy answered 4 months ago

Calculate the monthly returns for 08/01/2015 – 08/31/2019 period for (i) S&P 500: Date Adj Close...

Calculate the monthly returns for 08/01/2015 – 08/31/2019 period for (i) S&P 500: Date Adj Close 8/1/2015 1972.18 9/1/2015 1920.03 ######## 2079.36 ######## 2080.41 ######## 2043.94 1/1/2016 1940.24 2/1/2016 1932.23 3/1/2016 2059.74 4/1/2016 2065.3 5/1/2016 2096.95 6/1/2016 2098.86 7/1/2016 2173.6 8/1/2016 2170.95 9/1/2016 2168.27 ######## 2126.15 ######## 2198.81 ######## 2238.83 1/1/2017 2278.87 2/1/2017 2363.64 3/1/2017 2362.72 4/1/2017 2384.2 5/1/2017 2411.8 6/1/2017 2423.41 7/1/2017 2470.3 8/1/2017 2471.65 9/1/2017 2519.36 ######## 2575.26 ######## 2584.84 ######## 2673.61 1/1/2018 2823.81 2/1/2018 2713.83 3/1/2018 2640.87...

Date Open High Low Close Adj Close Volume Rate of return 1/1/2014 1845.859985 1850.839966 1770.449951 1782.589966...

Date Open High Low Close Adj Close Volume Rate of return 1/1/2014 1845.859985 1850.839966 1770.449951 1782.589966 1782.589966 75871910000 2/1/2014 1782.680054 1867.920044 1737.920044 1859.449951 1859.449951 69725590000 0.04311703 3/1/2014 1857.680054 1883.969971 1834.439941 1872.339966 1872.339966 71885030000 0.006932166 4/1/2014 1873.959961 1897.280029 1814.359985 1883.949951 1883.949951 71595810000 0.006200789 5/1/2014 1884.390015 1924.030029 1859.790039 1923.569946 1923.569946 63623630000 0.02103028 6/1/2014 1923.869995 1968.170044 1915.97998 1960.22998 1960.22998 63283380000 0.019058332 7/1/2014 1962.290039 1991.390015 1930.670044 1930.670044 1930.670044 66524690000 -0.015079831 8/1/2014 1929.800049 2005.040039 1904.780029 2003.369995 2003.369995 58131140000 0.037655295 9/1/2014 2004.069946 2019.26001 1964.040039 1972.290039 1972.290039...

3300 Econometics HW Set 1 DATE Cons. Disp.Icome 2015-01-01 $ 11,788.36 $ 13,226.57 2015-04-01 $ 11,887.54...

3300 Econometics HW Set 1 DATE Cons. Disp.Icome 2015-01-01 $ 11,788.36 $ 13,226.57 2015-04-01 $ 11,887.54 $ 13,327.81 2015-07-01 $ 11,971.95 $ 13,440.36 2015-10-01 $ 12,039.65 $ 13,471.39 2016-01-01 $ 12,111.78 $ 13,562.27 2016-04-01 $ 12,214.10 $ 13,541.45 2016-07-01 $ 12,294.30 $ 13,592.92 2016-10-01 $ 12,372.73 $ 13,685.36 2017-01-01 $ 12,427.65 $ 13,835.34 2017-04-01 $ 12,515.86 $ 13,909.77 2017-07-01 $ 12,584.91 $ 13,986.19 2017-10-01 $ 12,706.37 $ 14,065.92 2018-01-01 $ 12,722.84 $ 14,219.83 2018-04-01 $ 12,842.02 $ 14,306.61 2018-07-01 $...

Consider the following five monthly returns: 5% −2% 4% 8% −1% a. Calculate the arithmetic average...

Consider the following five monthly returns: 5% −2% 4% 8% −1% a. Calculate the arithmetic average monthly return over this period and express your answer as a percentage per month. b. Calculate the geometric average monthly return over this period. c. Calculate the monthly variance over this period. d. Calculate the monthly standard deviation over this period.

ASSIGNMENT 1 · ECON 3060 - 01 Due Date: September 4, 2019 1) The Graduate Management...

ASSIGNMENT 1 · ECON 3060 - 01 Due Date: September 4, 2019 1) The Graduate Management Admission Test (GMAT) is a standardized test used by schools to determine the aptitude of individuals who are applying for MBA programs. The range of the GMAT score is 200-800. Brian has recently taken the exam and scored 720. This is an example of _______ data. A) nominal B) ordinal C) interval D) ratio 2) A respondent of a survey indicates that she is...

Disney Annual Historical Prices Date Open High Low Adj. Close 10/1/2005 23.80 24.65 22.57 20.21 10/1/2006...

Disney Annual Historical Prices Date Open High Low Adj. Close 10/1/2005 23.80 24.65 22.57 20.21 10/1/2006 30.36 31.55 29.98 26.37 10/1/2007 34.38 35.69 33.57 30.13 10/1/2008 30.30 31.06 21.25 22.78 10/1/2009 27.76 29.98 26.84 24.43 10/1/2010 33.30 36.52 33.08 32.62 10/1/2011 30.03 36.60 28.19 31.84 10/1/2012 52.31 53.15 48.80 45.59 10/1/2013 64.37 69.87 63.10 64.63 10/1/2014 89.08 91.98 78.54 87.17 10/1/2015 102.97 115.40 99.88 110.52 10/1/2016 92.47 94.40 90.32 91.30 10/1/2017 99.31 100.98 96.80 97.81 Comparing the first six years...

1. Followings Tables shows previous 11 months stock market returns. Date Monthly SP500 Return Monthly DJIA...

1. Followings Tables shows previous 11 months stock market returns. Date Monthly SP500 Return Monthly DJIA Return 12/7/2007 -0.8628 -0.7994 1/8/2008 -6.1163 -4.6323 2/8/2008 -3.4761 -3.0352 3/8/2008 -0.5960 -0.0285 4/8/2008 4.7547 4.5441 5/8/2008 1.0674 -1.4182 6/8/2008 -8.5962 -10.1937 7/8/2008 -0.9859 0.2468 8/8/2008 1.2191 1.4548 9/8/2008 -9.2054 -6.0024 10/8/2008 -16.8269 -4.8410 Let consider we know the variance of monthly return for all stock were 25 percent in 2008, perform the following hypothesis for each index: Ho :µ= -5 Ha :µ ≠-5...

loan: $ 30,000.00 total payment: $500 APR(%): 8 part A: calculate the period rate assuming monthly...

loan: $ 30,000.00 total payment: $500 APR(%): 8 part A: calculate the period rate assuming monthly compounding partB: do the amortization schedule and use it to answer parts C and D partC: what is the life of your loan part D: what is the total interest payment over the life of the loan?

Account# 111 - Cash Date Description Debits Credits Balance Beginning Balance $0.00 CR 9/01/2015 CR 1...

Account# 111 - Cash Date Description Debits Credits Balance Beginning Balance $0.00 CR 9/01/2015 CR 1 owner's investment $21,000.00 $21,000.00 DR 9/02/2015 Race Car Purchase $13,500.00 $7,500.00 DR 9/03/2015 Track Rent $4,185.00 $3,315.00 DR 9/04/2015 Newpaper Advertising $251.19 $3,063.81 DR 9/06/2015 Cash Collected $1,200.00 $4,263.81 DR 9/07/2015 Service Provided $2,000.00 $6,263.81 DR 9/07/2015 Payment on Sep. 6 $450.00 $5,813.81 DR 9/09/2015 Sept. Advertising $325.68 $5,488.13 DR 9/11/2015 Payment on Sep. 3 $1,100.00 $4,388.13 DR 9/11/2015 (AR Collection) $400.00 $4,788.13 DR...

a) Consider a 5 1/8 bond, maturing 12/31/02 (coupon payment date is 06/30 and 12/31), 8...

a) Consider a 5 1/8 bond, maturing 12/31/02 (coupon payment date is 06/30 and 12/31), 8 trading at 101:11 for settlement 8/12/02. Calculate accrued interest and invoice price (M=100,000). b) Consider now a 5 1/2 bond, maturing 3/31/03, trading at 102:15 for settlement 8/12/02. Calculate accrued interest and invoice price (M=100,000).

Question