Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can anybody help me find the paths to these answers? Some WSO trading comps analysis excel practice. begin{tabular}{|l|l|l|l|} hline Comparable Company Analysis & &
Can anybody help me find the paths to these answers? Some WSO trading comps analysis excel practice.
\begin{tabular}{|l|l|l|l|} \hline Comparable Company Analysis & & \\ \hline Sin millions & & & \\ \hline Colgate & & & \\ \hline Share price & $30/ share & & \\ \hline Shares out. & 30 million & & \\ \hline Revenue & $1,000 & & \\ \hline EBITDA & $200 & & \\ \hline Net income & $75 & & \\ \hline Net debt & $200 & & \\ & & & \\ \hline Peer group mean & EV/Sales & EV/EBITDA & P/E \\ \hline & 1.4x & 6.6x & 16.4x \\ \hline Implied Colgate enterprise value & $1,400 & $1,320 & N/A \\ \hline Less: Colgate net debt & $200 & $200 & N/A \\ \hline Equals: Colgate implied equity value & $1,200 & $1,120 & $1,230 \\ \hline Colgate shares outstanding & 30mm & 30mm & 30mm \\ \hline Implied Colgate share price & & & \\ \hline Is Colgate overvalued based on comps? & No & No & No \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started