Use the information in the table below to calculate the following ratios for Windswept Woodworks for year 1 and year 2. (Round your answers to 2 decimal places.)   Windswept Woodworks, Inc. Input Data (millions of dollars)     Year 2     Year 1   Accounts payable   496     434   Accounts receivable   1,340     880   Accumulated depreciation   6,806     6,682   Cash & equivalents   284     178   Common stock   1,244     1,170   Cost of goods sold   1,500     n.a.   Depreciation expense   ?     n.a.   Common stock dividends paid   ?     n.a.   Interest expense   140     n.a.   Inventory   1,074     1,076   Addition to retained earnings   602     n.a.   Long-term debt   872     786   Notes payable   230     380     Gross plant & equipment   10,260     10,000   Retained earnings   3,122     2,526   Sales   3,018     n.a.   Other current liabilities   116     96   Tax rate   34 %   n.a.   Market price per share – year end $ 19.80   $ 17.50   Number of shares outstanding   500  million   500  million     a. Interest coverage ratio (Assume that year 1 EBIT was $1,297 and year 1 interest expense was $120.) Year 1 interest coverage ratio Year 2 interest coverage ratio   b. Average collection period (Assume that the accounts receivable balance was $950 on December 31 of the previous year and that year 1 sales were 2,700.) Year 1 ACP Year 2 ACP   c. Current ratio Year 1 current Ratio Year 2 Current Ratio   d. Quick ratio Year 1 Quick Ratio Year 2 Quick Ratio

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 56P: The following selected information is taken from the financial statements of Arnn Company for its...
icon
Related questions
Question

Use the information in the table below to calculate the following ratios for Windswept Woodworks for year 1 and year 2. (Round your answers to 2 decimal places.)

 

Windswept Woodworks, Inc.
Input Data
(millions of dollars)
    Year 2     Year 1  
Accounts payable   496     434  
Accounts receivable   1,340     880  
Accumulated depreciation   6,806     6,682  
Cash & equivalents   284     178  
Common stock   1,244     1,170  
Cost of goods sold   1,500     n.a.  
Depreciation expense   ?     n.a.  
Common stock dividends paid   ?     n.a.  
Interest expense   140     n.a.  
Inventory   1,074     1,076  
Addition to retained earnings   602     n.a.  
Long-term debt   872     786  
Notes payable   230     380    
Gross plant & equipment   10,260     10,000  
Retained earnings   3,122     2,526  
Sales   3,018     n.a.  
Other current liabilities   116     96  
Tax rate   34 %   n.a.  
Market price per share – year end $ 19.80   $ 17.50  
Number of shares outstanding   500  million   500  million
 

 

a. Interest coverage ratio (Assume that year 1 EBIT was $1,297 and year 1 interest expense was $120.)

Year 1 interest coverage ratio

Year 2 interest coverage ratio

 

b. Average collection period (Assume that the accounts receivable balance was $950 on December 31 of the previous year and that year 1 sales were 2,700.)

Year 1 ACP

Year 2 ACP

 

c. Current ratio

Year 1 current Ratio

Year 2 Current Ratio

 

d. Quick ratio

Year 1 Quick Ratio

Year 2 Quick Ratio
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning