Assignment 3
garinh
ComparisonWithIndustryPeers.xlsCover
| Company |
| Student Name |
| ID Number |
FR & COMPARISONS
| Financial Ratios - Trends and Comparisons with Industry | ||||||||
| Company Name: | ||||||||
| Amounts In: | Comparison | Ratio | ||||||
| Period: | of Company | Ranking | ||||||
| Statement Type: | FYE | FYE | FYE | FYE | RMA | Ratios to the | within the | |
| Date: | 2/1/14 | 1/31/15 | 1/30/16 | 1/28/17 | Trend | Norm | RMA Norms | Group |
| Financial Summary | ||||||||
| Current Assets | ||||||||
| Current Liabilities | ||||||||
| Total Assets | ||||||||
| Total Liabilities | ||||||||
| Total Net Worth | ||||||||
| Working Capital | ||||||||
| Cash | ||||||||
| Marketable Securities | ||||||||
| Accounts receivable, net | ||||||||
| Inventories | ||||||||
| Net Fixed Assets | ||||||||
| Intangibles | ||||||||
| Accounts payable | ||||||||
| Accrued expenses | ||||||||
| Working Assets | ||||||||
| Working Liabilities | ||||||||
| Working Investment | ||||||||
| Long Term Debt | ||||||||
| Tangible Net Worth | ||||||||
| Average Annual Long-term Debt Maturities ** | ||||||||
| Operating Cash Flow *** | ||||||||
| Net Sales | ||||||||
| Cost of Goods Sold | ||||||||
| Lease Payments | ||||||||
| Gross Profit | ||||||||
| Operating Profit | ||||||||
| Interest Expense | ||||||||
| Net Income | ||||||||
| Liquidity/Activity Ratios | ||||||||
| Current Ratio (x) | ||||||||
| Quick Ratio (x) | ||||||||
| Cash Flow Liquidity Ratio (x) | ||||||||
| Accounts Receivable (x) | ||||||||
| Accounts Receivable (Days) | ||||||||
| Inventory Turnover vs COGS (x) | ||||||||
| Inventory Turnover vs Aver Sales (Days) | ||||||||
| Accounts Payable vs COGS (Days) | ||||||||
| Accounts Payable vs Aver Sales (Days) | ||||||||
| Cash Conversion Cycle (Days) | ||||||||
| Leverage Ratios | ||||||||
| Debt Ratio (%) | ||||||||
| Long-term Debt to Total Capitalization (%) | ||||||||
| Debt to Worth (x) | ||||||||
| Debt to Tangible Net Worth (x) | ||||||||
| Times Interest Earned (x) | ||||||||
| Fixed Charge Coverage (x) | ||||||||
| Cash Flow Adequacy (x) | ||||||||
| Performance Ratios | ||||||||
| Fixed Asset Turnover (x) | ||||||||
| Total Asset Turnover (x) | ||||||||
| Gross Profit Margin (%) | ||||||||
| Operating Profit Margin (%) | ||||||||
| Net Profit Margin (%) | ||||||||
| Cash Flow Margin (%) | ||||||||
| Return on Assets (%) | ||||||||
| Return on Equity (%) | ||||||||
| Cash Return on Assets (%) | ||||||||
| Officers' Compensation/Sales (%) | ||||||||
| Sales/Working Capital (x) | ||||||||
| Sales Growth (%) | ||||||||
| Earnings Growth (%) | ||||||||
| Total Asset Growth (%) | ||||||||
| ** See AALTDM Tab for an explanation. | ||||||||
| *** From Cash Flow Statement. |
Working Investment
Debt
AALTDM
| Average Annual LTD Maturities (AALTDM) | ||||
| Fiscal Year | FY 2015 | FY 2014 | FY 2013 | FY 2012 |
| 2013 | 2012 report FYE 12 balance sheet | |||
| 2014 | 2013 report debt footnote | 2013 report debt footnote | ||
| 2015 | 2014 report debt footnote | 2013 report debt footnote | 2013 report debt footnote | |
| 2016 | Latest report debt footnote | 2014 report debt footnote | 2013 report debt footnote | 2013 report debt footnote |
| 2017 | Latest report debt footnote | 2014 report debt footnote | 2013 report debt footnote | 2013 report debt footnote |
| 2018 | Latest report debt footnote | 2014 report debt footnote | 2013 report debt footnote | |
| 2019 | Latest report debt footnote | 2014 report debt footnote | ||
| 2020 | Latest report debt footnote | |||
| Total Amount | Sum of 5 yrs above | Sum of 5 yrs above | Sum of 5 yrs above | Sum of 5 yrs above |
| Divide by | 5 | 5 | 5 | 5 |
