Practice Exercise 5
.xlsx
keyboard_arrow_up
School
University of Central Florida *
*We aren’t endorsed by this school
Course
5130
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
12
Uploaded by GIRALDOD55
Problem Set 1
1)
Dividend
Stock Price
5 years
10 years
12 years
5 years
10 years
$2.50 $2.50 $2.50 $3.04 $3.70 10%
10%
10%
0.06
0.06
4%
4%
4%
$50.69 $61.68 $3.04 $3.70 $3.93 2)
PV =
43.33
5 years
10 years
12 years
52.72
64.14
69.38
3)
D8
$ 12.30 D15
$ 15.13 D25
$ 20.33 4)
D8
$ 12.67 D15
$ 15.58 D25
$ 20.94 1. Suppose the company is expected to pay a divided of $2.5 and the required rate of return is 10% and the growth rate is 4%. What is the price of the stock after 5 years? after 10 years? after 12 years?
2. Suppose the company just paid a divided of $2.5 and the required rate of return is 10% and the growth rate is 4%. What is the price of the stock after 5 years? after 10 years? after 12 years?
3. Suppose ABC, Inc. is expected to pay a dividend of $10 next year. that is, D1 = $10. The dividends are expected to grow by 3%. What is D8, D15, D25?
4. Suppose ABC, Inc. just paid a dividend of $10. that is, D0 = $10. The dividends are expected to grow by 3%. What is D8, D15, D25?
12 years
$3.93 0.06
$65.56
Problem Set 2
1)
Present Value (Year 1) = $1.09 Present Value (Year 2) = $1.14 $2.23 Present Value =
$ 23.95 Price of Stock =
$26.18 2)
Year
Dividend
Terminal value
Total cash flow
10
1
1.2500
1.2500 0.9091
2
1.5
1.5 0.8264
3
1.725
36.225
37.95 0.7513
3)
Dividend
$1 Rate
10%
EGR
0.2
Constant Growth Rate
0.05
Year 1
$0.00 Year 2
$0.00 Year 3
$1.00 Year 4
$1.20 Year 5
$1.44 Year 6
$1.51 P0
30.24
1.
Suppose the company just paid dividend of $1. The dividends are expected to grow at 20% in Ye
Year 2. After that, the dividends will grow at a constant rate of 5% forever. If the required rate of
compute today's price of the stock.
2. Suppose the company just paid dividend of $1. The dividends are expected to grow at 25% in Ye
Year 2, and 15% in Year 3. After that, the dividends will grow at a constant rate of 5% forever. If the
return is 10%, compute today's price of the stock.
3. Suppose the company will not pay any dividend in Year 1. Suppose that the company pays divide
2 and after that the dividend will grow at 20% in Years 3 to 5. After that the dividends will grow at a
6% forever. If the required rate of return is 10%, compute today's price of the stock
Rate
10.00%
Year 0
$0.00 Year 1
$0.00 Year 2
$0.00 Year 3
$1.20 Year 4
$1.20 Year 5
$31.68 NPV
$ 21.24
Present value
1.136363636364
1.239669421488
28.51239669421
$ 30.89 ear 1 and 15% in f return is 10%, ear 1 and 20% in e required rate of end of $2 in Year a constant rate of k.
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
QUESTION 9
Stock Price
in one
year time
($)
92
Consider the following information about Delta Corporation:
Current Stock
Price ($)
Probability
(Pr)
44%
65
76
36%
57
20%
The standard deviation of the return on Delta Corporation is closest to:
O 47.26%
20.31%
66.98%
60.45%
arrow_forward
Sh11
arrow_forward
Return on stockholders' equity:
20Y8
fill in the blank %
20Y7
fill in the blank %
20Y6
fill in the blank %
20Y5
fill in the blank %
20Y4
fill in the blank %
arrow_forward
Solvency and Profitability Trend Analysis
Addai Company has provided the following comparative information:
20Y8
20Υ7
20Y6
20Υ5
20Y4
Net income
$273,406
$367,976
$631,176
$884,000
$800,000
Interest expense
616,047
572,003
528,165
495,000
440,000
Income tax expense
31,749
53,560
106,720
160,000
200,000
Total assets (ending balance)
4,417,178
4,124,350
3,732,443
3,338,500
2,750,000
Total stockholders' equity (ending balance)
3,706,557
3,433,152
3,065,176
2,434,000
1,550,000
Average total assets
4,270,764
3,928,396
3,535,472
3,044,250
2,475,000
Average total stockholders' equity
3,569,855
3,249,164
2,749,588
1,992,000
1,150,000
You have been asked to evaluate the historical performance of the company over the last five years.
Selected industry ratios have remained relatively steady at the following levels for the last five years:
20Υ4-20Υ8
Return on total assets
28%
Return on stockholders' equity
18%
Times interest earned
2.7
Ratio of liabilities to stockholders' equity
0.4
Required:
1.…
arrow_forward
1 Free Cash Flow Valuation Model
2
3 INPUTS (In millions)
4
5
6 Free cash flow
7 Marketable securities
8 Notes payable
9 Long-term bonds
10 Preferred stock
11 WACC
12 Number of shares of stock
13
B
Current
0
$40
$120
$360
$60
13.00%
25
1
D
E
F
Year
Projected
2
3
4
-$15.0
$15.0
$50.0
$54.0
14 a. Calculating the estimated horizon value (i.e., the value of operations at the end of the forecast
15 period immediately after the Year-4 free cash flow)
16 Constant long-term growth rate
17 Horizon value at Year 4
18
million
Formulas
#N/A
#N/A
19 b. Calculating the present value of the horizon value, the present value of the free cash flows,
20 and the estimated Year-0 value of operations
21 Present value of HV
22 Present value of FCF
23 Value of operations
24
million
#N/A
million
million
#N/A
#N/A
25 c. Calculating the estimated Year-0 price per share of common equity
26 Value of operations
27 + Value of marketable securities
28 Total intrinsic value
29 Value of total debt
30 - Value of…
arrow_forward
1.
stock EPS share price Growth rate
A $0.30 $4.80 4%
B $0.40 $5.50 6%
C $0.50 $7.50 7%
D $0.60 $8.00 5%
Using the PEG ratio, rank the stocks in order of investment opportunity, the first having the best, the last having the worst.
A. C,B,D,A B. A,D,B,C C. C,D,B,A D. B,D,C,A
2.Which of the following not true regarding financial statement
A.Group financial statement be produced by each subsidiary as well as the parent entity
B.Profit must be separated between members of the parent company and that of minority interest
C.Minority interest share of equity represents that ‘part of a subsidiary’s equity not allocated to members of the parent company.
D.Group financial statements must be produced by the parent entity only.
E.None of the options provided.
arrow_forward
Pls help me in text so i will rate please help
arrow_forward
Question 26
Consider the following data: D1-$1.55: Po-$49.50. g-3.70% (constant), and F-2.00%. What is the cost of equity raised by selling new common vock?
O a. 9.90%
Ob.6.90%
O c. 10.90%
O d. 8.90%
O e. 8.83%
arrow_forward
Price
Forward Dividend
1T Target Est
$75.20
$0.80
$87.76
Given the information in the table, if t he stock has a required return of 14.8%, what
is the value of the stock
arrow_forward
Question content area top
Part 1
(Common stock valuation) Assume the following:
•
the investor's required rate of return is
14.5
percent,
•
the expected level of earnings at the end of this year
(E1)
is
$6,
•
the retention ratio is
40
percent,
•
the return on equity
(ROE)
is
14
percent (that is, it can earn
14
percent on reinvested earnings), and
•
similar shares of stock sell at multiples of
6.742
times earnings per share.
Questions:
a. Determine the expected growth rate for dividends.
b. Determine the price earnings ratio
(P/E1).
c. What is the stock price using the P/E ratio valuation method?
d. What is the stock price using the dividend discount model?
e. What would happen to the P/E ratio
(P/E1)
and stock price if the company increased its retention rate to
80
percent (holding all else constant)? What would happen to the P/E ratio
(P/E1)
and stock price if the company paid out all its earnings in the form of dividends?…
arrow_forward
Required A
Required B Required C
What is the value of the stock if the current dividend is $1.4, the first-stage growth is 1.4%, the second-stage growth is
[a(7)%, and the discount rate is 14%?
Note: Do not round intermediate calculations. Round your answers to 2 decimal places.
Projected dividend
Terminal price
Present value
$
Year 1
1.41
$
Year 2
1.60 $
Year 3
arrow_forward
What is the price of a stock at the end of Year 1 (P1) if the dividend for Year 2 (D2) is $5, the price at the end of Year 2 (P2) is $20, and the discount rate is 10 percent? (Round your answer to two decimal places.)
Multiple choice question.
$22.73
$25.00
$19.73
$18.18
arrow_forward
Given
Investment E(R) σ
Stock A $15,000 10% 10%
Stock B $5,000 5% 25%
Total $20,000
and Corr(AB) = PAB = −0.25. Find the Covariance between returns of A and B
-0.00525
O 0.0625
-0.00625
0.00625
-0.0625
arrow_forward
Forward
Dividend
Price
1T Target Est
$75.20
$0.80
$87.76
Given the information in the table, ift he stock has a
required return of 5.5%, what is the value of the stock
arrow_forward
Price
Forward Dividend
1T Target Est
$86.36
$2.08
$105.28
Given the information in the table, if the required return on the stock is 14.5%, what is the
value of the stock?
arrow_forward
Scenario
1
Scenario
2
Scenario
3
Scenario
4
Scenario
Probabil
ity
10.0%
25.0%
30.0%
20.0%
Rate of Return
Stock X
10%
10%
5%
-5%
-10.00%
Stock Y
-5%
5%
10%
15%
25%
5
15.0%
What is the correlation between Stock X and Stock Y?
arrow_forward
Day
5/4/2020
5/5/2020
5/6/2020
5/7/2020
5/8/2020
LMT
HPR
345.82
321.56
-7.015%
337.21
4.867%
341.11
1.157%
355.32
4.166%
S/9/2020
362.31
1.967%
12. What is WEC stock Total Geometric Return based on the table above?
A. 1.028%
В. 3.249%
C. 4.768%
D. 5.141%
E. 10.476%
arrow_forward
1
2
A
Investment
3
Broad Stock Market Index
4 Small Capitalization Market Index
5
Local Casino
6
7
8
9
10 Yearly
Daily
Monthly
Time Period
B
Probability of Price
Increase, Daily
Time
0.5030
0.5005
0.4900
1
30
365
C
Probability of Price
Decrease, Daily
Expected Return: Daily
15 (Use cells A3 to D10 from the given information to complete this question.)
16
17
Stock Name
18 Broad Stock Market Index
19 Small Capitalization Market Index
20 Local Casino
21
22
0.4970
0.4995
0.5100
D
Expected Return:
Monthly
Size of Price Change
0.0550
0.1050
0.0500
E
11
12 Required:
13
Using the information in the tables above, please calculate the expected return of each investment over one day, one month, and one year.
14
Expected Return
Yearly
F
பட
G
arrow_forward
10
6
points
Use the Black-Scholes formula for the following stock:
Time to expiration
6 months
Standard deviation
53% per year
Exercise price
$43
Stock price
$43
Annual interest rate
3%
Dividend
0
eBook
Recalculate the value of the call with the following changes:
a. Time to expiration
b. Standard deviation
Print
c. Exercise price
References
d. Stock price
e.
Interest rate
3 months
25% per year
$49
$49
5%
Select each scenario independently.
Note: Round your answers to 2 decimal places.
Value of the
Call Option
a.
C falls to
b. C falls to
c. C falls to
d. C rises to
e.
C rises to
Check my work
arrow_forward
Stock
Price ($)
Dividend Yield
WSR
16
7
HCC
56
2
SNDK
80
2
You invested a total of $11,200 in shares of the 3 stocks shown above and
expected to earn $304 in annual dividends. If you purchased a total of 250
shares. How many of each did you purchase?
You are to do this problem using the Gauss Jordan method shown in the
book and in our recorded sessions. Show each matrix step as I have
modelled for you.
arrow_forward
A4 5c
Consider the following information on three stocks in four possible future states of the economy:
State of economy
Probability of state of economy
Stock A
Stock B
Stock C
Boom
0.3
0.35
0.45
0.38
Good
0.3
0.15
0.20
0.12
Poor
0.3
0.05
–0.10
–0.05
Bust
0.1
0.00
–0.30
–0.10
stock A:
State of economy
Probability
Rate of return
Average
(a)
(b)
(c)
(d = b × c)(d = b × c)
Boom
0.3
0.35
0.105
Good
0.3
0.15
0.045
Poor
0.3
0.05
0.015
Bust
0.1
0
0
Expected rate of return
0.165
stock B:
State of economy
Probability
Rate of return
Average
(a)
(b)
(c)
(d = b × c)(d = b × c)
Boom
0.3
0.45
0.135
Good
0.3
0.2
0.06
Poor
0.3
-0.1
-0.03
Bust
0.1
-0.3
-0.03
Expected rate of return
0.135
Stock C:
State of economy
Probability
Rate of return
Average
(a)
(b)
(c)
(d = b × c)(d = b…
arrow_forward
A
B
C
O 144.67
O 141.67
O $133.81
Stock
O 131.81
Shares
1,000
5,000
3,000
Based on Table 3 the three securities comprise an index. Calculate the market
value weighted index for time period t+1?
Price_t
$45
$24
$15
Price_t+1
$64
$26
$29
arrow_forward
Use the information below to answer the question
52WHI 52WLo Ticker Div Yield% P/E Vol 00s High Low Close Net Chg
52.53 28.31 KO 0.65 1.34 13.80 6,412 54.12 32.50? -0.81
What is the EPS for the stock?
$3.52
O $2.94
O $3.08
O $2.12
arrow_forward
What is Stock X's geometric returns if it
has the following returns? Year 1 8% Year
2 - 5% Year 3 10% Year 4 - 6% Year 5 15%
a. 4.1%. b. 5.2% c. 6.8% d. 8.5%
arrow_forward
Question content area top
Part 1
(Preferred stock valuation) Pioneer's preferred stock is selling for
$21
in the market and pays a
$2.70
annual dividend.
a. If the market's required yield is
11
percent, what is the value of the stock for that investor?
b. Should the investor acquire the stock?
Question content area bottom
Part 1
a. The value of the stock for that investor is
$enter your response here
per share. (Round to the nearest cent.)
Part 2
b. Should the investor acquire the stock? (Select from the drop-down menus.)
The investor
▼
should
should not
acquire the stock because it is currently
▼
underpriced
overpriced
in the market.
arrow_forward
4
t of
estion
Determine the market value of a Digicel Stock if Do = 3.00, Ks = 13%, G = 6%.
Select one:
O a.
O b.
O c.
O d.
$45.43
$30.29
$53.00
$3.18
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- QUESTION 9 Stock Price in one year time ($) 92 Consider the following information about Delta Corporation: Current Stock Price ($) Probability (Pr) 44% 65 76 36% 57 20% The standard deviation of the return on Delta Corporation is closest to: O 47.26% 20.31% 66.98% 60.45%arrow_forwardSh11arrow_forwardReturn on stockholders' equity: 20Y8 fill in the blank % 20Y7 fill in the blank % 20Y6 fill in the blank % 20Y5 fill in the blank % 20Y4 fill in the blank %arrow_forward
- Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information: 20Y8 20Υ7 20Y6 20Υ5 20Y4 Net income $273,406 $367,976 $631,176 $884,000 $800,000 Interest expense 616,047 572,003 528,165 495,000 440,000 Income tax expense 31,749 53,560 106,720 160,000 200,000 Total assets (ending balance) 4,417,178 4,124,350 3,732,443 3,338,500 2,750,000 Total stockholders' equity (ending balance) 3,706,557 3,433,152 3,065,176 2,434,000 1,550,000 Average total assets 4,270,764 3,928,396 3,535,472 3,044,250 2,475,000 Average total stockholders' equity 3,569,855 3,249,164 2,749,588 1,992,000 1,150,000 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: 20Υ4-20Υ8 Return on total assets 28% Return on stockholders' equity 18% Times interest earned 2.7 Ratio of liabilities to stockholders' equity 0.4 Required: 1.…arrow_forward1 Free Cash Flow Valuation Model 2 3 INPUTS (In millions) 4 5 6 Free cash flow 7 Marketable securities 8 Notes payable 9 Long-term bonds 10 Preferred stock 11 WACC 12 Number of shares of stock 13 B Current 0 $40 $120 $360 $60 13.00% 25 1 D E F Year Projected 2 3 4 -$15.0 $15.0 $50.0 $54.0 14 a. Calculating the estimated horizon value (i.e., the value of operations at the end of the forecast 15 period immediately after the Year-4 free cash flow) 16 Constant long-term growth rate 17 Horizon value at Year 4 18 million Formulas #N/A #N/A 19 b. Calculating the present value of the horizon value, the present value of the free cash flows, 20 and the estimated Year-0 value of operations 21 Present value of HV 22 Present value of FCF 23 Value of operations 24 million #N/A million million #N/A #N/A 25 c. Calculating the estimated Year-0 price per share of common equity 26 Value of operations 27 + Value of marketable securities 28 Total intrinsic value 29 Value of total debt 30 - Value of…arrow_forward1. stock EPS share price Growth rate A $0.30 $4.80 4% B $0.40 $5.50 6% C $0.50 $7.50 7% D $0.60 $8.00 5% Using the PEG ratio, rank the stocks in order of investment opportunity, the first having the best, the last having the worst. A. C,B,D,A B. A,D,B,C C. C,D,B,A D. B,D,C,A 2.Which of the following not true regarding financial statement A.Group financial statement be produced by each subsidiary as well as the parent entity B.Profit must be separated between members of the parent company and that of minority interest C.Minority interest share of equity represents that ‘part of a subsidiary’s equity not allocated to members of the parent company. D.Group financial statements must be produced by the parent entity only. E.None of the options provided.arrow_forward
- Pls help me in text so i will rate please helparrow_forwardQuestion 26 Consider the following data: D1-$1.55: Po-$49.50. g-3.70% (constant), and F-2.00%. What is the cost of equity raised by selling new common vock? O a. 9.90% Ob.6.90% O c. 10.90% O d. 8.90% O e. 8.83%arrow_forwardPrice Forward Dividend 1T Target Est $75.20 $0.80 $87.76 Given the information in the table, if t he stock has a required return of 14.8%, what is the value of the stockarrow_forward
- Question content area top Part 1 (Common stock valuation) Assume the following: • the investor's required rate of return is 14.5 percent, • the expected level of earnings at the end of this year (E1) is $6, • the retention ratio is 40 percent, • the return on equity (ROE) is 14 percent (that is, it can earn 14 percent on reinvested earnings), and • similar shares of stock sell at multiples of 6.742 times earnings per share. Questions: a. Determine the expected growth rate for dividends. b. Determine the price earnings ratio (P/E1). c. What is the stock price using the P/E ratio valuation method? d. What is the stock price using the dividend discount model? e. What would happen to the P/E ratio (P/E1) and stock price if the company increased its retention rate to 80 percent (holding all else constant)? What would happen to the P/E ratio (P/E1) and stock price if the company paid out all its earnings in the form of dividends?…arrow_forwardRequired A Required B Required C What is the value of the stock if the current dividend is $1.4, the first-stage growth is 1.4%, the second-stage growth is [a(7)%, and the discount rate is 14%? Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Projected dividend Terminal price Present value $ Year 1 1.41 $ Year 2 1.60 $ Year 3arrow_forwardWhat is the price of a stock at the end of Year 1 (P1) if the dividend for Year 2 (D2) is $5, the price at the end of Year 2 (P2) is $20, and the discount rate is 10 percent? (Round your answer to two decimal places.) Multiple choice question. $22.73 $25.00 $19.73 $18.18arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education