Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EARTHWEAR CLOTHIERS Table 5-1 Ratio Analyses SAA December 31, 2019 1/3/2020 December 31 2015 2016 2017 2018 2019 2019 Difference from Expected Industry (Audited) (Audited)

EARTHWEAR CLOTHIERS Table 5-1
Ratio Analyses SAA
December 31, 2019 1/3/2020
December 31
2015 2016 2017 2018 2019 2019

Difference from Expected

Industry
(Audited) (Audited) (Audited) (Audited) Expected* Actual (unaudited) Average Difference (from 2019)
SHORT-TERM LIQUIDITY RATIOS:
Current Ratio 1.64 1.43 1.92 1.80 1.94 2.17 0.23 2.10 0.07
current assets / current liabilities
Quick Ratio 0.39 0.44 0.62 0.53 0.65 0.73 0.08 0.80 -0.07
liquid assets / current liabilities
Operating Cash Flow Ratio 0.69 0.42 0.81 0.34 0.40 0.40 0.00 N/A N/A
cash flow from operations / current liabilities
ACTIVITY RATIOS:
Receivables Turnover 71.18 77.25 74.34 73.82 75.41 118.00 42.60 N/A N/A
net sales / net ending receivables
Days Outstanding in Accounts Receivable 5.13 4.73 4.91 4.94 4.84 3.09 -1.74 14.10 -11.01
365 days / receivables turnover
Inventory Turnover 3.43 4.27 4.48 4.47 4.99 3.87 -1.12 6.20 -2.33
cost of sales / inventory
Days of Inventory on Hand 106.41 85.51 81.40 81.72 69.22 94.99 25.78 58.70 36.29
365 / (cost of sales / inventory)
PROFITABILITY / PERFORMANCE RATIOS:
Gross Profit Percentage 44.95% 44.91% 44.89% 42.51% 42.49% 43.90% 1.41% 38.80% 5.10%
gross profit / net sales
Profit Margin 2.34% 3.61% 3.64% 2.37% 3.02% 4.26% 1.24% 3.30% 0.96%
net income / net sales
Return on Assets 14.80% 6.84% 10.53% 6.83% 4.69% 11.17% 6.48% 7.40% 3.77%
net income / total assets
Return on Equity 26.43% 12.86% 16.22% 11.03% 5.92% 16.70% 10.78% 17.50% -0.80%
net income / total owners' equity
COVERAGE RATIOS:
Debt to Equity 0.79 0.88 0.58 0.61 0.51 0.50 -0.01 0.84 -0.34
total liabilities / shareholders' investment
Times Interest Earned 53.88 26.31 26.41 23.92 10.19 50.57 40.38 N/A N/A
(net income + interest expense) / interest expense

* Expected values are obtained by using the forecast function in Excel (using the row of data from 2015 and 2018 to obtain the expected value for 2019).

Industry Source: Dun & Bradstreet (D&B). The median values of the industry ratios are used for comparison purposes. For ratios not specifically included on D&B, ratios were calculated from average financial statement data provided.

N/A = not available or could not be calculated from financial data.

The McGraw-Hill Companies, Inc., 2019

1. Comments and Summary

Based on your review of work paper 5-1, list one or two ratios in each of the following categories that you believe increase the risk of potential misstatement. Explain why you believe the risk is increased and identify possible causes of a potential misstatement and indicate if you believe the auditor would need to revise his or her typical audit approach to address the risk.

For example, "Days of Inventory on Hand" increased significantly indicating merchandise is held in inventory for a longer period than prior years and it is also held for a longer period than the industry average. This increases the risk of obsolete inventory and/or the market value dropping below recorded cost. The auditor should increase the extent of inventory-valuation testing and/or change the nature of the testing to address the increased risk.

SHORT-TERM LIQUIDITY RATIOS:
Enter your response here (This cell will expand automatically to fit your response - use ALT+ENTER to begin a new line)
ACTIVITY RATIOS:
Enter your response here (This cell will expand automatically to fit your response - use ALT+ENTER to begin a new line)
PROFITABILITY / PERFORMANCE RATIOS:
Enter your response here (This cell will expand automatically to fit your response - use ALT+ENTER to begin a new line)
COVERAGE RATIOS:
Enter your response here (This cell will expand automatically to fit your response - use ALT+ENTER to begin a new line)
2. Assessment of Financial Position

Based on your review of work paper 5-1, assess the client's ability to continue as a going concern (to stay in business) by responding to the following questions.

A. Identify ratios and trends, if any, that cause concern about the client's ability to continue as a going concern
Enter your response here (This cell will expand automatically to fit your response - use ALT+ENTER to begin a new line)

B. Identify ratios and trends, if any, that indicate a high likelihood that the client will continue successfully as a going concern

Enter your response here (This cell will expand automatically to fit your response - use ALT+ENTER to begin a new line)
C. Assess the client's financial condition as one of the following (select one from the drop down list in cell B35)
Click on the yellow cell above and the drop down list button will appear in the far right side of the cell. Your selection will then appear in this box. You can change your selection using the drop down list.
D. Briefly explain the reasoning behind your assessment.
Enter your response here (This cell will expand automatically to fit your response - use ALT+ENTER to begin a new line)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting An Introduction

Authors: Eddie McLaney, Peter Atrill

3rd Edition

ISBN: 0273688227, 978-0273688228

More Books

Students also viewed these Accounting questions