Finc 440 and Finc 351 Week One

Sheet: ratios

McCormick & Co., Inc. (NYS: MKC)

Note: This worksheet is programmed to

calculate the performance and insert

the comments

Most Recent Year

Oldest Year

Performance From First to Recent Year;

Profitability Ratios

11/30/2011

11/30/2010

11/30/2009

11/30/2008

11/30/2007

Shows Percentage Change in Ratios

ROA % (Net)

9.97

Performance Improved

0.16065192083818403

Notice how conditional statements

ROE % (Net)

Performance Improved

0.07412280701754376

were programmed to determine if

ROI % (Operating)

Performance Deteriorated

-0.0023946360153257046

ratios improved or deteriorated, and

EBITDA Margin %

17.33

Performance Improved

0.16778975741239882

calculate the percentage change in

Calculated Tax Rate %

Performance Improved

-0.048212528697933715

the ratos.

Revenue per Employee

410,844

444,907

425,613

422,389

388,827

Performance Improved

0.05662415418682345

Liquidity Ratios

11/30/2011

11/30/2010

11/30/2009

11/30/2008

11/30/2007

Quick Ratio

0.57

Performance Deteriorated

-0.15789473684210523

Current Ratio

1.14

Performance Improved

0.07894736842105271

Net Current Assets % TA

(2.04)

4.37

Performance Improved

0.2860411899313501

Debt Management

11/30/2011

11/30/2010

11/30/2009

11/30/2008

11/30/2007

LT Debt to Equity

Performance Deteriorated

0.2075471698113207

Total Debt to Equity

Performance Deteriorated

0.16417910447761191

Interest Coverage

Performance Improved

0.8065068493150687

Asset Management

11/30/2011

11/30/2010

11/30/2009

11/30/2008

11/30/2007

0.037066166023949666

Total Asset Turnover

1.09

Performance Deteriorated

-0.09174311926605512

Receivables Turnover

9.09

8.87

Performance Improved

0.3022922636103151

Inventory Turnover

4.35

4.13

Performance Deteriorated

-0.033898305084745686

Accounts Payable Turnover

Performance Improved

-0.11387329591018443

Accrued Expenses Turnover

Performance Improved

0.43203883495145634

Property Plant & Equip Turnover

Performance Improved

0.20032840722495893

Cash & Equivalents Turnover

70.63

73.9

81.43

Performance Improved

0.14920273348519353

Per Share

11/30/2011

11/30/2010

11/30/2009

11/30/2008

11/30/2007

Cash Flow per Share

2.43

1.74

Performance Improved

0.471264367816092

Book Value per Share

10.13

Performance Improved

0.41931684334511193

Source of Data: Mergent Online Database.

Retrieved October 19, 2012