Finance Engineering homework in excel (Company: Columbia Sportwear)

profileGgnggnit

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
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      finance.xlsx