Companies to use: Wayfair Inc as Primary, Target & Walmart as secondary for comparisons

The 11^th tab in your Financial Statement Analysis Template must be labeled Historical and Competitor Ratios. The list of ratios to be included are as follows. They should be grouped under the headings, as shown:Liquidity Ratios

Current Ratio

Quick Ratio

Leverage Ratios

Debt to Total Assets Ratio

Debt Equity Ratio

Long-Term Debt to Equity

Times Interest Earned Ratio

Activity Ratios

Inventory Turnover

Fixed Assets Turnover

Total Assets Turnover

Accounts Receivable Turnover

Average Collection Period

Profitability Ratios

Gross Profit Margin

Operating Profit Margin

Net Profit Margin

Return on Total Assets (ROA)

Return on Stockholders Equity (ROE)

Earnings Per Share (EPS)

Price Earnings Ratio

Calculate the ratios for your chosen company for the last three years, linking the ratio calculations back to the historical financial statement using formulas.

Calculate the ratios for each of your companys competitors (most recent year only), linking the ratio calculations to the competitor financial statements using formulas.

Using the internet, locate the industry averages for the ratios listed above, and include them in the final column of the ratio tab. Include a footnote on the tab to identify the source of the industry averages.

Other instructions:

The Excel workbook should be professionally formatted. Professional formatting includes:

All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent.

Dollar signs are included in the first and last numbers of each column.

Subtotals and totals are preceded by a single underline. Totals are followed by a double underline.

Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read.

All totals and subtotals in the competitor financial statements as well as the ratio calculations should be calculated using formulas.