company

Company: LEGGETT & PLATT INC

Required: Excel Spreadsheet (2 Worksheet: Ratios & Stock Price Graph) [Excel Spreadsheet is attached attached}

1. Worksheet 1: Ratios

All calculations need to be in a formula form using cell references only. [in Excel worksheet]

Calculate the following ratios from the firm’s financial statements for the past 3 years.

§ Liquidity Ratios : Current Ratio, Quick Ratio, and Cash Ratio.

§ Debt Management Ratios : Debt/Equity Ratio, Total Debt ratio, Equity multiplier, and Time Interest Earned Ratio.

§ Asset Management Ratios : Total Asset Turnover, Inventory Turnover, and Days’ Sales in Account Receivables.

§ Profitability Ratios : Profit margin, Return on assets (ROA), Return on equity (ROE), and Basic Earning Power (BEP).

§ Market Value Ratios : Price-earnings ratio, Book Value per share, and Market-to-book ratio.

2. Worksheet 2: Stock Price Graph

Graph the company’s 5-year stock prices

3. Datas: Screenshot Only

§ (3 Printouts) The last 5-year financial statements of the firm (Capital IQ/Market Intelligence)

· Balance sheet

· Income statement

· Cash Flow Statement

§ (5 Printouts) Fiscal year-end stock prices for the past 5 years (Yahoo Finance - - Must be 5 Screenshots).

§ (1 Printout) Key Stat (Yahoo Finance - - Must be 1 Screenshot)

**[COMBINE ALL DATA AND GRAPH INTO 1 PDF FILE]**