Question

28. Complete the following table for Lubbock Lock Companys most recent fiscal Year 12 times Inventory turnover Receivables t

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans :

(1) Days sales outstanding = Number of days in a year / Receivable turnover ratio

60.833 = 365 days / Receivable turnover ratio

Receivable turnover ratio = 365 / 60.833

Receivable turnover ratio = 6.

(2) Days Sales in inventory = Number of days in a year / Inventory turnover ratio

= 365 days / 12

Days Sales in inventory = 30.4167 days

(3) Operating cycle = Inventory period + Account receivable period

= Days Sales in inventory + Days sales outstanding

= 30.5167 days + 60.833 days

Operating cycle = 91.2497 days

(4) Net operating cycle = Days Sales in inventory + Days sales outstanding - Days purchase outstanding

= 30.5167 days + 60.833 days - 45 days

Net operating cycle = 46.2497 days.

Add a comment
Know the answer?
Add Answer to:
28. Complete the following table for Lubbock Lock Company's most recent fiscal Year 12 times Inventory...
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
  • Ivanhoe Automotive's balance sheet at the end of its most recent fiscal year shows the following...

    Ivanhoe Automotive's balance sheet at the end of its most recent fiscal year shows the following information: Ivanhoe Automotive Balance Sheet as of March 31, 2017 Assets Cash and marketable sec. Accounts receivable Liabilities and Equity: Accounts payable and sculs Notes payable $168,000 27,000 $40,000 158,000 232.000 $430,000 Inventory Total current assets Total current liabilities Long-term debt Total liabilities Common stock Retained earnings Total liabilities and equity $195,000 172,000 3367.000 317,000 613,000 $1,302,000 Net plant and equipment Goodwill and other...

  • Exercise 6-12 The following information is available for Cullumber Company for three recent fiscal years. Inventory...

    Exercise 6-12 The following information is available for Cullumber Company for three recent fiscal years. Inventory Net sales Cost of goods sold 2017 $562,811 1,978,222 1,560,073 2016 $569,532 1,746,610 1,309,350 2015 $325,890 1,300,667 940,444 Calculate the inventory turnover, days in inventory, and gross profit rate for 2017 and 2016. (Round inventory turnovel decimal places, e.g. 125 and gross profit rate to I decimal place, e.g. 5.296.) 2017 2016 Inventory Turnover times times Days in Inventory days days Gross Profit Rate...

  • Accounts Receivable and Inventory Analyses for Kellogg's and General Mills The following information was obtained from...

    Accounts Receivable and Inventory Analyses for Kellogg's and General Mills The following information was obtained from the fiscal year 2015 and 2014 financial statements included in Form 10-K of Kellogg Company and Subsidiaries and General Mills, Inc. and Subsidiaries (Year-ends for Kellogg's are January 2, 2016, and January 3, 2015, and for General Mills are May 31, 2015, and May 25, 2014.) Assume all sales are on credit for both companies (in millions) Kellogg's General Mills Accounts receivable, net End...

  • 11. Tamagachi, Inc. uses the FIFO inventory method. The following financial ratios are available for fiscal...

    11. Tamagachi, Inc. uses the FIFO inventory method. The following financial ratios are available for fiscal year 2017 for Tamagachi, Inc.: Days inventory outstanding 28 Days sales outstanding 42 Return on assets 0.07 Return on equity 0.13 Net profit margin 0.05 Days payables outstanding 39 Which of the following statements is true? a. Tamagachi’s cash conversion cycle is 31 days. b. Tamagachi’s cash conversion cyle is 53 days. c. Tamagachi’s leverage is 6 percent. d. Tamagachi’s leverage is 15 percent....

  • Compute the firms return on assets for the most recent fiscal year Peer Group Average Ratios...

    Compute the firms return on assets for the most recent fiscal year Peer Group Average Ratios Liquidity Current Quick Cash Ratio 1/31/2019 1/31/2018 6,5036 ,423 4.292 4,200 2,223 1,718 1.718 226 234 268 271 2.503 1.619 1238 Dillard's, Inc. Income Statement Sales Cost Of Goods Gross Profit Selling & Admin Expenses Depreciation Earnings Before Interest & Taxes Non-Operating Income Interest Expense Pretax income Income Taxes Investment Gains/Losses Net Income 2.212 53 208 213 Leverage Total Debt LTD Ratio Debt-Equity Equity...

  • A recent annual report for NPS contained the following data: (dollars in thousands) Current Year Previous...

    A recent annual report for NPS contained the following data: (dollars in thousands) Current Year Previous Year Accounts receivable $ 3,727,000 $ 4,527,000 Less: Allowance for doubtful accounts 185,000 148,000 Net accounts receivable $ 3,542,000 $ 4,379,000 Net sales (assume all on credit) $ 35,397,000 Required: 1. Determine the receivables turnover ratio and average days sales in receivables for the current year. (Use 365 days a year. Do not round intermediate calculations. Enter your answers in thousands not in dollars.)...

  • Obtain a copy of the annual report of Avon Products, Inc. for the most recent year....

    Obtain a copy of the annual report of Avon Products, Inc. for the most recent year. You can find the annual report at the company's website (www.avon.com (Links to an external site.)) in the investor information section or at the Securities and Exchange Commission's website (www.sec.gov (Links to an external site.)). using EDGAR (Electronic Data Gathering Analysis and Retrieval). Form 10-K, which includes the annual report is required to be filed on EDGAR. Search or scroll within the annual report...

  • The following information is available for Gildan Activewear Inc., headquartered in Montreal, for three recent fiscal...

    The following information is available for Gildan Activewear Inc., headquartered in Montreal, for three recent fiscal years (in US. $ thousands) 2016 2014 2015 Inventory 851,033 $779,407 $595.794 Net sales 2,959,238 2,359,994 2.284,303 Cost of goods sold 2,229,130 1701,311 1,550,266 Part 1 Calculate the inventory turnover, days in inventory.and gross profit margin for 2016 and 2015, (Round inventory turnover and current ratio to 1 decimal place, eg. 15.2. Round days in inventory to nearest day. Use 365 days for calculation.)...

  • Compute the firms Total Asset Turnover for the most recent fiscal year. Peer Group Average Ratios...

    Compute the firms Total Asset Turnover for the most recent fiscal year. Peer Group Average Ratios Liquidity Current Quick Cash Ratio 1/31/2019 1/31/2018 6,5036 ,423 4.292 4,200 2,223 1,718 1.718 226 234 268 271 2.503 1.619 1238 Dillard's, Inc. Income Statement Sales Cost Of Goods Gross Profit Selling & Admin Expenses Depreciation Earnings Before Interest & Taxes Non-Operating Income Interest Expense Pretax income Income Taxes Investment Gains/Losses Net Income 2.212 53 208 213 Leverage Total Debt LTD Ratio Debt-Equity Equity...

  • 1.GPR, Inc., has an inventory turnover of 22.74 times, a payables turnover of 13.01 times, and...

    1.GPR, Inc., has an inventory turnover of 22.74 times, a payables turnover of 13.01 times, and a receivables turnover of 8.40 times. What is the length of the company's cash cycle? Assume 365 days per year. 55.46 days 87.56 days 31.45 days 43.45 days 18.13 days 2.Cosplay Unlimited sells 820 outfits per year at an average price of $159. The terms of the sale are 1/10, net 30. The discount is taken by 71 percent of customers. What is the...

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