Week 6 Finc 351 and 440
barkersbaseball
homework_9.22.14_valuation_by_comparables.xlsComparables
| Valuation By Comparables Model | ||||||
| Your Company | Competitor | Competitor | Competitor | Competitor | ||
| INPUTS | McCormick (MKC) | Campbell Soup (CPB) | General Mills (GIS) | Pepsico (PEP) | Heinz (HNZ) | Average |
| Number of Shares Outstanding | 132.30 | 358.00 | 343.50 | 1,602.00 | 318.06 | 550.77 |
| Current Share Price ($) | $36.05 | $33.11 | $69.59 | $60.56 | $43.94 | $48.65 |
| Total Sales or Revenues | $3,192.10 | $7,586.00 | $14,691.30 | $43,251.00 | $10,148.08 | $15,773.70 |
| Price/Earnings Ratio | 15.87 | 14.96 | 14.34 | 16.39 | 15.92 | 15.50 |
| Book Value/Share ($) | $10.13 | $2.78 | $18.48 | $9.87 | $6.11 | $9.47 |
| Earnings/Share ($) (TTM) | $2.27 | $2.20 | $4.83 | $3.34 | $2.70 | $3.07 |
| Cash Flow / Share ($) | $2.99 | $3.03 | $6.35 | $4.37 | $3.65 | $4.08 |
| Outputs | McCormick (MKC) | Campbell Soup (CPB) | General Mills (GIS) | Pepsico (PEP) | Heinz (HNZ) | Average |
| Revenue/Share ($) | $24.13 | $21.19 | $42.77 | $27.00 | $31.91 | $29.40 |
| Price/Book | 3.56 | 11.91 | 3.77 | 6.14 | 7.19 | 6.51 |
| Price/Sales | 1.49 | 1.56 | 1.63 | 2.24 | 1.38 | 1.66 |
| Price/Cash Flow | 12.06 | 10.93 | 10.96 | 13.86 | 12.04 | 11.97 |
| Value of Your Company | P/E | Price/Book | Price/Sales | Price/Cash Flow | Average | |
| $35.18 | $65.97 | $40.07 | $35.78 | $47.07 | ||
| Note: Data from http://www.marketwatch.com | Note: Based on the data | |||||
| Updated February 16, 2010 | included in the analysis, this | |||||
| "Average" is the estimate of | ||||||
| Use diluted number of shares. | the value of your company's | |||||
| Use TTM EPS. | stock. |
Sheet2
&A
Page &P
Sheet3
&A
Page &P
Sheet4
&A
Page &P
Sheet5
&A
Page &P
Sheet6
&A
Page &P
Sheet7
&A
Page &P
Sheet8
&A
Page &P
Sheet9
&A
Page &P
Sheet10
&A
Page &P
Sheet11
&A
Page &P
Sheet12
&A
Page &P
Sheet13
&A
Page &P
Sheet14
&A
Page &P
Sheet15
&A
Page &P
Sheet16
&A
Page &P
