Question
In: Finance
Given the following price data for EA and the Market Index (DIA) from 2000 to 2015,...
Given the following price data for EA and the Market Index (DIA) from 2000 to 2015, find the returns for each price series, then calculate the beta for EA's stock. (Round to 3 decimals)
| Year | Ea | DIA |
| 2000 | 21.3125 | 74.67136 |
| 2001 | 29.975 | 70.95762 |
| 2002 | 24.885 | 60.53014 |
| 2003 | 47.68 | 77.4199 |
| 2004 | 61.68 | 81.3084 |
| 2005 | 52.31 | 82.6164 |
| 2006 | 50.36 | 98.24182 |
| 2007 | 58.41 | 106.8822 |
| 2008 | 16.04 | 72.5348 |
| 2009 | 17.75 | 89.03117 |
| 2010 | 16.38 | 101.5058 |
| 2011 | 20.6 | 109.6855 |
| 2012 | 14.52 | 120.583 |
| 2013 | 22.94 | 156.3253 |
| 2014 | 47.02 | 171.5243 |
| 2015 | 68.72 | 171.6787 |
Solutions
Expert Solution
Answer:
The above excel with 'show formula' is as below:
jeff jeffy answered 9 months agoRelated Solutions
Using the following data, the Consumer Price Index for 2011 and 2015 using the base 1982...
Using the following data, the Consumer Price Index for 2011 and
2015 using the base 1982 = 100 ($1,210,000) are __________ and
________________.
In reality, the CPI is based on a larger basket of good.
Assuming the following prices, the average annual inflation rate
for the 33 years (1982-2015) is_______________
The core inflation rate is similar except that it excludes
___________ and ____________ prices because ___________________.
The core rate is __________________
If the average rate of inflation is the expected...
Generate comparative boxplots for: Male data between 2000 and 2015, Female data between 2000 and 2015,...
Generate comparative boxplots for: Male data between 2000 and
2015, Female data between 2000 and 2015, Both Sexes data between
2000 and 2015
Using the data from 2000, estimate the mean adult mortality
rates for male, female and both sexes for the world population with
95% confidence.
Using the data from 2015, estimate the mean male, female and
both sexes adult mortality rates for the world population with 95%
confidence.
Estimate the mean difference (with 95% confidence) between: Male
adult...
SHOW YOUR WORK PLEASE Using the following data, the Consumer Price Index for 2011 and 2015...
SHOW YOUR WORK PLEASE
Using the following data, the Consumer Price Index for 2011 and
2015 using the base 1982 = 100 ($1,210,000) are __________ and
________________.
In reality, the CPI is based on a larger basket of good.
Assuming the following prices, the average annual inflation rate
for the 33 years (1982-2015) is_______________
The core inflation rate is similar except that it excludes
___________ and ____________ prices because ___________________.
The core rate is __________________
If the average rate of...
1.Given the following data for the reaction A ® B, determine the activation energy, Ea, of...
1.Given the following data for the reaction A ® B, determine the
activation energy, Ea, of the reaction.
k (M/s)
T (K)
0.681
500
0.715
1,000
a.
2.05 ´ 10–2 kJ/mol
b.
405 J/mol
c.
6.90 J/mol
d.
48.7 J/mol
e.
9.95 kJ/mol
2. The mechanism for the reaction
2H2O2(aq) ®
2H2O(l) + O2(g) in the
presence of I–(aq) is proposed to be:
Step 1: H2O2(aq) +
I–(aq) ® H2O(l) +
OI–(aq)
Step 2: H2O2(aq) +
OI–(aq) ® H2O(l) +...
The following data is provided for a market 500 Index: &nb
The following data is provided for a market 500
Index:
Year Total return
Year Total
return
2010 9.0%
2020
2.0%
2011 11.0%
2021
3.0%
2012 -3.0%
2022
3.0%
2013 1.0%
2023
-1.0%
2014 5.0%
2024
5.0%
2015 -12.0%
2025
4.0%
2016 3.0%
2026
-3.0%
2017 4.9%
2027
3.5%
2018 -7.0%
2028
7.0%
2019 0.1%
2029
5.8%
Calculate...
You are given the following global market data. The world price for a good is 40...
You are given the following global market data.
The world price for a good is 40 and the domestic
demand-and-supply curves are given by the following equations:
Demand: P=100-0.5Q
Supply: P=70+0.4Q
where P=price and Q=quantity
1. Calculate how much is consumed.
2. Calculate how much is produced in the home economy.
3. Fine the consumer surplus and producer surplus.
4. If a tariff of 20 percent is imposed, by how much do consumption
and domestic production change?
5. How much...
Given the following relative weights of importance for the major components of the Consumer Price Index...
Given the following relative weights of importance for the major
components of the Consumer Price Index or CPI:
RIW
2016
2017
Food:
Food at home
10.1
148.4
153.3
Food away from home
6.1
138.7
148.6
Alcoholic Beverages
1.6
148.5
151.8
Housing:
Residential Rent
5.5
165.7
171.0
Homeowners Rent
18.9
151.2
155.7
Furnishings, utilities, etc.
18.2
123.7
126.5
Apparel and upkeep
6.5
132.0
138.7
Transportation:
New Vehicles
5.5
139.1
143.0
Used Vehicles
1.4
128.7
131.9
Motor Fuel
4.8
111.6
115.3
Public...
Suppose seafood price and quantity data for the years 2000 and 2009 follow. Use 2000 as...
Suppose seafood price and quantity data for the years 2000 and
2009 follow. Use 2000 as the base period.
Seafood
2000
Qty. (lb)
2000
Price ($/lb)
2009
Price ($/lb)
Halibut
75,290
2.01
2.43
Lobster
83,180
3.72
3.09
Tuna
50,779
1.87
1.97
(a)
Compute a price relative for each type of seafood. (Round your
answers to one decimal place.)
Seafood
Price Relative
Halibut
Lobster
Tuna
(b)
Compute a weighted aggregate price index for the seafood catch.
(Round your answer to one...
Suppose seafood price and quantity data for the years 2000 and 2009 follow. Use 2000 as...
Suppose seafood price and quantity data for the years 2000 and
2009 follow. Use 2000 as the base period.
Seafood
2000
Qty. (lb)
2000
Price ($/lb)
2009
Price ($/lb)
Halibut
75,090
2.01
2.33
Lobster
83,280
3.62
3.09
Tuna
50,779
1.87
1.97
(a)
Compute the index number (price relative) for each type of
seafood. (Round your answers to one decimal place.)
Seafood
Price Relative
Halibut
Lobster
Tuna
(b)
Compute a weighted aggregate price index for the seafood catch.
(Round your answer...
1. Given that the price index in the previous (month) was 1.05 and the expected price...
1. Given that the price index in the previous (month) was 1.05
and the expected price in the previous period was 1.00.
a.) What would be the current expected price "Range" if adaptive
expectations were used?
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What experience have you had with Organization Development or with Change Management? Describe the organization, the...
- 1. Renfro Rentals has issued bonds that have a 12% coupon rate, payable semiannually. The bonds...
- Given an array of positive integers a, your task is to calculate the sum of every...
- Define “culture.” Software is defined by the Merriam-Webster Dictionary as "the programs that run on a...
- In humans, hypotrichosis (sparse body hair) is a rare autosomal recessive condition. Let h = hypotrichosis...
- Increase all of the listing prices by 5% for all listings under $500,000 and 10% for...
- Samsung Industry that requires you to act as a change agent to form an organizational change...
ADVERTISEMENT