Class Collaborate-AC-163-44 P x CengageNOWv2| Online teachin X + 2.cengagenow.com/ilmn/takeAssignment/takeAssignmentMain.do?invoker-assignments&takeAssignments... A Determine the following measures for 2018. Round ratio values to one decimal place and dollar amounts to the nearest cent. For number of days' sales in receivables and number of days' sales in inventory, round intermediate calculations to the nearest whole dollar and final amounts to one decimal place. Assume there are 365 days in the year. 1. Working capital Г 2,790,000 2. Current ratio 4.1 3. Quick ratio 2.5 4. Accounts receivable turnover 16 5. Days' sales in receivables 22.8 days 6. Inventory turnover 7. Days sales in inventory 8. Debt ratio days % 9. Ratio of liabilities to stockholders' equity 10. Ratio of fixed assets to long-term liabilities 11. Times interest earned times times 12. Times preferred dividends earned Check My Work 8 144 0 P Previous Email Instructor Save and Exr Submit Assignment for Grading pri se delete horole backspace 3:56 PM 4/10/2024 44

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...
icon
Related questions
Question
Class Collaborate-AC-163-44 P x
CengageNOWv2| Online teachin X
+
2.cengagenow.com/ilmn/takeAssignment/takeAssignmentMain.do?invoker-assignments&takeAssignments... A
Determine the following measures for 2018.
Round ratio values to one decimal place and dollar amounts to the nearest cent. For number of days' sales in receivables and number of
days' sales in inventory, round intermediate calculations to the nearest whole dollar and final amounts to one decimal place. Assume
there are 365 days in the year.
1. Working capital
Г
2,790,000
2.
Current ratio
4.1
3. Quick ratio
2.5
4.
Accounts receivable turnover
16
5. Days' sales in receivables
22.8
days
6.
Inventory turnover
7. Days sales in inventory
8. Debt ratio
days
%
9. Ratio of liabilities to stockholders' equity
10.
Ratio of fixed assets to long-term liabilities
11. Times interest earned
times
times
12.
Times preferred dividends earned
Check My Work
8
144
0
P
Previous
Email Instructor
Save and Exr
Submit Assignment for Grading
pri se
delete
horole
backspace
3:56 PM
4/10/2024
44
Transcribed Image Text:Class Collaborate-AC-163-44 P x CengageNOWv2| Online teachin X + 2.cengagenow.com/ilmn/takeAssignment/takeAssignmentMain.do?invoker-assignments&takeAssignments... A Determine the following measures for 2018. Round ratio values to one decimal place and dollar amounts to the nearest cent. For number of days' sales in receivables and number of days' sales in inventory, round intermediate calculations to the nearest whole dollar and final amounts to one decimal place. Assume there are 365 days in the year. 1. Working capital Г 2,790,000 2. Current ratio 4.1 3. Quick ratio 2.5 4. Accounts receivable turnover 16 5. Days' sales in receivables 22.8 days 6. Inventory turnover 7. Days sales in inventory 8. Debt ratio days % 9. Ratio of liabilities to stockholders' equity 10. Ratio of fixed assets to long-term liabilities 11. Times interest earned times times 12. Times preferred dividends earned Check My Work 8 144 0 P Previous Email Instructor Save and Exr Submit Assignment for Grading pri se delete horole backspace 3:56 PM 4/10/2024 44
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage