Question

ULUNUH Business Course Preparing The Cash Return to course Question 10 Not yet answered Marked out of 5.00 P Flag question Co
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1) Accounts Receivable turnover = Sales

---------------

Average accounts Receivable

= $ 20967

--------------

( $ 2718+$ 2313)/2

= $ 20967

--------------- = 8.34

$ 2515.50

2) Average days to collect Receivables = Days in Period * Average accounts Receivables

-----------------------------------------------------------------

Net Sales

= 365*2515.50 918157.50

-------------------- = -------------- = 43.79 days

20967 20967

3) Inventory Turnover Ratio = Sales / Average Inventory

= 20967 20967

---------- = ----------- = 6.45

( 3375+3126 )/2 3250.50

4) Average days in Inventory = (Cost of Average Inventory/ Cost of Good Sold )*365

=( 3250.50/9654)*365 = 122.90 days

5) Accounts Payable Turnover Ration = Total Purchases / Average Accounts Payable

= 9903/(468+630) =9903/1098 = 9

Purchase = Cost of goods sold + Ending inventory - Starting Inventory

= 9654+3375-3126

= 9903

========

6) Average days payable outstanding = ( Days in Period * Average accounts Payable)/ Cost of Goods Sold

= (365*1098)/9654 = 41.51 days

7) Cash Conversion Cycle = Days of Inventory Outstanding+ Days of sales outstanding+Days of Payable Outstanding

= ( Inventory / Cost of Good Sold ) *365+( Accounts Receivable /Sales)*365+ (Accounts Payable / Cost of Goods Sold)*365

=(3375/9654)*365+(2313/20967)*365+(468/9654)*365

=127.60+40.26+17.69 = 185.55

Add a comment
Know the answer?
Add Answer to:
ULUNUH Business Course Preparing The Cash Return to course Question 10 Not yet answered Marked out...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Business Course Return to course # My Subscriptions eBook Question 3 Not complete Marked out of...

    Business Course Return to course # My Subscriptions eBook Question 3 Not complete Marked out of 2200 P Flag question Recording Goodwill upon Acquisition On January 1, 2020, the balance sheet of Napervile Company (a sole proprietorship) was as follows. Assets Liabilities Accounts receivable inet of allowance) $120.000 Current $76,000 Inventory 180,000 Noncurrent 160,000 $236.000 Plant and equipment niet of depreciation 400,000 Equity Land 60,000 Owners' equity 524,000 Total 5760,000 Total liabilities and owners' equity 5760,000 On January 1, 2020,...

  • please show work * Return to course ÈBusiness Course Question 7 Not yet answered Marked out...

    please show work * Return to course ÈBusiness Course Question 7 Not yet answered Marked out of 5.00 P Flag question 2020 Performing a Vertical and Horizontal Analysis Complete a vertical analysis of the following income statement from Gomez Corporation . Do not use a negative sign in your answers. • Round to the nearest whole percentage point (for example, enter 60 for 60.4% or 61 for 60.5%). Vertical Analysis 2020 2019 Income Statement 2019 % of Sales % of...

  • Question 26 Not yet answered Marked out of 1.00 P Flag question Richards Corporation had the...

    Question 26 Not yet answered Marked out of 1.00 P Flag question Richards Corporation had the following balances at December 31, 2020: $212,000 $1,255,000 Goodwill 6,000 Common stock 5,000 120,000 Prepaid Insurance 35,000 Accounts payable 24,000 50,000 Property, plant, and equipment Interest payable Line of credit, due on demand Customer list Additional paid-in capital Salaries payable Cash and cash equivalents Pension liability Inventory Land held for future expansion 545,000 Retained earnings December 31, 2019 12,000 Accumulated depreciation 410,000 145,000 85,000...

  • C m ybusinesscourse.com/platform/mod/quiz/attempt.php?attempt3239627&cmid=20414184 Business Course *Return to course Question 6 Not complete Marked out of 3.00...

    C m ybusinesscourse.com/platform/mod/quiz/attempt.php?attempt3239627&cmid=20414184 Business Course *Return to course Question 6 Not complete Marked out of 3.00 P Flag question Balance Sheet The following balance sheet data are for Normandy Catering Service, a corporation at May 31, 2016: Accounts Receivable $18,200 Accounts payable $5,500 Notes Payable 20,000 Cash 12,200 Equipment, net 55,000 Common Stock 43,000 Supplies 16,400 Retained Earnings ? Required Prepare a balance sheet for Normandy as of May 31, 2016. NORMANDY CATERING SERVICE Balance Sheet May 31, 2016 ASSETS...

  • Topic: Compute and interpret turnover ratios for two years LO: 3 8. Selected recent balance sheet...

    Topic: Compute and interpret turnover ratios for two years LO: 3 8. Selected recent balance sheet and income statement information for Holiday Corporation follows: (in millions) Average inventory Average accounts receivable Average accounts payable Sales Cost of goods sold 2016 $ 13,808 34,642 28.100 300,893 230,170 2015 $ 13,958 36,706 29.116 318,113 242,780 A Calculate accounts receivable turnover (ART) for 2016 and 2015. Has ART improved during the year or worsened? B. Calculate inventory turnover (INVT) for 2016 and 2015....

  • Business Retum to course Question 4 Not complete Marked out of 4.00 P Flex gestion Inventory...

    Business Retum to course Question 4 Not complete Marked out of 4.00 P Flex gestion Inventory Turnover and Days' Sales in Inventory W. Glass & Company reported the following information in its recent annual report: 2015 2016 Cost of goods sold $4,500,000 55.100.000 Beginning inventory 900.000 860,000 Ending inventory 360,000 640,000 Calculate the company's inventory turnover and days' sales in inventory for both years. Round answers to two decimal places. Use rounded answers for subsequent calculations. 2015 Inventory turnover Days'...

  • QUESTION 28 Not yet answered Marked out of 1.00 The following information is for SQU Company:...

    QUESTION 28 Not yet answered Marked out of 1.00 The following information is for SQU Company: Trademark 70,000, Share Capital 120,000, Land 90,000; Retained Earnings 250,000, Building 100,000, Accumulated Depreciation 20,000; Land held for investment 75,000; Accounts Payable 60,000; Prepaid Insurance 30,000; Loan Payable 10,000; Inventory 70.000; Mortgage Payable 90,000; Accounts Receivable 50,000; Cash 65,000 The total dollar amount of liabilities to be classified as non-current liabilities is P Flag question Select one: O a R0.60,000 b.R.O.100,000 o c.R.0.70,000 d....

  • Lendell Company has these comparative balance sheet data: Lendell Company Balance Sheets December 31 2020 2019...

    Lendell Company has these comparative balance sheet data: Lendell Company Balance Sheets December 31 2020 2019 Cash $ 15,000 $ 30,000 Accounts receivable (net) 71,000 60,000 Inventory 61,000 50,000 Plant assets (net) 197,000 175,000 View Policies $344,000 Accounts payable $50,000 $59,200 Mortgage payable (15%) 108,000 108,000 Common stock, $10 par 138,500 124,500 Retained earnings 47,500 23,300 $344,000 $315,000 Additional information for 2020: 1. Net income was $25,700. 2. Sales on account were $412,500. Sales returns and allowances amounted to $19,500....

  • E Business Course Return to course Question 3 Not complete Marked out of 12.00 P Flag...

    E Business Course Return to course Question 3 Not complete Marked out of 12.00 P Flag question Inventory Management Metrics Large retailers like Costco and Target typically use gross margin ratio (gross margin + sales), invento on investment (GMROI) to evaluate how well inventory has been managed. The goal is to maximize scenarios, a base scenario (A) followed by three modifications (B, C, and D) to the base scenario. Scenario A Scenario B Scenario C Scenario D Sales $50,000 $...

  • View Policies Current Attempt in Progress Lendell Company has these comparative balance sheet data: Lendell Company...

    View Policies Current Attempt in Progress Lendell Company has these comparative balance sheet data: Lendell Company Balance Sheets December 31 2020 Cash $15.000 Accounts receivable (net) 70,000 Inventory 61,000 Plant assets (net) 195,000 $341,000 Accounts payable $50,000 Mortgage payable (15%) 101,500 Common stock, $10 par 144,000 Retained earnings 45.500 5341,000 2019 $ 30,000 59.000 49.000 179.000 $317.000 $60.900 101.500 118.500 36.100 $317.000 Additional information for 2020: 1 2 3. - 5. Net income was $25.800. Sales on account were $407,700....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT