# Finance Engineering homework in excel (Company: Columbia Sportwear)

Ggnggnit

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.

• 9 years ago
• 10

Purchase the answer to view it

• finance.xlsx