Using an Excel spreadsheet$*$ and your company's financial statements, compute the following for the most recent two years : Current ratio Leverage & Liquidity

Debt to EBITDA

Efficiency

Dividend Payout

$160\mathrm{.}04\%,99\mathrm{.}00\%$

$41\mathrm{.}99\%$

Compare

TGT

AMZN

Spec Retailer

BBY

Return on Assets

Working capital $($not really a ratio$)$

Inventory turnover ratio

Accounts Receivable turnover ratio

Debt to total assets ratio

Return on assets

Asset turnover ratio

Return on equity

Gross profit ratio

Profit margin ratio

Also using the spreadsheet, prepare the following for the most recent two years:

Comparative Income Statement $-$ Vertical Analysis

Comparative Balance Sheet $-$ Horizontal Analysis