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...
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...
Use the following information for Questions 23-24: You are the manager of Lobo Corporation and you...
Use the following information for Questions 23-24: You are the manager of Lobo Corporation and you must decide between two mutually exclusive projects.The following information is available for the projects: Project A Project B Annual Revenues          985,000         725,000 Annual Operating Costs          360,000         400,000 Initial Investment       1,800,000         800,000 Salvage Value                  -                    -   Project Life 5 5 NPV ???         497,725 IRR 0.22 0.3 Required: Compute the NPV for Project A.
[The following information applies to the questions displayed below.] Rubio recently invested $20,000 (tax basis) in...
[The following information applies to the questions displayed below.] Rubio recently invested $20,000 (tax basis) in purchasing a limited partnership interest. His at-risk amount is $15,000. In addition, Rubio’s share of the limited partnership loss for the year is $22,000, his share of income from a different limited partnership is $5,000, and he has $40,000 in wage income and $10,000 in long-term capital gains. a. How much of Rubio’s $22,000 loss is allowed considering only the tax-basis loss limitations? b....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT