Evaluating Risk and Return-995709
.xlsx
keyboard_arrow_up
School
Northern Arizona University *
*We aren’t endorsed by this school
Course
120
Subject
Finance
Date
Nov 24, 2024
Type
xlsx
Pages
6
Uploaded by MegaResolve8522
Evaluating Risk and Return
Bartman Industries
Reynolds Inc.
Winslow 5000
Year
Stock Price
Dividend
Stock Price
Dividend
Includes Dividends
2020
$17.35
$1.16
$49.25
$2.80
$11,006.20
2019
$14.70
$1.07
$53.20
$2.70
$8,463.89
2018
$16.50
$1.00
$49.25
$2.55
$8,354.95
2017
$10.75
$0.95
$58.25
$2.40
$6,268.43
2016
$11.52
$0.90
$61.80
$2.25
$5,533.19
2015
$7.62
$0.85
$57.05
$2.10
$4,625.87
a.
Calculating the annual rates of return for Bartman, Reynolds, and the Winslow 5000 Index
Year
Bartman
Reynolds
Winslow
2020
25.92%
-2.16%
30.04%
2019
-4.42%
13.50%
1.30%
2018
62.79%
-11.07%
33.29%
2017
1.56%
-1.86%
13.29%
2016
62.99%
12.27%
19.61%
Calculating each entity's average return over the 5-year period
Bartman
Reynolds
Winslow
Average return
29.77%
2.14%
19.51%
b.
Calculating the standard deviations of the returns for Bartman, Reynolds, and the Wiinslow 5000
Bartman
Reynolds
Winslow
Standard deviation
32.30%
10.50%
12.95%
c.
Calculating the coefficients of variation for Bartman, Reynolds, and the Wiinslow 5000
Bartman
Reynolds
Winslow
Coefficient of variation
1.09
4.92
0.66
d.
Calculating the Sharpe ratios for Bartman, Reynolds, and the Index using their average returns
Risk-free rate
3.00%
Bartman
Reynolds
Winslow
Sharpe ratio
0.8287
-0.0824
1.2746
e.
Constructing a scatter diagram that shows Bartman's and Reynolds's returns on the vertical axis and
the Winslow 5000 Index's returns on the horizontal axis
A
B
C
D
E
F
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
f.
Estimating Bartman's and Reynolds's betas by running regressions of their returns against the index's returns
A
B
C
D
E
F
60
61
62
Bartman's Calculations
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.726648591936013
R Square
0.52801817616259
Adjusted R Square
0.37069090155012
Standard Error
0.256252960289425
Observations
5
ANOVA
df
SS
MS
F
Significance F
Regression
1
0.220385306315156
0.220385306315156
3.35617697225868
0.164343991837771
Residual
3
0.196996738971281
0.065665579657094
Total
4
0.417382045286437
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Intercept
-0.055879735399344
0.224452619983748
-0.248960049579238
0.819462935207227
-0.770188146577873
X Variable 1
1.81258110069832
0.989407095995772
1.8319871648728
0.164343991837771
-1.3361538563749
Reynolds's Calculations
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.750723356747679
R Square
0.563585558366504
Adjusted R Square
0.418114077822005
Standard Error
0.080078820732396
Observations
5
ANOVA
df
SS
MS
F
Significance F
Regression
1
0.024843760561501
0.024843760561501
3.87419964557318
0.143684802318065
Residual
3
0.019237852589674
0.006412617529891
Total
4
0.044081613151175
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Intercept
0.140061713546818
0.070141242849622
1.99685246306656
0.1397517121969
-0.08315902560797
X Variable 1
-0.608575965987938
0.309188831934347
-1.96829866777712
0.143684802318065
-1.59255282181239
Formulas
Bartman's beta
1.8126 =B81
Reynolds's beta
-0.6086 =B104
g.
Calculating the two companies' required returns
Market return
9.00%
Risk-free rate
4.50%
Bartman's required return
12.66% =B114+B109*(B113-B114)
Reynolds's required return
1.76% =B114+B110*(B113-B114)
h.
Calculating the portfolio's beta and required return
Bartman's weght
50%
Reynolds's weght
50%
Portfolio's beta
0.6020 =(B109+B110)/2
A
B
C
D
E
F
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Data as given are shown below:
Year
Bartman
Reynolds
Market Index
Stock Price
Dividend
Stock Price
Dividend
2020
$17.250
$1.150
$48.750
$3.000
11,663.98
2019
14.750
1.06
52.300
2.90
8,785.70
2018
16.500
1.000
48.750
2.750
8,679.98
2017
10.750
0.950
57.250
2.500
6,434.03
2016
11.375
0.900
60.000
2.250
5,602.28
2015
7.625
0.850
55.750
2.000
4,705.97
Use the data given to calculate annual returns for Bartman and Reynolds, and the Market Index, and then calculate average returns over the five-year period. (Hint: Remember, returns are calculated by subtracting the beginning price from the ending price to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning price. Assume that dividends are already included in the…
arrow_forward
Year
2021
2020
2019
2018
2017
2016
Goodman Corporation
Stock Price
$26.22
22.17
24.95
16.25
17.12
11.41
Dividend
$1.69
1.52
1.45
1.40
1.34
1.26
Landry Incorporated
Stock Price
$74.73
80.04
74.73
86.98
91.48
84.61
Dividend
$4.51
4.34
4.16
3.74
3.40
3.00
Market Index
Includes Dividends
17,435.13
13,147.79
12,949.11
9,485.43
8,064.16
6,891.67
arrow_forward
EVALUATING RISK AND RETURN Bartman Industries's and Reynolds Inc.'s stock prices
and dividends, along with the Winslow 5000 Index, are shown here for the period 2012-
2017. The Winslow 5000 data are adjusted to include dividends.
Year
2017
2016
2015
2014
2013
2012
Bartman Industries
Stock Price
$17.25
14.75
16.50
10.75
11.37
7.62
Reynolds Inc.
Dividend Stock Price
$1.15
1.06
1.00
0.95
0.90
0.85
$48.75
52.30
48.75
57.25
60.00
55.75
Dividend
$3.00
2.90
2.75
2.50
2.25
2.00
Winslow 5000
Includes Dividends
$11,663.98
8,785.70
8,679.98
6,434.03
5,602.28
4,705.97
a. Use the data to calculate annual rates of return for Bartman, Reynolds, and the
Winslow 5000 Index. Then calculate each entity's average return over the 5-year peri-
od. (Hint: Remember, returns are calculated by subtracting the beginning price from
the ending price to get the capital gain or loss, adding the dividend to the capital gain
or loss, and dividing the result by the beginning price. Assume that dividends are
already…
arrow_forward
Analyse Apple common stockholder dividend payment (EPS, Dividend Yield) for the last 3 years.
arrow_forward
XYZ stock price and dividend history are as follows:
Beginning-of-Year Dividend Paid at
Price
$ 125
141
Year
2018
2019
2020
2021
120
125
Year-End
$2
An investor buys six shares of XYZ at the beginning of 2018, buys another three shares at the beginning of 2019, sells one share
at the beginning of 2020, and sells all eight remaining shares at the beginning of 2021.
Arithmetic time-weighted average returns
Geometric time-weighted average returns
Date
01/01/2018
01/01/2019
64012320
2
Required:
a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Do not round intermediate
calculations. Round your answers to 2 decimal places.)
2
2
Cash Flow
b-1. Prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2018, to January 1,
2021 (Negative amounts should be indicated by a minus sign.)
%
%
arrow_forward
XYZ's stock price and dividend history are as follows:
Year
2018
2019
2020
2021
Beginning-of-Year
Price
$ 132
158
119
132
Dividend Paid at
An investor buys three shares of XYZ at the beginning of 2018, buys another two shares at the beginning of 2019, sells one share at
the beginning of 2020, and sells all four remaining shares at the beginning of 2021.
Arithmetic average rate of return
Geometric average rate of return
Year-End
$
4
4
4
4
a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of
return and final answers to 2 decimal places. Do not round other calculations.)
Dollar-weighted rate of return
%
0.13 %
b. What is the dollar-weighted rate of return? (Hint. Carefully prepare a chart of cash flows for the four dates corresponding to the turns
of the year for January 1, 2018, to January 1, 2021. If your calculator cannot calculate internal rate of return, you will have to use trial
and error.) (Round your…
arrow_forward
XYZ stock price and dividend history are as follows:
Year
Beginning-of-Year Price
Dividend Paid at Year-End
2018
$ 110
$ 3
2019
113
3
2020
100
3
2021
105
3
An investor buys four shares of XYZ at the beginning of 2018, buys another two shares at the beginning of 2019, sells one share at the beginning of 2020, and sells all five remaining shares at the beginning of 2021.
Required:
a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Do not round intermediate calculations. Round your answers to 2 decimal places.)
b-1. Prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2018, to January 1, 2021. (Negative amounts should be indicated by a minus sign.)
b-2. What is the dollar-weighted rate of return? (Hint: If your calculator cannot calculate internal rate of return, you will have to use a spreadsheet or trial and error.) (Negative value should be indicated by a minus…
arrow_forward
XYZ's stock price and dividend history are as follows:
Year Beginning-of-Year Price Dividend Paid at Year-End
2019
2020
2021
2022
$ 120
150
110
120
An investor buys three shares of XYZ at the beginning of 2019, buys another two shares at the beginning of 2020, sells one share at
the beginning of 2021, and sells all four remaining shares at the beginning of 2022.
Arithmetic average rate of return
Geometric average rate of return
$5
Required:
a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of
return and final answers to 2 decimal places. Do not round other calculations.)
5
5
5
%
%
Dollar-weighted rate of return
b. What is the dollar-weighted rate of return? (Hint Carefully prepare a chart of cash flows for the four dates corresponding to the turns
of the year for January 1, 2019, to January 1, 2022. If your calculator cannot calculate IRR, you will have to use trial and error or a
spreadsheet program.) (Round…
arrow_forward
if a dividend in 2018 was $1.20 per share and in 2019 dividend was $1.70 per share
What is the dividend growth rate?
Select one:
О а. 41.6%
ь. 12%
O c. 20%
O d. 1.70%
4
arrow_forward
Consider the following price and dividend data for Quicksilver Inc.:
Dividend ($)
Price ($)
$14.4
$13.51
$9.14
$10.74
$8.02
$7.72
Date
December 31, 2020
January 26, 2021
April 28, 2021
July 29, 2021
October 28, 2021
December 30, 2021
Assume that you purchased Quicksilver's stock at the closing price on December 31, 2020 and sold it after the dividend had been paid at the closing price on January 26, 2021. Your capital gains
rate (yield) for this period is closest to
A. 0.88%
OB. -5.42%
$0.11
$0.11
$0.11
$0.11
OC.-6.18%
OD. 0.8%
...
arrow_forward
The following table shows the expected dividend payments and required rate of return of Globex Corp. Clearly explain the assumptions, if any, you are using to solve below question(s).
Year
2021
2022
2023
2024
2025
2026
2027
ke
Dividend
$ 0.40
$ 0.44
$ 0.48
$ 0.53
$ 0.59
$ 0.61
$0.63
12%
1,Calculate value of Globex Corp share in 2021.
2.The market price of Globex Corp share is $8.50. Based on your answer in (i), is Globex Corp share overvalued, undervalued or fairly priced? Explain clearly.
arrow_forward
Year Dividends (RM)2020 3,282019 3.012018 2.762017 2.532016 2.322015 2.13Cha owns stock in a company which has paid the annual dividends shown in the above table.
The required return is assumed to be 12 percent. Using the constant growth model, calculate the per share value of the stock.
arrow_forward
XYZ stock price and dividend history are as follows:
Beginning-of-Year Dividend Paid at
Year-End
Price
$3
3
Year
2018
2019
2020
2021
$ 120
145
115
120
Arithmetic time-weighted average returns
Geometric time-weighted average returns
An Investor buys six shares of XYZ at the beginning of 2018, buys another two shares at the beginning of 2019, sells one share
at the beginning of 2020, and sells all seven remaining shares at the beginning of 2021.
Date
01/01/2018
01/01/2019
01/01/2020
01/01/2021
Required:
a. What are the arithmetic and geometric average time-weighted rates of return for the Investor? (Do not round Intermediate
calculations. Round your answers to 2 decimal places.)
Rate of return
3
Cash Flow
$
3
b-1. Prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2018, to January 1,
2021. (Negative amounts should be Indicated by a minus sign.)
(720)
(417)
139
868
Check my work
(5.0000) %
4.00 %
3.61 %
b-2. What is the dollar-weighted…
arrow_forward
XYZ's stock price and dividend history are as follows:
Year Beginning-of-Year Price Dividend Paid at Year-End
2019
$ 155
2020
185
2021
145
2022
155
Arithmetic
average rate of return
Geometric average rate of return
An investor buys three shares of XYZ at the beginning of 2019, buys another two shares at the beginning of 2020, sells one share at
the beginning of 2021, and sells all four remaining shares at the beginning of 2022.
$ 3
3
3
Required:
a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of
return and final answers to 2 decimal places. Do not round other calculations.)
%
%
Dollar-weighted rate of return
wwww
3
%
b. What is the dollar-weighted rat of return? (Hint. Carefully prepare a chart of cash flows for the four dates corresponding to the turns
of the year for January 1, 2019, to January 1, 2022. If your calculator cannot calculate IRR, you will have to use trial and error or a
spreadsheet…
arrow_forward
Faux Corp Stock Over the Last 10 years
- Beta = 1.1
- Market Risk premium = 10%
- Current risk-free rate 3%
- Last dividend $5
- Current Stock Price $30
Dividend History
2016 - $4.20
2017 - $4.40
2018 - $4.55
2019 - $4.75
2020 - $5.00
1. Calculate the cost of equity using SML
arrow_forward
A stock ended 2019 at $28.80 per share and paid a $1.75
dividend per share in 2021. What is the holding period return
if the stock ended 2021 at $38.80?
40.80%
34.72%
-28.65%
-30.28%
arrow_forward
XYZ stock price and dividend history are as follows:
Year
Beginning-of-Year Price
Dividend Paid at Year-End
2018
$ 130
$ 2
2019
153
2
2020
128
2
2021
133
2
An investor buys five shares of XYZ at the beginning of 2018, buys another two shares at the beginning of 2019, sells one share at the beginning of 2020, and sells all six remaining shares at the beginning of 2021.
Required:
a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Do not round intermediate calculations. Round your answers to 2 decimal places.)
b-1. Prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2018, to January 1, 2021. (Negative amounts should be indicated by a minus sign.)
b-2. What is the dollar-weighted rate of return? (Hint: If your calculator cannot calculate internal rate of return, you will have to use a spreadsheet or trial and error.) (Negative value should be indicated by a minus…
arrow_forward
es
XYZ stock price and dividend history are as follows:
Beginning-of-Year
Dividend Paid at
Year-End
Price
$100
110
$ 4
4
90
95
Year
2018
2019
2020
2021
An investor buys three shares of XYZ at the beginning of 2018, buys another two shares at the beginning of 2019, sells one share at
the beginning of 2020, and sells all four remaining shares at the beginning of 2021.
Required:
a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Do not round intermediate
calculations. Round your answers to 2 decimal places.)
Arithmetic time-weighted average returns
Geometric time-weighted average returns
2018
2019
2020
2021
b-1. Prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2018, to January 1, 2021.
(Negative amounts should be indicated by a minus sign.)
Date
4
4
Cash Flow
$
Rate of return
(300)
(208)
110
396
3.15 %
2.33 %
b-2. What is the dollar-weighted rate of return? (Hint: If your calculator cannot…
arrow_forward
XYZ stock price and dividend history are as follows:
Dividend Paid at
Year-End
$5
Year
2018
2019
2020
2021
Beginning-of-
Year Price
$ 130
144
120
125
An investor buys six shares of XYZ at the beginning of 2018, buys another three shares at the beginning of 2019, sells one share at the
beginning of 2020, and sells all eight remaining shares at the beginning of 2021.
Required:
a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Do not round intermediate
calculations. Round your answers to 2 decimal places.)
Arithmetic time-weighted average returns
Geometric time-weighted average returns
5
5
5
Date
b-1. Prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2018, to January 1, 2021.
(Negative amounts should be indicated by a minus sign.)
Cash Flow
%
%
arrow_forward
XYZ stock price and dividend history are as follows:
Dividend Paid at
Year-End
Year
2018
2019
2020
2021
Beginning-of-
Year Price
$ 120
129
115
120
An investor buys six shares of XYZ at the beginning of 2018, buys another two shares at the beginning of 2019, sells one share at the
beginning of 2020, and sells all seven remaining shares at the beginning of 2021.
Required:
a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Do not round intermediate
calculations. Round your answers to 2 decimal places.)
Arithmetic time-weighted average returns
Geometric time-weighted average returns
%
[%
arrow_forward
Integrative—Risk and Valuation
Given the following information for the stock of Foster Company, calculate the risk premium on its common stock.
Current price per share of common stock
$33.82
Expected dividend per share next year
$1.12
Constant annual dividen growth rate
8.8%
Risk-free rate of return
4.3%
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781285867977
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781285065137
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781305635937
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Related Questions
- Data as given are shown below: Year Bartman Reynolds Market Index Stock Price Dividend Stock Price Dividend 2020 $17.250 $1.150 $48.750 $3.000 11,663.98 2019 14.750 1.06 52.300 2.90 8,785.70 2018 16.500 1.000 48.750 2.750 8,679.98 2017 10.750 0.950 57.250 2.500 6,434.03 2016 11.375 0.900 60.000 2.250 5,602.28 2015 7.625 0.850 55.750 2.000 4,705.97 Use the data given to calculate annual returns for Bartman and Reynolds, and the Market Index, and then calculate average returns over the five-year period. (Hint: Remember, returns are calculated by subtracting the beginning price from the ending price to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning price. Assume that dividends are already included in the…arrow_forwardYear 2021 2020 2019 2018 2017 2016 Goodman Corporation Stock Price $26.22 22.17 24.95 16.25 17.12 11.41 Dividend $1.69 1.52 1.45 1.40 1.34 1.26 Landry Incorporated Stock Price $74.73 80.04 74.73 86.98 91.48 84.61 Dividend $4.51 4.34 4.16 3.74 3.40 3.00 Market Index Includes Dividends 17,435.13 13,147.79 12,949.11 9,485.43 8,064.16 6,891.67arrow_forwardEVALUATING RISK AND RETURN Bartman Industries's and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2012- 2017. The Winslow 5000 data are adjusted to include dividends. Year 2017 2016 2015 2014 2013 2012 Bartman Industries Stock Price $17.25 14.75 16.50 10.75 11.37 7.62 Reynolds Inc. Dividend Stock Price $1.15 1.06 1.00 0.95 0.90 0.85 $48.75 52.30 48.75 57.25 60.00 55.75 Dividend $3.00 2.90 2.75 2.50 2.25 2.00 Winslow 5000 Includes Dividends $11,663.98 8,785.70 8,679.98 6,434.03 5,602.28 4,705.97 a. Use the data to calculate annual rates of return for Bartman, Reynolds, and the Winslow 5000 Index. Then calculate each entity's average return over the 5-year peri- od. (Hint: Remember, returns are calculated by subtracting the beginning price from the ending price to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning price. Assume that dividends are already…arrow_forward
- Analyse Apple common stockholder dividend payment (EPS, Dividend Yield) for the last 3 years.arrow_forwardXYZ stock price and dividend history are as follows: Beginning-of-Year Dividend Paid at Price $ 125 141 Year 2018 2019 2020 2021 120 125 Year-End $2 An investor buys six shares of XYZ at the beginning of 2018, buys another three shares at the beginning of 2019, sells one share at the beginning of 2020, and sells all eight remaining shares at the beginning of 2021. Arithmetic time-weighted average returns Geometric time-weighted average returns Date 01/01/2018 01/01/2019 64012320 2 Required: a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Do not round intermediate calculations. Round your answers to 2 decimal places.) 2 2 Cash Flow b-1. Prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2018, to January 1, 2021 (Negative amounts should be indicated by a minus sign.) % %arrow_forwardXYZ's stock price and dividend history are as follows: Year 2018 2019 2020 2021 Beginning-of-Year Price $ 132 158 119 132 Dividend Paid at An investor buys three shares of XYZ at the beginning of 2018, buys another two shares at the beginning of 2019, sells one share at the beginning of 2020, and sells all four remaining shares at the beginning of 2021. Arithmetic average rate of return Geometric average rate of return Year-End $ 4 4 4 4 a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of return and final answers to 2 decimal places. Do not round other calculations.) Dollar-weighted rate of return % 0.13 % b. What is the dollar-weighted rate of return? (Hint. Carefully prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2018, to January 1, 2021. If your calculator cannot calculate internal rate of return, you will have to use trial and error.) (Round your…arrow_forward
- XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2018 $ 110 $ 3 2019 113 3 2020 100 3 2021 105 3 An investor buys four shares of XYZ at the beginning of 2018, buys another two shares at the beginning of 2019, sells one share at the beginning of 2020, and sells all five remaining shares at the beginning of 2021. Required: a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b-1. Prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2018, to January 1, 2021. (Negative amounts should be indicated by a minus sign.) b-2. What is the dollar-weighted rate of return? (Hint: If your calculator cannot calculate internal rate of return, you will have to use a spreadsheet or trial and error.) (Negative value should be indicated by a minus…arrow_forwardXYZ's stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2019 2020 2021 2022 $ 120 150 110 120 An investor buys three shares of XYZ at the beginning of 2019, buys another two shares at the beginning of 2020, sells one share at the beginning of 2021, and sells all four remaining shares at the beginning of 2022. Arithmetic average rate of return Geometric average rate of return $5 Required: a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of return and final answers to 2 decimal places. Do not round other calculations.) 5 5 5 % % Dollar-weighted rate of return b. What is the dollar-weighted rate of return? (Hint Carefully prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2019, to January 1, 2022. If your calculator cannot calculate IRR, you will have to use trial and error or a spreadsheet program.) (Round…arrow_forwardif a dividend in 2018 was $1.20 per share and in 2019 dividend was $1.70 per share What is the dividend growth rate? Select one: О а. 41.6% ь. 12% O c. 20% O d. 1.70% 4arrow_forward
- Consider the following price and dividend data for Quicksilver Inc.: Dividend ($) Price ($) $14.4 $13.51 $9.14 $10.74 $8.02 $7.72 Date December 31, 2020 January 26, 2021 April 28, 2021 July 29, 2021 October 28, 2021 December 30, 2021 Assume that you purchased Quicksilver's stock at the closing price on December 31, 2020 and sold it after the dividend had been paid at the closing price on January 26, 2021. Your capital gains rate (yield) for this period is closest to A. 0.88% OB. -5.42% $0.11 $0.11 $0.11 $0.11 OC.-6.18% OD. 0.8% ...arrow_forwardThe following table shows the expected dividend payments and required rate of return of Globex Corp. Clearly explain the assumptions, if any, you are using to solve below question(s). Year 2021 2022 2023 2024 2025 2026 2027 ke Dividend $ 0.40 $ 0.44 $ 0.48 $ 0.53 $ 0.59 $ 0.61 $0.63 12% 1,Calculate value of Globex Corp share in 2021. 2.The market price of Globex Corp share is $8.50. Based on your answer in (i), is Globex Corp share overvalued, undervalued or fairly priced? Explain clearly.arrow_forwardYear Dividends (RM)2020 3,282019 3.012018 2.762017 2.532016 2.322015 2.13Cha owns stock in a company which has paid the annual dividends shown in the above table. The required return is assumed to be 12 percent. Using the constant growth model, calculate the per share value of the stock.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningFundamentals of Financial Management (MindTap Cou...FinanceISBN:9781285867977Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningFundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningFundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781285867977
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781285065137
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781305635937
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning