Question
In: Finance
Year A Returns B Returns 2005 -4.6 15.7 2006 1.7 -6.7 2007 -31.5 -26.5 2008 -11.6...
| Year | A Returns | B Returns |
| 2005 | -4.6 | 15.7 |
| 2006 | 1.7 | -6.7 |
| 2007 | -31.5 | -26.5 |
| 2008 | -11.6 | -3.7 |
| 2009 | 29.8 | 9.6 |
| 2010 | 26.9 | 8.6 |
| 2011 | 22.9 | 4.7 |
| 2012 | 50.7 | 42.7 |
| 2013 | 37.3 | 41.7 |
| 2014 | 30.5 | 39.2 |
The following table, LOADING..., contains annual returns for the stocks of Company Upper A (Upper A) and Company Upper B (Upper B). The returns are calculated using end-of-year prices (adjusted for dividends and stock splits) retrieved from http://www.finance.yahoo.com/. Use the information to create an Excel spreadsheet that calculates the standard deviation of annual returns over the 10-year period for Upper A, Upper B, and of the equally-weighted portfolio of Upper A and Upper B over the 10-year period. (Hint: Review the Excel screenshot on page 173.)
Solutions
Expert Solution
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.
jeff jeffy answered 5 months agoRelated Solutions
Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A...
Consider the data in the following table:
Year
2004
2005
2006
2007
2008
2009
Stock A
-10%
20%
5%
-5%
2%
9%
Stock B
21%
7%
30%
-3%
-8%
25%
Use the above information to answer the following questions.
Round your answers to four decimal places (i.e. 0.0105).
1. Estimate the average return for stock A.
2. Estimate the average return for stock B.
3. Estimate the volatility of stock A.
4.Estimate the volatility of stock B.
5 .Estimate the...
This is a tableau question. Year Sales 2005 49387 2006 53412 2007 56783 2008 58436 2009...
This is a tableau question.
Year
Sales
2005
49387
2006
53412
2007
56783
2008
58436
2009
59994
2010
61515
2011
63182
2012
67989
2013
70448
2014
72601
2015
75482
2016
78341
2017
81111
2018
82517
2019
83275
2020
84005
I. (a) Determine the trend line using both linear and two
nonlinear equations Hint: You can choose any two of the nonlinear
options in edit trend lines within Tableau. (b) Write down the
equations (coefficients). Hint: Double click on trend line...
Balance Sheet as at year end 31st Dec 2005 2006 2007 2008 2009 CAPITAL AND LIABILITIES:...
Balance Sheet as at year end 31st Dec
2005
2006
2007
2008
2009
CAPITAL AND
LIABILITIES:
Equity share capital
400,000
600,000
500,000
400,000
600,000
Long term loan
500,000
250,000
300,000
400,000
300,000
Sundry creditors
200,000
300,000
350,000
340,000
250,000
Short term loan
50,000
40,000
60,000
115,000
50,000
ASSETS:
Land and Building
300,000
500,000
600,000
700,000
450,000
Furniture
600,000
450,000
400,000
400,000
500,000
Cash at bank
50,000
60,000
70,000
50,000
70,000
Stock
140,000
150,000
100,000
80,000
120,000
Prepaid expenses
60,000
30,000...
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Dividend $ 7.46 $ 7.91...
Year
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
Dividend
$ 7.46
$ 7.91
$ 8.38
$ 8.80
$ 9.24
$ 9.70
$ 10.28
$ 10.79
$ 11.33
$ 12.01
Find both the arithmetic growth rate and the geometric growth
rate of the dividends for Davy's Crock Pot Stores. Assuming the
January 1, 2011 price of the stock is $110.00, determine the
current required rate of return for the company (use the geometric
growth rate to calculate the...
PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585 7,205 ...
PepsiCo Revenues ($ millions), 2005–2010
Quarter
2005
2006
2007
2008
2009
2010
Qtr1
6,585
7,205
7,350
8,332
8,263
9,368
Qtr2
7,697
8,599
9,607
10,945
10,592
14,801
Qtr3
8,184
8,950
10,171
11,244
11,080
15,514
Qtr4
10,096
10,383
12,346
12,729
13,297
18,155
(b)
State the model found when performing a regression using seasonal
binaries. (A negative value should be indicated by a minus
sign. Round your answers to 4 decimal places.
yt =___...
PepsiCo Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 6,585 7,205 ...
PepsiCo Revenues ($ millions), 2005–2010
Quarter
2005
2006
2007
2008
2009
2010
Qtr1
6,585
7,205
7,350
8,333
8,263
9,368
Qtr2
7,697
8,599
9,607
10,945
10,592
14,801
Qtr3
8,184
8,950
10,171
11,244
11,080
15,514
Qtr4
10,096
10,383
12,346
12,729
13,297
18,155
(b)
State the model found when performing a regression using seasonal
binaries. (A negative value should be indicated by a minus
sign. Round your answers to 4 decimal places.
yt =___...
Cash Flow Data for Interceptors, Inc. 2005 2006 2007 2008 Cash $ 40 $ 50 $...
Cash Flow Data for Interceptors, Inc.
2005
2006
2007
2008
Cash
$
40
$
50
$
60
$
70
Cash from operations
$
132
$
130
$
127
$
122
Net capital spending
$
150
$
145
$
150
$
155
Cash from financing
$
28
$
25
$
33
What must cash flow from financing have been in 2008 for
Interceptors, Inc.?
$33
$43
$10
$40
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,206 5,131 6,090...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006
2007 2008 2009 2010
Qtr1 5,206 5,131 6,090 7,410 7,180 7,516
Qtr2 6,310 6,480 7,720 9,060 8,232 8,665
Qtr3 6,037 6,422 7,677 8,314 8,040 8,417
Qtr4 5,551 5,920 7,318 7,100 7,498 10,485
Click here for the Excel Data File (a-1) Use MegaStat or Minitab
to deseasonalize Coca-Cola’s quarterly data.
(Round your answers to 3 decimal places.)
1 2 3 4 2005 2006 2007 2008 2009 2010 mean
(a-2) State the adjusted four...
Coca-Cola Revenues ($ millions), 2005–2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr1 5,200 5,117 6,075...
Coca-Cola Revenues ($ millions), 2005–2010
Quarter
2005
2006
2007
2008
2009
2010
Qtr1
5,200
5,117
6,075
7,380
7,150
7,800
Qtr2
6,304
6,465
7,705
9,045
8,220
8,659
Qtr3
6,031
6,410
7,662
8,305
8,025
8,411
Qtr4
5,545
5,905
7,303
7,040
7,480
10,479
(a-1) Use MegaStat or Minitab to deseasonalize
Coca-Cola’s quarterly data. (Round your answers to 3
decimal places.)
1
2
3
4
2005
2006
2007
2008
2009
2010
mean
(a-2) State the adjusted four quarterly indexes.
(Round your answers to 3...
India's Current Account Assumptions (millions USD) 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013...
India's Current Account
Assumptions (millions USD)
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
Goods: exports
77,939
102,175
123,876
153,530
199,065
167,958
230,967
307,847
298,321
319,110
329,633
Goods: imports
-95,539
-134,692
-166,572
-208,611
-291,740
-247,908
-324,320
-428,021
-450,249
-433,760
-415,529
Balance on goods
-17,600
-32,517
-42,696
-55,081
-92,675
-79,950
-93,353
-120,174
-151,928
-114,650
-85,895
Services: credit
38,281
52,527
69,440
86,552
106,054
92,889
117,068
138,528
145,525
148,649
156,252
Services: debit
-35,641
-47,287
-58,514
-70,175
-87,739
-80,349
-114,739
-125,041...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Consider the three stocks in the following table. Pt represents price at time t, and Qt...
- Butterfly Tractors had $21.50 million in sales last year. Cost of goods sold was $9.50 million,...
- Discussion Questions: What impact will Brisson’s decision to manufacture MS-7 have on the cost structure of...
- An investment will pay $100 at the end of each of the next 3 years, $250...
- Due to concerns about the spread of coronavirus, representatives from athletic leagues across the globe have...
- Apple has just paid a quarterly dividend of $3.69. Dividends are expected to grow by 10%...
- You are told today that you’ll inherit a castle from your uncle in 5 years. You’ll...
ADVERTISEMENT