Create a new worksheet in your file labeled ‘Ratios’ in excel
The company is columbia sportswear, and it could be found in yahoo finance.
KEEP IN MIND:
SALES = REVENUE
CREDIT SALES = REVENUE
ACCOUNTS RECEIVABLE = TOTAL RECEIVABLES
NET FIXED ASSETS = TOTAL ASSETS – TOTAL CURRENT ASSETS
LONG TERM DEBT = ADD UP ALL NON-CURRENT LIABILITIES
(OR TAKE TOTAL LIABILITIES – TOTAL CURRENT LIABILITIES)
Calculate the following ratios using only the data for the most recent 2 years:
Liquidity:
-Current
-Quick
Efficiency:
-Inventory Turnover
-Accounts Receivable Turnover
-Average Collection Period
-Fixed Asset Turnover
-Total Asset Turnover
Leverage Ratios
-Total Debt Ratio
-Long-Term Debt Ratio
-Long-Term-Debt to Total Capitalization
-Debt to Equity
-Long-Term-Debt to Equity
Coverage Ratios
-Times Interest Earned (make the interest expense positive, so that your result is positive)
-Cash Coverage Ratio (use ‘Depreciation/Amortization’ for non-cash expenses and make the interest expense positive)
Profitability Ratios
-Gross Profit Margin
-Operating Profit Margin
-Net Profit Margin
-Return on Total Assets
-Return on Equity
-Return on Common Equity
-Du Pont Analysis of ROE
-Altman Z Score (for the recent year only). Is there an immediate risk of bankruptcy or financial distress? To figure out the market value of the Equity, you must find the current stock price and multiply it by the total number of shares outstanding.