Use the information in the table below to calculate the following ratios for Windswept Woodworks for year 1 and year 2. Windswept Woodworks, Incorporated Input Data (millions of dollars) Accounts payable Accounts receivable Accumulated depreciation Cash & equivalents. Common stock Cost of goods sold Depreciation expense Common stock dividends paid. Interest expense Inventory Addition to retained earnings. Long-term debt. Notes payable Gross plant & equipment Retained earnings. Sales Other current liabilities Tax rate Year 2 interest coverage ratio Year 1 interest coverage ratio Year 2 ACP Year 1 ACP c. Current ratio Year 2 current ratio Year 1 current ratio d. Quick ratio Year 2 622 1,466 6,932 410 Year 2 quick ratio Year 1 quick ratio 1,370 1,590 days days ? ? 230 1,200 602 998 320 10,620 3,248 3,108 Market price per share-year end Number of shares outstanding (For all requirements, round your answers to 2 decimal places.) Required: a. Interest coverage ratio (Assume that year 1 EBIT was 1,307 and year 1 interest expense was 200.) 206 21% $ 27.80 Year 1 554 1,000 6,802 298 500 million 1,290 n.a. n.a. n.a. b. Average collection period (Assume that the accounts receivable balance was 1,040 on December 31 of the previous year and that year 1 sales were 2,808.) (Use 365 days in a year.) n.a. 1,196 n.a. 906 470 10,360 2,646 n.a. 186 n.a. $25.50 500 million
Use the information in the table below to calculate the following ratios for Windswept Woodworks for year 1 and year 2. Windswept Woodworks, Incorporated Input Data (millions of dollars) Accounts payable Accounts receivable Accumulated depreciation Cash & equivalents. Common stock Cost of goods sold Depreciation expense Common stock dividends paid. Interest expense Inventory Addition to retained earnings. Long-term debt. Notes payable Gross plant & equipment Retained earnings. Sales Other current liabilities Tax rate Year 2 interest coverage ratio Year 1 interest coverage ratio Year 2 ACP Year 1 ACP c. Current ratio Year 2 current ratio Year 1 current ratio d. Quick ratio Year 2 622 1,466 6,932 410 Year 2 quick ratio Year 1 quick ratio 1,370 1,590 days days ? ? 230 1,200 602 998 320 10,620 3,248 3,108 Market price per share-year end Number of shares outstanding (For all requirements, round your answers to 2 decimal places.) Required: a. Interest coverage ratio (Assume that year 1 EBIT was 1,307 and year 1 interest expense was 200.) 206 21% $ 27.80 Year 1 554 1,000 6,802 298 500 million 1,290 n.a. n.a. n.a. b. Average collection period (Assume that the accounts receivable balance was 1,040 on December 31 of the previous year and that year 1 sales were 2,808.) (Use 365 days in a year.) n.a. 1,196 n.a. 906 470 10,360 2,646 n.a. 186 n.a. $25.50 500 million
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:Use the information in the table below to calculate the following ratios for Windswept Woodworks for year 1 and year 2.
Windswept Woodworks, Incorporated
Input Data
(millions of dollars)
Accounts payable
Accounts receivable
Accumulated depreciation
Cash & equivalents.
Common stock
Cost of goods sold
Depreciation expense
Common stock dividends paid.
Interest expense
Inventory
Addition to retained earnings.
Long-term debt.
Notes payable
Gross plant & equipment
Retained earnings.
Sales
Other current liabilities
Tax rate
Year 2 interest coverage ratio
Year 1 interest coverage ratio
Year 2 ACP
Year 1 ACP
c. Current ratio
Year 2 current ratio
Year 1 current ratio
d. Quick ratio
Year 2
622
1,466
6,932
410
Year 2 quick ratio
Year 1 quick ratio
1,370
1,590
days
days
?
?
230
1,200
602
998
320
10,620
3,248
3,108
Market price per share-year end
Number of shares outstanding
(For all requirements, round your answers to 2 decimal places.)
Required:
a. Interest coverage ratio (Assume that year 1 EBIT was 1,307 and year 1 interest expense was 200.)
206
21%
$ 27.80
Year 1
554
1,000
6,802
298
500 million
1,290
n.a.
n.a.
n.a.
b. Average collection period (Assume that the accounts receivable balance was 1,040 on December 31 of the previous year and that
year 1 sales were 2,808.) (Use 365 days in a year.)
n.a.
1,196
n.a.
906
470
10,360
2,646
n.a.
186
n.a.
$25.50
500 million
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 5 steps with 17 images
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