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]**
—-
LEGGETT & PLATT INC is a company based in Los Angeles, California.
Excel Spreadsheet (2 Worksheet: Ratios & Stock Price Graph) is required [Excel Spreadsheet is included].
1. Ratios Worksheet 1
All computations must be done in the form of a formula with only cell references. [in an Excel spreadsheet]
Calculate the following ratios using the company’s financial statements from the last three years.
Current, Quick, and Cash Ratios are all examples of liquidity ratios.
Debt/Equity Ratio, Total Debt Ratio, Equity Multiplier, and Time Interest Earned Ratio are all debt management ratios.
Total Asset Turnover, Inventory Turnover, and Days’ Sales in Account Receivables are three asset management ratios.
Profitability is an important factor. Profit margin, Return on Assets (ROA), Return on Equity (ROE), and Basic Earning Power (BEP) are examples of ratios (BEP).
Price-earnings ratio, Book Value per Share, and Market-to-Book ratio are all examples of market value ratios.
2. Stock Price Graph Worksheet 2
