Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DCF and Market Multiples a. Compare the calculated values (DCF & Market multiples) below to the current market value of the subject company below: 276.17B

DCF and Market Multiples a. Compare the calculated values (DCF & Market multiples) below to the current market value of the subject company below:

276.17B

. b. Explain why this projection is accurate.

Recommendation a. Make a recommendation as to Buy, Sell, or Hold the security. b. Justify your recommendation with support and reason, citing course materials or additional research, as appropriate.

Considerations a. Consider your valuation and identify three inherent risks of the valuation process. b. Describe each risk. c. Explain how each risk impacts valuing the company.

Calculated DCF:

image text in transcribed

Market Multiples:

image text in transcribed

Market Value:

image text in transcribed

\begin{tabular}{|l|r|r|r|r|} \hline & PepsiCo & Starbucks & \multicolumn{1}{l|}{ Nestle } & \multicolumn{1}{l|}{ Average } \\ \hline PE Ratio (Current) & 40.90 & 34.81 & 36.81 & 37.50 \\ \hline PB Ratio (Current) & 15.60 & -14.46 & 7.80 & 2.98 \\ \hline Company EPS (Current) & & & & \\ \hline Average PE ratio & $4.75 & $3.08 & $3.55 & 3.79 \\ \hline Company equity value & 178.50 & 37.50 & 37.50 & 37.50 \\ & & 115.51 & 133.18 & 142.28 \\ \hline Company BVPS (FY '22) & 12.45 & & & \\ \hline Average PB ratio & 2.98 & 2.98 & 16.76 & 7.27 \\ \hline Company equity value & 37.11 & (22.10) & 49.96 & 2.98 \\ \hline \end{tabular} Market Summary > Coca-Cola Co 63.62 uso +0.12(0.18%)+ today May 11, 2:13 PM EDT - Disel aimer 10 50 1M 6M YTD \begin{tabular}{l|l} 1Y & 5Y \end{tabular} Max 63.8 \begin{tabular}{|l|r|r|r|r|} \hline & PepsiCo & Starbucks & \multicolumn{1}{l|}{ Nestle } & \multicolumn{1}{l|}{ Average } \\ \hline PE Ratio (Current) & 40.90 & 34.81 & 36.81 & 37.50 \\ \hline PB Ratio (Current) & 15.60 & -14.46 & 7.80 & 2.98 \\ \hline Company EPS (Current) & & & & \\ \hline Average PE ratio & $4.75 & $3.08 & $3.55 & 3.79 \\ \hline Company equity value & 178.50 & 37.50 & 37.50 & 37.50 \\ & & 115.51 & 133.18 & 142.28 \\ \hline Company BVPS (FY '22) & 12.45 & & & \\ \hline Average PB ratio & 2.98 & 2.98 & 16.76 & 7.27 \\ \hline Company equity value & 37.11 & (22.10) & 49.96 & 2.98 \\ \hline \end{tabular} Market Summary > Coca-Cola Co 63.62 uso +0.12(0.18%)+ today May 11, 2:13 PM EDT - Disel aimer 10 50 1M 6M YTD \begin{tabular}{l|l} 1Y & 5Y \end{tabular} Max 63.8

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

An Anatomy Of The Financial Crisis

Authors: Nashwa Saleh

1st Edition

0857289616,0857286684

More Books

Students also viewed these Finance questions