Calculating the CCC from the Financial Statement he following data are taken from the financial statement: Annual Sales (on Credit) 1,216,666 Cost of Goods Sold 1,013,889 Average Inventory Average Accounts Receivable 250,000 300,000 Average Accounts Payable 150,000 COMPUTE FOR THE FOLLOWING and interpret your answer: . DIO stands for Days Inventory Outstanding 89.99999014 D10 (Ave. Inventory/Cost of Goods Sold)*365 =(250,000/1,013,889)*365 =89.99 or 90 days takes the company approximately 90 days to turn inventory into sales 2. DSO stands for Days Sales Outstanding 90.00004932 OSO=(Ave. Accts. Receivables/Total Credit Sales)*365 =(300,000/1,216,666)*365 =90 days #NAME? 3. DPO stands for Days Payable Outstanding 53.99999408 OPO3(Ave. Accts. Payables/Cost of Goods Sold)*365 =(150,000/1,013,889)*365 =53.99 or 54 days t takes the company approximately 54 days to pay its invoices .CASH CONVERSION CYCLE 126.0000454 CCC= DIO + DSO - DPO = 90+90-54 = 126 takes the company approximately 126 days to turn its initial cash investment in inventory back into cash

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)
22nd Edition
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:James A. Heintz, Robert W. Parry
Chapter15: Financial Statements And Year-end Accounting For A Merchandising Business
Section: Chapter Questions
Problem 9SPA: FINANCIAL RATIOS Use the work sheet and financial statements prepared in Problem 15-8A. All sales...
icon
Related questions
icon
Concept explainers
Question
Calculating the CCC from the Financial Statement
The following data are taken from the financial statement:
Annual Sales ( on Credit )
1,216,666
Cost of Goods Sold
1,013,889
Average Inventory
250,000
Average Accounts Receivable
300,000
Average Accounts Payable
150,000
COMPUTE FOR THE FOLLOWING and interpret your answer:
1. DIO stands for Days Inventory Outstanding
89.99999014
DIO= (Ave. Inventory/Cost of Goods Sold)*365
=(250,000/1,013,889)*365
=89.99 or 90 days
It takes the company approximately 90 days to turn inventory into sales
2. DSO stands for Days Sales Outstanding
90.00004932
DSO=(Ave. Accts. Receivables/Total Credit Sales)*365
=(300,000/1,216,666)*365
=90 days
#NAME?
3. DPO stands for Days Payable Outstanding
53.99999408
DPO=(Ave. Accts. Payables/Cost of Goods Sold)*365
=(150,000/1,013,889)*365
=53.99 or 54 days
It takes the company approximately 54 days to pay its invoices
4.CASH CONVERSION CYCLE
126.0000454
CCC= DIO + DSO - DPO
= 90+90-54
= 126
It takes the company approximately 126 days to turn its initial cash investment in inventory back into cash
Transcribed Image Text:Calculating the CCC from the Financial Statement The following data are taken from the financial statement: Annual Sales ( on Credit ) 1,216,666 Cost of Goods Sold 1,013,889 Average Inventory 250,000 Average Accounts Receivable 300,000 Average Accounts Payable 150,000 COMPUTE FOR THE FOLLOWING and interpret your answer: 1. DIO stands for Days Inventory Outstanding 89.99999014 DIO= (Ave. Inventory/Cost of Goods Sold)*365 =(250,000/1,013,889)*365 =89.99 or 90 days It takes the company approximately 90 days to turn inventory into sales 2. DSO stands for Days Sales Outstanding 90.00004932 DSO=(Ave. Accts. Receivables/Total Credit Sales)*365 =(300,000/1,216,666)*365 =90 days #NAME? 3. DPO stands for Days Payable Outstanding 53.99999408 DPO=(Ave. Accts. Payables/Cost of Goods Sold)*365 =(150,000/1,013,889)*365 =53.99 or 54 days It takes the company approximately 54 days to pay its invoices 4.CASH CONVERSION CYCLE 126.0000454 CCC= DIO + DSO - DPO = 90+90-54 = 126 It takes the company approximately 126 days to turn its initial cash investment in inventory back into cash
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
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
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
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
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning