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
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
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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 | |||||
1,340 | 880 | ||||||
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 |
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.
Year 1 current Ratio
Year 2 Current Ratio
d. Quick ratio
Year 1 Quick Ratio
Year 2 Quick Ratio
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 4 steps
Knowledge Booster
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.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