Allen_Berk_DeMarzo_Problem_9-25_Start
.xlsx
keyboard_arrow_up
School
East Carolina University *
*We aren’t endorsed by this school
Course
6604
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
6
Uploaded by lexinallen2000
Problem 9-25
a.
Using the average P/E multiple in Table 9.1 (far below), estimate KCP
b.
c.
Using the average price to book value multiple in Table 9.1 (far below
d.
EPS
$1.65
Book value of equity
$12.05
a.
Using the average P/E multiple in Table 9.1 (far below), estimate KCP
Price per share
b.
Highest P/E
Lowest P/E
Highest share price
Lowest share price
c.
Using the average price to book value multiple in Table 9.1 (far below
Suppose that in January 2006, Kenneth Cole Productions had EPS of $1.65 a
share.
Complete the steps below using cell references to given data or previous reference is all you need. To copy/paste a formula across a row or down mixed cell reference may be preferred. If a specific Excel function is to b
of that function. Do not type in numerical data into a cell or function. Ins
which the data is found. Make your computations only in the blue cells h
otherwise directed, use the earliest appearance of the data in your formu
What range of share prices do you estimate based on the highest and l
below)?
What range of share prices do you estimate based on the highest and l
Table 9.1 (far below)?
What range of share prices do you estimate based on the highest and l
below)?
Price per share
d.
Highest price-to-book
Lowest price-to-book
Highest share price
Lowest share price
Table 9-1
Stock Prices and Multiples for the Footwear Industry, January 2006
Market
Enterprise
Stock Price
Capitalization
Value
Ticker
Company
($)
($ million)
($ million)
NKE
Nike
84.20 21,830 20,518 Puma AG
312.05 5,088 4,593 RBK
Reebok
58.72 3,514 3,451 WWW
Wolverine World Wide
22.10 1,257 1,253 BWS
Brown Shoe
43.36 800 1,019 SKX
Sketchers
17.09 683 614 SRR
Stride Rite
13.70 497 524 DECK
Deckers Outdoor
30.05 373 367 WEYS
Weco Group
19.90 230 226 RCKY
Rocky Shoes & Boots
19.96 106 232 DFZ
R.G. Barry Corp.
6.83 68 92 BOOT
LaCross Footwear
10.40 62 75 Average (excl. KCP)
Maximum/Average
Minimum/Average
Requirements
1.
Start Excel - completed.
2.
3.
What range of share prices do you estimate based on the highest and l
Table 9.1 (far below)?
PMMA
Y
In cell D15
, by using cell references, calculate the share price based o
In cell D19
, by using cell references and the function MAX
, determin
Note
: Be sure to enter the corresponding cells for all the twelve comp
4.
5.
6.
7.
8.
9.
10.
11.
12.
Save the workbook. Close the workbook and then exit Excel. Submit In cell D20
, by using cell references and the function MIN
, determine
Note
: Be sure to enter the corresponding cells for all the twelve comp
In cell D21
, by using cell references, calculate the highest share price pt.)
.
Note
: Use the highest P/E multiple determined above in your calculat
In cell D22
, by using cell references, calculate the lowest share price b
pt.)
.
Note
: Use the lowest P/E multiple determined above in your calculatio
In cell D26
, by using cell references, calculate the share price based o
pt.)
.
In cell D30
, by using cell references and the function MAX
, determin
(1 pt.)
.
Note
: Be sure to enter the corresponding cells for all the twelve comp
In cell D31
, by using cell references and the function MIN
, determine
pt.)
.
Note
: Be sure to enter the corresponding cells for all the twelve comp
In cell D32
, by using cell references, calculate the share price based o
(1 pt.)
.
Note
: Use the highest price to book value multiple determined above In cell D33
, by using cell references, calculate the share price based o
(1 pt.)
. Note
: Use the lowest price to book value multiple determined above i
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 number 6
arrow_forward
Pls thanks correct steo by step
arrow_forward
octoring Enable x +
getproctorio.com/secured #lockdown
octoring Enabled: Chapter 4 Required Homework (G... i
03:48:29
5
The Home Depot is the largest home improvement retailer in the United States. Home Depot financial statements for 2024 are shown
below (in thousands):
2024 Income Statement
Net sales
Cost of goods sold
Gross profit
Operating expenses
Interest expense
Income tax expense
Net income
Assets
Cash
$ 10,000
(6,550)
3,450
(2,350)
(300)
(320)
$ 480
Comparative Balance Sheets
Accounts receivable
Inventory
Property, plant, and equipment (net)
Bonds payable
Common stock
Retained earnings
Liabilities and Shareholders' Equity
Current liabilities
December 31
2024
Saved
$ 700
700
900
3,000
$ 5,300
1,700
1,900
700
1,000
$ 5,300
2023
$ 600
500
700
3,100
$ 4,900
$ 1,450
1,900
700
850
$ 4,900
Help
Required:
Calculate Home Depot ratios for 2024.
Note: Consider 365 days a year. Do not round intermediate calculations and round your final answers to 2 decimal places.
arrow_forward
Cost of equity
arrow_forward
Expalin the ratio of this solution
arrow_forward
The Sunland Products Co. currently has debt with a market value of $300 million outstanding. The debt consists of 9 percent coupon
bonds (semiannual coupon payments) which have a maturity of 15 years and are currently priced at $1,434.63 per bond. The firm also
has an issue of 2 million preferred shares outstanding with a market price of $10 per share. The preferred shares pay an annual
dividend of $1.20. Sunland also has 14 million shares of common stock outstanding with a price of $20.00 per share. The firm is
expected to pay a $2.20 common dividend one year from today, and that dividend is expected to increase by 5 percent per year
forever. If Sunland is subject to a 40 percent marginal tax rate, then what is the firm's weighted average cost of capital?
Eyeol Template
arrow_forward
1 percent = Rf
6 percent = MRP
1.4 Beta
Rf + MRP * Beta
what is cost of equity
arrow_forward
a. Cost of equity
b. Cost of equity
c. Cost of equity
d-1. WACC
d-2. WACC
9.10 %
9.76 %
12.15 %
%
%
arrow_forward
The price-earnings per share of A, B, C, D and E is P6.00, P6.25, P6.80, P6.90 and P6.20. If A has earnings per share of P1,200.00, it would currently be ____ by ____ compared to the group average.
a. Overvalued by P516
b. Undervalued by P540
c. Undervalued by P516
d. Overvalued by P550
arrow_forward
Colonel Motors (C)
Separated Edison (S)
Expected Return
10%
8%
Standard Deviation
6%
3%
Please represent graphically all potential combinations of stocks C and S, if the correlation
coefficient between the returns of stocks C and S is:
A) 1
B) 0
C) -1
Please report these investment opportunity sets in the corresponding Excel sheets.
arrow_forward
tol Processing ng
Help
Save & Exit
Submit
Saved
Practice Problems i
Check my work
Eaton Electronic Company's treasurer uses both the capital asset pricing model and the dividend valuation model to compute the cost
of common equity (also referred to as the required rate of return for common equity).
Assume:
Rf =
7%
Km
10%
=
1.6
D1 = $ 0.70
$ 19
8%
%3D
PO =
nt
a. Compute Ki (required rate of return on common equity based on the capital asset pricing model). (Do not round intermediate
calculations. Input your answer as a percent rounded to 2 decimal places.)
ences
Ki
b. Compute Ke (required rate of return on common equity based on the dividend valuation model). (Do not round intermediate
calculations, Input vour answer as a percent rounded to 2 decimal places.)
< Prev
10 of 10
Next
Mc
Graw
Hill
149
MacBook Air
arrow_forward
1. What is the Stock Price when the Equity Ratio is 75%?
a. 107.14
b. 52.08
c. 29.41
d. 75%
e. 25%
2. What is the Stock Price when the Equity Ratio is 50%?
a. 107.14
b. 52.08
c. 29.41
d. 75%
e. 25%
3. What is the Stock Price when the Equity Ratio is 25%?
a. 107.14
b. 52.08
c. 29.41
d. 75%
e. 25%
4. What is the equity ratio on the optimal capital structure?
a. 107.14
b. 52.08
c. 29.41
d. 75%
e. 25%
5. What is the debt ratio on the optimal capital structure?
a. 107.14
b. 52.08
c. 29.41
d. 75%
e. 25%
6. What is the Stock Price on the optimal capital structure?
a. 107.14
b. 52.08
c. 29.41
d. 75%
e. 25%
arrow_forward
Estimating EPS from Statement of Equity
Below is an excerpt from the Consolidated Statement of Equity for Conglomerate Y for the fis
year ended Year 10 (millions).
Fiscal Year Ended December 27, Year 10
Preferred Stock
Conglomerate Y and Subsidiaries
Consolidated Statement of Equityt
Repurchased Preferred Stock
Balance, beginning of year
Redemptions
Balance, end of year
Common Stock
Balance, beginning of year
Repurchased common stock
Balance, end of year
Capital in Excess of Par Value
Balance, beginning of year
Stock-based compensation expense
Stock option exercises, RSUS, PSUs and Yunits converted
Withholding tax on RSUS and PSUs converted
Other
Balance, end of year
Retained Earnings
Balance, beginning of year
Net income attributable to Conglomerate Y
Cash dividends declared-common
Cash dividends declared-preferred
Cash dividends declared-RSUS and PSUs
Balance, end of year
Shares Amount
0.8
$41
(0.6)
(0.1)
(0.7)
1,529
(66)
1,463
(171)
(10)
$(181)
$25
$25
$4,095
297
(200)
(91)
14…
arrow_forward
Calculate ABC’s price per share using the median peer P/E ratio.
Peers
P/E
EPS
1
15.23
3.10
2
25.50
2.90
3
119.12
2.70
4
37.50
2.10
5
68.12
1.75
6
51.25
1.80
Industry
21.50
1.76
ABC
20.00
3.15
$129.62
$151.42
$139.78
$189.50
arrow_forward
48
The Sunland Products Co. currently has debt with a market value of $300 million outstanding. The debt consists of 9 percent coupon
bonds (semiannual coupon payments) which have a maturity of 15 years and are currently priced at $1,434.63 per bond. The firm also
has an issue of 2 million preferred shares outstanding with a market price of $10 per share. The preferred shares pay an annual
dividend of $1.20. Sunland also has 14 million shares of common stock outstanding with a price of $20.00 per share. The firm is
expected to pay a $2.20 common dividend one year from today, and that dividend is expected to increase by 5 percent per year
forever. If Sunland is subject to a 40 percent marginal tax rate, then what is the firm's weighted average cost of capital?
Excel Template
(Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have
different values. When using this template, copy the problem statement from this screen…
arrow_forward
Do not use AI
arrow_forward
What is the standard deviation of a portfolio formed of shares A and B?
Asset (A)
E(R₂) = 9%
SDA = 4%
W₁ = 0.4
Select one:
A.
4.99%
B.
4.56%
C.
3.68%
D.
5.16
Asset (B)
E(R₂) = 11%
SDB = 6%
WB = 0.6
COVA, B = 0.0011
arrow_forward
Assume that company A is similar in terms of industry and other characteristics to firms B, C, and D. If you are using the average P/E ratio of the comparable firms, what should the price of Stock
A be if it's expected earnings are $2.25 per share?
Stock
Stock B
Stock C
Stock D
$18.93
$18.98
$60.77
$60.95
Price per share
$37.22
$56.92
$421.34
Earnings per share
$2.05
$2.96
$1.09
AVERAGE
P/E Ratio
arrow_forward
Valuation with price/earnings multiples For each of the firms shown in the following table, use the data given to estimate its common stock value employing price/earnings (P/E) multiples.
Firm Expected EPS Price/earnings multiple
A $3.00 6.2
B $4.50 10.0
C $1.80 12.6
D $2.40 8.9
E $5.10 15.0
arrow_forward
Need answer with this question
arrow_forward
3 is not the right answer can someone help?
arrow_forward
use attachment to answer question
This question relates to Diagram 3 from the 9.4 diagrams, which shows the Security Market Line.
A share has a beta of 0.75 and, based on the CAPM and the current price of the share, you believe it to be underpriced. Is this Share 1, 2, 3, or 4.
Select one:
a.
1
b.
2
c.
3
d.
4
arrow_forward
True answer
arrow_forward
(Weighted Averages MC)
Use the table to answer the question that follows.
ROR
Portfolio 1 Portfolio 2 Portfolio 3
7.3%
$1,150 $800
$1,100
1.8% $1,825
$2,500
$525
2.7%
-6.7% $1,405
10.4% $1,045
$1,450
$250
$825
$1,200
$1,880
$400
$2,225
Using technology, calculate the weighted mean of the RORs for each portfolio. Based on the results, which list shows a comparison of the overall performance of the portfolios,
from best to worst?
O Portfolio 3, Portfolio 1, Portfolio 2
Portfolio 2, Portfolio 3, Portfolio 1
O Portfolio 1, Portfolio 2, Portfolio 3
O Portfolio 3, Portfolio 2, Portfolio 1
arrow_forward
Company V
Company U
Target price
20.20
4.81
Last price
19.60
4.04
Average Target Price
16.03
4.85
Based on the information given, which company will the investor choose to invest in and state why?
arrow_forward
Northwest Utility Company faces increasing needs for capital. Fortunately, it has an Aa3 credit rating. The corporate tax rate is 35
percent. Northwest's treasurer is trying to determine the corporation's current weighted average cost of capital in order to assess the
profitability of capital budgeting projects.
Historically, the corporation's earnings and dividends per share have increased about 6.2 percent annually and this should continue in
the future. Northwest's common stock is selling at $60 per share, and the company will pay a $4.50 per share dividend (D₁).
The company's $100 preferred stock has been yielding 8 percent in the current market. Flotation costs for the company have been
estimated by its investment banker to be $2.00 for preferred stock.
The company's optimum capital structure is 50 percent debt, 10 percent preferred stock, and 40 percent common equity in the form of
retained earnings. Refer to the following table on bond issues for comparative yields on bonds of…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Related Questions
- Question number 6arrow_forwardPls thanks correct steo by steparrow_forwardoctoring Enable x + getproctorio.com/secured #lockdown octoring Enabled: Chapter 4 Required Homework (G... i 03:48:29 5 The Home Depot is the largest home improvement retailer in the United States. Home Depot financial statements for 2024 are shown below (in thousands): 2024 Income Statement Net sales Cost of goods sold Gross profit Operating expenses Interest expense Income tax expense Net income Assets Cash $ 10,000 (6,550) 3,450 (2,350) (300) (320) $ 480 Comparative Balance Sheets Accounts receivable Inventory Property, plant, and equipment (net) Bonds payable Common stock Retained earnings Liabilities and Shareholders' Equity Current liabilities December 31 2024 Saved $ 700 700 900 3,000 $ 5,300 1,700 1,900 700 1,000 $ 5,300 2023 $ 600 500 700 3,100 $ 4,900 $ 1,450 1,900 700 850 $ 4,900 Help Required: Calculate Home Depot ratios for 2024. Note: Consider 365 days a year. Do not round intermediate calculations and round your final answers to 2 decimal places.arrow_forward
- Cost of equityarrow_forwardExpalin the ratio of this solutionarrow_forwardThe Sunland Products Co. currently has debt with a market value of $300 million outstanding. The debt consists of 9 percent coupon bonds (semiannual coupon payments) which have a maturity of 15 years and are currently priced at $1,434.63 per bond. The firm also has an issue of 2 million preferred shares outstanding with a market price of $10 per share. The preferred shares pay an annual dividend of $1.20. Sunland also has 14 million shares of common stock outstanding with a price of $20.00 per share. The firm is expected to pay a $2.20 common dividend one year from today, and that dividend is expected to increase by 5 percent per year forever. If Sunland is subject to a 40 percent marginal tax rate, then what is the firm's weighted average cost of capital? Eyeol Templatearrow_forward
- 1 percent = Rf 6 percent = MRP 1.4 Beta Rf + MRP * Beta what is cost of equityarrow_forwarda. Cost of equity b. Cost of equity c. Cost of equity d-1. WACC d-2. WACC 9.10 % 9.76 % 12.15 % % %arrow_forwardThe price-earnings per share of A, B, C, D and E is P6.00, P6.25, P6.80, P6.90 and P6.20. If A has earnings per share of P1,200.00, it would currently be ____ by ____ compared to the group average. a. Overvalued by P516 b. Undervalued by P540 c. Undervalued by P516 d. Overvalued by P550arrow_forward
- Colonel Motors (C) Separated Edison (S) Expected Return 10% 8% Standard Deviation 6% 3% Please represent graphically all potential combinations of stocks C and S, if the correlation coefficient between the returns of stocks C and S is: A) 1 B) 0 C) -1 Please report these investment opportunity sets in the corresponding Excel sheets.arrow_forwardtol Processing ng Help Save & Exit Submit Saved Practice Problems i Check my work Eaton Electronic Company's treasurer uses both the capital asset pricing model and the dividend valuation model to compute the cost of common equity (also referred to as the required rate of return for common equity). Assume: Rf = 7% Km 10% = 1.6 D1 = $ 0.70 $ 19 8% %3D PO = nt a. Compute Ki (required rate of return on common equity based on the capital asset pricing model). (Do not round intermediate calculations. Input your answer as a percent rounded to 2 decimal places.) ences Ki b. Compute Ke (required rate of return on common equity based on the dividend valuation model). (Do not round intermediate calculations, Input vour answer as a percent rounded to 2 decimal places.) < Prev 10 of 10 Next Mc Graw Hill 149 MacBook Airarrow_forward1. What is the Stock Price when the Equity Ratio is 75%? a. 107.14 b. 52.08 c. 29.41 d. 75% e. 25% 2. What is the Stock Price when the Equity Ratio is 50%? a. 107.14 b. 52.08 c. 29.41 d. 75% e. 25% 3. What is the Stock Price when the Equity Ratio is 25%? a. 107.14 b. 52.08 c. 29.41 d. 75% e. 25% 4. What is the equity ratio on the optimal capital structure? a. 107.14 b. 52.08 c. 29.41 d. 75% e. 25% 5. What is the debt ratio on the optimal capital structure? a. 107.14 b. 52.08 c. 29.41 d. 75% e. 25% 6. What is the Stock Price on the optimal capital structure? a. 107.14 b. 52.08 c. 29.41 d. 75% e. 25%arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,