Question

In: Accounting

Calculate the receivables and inventory turnover ratios for the year.

Universal Calendar Company began the year with accounts receivable and inventory balances of $100,000 and $80,000, respectively. Year-end balances for these accounts were $120,000 and $60,000, respectively. Sales for the year of $600,000 generated a gross profit of $200,000. Calculate the receivables and inventory turnover ratios for the year.

Solutions

Expert Solution

Step 1.

Receivables turnover ratio =                  Net sales

                                               Average accounts receivable (net)

Receivables turnover ratio =                  $600,000

                                                   [$100,000 + 120,000] / 2

 

Receivables turnover ratio = 5.45 times

 

 

Step 2.

Inventory turnover ratio =               Cost of goods sold

                                                         Average inventory

Inventory turnover ratio =                      $400,000*

                                                      [$80,000 + 60,000] / 2

 

Inventory turnover ratio = 5.71 times

 

 

*$600,000 - 200,000


Receivables turnover ratio = 5.45 times

Inventory turnover ratio = 5.71 times

 

Related Solutions

What do the turnover ratios and cash cycle indicate about this company? Company Industry Receivables Turnover...
What do the turnover ratios and cash cycle indicate about this company? Company Industry Receivables Turnover (Days) 15 13 Inventory Turnover (Days) 18 21 Cost of Goods Sold (COGS) or Cost of Revenue in $ 51445 46488 Accounts Payable (AP) in $ 1281 2402 Payables Turnover  (Pay TO)                  = COGS / AP 40.16 19.35 Days Payables (DP)  = 365 / Pay TO 9.08 18.86 Cash Cycle = 1 + 2 - 6 23.91 15.14
COMPUTE AND ANALYZE THE LIQUIDITY RATIOS: CURRENT RATIO, ACCOUNTS RECEIVABLE TURNOVER, INVENTORY TURNOVER. EXPLAIN HOW THEY...
COMPUTE AND ANALYZE THE LIQUIDITY RATIOS: CURRENT RATIO, ACCOUNTS RECEIVABLE TURNOVER, INVENTORY TURNOVER. EXPLAIN HOW THEY AFFECT INVERSTORS' OR CREDITORS' DECISIONS REGARDING THE COMPANY.
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return...
Compute Financial ratios Current Ratio, Quick Ratio, Reeivables turnover, Inventory turnover, Profit margin, Asset turnover, Return on assets, Return on equity, Earnings per Share, Price-earnings, Cash Dicidend payot, Debt Ratio, Debt-to-Equity, and Times Interest earned Orange Company Income Statement For the Years Ended December 31 2013 2012 Net sales (all on account) $            600,000 $                520,000 Expenses: Cost of Goods Sold $            415,000 $                354,000 Selling and administrative $            120,800 $                114,600 Interest Expense $                7,800 $                    6,000 Income Tax...
QUESTION 5 Explain what the following ratios measure. a. Asset turnover: b. Inventory turnover: c. Operating...
QUESTION 5 Explain what the following ratios measure. a. Asset turnover: b. Inventory turnover: c. Operating cycle: d. Cash conversion cycle: e. Customer collection period:
Explain what the following ratios measure. a. Asset turnover (2 marks) b. Inventory turnover (2 marks)...
Explain what the following ratios measure. a. Asset turnover b. Inventory turnover c. Operating cycle d. Cash conversion cycle e. Customer collection period
What is the formula for the following ratios AND what do they measure? Inventory turnover Days'...
What is the formula for the following ratios AND what do they measure? Inventory turnover Days' sales in inventory
Analyzing Effects of LIFO on Inventory Turnover Ratios The current assets of Exxon Mobil Corporation follow:...
Analyzing Effects of LIFO on Inventory Turnover Ratios The current assets of Exxon Mobil Corporation follow: $ millions 2014 2013 Current assets Cash and cash equivalents $4,658 $4,913 Notes and accounts receivable, less estimated doubtful amounts 28,009 33,152 Inventories: Crude oil, products and merchandise 12,384 12,117 Materials and supplies 4,294 4,018 Other current assets 3,565 5,108 Total current assets $52,910 $59,308 In addition, the following note was provided in its 2014 10-K report: Inventories. Crude oil, products, and merchandise inventories...
In the 5Cs method, the lender uses financial ratios such us Current Ratio, Inventory Turnover Ratio,...
In the 5Cs method, the lender uses financial ratios such us Current Ratio, Inventory Turnover Ratio, Gross Profit–Sales Ratio and Interest Coverage Ratio to decide whether to accept a loan application of a firm or to reject it. Please explain the role of each ratio in shaping the lender decision. Current ratio: Inventory Turnover Ratio: Gross Profit–Sales Ratio: Interest Coverage Ratio:
In the 5Cs method, the lender uses financial ratios such us Current Ratio, Inventory Turnover Ratio,...
In the 5Cs method, the lender uses financial ratios such us Current Ratio, Inventory Turnover Ratio, Gross Profit–Sales Ratio and Interest Coverage Ratio to decide whether to accept a loan application of a firm or to reject it. Please explain the role of each ratio in shaping the lender decision. Current ratio: Inventory Turnover Ratio: Gross Profit–Sales Ratio: Interest Coverage Ratio:
Analyzing Effects of LIFO on Inventory Turnover Ratios The current assets of Exxon Mobil Corporation follow:...
Analyzing Effects of LIFO on Inventory Turnover Ratios The current assets of Exxon Mobil Corporation follow: $ millions 2014 2013 Current assets Cash and cash equivalents $4,658 $4,913 Notes and accounts receivable, less estimated doubtful amounts 28,009 33,152 Inventories: Crude oil, products and merchandise 12,384 12,117 Materials and supplies 4,294 4,018 Other current assets 3,565 5,108 Total current assets $52,910 $59,308 In addition, the following note was provided in its 2014 10-K report: Inventories. Crude oil, products and merchandise inventories...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT