Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribedimage text in transcribed

\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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Arab World Facing The Challenge Of The New Millennium

Authors: Henry T. Azzam

1st Edition

1860648169,0857710494

More Books

Students also viewed these Finance questions