Question

In: Accounting

The following information is to be used for answering questions 24 to 30 inclusive Cash 20,000...

The following information is to be used for answering questions 24 to 30 inclusive

Cash 20,000

Accounts Receivable 40,000

Inventories 40,000

Current Assets 100,000

Accounts Payable 30,000

Accruals 10,000

Notes Payable 40,000

Current Liabilities 80,000

Sales 250,000

Cost of Goods Sold 170,000

The current ratio is 1.25

DSO is 58.4 days

DIH is 85.9 days

OC is 144.4 days

4. The company's days payable outstanding (DPO) is__?

6. The company's cash conversion cycle (CCCC) is__?

7. The company's working capital requirement is__?

Solutions

Expert Solution

Days Payable Outstanding =

Ending Accounts Payable/(Cost of sales/Number of days)

Ending Accounts Payable

$    30,000.00

Cost of sales

$ 170,000.00

($ 30000/($ 170000/365))

DPO=

64.41

Days

64 days (Approx)

Cash Conversion Cycle =

DIO+DSO-DPO

DIO

85.88 Days

DSO

58.4 Days

DPO

64.41 Days

Calculation of DIO

(Inventory/(Cost of sales/365))

(40000/(170000/365))

85.88

Calculation of CCC =

DIO+DSO-DPO

(85.88+58.4-64.41)

79.87

Days

Working Capital requirement =

Current Assets-Current Liabilities

($ 100000-$ 80000)

$    20,000.00

Answers

4. The company's days payable outstanding (DPO) is 64 Days.

6. The company's cash conversion cycle (CCCC) is 79.87 Days

7. The company's working capital requirement is $ 20000.


Related Solutions

Use the information here for answering questions 1 to 2 on this page. On 30 September...
Use the information here for answering questions 1 to 2 on this page. On 30 September 2019, Lilah Ltd provided a personal coaching service package to Customer Z, consisting of an initial in-person consultation and follow up telephone support (up to 6 hours per month) for a two-year period. Customer Z paid $2,000 upfront for this package on 30 Sept 19 when they had their initial consultation. Lilah Ltd charges $600 for an initial in-person consultation and $100 per month...
Use the following information for the next four questions: 2017 2018 Beginning Cash Balance 20,000 50,000...
Use the following information for the next four questions: 2017 2018 Beginning Cash Balance 20,000 50,000 Net Income                 65,000.00                 75,000.00 Accounts Receivable                 10,000.00                    6,000.00 Prepaid Insurance                    5,000.00                    3,500.00 Inventory                 20,000.00                 24,000.00 Accounts Payable                    3,000.00                    2,000.00 Unearned Revenue                    5,000.00                    7,000.00 Depreciation Expense                 25,000.00                 20,000.00 Cash Paid for Dividends                 25,000.00                    5,000.00 Cash Payment to Repay Note Payable                               -                    10,000.00 Cash Payment to Purchase Land...
Discuss the different estimating techniques that are used for construction projects by answering the following questions...
Discuss the different estimating techniques that are used for construction projects by answering the following questions in your post: What are the three most common types of estimating techniques, and in what situation is it most appropriate to use each one? What else is important to consider when deciding which technique to use?
Consider the following information when answering the question below. Fixed expenses $20,000 Variable cost per unit...
Consider the following information when answering the question below. Fixed expenses $20,000 Variable cost per unit $25 Selling price per unit $30 The break even point in units is: Select one: a. 20,000 units b. 800 units c. 667 units d. 4,000 units e. 2,500 units
Use the following information as the basis for answering all questions: A diploid eukaryotic organism has...
Use the following information as the basis for answering all questions: A diploid eukaryotic organism has 3 unique chromosomes. Chromosome I is a metacentric chromosome, chromosome II is a telocentric chromosome, and Chromosome III is a submetacentric chromosome. 1.)How many total chromosomes do the somatic cells of this organism have in G2 of cell cycle? 2.) How many total chromatids do the somatic cells of this organism have in G2 of cell cycle? 3.) How many total chromosomes are in...
Write 3 pages answering the following questions. Carrier Discovery - Information Technology specialization management information system...
Write 3 pages answering the following questions. Carrier Discovery - Information Technology specialization management information system Purpose For this assignment, you will be conducting field research by conducting an informational interview with someone from your network to gather more career information. This information will support you as you continue to explore options in the labor market. Explanation of tasks Share your knowledge from your informational interview of someone in the field by submitting the result. You may use the form...
Use the following information for the next three questions: You have $20,000 available to invest in...
Use the following information for the next three questions: You have $20,000 available to invest in the market portfolio, which has an expected return of 9% and the risk-free asset, which returns 3%: 18. How would you use your available funds to invest in the market portfolio and the risk-free asset to achieve a beta of 0.9? How much money would you invest in the market? A) $18,000 B) $2,000 C) $4,300 D) $2,180 19. What is the expected return...
Read case and get all the information before answering these questions. Please answer these questions specifically...
Read case and get all the information before answering these questions. Please answer these questions specifically what they are asking for with details 1. What specific type of wholesaler is Joe? 2. Evaluate Joe's marketing strategy for his current lumber business. Be and be sure to mention the specific components. 3. Contrast the components of the marketing strategy for the Arbor Products with Joe's current Hanratty lumber business. 4. What should Joe do now? Which option should he take? Be...
THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 1 – 6. Quiz Company reported the following information...
THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 1 – 6. Quiz Company reported the following information for the month of July. Sales $550,000 Materials purchases 64,000 Direct labor 43,500 Overhead 108,750 Selling costs 94,000 Administrative costs 183,500 Raw materials inventory, July 1 40,000 Work-in-process inventory, July 1 21,000 Finished goods inventory, July 1 23,200 Raw materials inventory, July 31 19,800 Work-in-process inventory, July 31 32,500 Finished goods inventory, July 31 22,100 Determine the cost of direct materials used for the...
THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 8 – 10. Quiz Company provided the following information...
THE FOLLOWING INFORMATION IS USED FOR QUESTIONS 8 – 10. Quiz Company provided the following information for the preparation of the cash budget for June. The cash balance of June 1 is expected to be $3,763. Projected sales are as follows.                 April       May       June Cash sales           $10,000                 $18,000                 $18,600 Credit sales         28,900   35,000   54,000 Credit sales are collected over a three-month period: 40% in the month of sale, 30% in the first month after the sale, 20% in the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT