Macy's Inc. use : SEC's EDGAR to get the 10-K financial data for the company. Key Business Ratios database. Mergent Online.sic 5311

Sec 1 - Company Profile and Analyses of the Industry - Description of the company, Brief company history, Description of the industry competitors, industry outlook, etc., Business segment information of 10-k.

Sec 2 - Analysis of Historical Financial Data

Perform time-series and cross-sectional analyses of your firm for each of the measures listed below. Time-series analysis compares the same measure for the same company or industry over a period of time (4 years minimum) Cross-sectional analysis refers to a comparison of a company with the industry using the same measure.

The 'current ratio' from this report is shown below. Use the 'median' ratio.

Industry Quartiles . Solvency Current Ratio

2014 Upper|Median|Lower 2.5

2015 Upper|Median|Lower . 2.1

2016 Upper|Median|Lower . 2.4

2017 Upper|Median|Lower . 2.2

Calculate the ratios. These calculations, used by D&B Key Business Ratios. Normally you would use average inventory, accounts receivable etc., but that would not be consistent with the industry ratios you are comparing the company with check key business ratio.

Present the ratios like:

Ratio current ratio . Company name Industry

2014 Edger financials Key busiess ratio

2015

2016

2017

If you use the % sign is the title of the ratio like the example below, then express 98% as 98 in the table. This is the way the ratios are in the Key Business Ratios database.

Total networth %

Company

Industry . 98.00 . 109.50 . 110.10

If you do not use the percent sign in the table, then express the percentages as .98 or 98%. Be sure to change the industry key business ratios to match.

Total networth %

Company

Industry . 98.00% . 109.50% . 110.10%

Include ratios in your analysis:

1)Solvency Ratios (2) Curent ratio (total curent assets / total curent liabilities) (3) Total Liabilities/Net Worth % (total liabilities / total equity) (4) Efficiency Ratios (5)Assets / Sales % (6)Days in Inventory 365/(Sales/inventory) (7)Profitability Ratios (8)Return on Assets % (net profit for year / sales) (9)Return on Net Worth % (net profit for year / equity)

Explain:

1) what the ratio measures,

2) how the measure has changed over time for the same firm,

3) how the firm's measure compares with the industry and

4) what these results indicate about the company.