fill out the missing sections to conduct a peer multiples valuation.

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.

Don't use plagiarized sources. Get Your Custom Assignment on
fill out the missing sections to conduct a peer multiples valuation.
From as Little as $13/Page

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