80.2K

Verified Solution

Link Copied!

Perform the following Ratios for the company from 20X2 to 20X6 (See Appendix 2, Table 3). Input your formulas in Table 3 shown below in Excel Spreadsheet or showing formulas. Comment on your findings particularly with respect to any anomalies:

A. Gross Margin

B. Net Profit Margin

C. Asset Turnover

D. Accounts Receivable Turnover

E. Working capital

F. Current Ratio

G. Quick Ratio

H. Debt Ratio (Debt to Asset)

Appendix 2 Template Table 3: Ratios 2082 2083 2084 2085 2086 A. Gross Margin B. Net Profit Margin C. Asset Turnover D. Accounts Receivable Turnover E. Working capital F. Current Ratio G. Quick Ratio H. Debt Ratio (Debt to Assets) Formula Gross profit/Sales Net income/Sales Sales/Total Assets (Using Ending Total Assets) Sales/Accounts Receivables (Using Ending A/R) Current assets - Current liabilities Current assets/Current liabilities Cash & Cash Equivalents + ST Investments + A/R/Current Liab. Total Liabilities/Total Assets Note: ST = Short-Term Appendix 2 Template Table 3: Ratios 2082 2083 2084 2085 2086 A. Gross Margin B. Net Profit Margin C. Asset Turnover D. Accounts Receivable Turnover E. Working capital F. Current Ratio G. Quick Ratio H. Debt Ratio (Debt to Assets) Formula Gross profit/Sales Net income/Sales Sales/Total Assets (Using Ending Total Assets) Sales/Accounts Receivables (Using Ending A/R) Current assets - Current liabilities Current assets/Current liabilities Cash & Cash Equivalents + ST Investments + A/R/Current Liab. Total Liabilities/Total Assets Note: ST = Short-Term

Answer & Explanation Solved by verified expert

See Answer