PUNY Business Finances Several Brands Stock Price & Stock Valuation Exercise I need excel answers to these 7 problems. I will eventually do another version

PUNY Business Finances Several Brands Stock Price & Stock Valuation Exercise I need excel answers to these 7 problems. I will eventually do another version of these quetiosn with different values so if you can build the excel file so I can easily substitute the given numbers that would be great. Thanks. ?
Do Homework – Amith Chandrashaker
mathxl.com/Student/PlayerHomework.aspx?homeworkld=566048631&questionld=1&flushed=true&cld=6020873¢erwin=yes
ices
Managerial Finance Summer 1 2020
Amith Chandrashaker : L 06/25/20 5:02 PM
Homework: Chapter 9 Homework
Save
Score: 0 of 1 pt
7 of 7 (6 complete)
HW Score: 57.14%, 4 of 7 pts
P9-27 (similar to)
Question Help
In addition to footwear, Kenneth Cole Productions designs and sources handbags, apparel, and other accessories. You decide, therefore, to consider comparables for
KCP outside the footwear industry. You also know the following about KCP: it has sales of $518 million, EBITDA of $55.6 million, excess cash of $100 million, $3 million
of debt, EPS of $1.65, book value of equity of $12.05 per share, and 21 million shares outstanding.
a. Suppose that Fossil, Inc., has an enterprise value to EBITDA multiple of 11.34 and a P/E multiple of 15.72. What share price would you estimate for KCP using each
of these multiples, based on the data for KCP?
b. Suppose that Tommy Hilfiger Corporation has an enterprise value to EBITDA multiple of 8.95 and a P/E multiple of 17.72. What share price would you estimate for
KCP using each of these multiples based on the data for KCP?
Ind
a. Suppose that Fossil, Inc., has an enterprise value to EBITDA multiple of 11.34 and a P/E multiple of 15.72. What share price would you estimate for KCP using each
of these multiples, based on the data for KCP?
Using the Enterprise value/EBITDA ratio for Fossil the price is $
(Round to the nearest cent.)
Enter your answer in the answer box and then click Check Answer.
?
3 parts
Clear All
Check Answer
remaining
A
Chrome
File
Edit
View
History
Bookmarks People Tab
Window
Help
35°
C Mumbai: 2:32 AM
D
E
100% C2
Thu 5:02 PM Amith Chandrashaker Q
lil
Course Home
?
+
+ ? C
openvellum.ecoll
?.
Do Homework – Amith Chandrashaker
mathxl.com/Student/Player Homework.aspx?homeworkld=566048631&questionld=1&flushed=true&cld=6020873¢erwin=yes
Google Maps
ices…
>>
Other Bookmarks
My Gmail
f Facebook
??????
1
ILIUTI
Managerial Finance Summer 1 2020
Amith Chandrashaker 8 | 06/25/20 5:02 PM
My Courses
Course Home
Homework: Chapter 9 Homework
Save
Purchase Options
Score: 1 of 1 pt
6 of 7 (6 complete)
HW Score: 57.14%, 4 of 7 pts
Pearson e Text
P9-24 (similar to)
Question Help
Assignments
>
Results
You notice that PepsiCo (PEP) has a stock price of $111.44 and EPS of $6.39. Its competitor, the Coca-Cola Company (KO), has EPS of $2.31. Estimate the value of a
share of Coca-Cola stock using only this data.
Dynamic Study Modules
The value of a share of Coca-Cola stock is $ 40.29. (Round to the nearest cent.)
News
Financial Calculator
Incorrect: 2
Study Plan
Multimedia Library
Chapter Resources
>
Communication Tools
>
Accessible Resources
Question is complete.
?
Homework: Chapter 9 Homework
All parts showing
Similar Question
Copyright © 2020 Pearson Education Inc. All rights reserved. | Terms of Use | Privacy Policy. | Permissions | Contact Us
Umer and Vishal
10 CHECK MYS
Sara Jean lose…
Nathan, Ev ana…
x
Chat (130)
— –? — ??? ?????
TUU70
Chrome
File
Edit
View
History
Bookmarks People
Tab
Window
Help
35°
C Mumbai: 2:32 AM
D
E
100% C2
Thu 5:02 PM Amith Chandrashaker Q
lil
Course Home
?
+
+ ? C
openvellum.ecoll
?.
Do Homework – Amith Chandrashaker
mathxl.com/Student/Player Homework.aspx?homeworkld=566048631&questionld=1&flushed=true&cld=6020873¢erwin=yes
Google Maps
ices…
>>
Other Bookmarks
My Gmail
f Facebook
??????
1
ILIUTI
Managerial Finance Summer 1 2020
Amith Chandrashaker 8 | 06/25/20 5:02 PM
My Courses
Course Home
Homework: Chapter 9 Homework
Save
Purchase Options
Score: 0 of 1 pt
5 of 7 (6 complete)
HW Score: 57.14%, 4 of 7 pts
Pearson e Text
X P9-15 (similar to)
Question Help
Assignments
>
Results
Dynamic Study Modules
Halliford Corporation expects to have earnings this coming year of $3.23 per share. Halliford plans to retain all of its earnings for the next two years. For the
subsequent two years, the firm will retain 48% of its earnings. It will then retain 22% of its earnings from that point onward. Each year, retained earnings will be invested
in new projects with an expected return of 27.79% per year. Any earnings that are not retained will be paid out as dividends. Assume Halliford’s share count remains
constant and all earnings growth comes from the investment of retained earnings. If Halliford’s equity cos capital is 8.6%, what price would you estin for Halliford
stock?
Note: Remenber that growth rate is computed as: retention rate x rate of return.
News
Financial Calculator
Incorrect: 2.
The price per share is $ 157.03. (Round to the nearest cent.)
Study Plan
Multimedia Library
Chapter Resources
>
Communication Tools
>
Accessible Resources
Question is complete. Tap on the red indicators to see incorrect answers.
?
All parts showing
Similar Question
Copyright © 2020 Pearson Education Inc. All rights reserved. | Terms of Use | Privacy Policy. | Permissions | Contact Us
10 CHECK MYS
Umer and Vishal
Sara Jean lose…
Nathan, Ev ana…
x
Chat (130)
+
100%
Chrome
File
Edit
View
History
Bookmarks People Tab
Window
Help
35°
C Mumbai: 2:32 AM
D
E
100% C2
Thu 5:02 PM Amith Chandrashaker Q
lil
Course Home
?
+
+ ? C
openvellum.ecoll
?.
Do Homework – Amith Chandrashaker
mathxl.com/Student/Player Homework.aspx?homeworkld=566048631&questionld=1&flushed=true&cld=6020873¢erwin=yes
Google Maps
ices…
>>
Other Bookmarks
My Gmail
f Facebook
??????
1
ILIUTI
Managerial Finance Summer 1 2020
Amith Chandrashaker 8 | 06/25/20 5:02 PM
My Courses
Course Home
Homework: Chapter 9 Homework
Save
Purchase Options
Score: 1 of 1 pt
3 of 7 (6 complete)
HW Score: 57.14%, 4 of 7 pts
Pearson e Text
P9-4 (similar to)
Question Help
Assignments
>
Results
Krell Industries has a share price of $21.57 today. If Krell is expected to pay a dividend of $0.91 this year, and its stock price is expected to grow to $23.68 at the end of
the year, what is Krell’s dividend yield and equity cost of capital?
Dynamic Study Modules
What is Krell’s dividend yield?
News
Krell’s dividend yield is 4.2 %. (Round to one decimal place.)
Financial Calculator
Incorrect: 2
What is Krell’s capital gain rate?
Study Plan
Krell’s capital gain rate is 9.8 %. (Round to one decimal place.)
Multimedia Library
What is Krell’s equity cost of capital?
Chapter Resources
>
Krell’s equity cost of capital, or expected total return is 14.0 %. (Round to one decimal place.)
Communication Tools
>
Accessible Resources
Question is complete.
?
All parts showing
Similar Question
Copyright © 2020 Pearson Education Inc. All rights reserved. | Terms of Use | Privacy Policy. | Permissions | Contact Us
10 CHECK MYS
Umer and Vishal
Sara Jean lose…
Nathan, Ev ana…
x
Chat (130)
+
100%
Chrome
File
Edit
View
History
Bookmarks People Tab
Window
Help
35°
C Mumbai: 2:32 AM
D
E
100% C2
Thu 5:02 PM Amith Chandrashaker Q
lil
Course Home
?
+
+ ? C
openvellum.ecoll
?.
Do Homework – Amith Chandrashaker
mathxl.com/Student/Player Homework.aspx?homeworkld=566048631&questionld=1&flushed=true&cld=6020873¢erwin=yes
Google Maps
ices…
>>
Other Bookmarks
My Gmail
f Facebook
??????
1
ILIUTI
Managerial Finance Summer 1 2020
Amith Chandrashaker 8 | 06/25/20 5:02 PM
My Courses
Course Home
Homework: Chapter 9 Homework
Save
Purchase Options
Score: 0 of 1 pt
4 of 7 (6 complete)
HW Score: 57.14%, 4 of 7 pts
Pearson e Text
X P9-12 (similar to)
Question Help
Assignments
>
Results
Procter and Gamble (PG) paid an annual dividend of $2.91 in 2018. You expect PG to increase its dividends by 7.5% per year for the next five years (through 2023),
and thereafter by 3.4% per year. If the appropriate equity cost of capital for Procter and Gamble is 8.4% per year, use the dividend-discount model to estimate its value
per share at the end of 2018.
Dynamic Study Modules
News
The price per share is $ 71.93′. (Round to the nearest cent.)
Financial Calculator
Incorrect: 2
Study Plan
Multimedia Library
Chapter Resources
>
Communication Tools
>
Accessible Resources
Question is complete. Tap on the red indicators to see incorrect answers.
?
Homework: Chapter 9 Homework
All parts showing
Similar Question
Copyright © 2020 Pearson Education Inc. All rights reserved. | Terms of Use | Privacy Policy. | Permissions | Contact Us
Umer and Vishal
10 CHECK MYS
Sara Jean lose…
Nathan, Ev ana…
x
Chat (130)
WWW
TUU70

Purchase answer to see full
attachment