FIN 534 WEEK 2 DISCUSSION DECEMBER 2014 - NEW
frogod
financial_ratio_analysis_model_123014.xlsSheet: ratios
McCormick & Co., Inc. (NYS: MKC)
Note: This worksheet is programmed to
ENTER DATA IN THE YELLOW-CODED CELLS ONLY
calculate the performance and insert
the comments
Most Recent Year
Oldest Year
Performance From First to Recent Year;
Profitability Ratios
Shows Percentage Change in Ratios
ROA % (Net)
9.03
9.86
9.97
Performance Deteriorated
-0.0044101433296583155
Notice how conditional statements
ROE % (Net)
Performance Deteriorated
-0.1422877640494221
were programmed to determine if
ROI % (Operating)
Performance Deteriorated
-0.06976744186046512
ratios improved or deteriorated, and
EBITDA Margin %
17.33
Performance Deteriorated
-0.07312826465467206
to calculate the percentage change in
Calculated Tax Rate %
Performance Improved
-0.16222987785781395
the ratios.
Revenue per Employee
Performance Deteriorated
-0.03118560758247516
Liquidity Ratios
41608.0
41243.0
40877.0
40512.0
40147.0
Quick Ratio
Performance Improved
0.06122448979591842
Current Ratio
Performance Improved
0.08403361344537823
Net Current Assets % TA
Performance Improved
0.5333333333333334
Debt Management
41608.0
41243.0
40877.0
40512.0
40147.0
LT Debt to Equity
Performance Improved
-0.19696969696969696
Total Debt to Equity
Performance Improved
-0.13513513513513511
Interest Coverage
Performance Improved
0.20135746606334834
Asset Management
41608.0
41243.0
40877.0
40512.0
40147.0
Total Asset Turnover
Performance Deteriorated
-0.010309278350515474
Receivables Turnover
8.58
8.97
9.09
8.87
8.18
Performance Improved
0.04889975550122254
Inventory Turnover
Performance Deteriorated
-0.09738717339667462
Accounts Payable Turnover
Performance Improved
-0.06890611541774323
Accrued Expenses Turnover
9.36
9.72
Performance Improved
0.2203389830508474
Property Plant & Equip Turnover
Performance Improved
0.0938897168405365
Cash & Equivalents Turnover
73.9
81.43
Performance Deteriorated
-0.28674935527446893
Per Share
41608.0
41243.0
40877.0
40512.0
40147.0
Cash Flow per Share
Performance Improved
0.10691823899371064
Book Value per Share
10.13
Performance Improved
0.45508390918065145
Source of Data: Mergent Online Database, Strayer University Resource Center
Retrieved December 30, 2014
