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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education