Chapter Problem 5-39 Ratio/Trend Analysis Compared to Industry Arthur, CPA, is auditing The Home Improvement Store as of December 31, 2016. As with all audit engagements, Arthur's initial procedures are to analyze the entity's financial data by reviewing trends in significant ratios and comparing the company's performance with the industry so that he better understands the business and can determine where to concentrate his audit efforts. As part of Arthur's audit of The Home Improvement Store, he performed analytical procedures by calculating the following ratios and obtaining related industry data. The Home Improvement Store Industry 2012 2013 2014 2015 2016 2012 2013 2014 2015 2016 Quick ratio 0.67 0.73 1.38 0.45 0.29 0.79 0.81 0.07 091 1.08 Days of laventory on hand 62.73 75.15 12.40 84.02 80.52 82.26 79.89 86.06 84.13 75.04 Inventory current assets 53.48% 45.51% 48.42% 62.28% 80.91% 58.04% 56.44% 60.19% 60.92% 50.33% Return on assets 16.10% 9.75% 5.70% 2.16% 6.05% 6.98% 8.87% 7.05% 5.06% 11.73% Debt to equity 0.02 0.07 1.47 236 0.72 0.44 0.31 0.56 0.53 0.57 Required: Compare The Home Improvement Store's ratios with those of its industry. You may want to reference the advanced module in this chapter for more information regarding the ratios used in the analytical procedure. For each ratio provided in the table above a. Indicate the potential risks the ratio and/or historical patterns may present.. b. Indicate one or two plausible explanations for why The Home Improvement Store's ratios or historical patterns differ from those of the industry. Page 1
Chapter Problem 5-39 Ratio/Trend Analysis Compared to Industry Arthur, CPA, is auditing The Home Improvement Store as of December 31, 2016. As with all audit engagements, Arthur's initial procedures are to analyze the entity's financial data by reviewing trends in significant ratios and comparing the company's performance with the industry so that he better understands the business and can determine where to concentrate his audit efforts. As part of Arthur's audit of The Home Improvement Store, he performed analytical procedures by calculating the following ratios and obtaining related industry data. The Home Improvement Store Industry 2012 2013 2014 2015 2016 2012 2013 2014 2015 2016 Quick ratio 0.67 0.73 1.38 0.45 0.29 0.79 0.81 0.07 091 1.08 Days of laventory on hand 62.73 75.15 12.40 84.02 80.52 82.26 79.89 86.06 84.13 75.04 Inventory current assets 53.48% 45.51% 48.42% 62.28% 80.91% 58.04% 56.44% 60.19% 60.92% 50.33% Return on assets 16.10% 9.75% 5.70% 2.16% 6.05% 6.98% 8.87% 7.05% 5.06% 11.73% Debt to equity 0.02 0.07 1.47 236 0.72 0.44 0.31 0.56 0.53 0.57 Required: Compare The Home Improvement Store's ratios with those of its industry. You may want to reference the advanced module in this chapter for more information regarding the ratios used in the analytical procedure. For each ratio provided in the table above a. Indicate the potential risks the ratio and/or historical patterns may present.. b. Indicate one or two plausible explanations for why The Home Improvement Store's ratios or historical patterns differ from those of the industry. Page 1
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:Chapter
Problem 5-39 Ratio/Trend Analysis Compared to Industry
Arthur, CPA, is auditing The Home Improvement Store as of December 31, 2016.
As with all audit engagements, Arthur's initial procedures are to analyze the
entity's financial data by reviewing trends in significant ratios and comparing the
company's performance with the industry so that he better understands the
business and can determine where to concentrate his audit efforts. As part of
Arthur's audit of The Home Improvement Store, he performed analytical
procedures by calculating the following ratios and obtaining related industry
data.
The Home Improvement Store
Industry
2012
2013
2014
2015
2016
2012
2013
2014
2015
2016
Quick ratio
0.67
0.73
1.38
0.45
0.29
0.79
0.81
0.07 091
1.08
Days of laventory on hand
62.73
75.15
12.40
84.02
80.52
82.26
79.89
86.06
84.13 75.04
Inventory current assets
53.48%
45.51%
48.42%
62.28%
80.91%
58.04%
56.44%
60.19%
60.92% 50.33%
Return on assets
16.10%
9.75%
5.70% 2.16%
6.05%
6.98%
8.87%
7.05%
5.06% 11.73%
Debt to equity
0.02
0.07
1.47
236
0.72
0.44
0.31
0.56
0.53 0.57
Required:
Compare The Home Improvement Store's ratios with those of its industry. You
may want to reference the advanced module in this chapter for more
information regarding the ratios used in the analytical procedure. For each
ratio provided in the table above
a. Indicate the potential risks the ratio and/or historical patterns may present..
b. Indicate one or two plausible explanations for why The Home Improvement
Store's ratios or historical patterns differ from those of the industry.
Page 1
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education