Description
Using the data provided in the Table below, fill out the missing sections to conduct a peer multiples valuation.complete the assignment in the attached excel. all questions and directions are on the excel.
Unformatted Attachment Preview
FIN561 Week 3 Homework (50 points)
Peer Multiples Valuation:
1 (25 pts) Using the data provided in the Table below, fill out the missing sections to conduct a peer multiples valua
Company Name
A
B
C
D
E
Market Data
Price
Shares (M) Market Cap Net Debt EV ($M)
($/share)
($M)
($M)
$9.45
100
125
$5.68
1,250
200
$18.11
50
25
$12.27
630
350
$9.03
1,500
0
Financial Data
Sales
($M)
268
4,136
443
1,949
6,622
Average:
Median:
2 (10 pts) If Company A is your acquisition target, at what share price range would you expect to start your negotia
What if Company D was your acquisition target?
3 (10 pts) What factors could make your peer multiples unreliable? Name and describe at least four.
4 (5 pts) Proper grammar, full sentences, correct spelling and punctuation, and a neat and professional format with
s to conduct a peer multiples valuation.
Financial Data
EBITDA Earnings EV/Sales
($M)
($M)
76
47
778
412
96
56
528
294
795
423
?
?
Valuation
EV/EBITDA
?
?
P/E
?
?
ld you expect to start your negotiations based upon its P/E multiple?
escribe at least four.
a neat and professional format with clearly labeled answers are required.
Purchase answer to see full
attachment