Question

In: Finance

Financial​ ratios: Asset management. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the...

Financial​ ratios: Asset management. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the inventory​ turnover, days' sales in​ inventory, receivables​ turnover, days' sales in​ receivables, and total asset turnover for 2013 and 2014 for Tyler Toys. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the​ shareholders?

Tyler Toys, Inc.

Income Statement for Years Ending December 31, 2013 and 2014

2014

2013

Revenue

$14,147,844

$13,566,081

Cost of goods sold

$-8,448,121

$-8,131,751

Selling, general, and
administrative expenses

$-997,351

$-981,956

Depreciation

$-1,498,005

$-1,471,279

EBIT

$3,204,367

$2,981,095

Interest expense

$-375,975

$-355,216

Taxes

$-1,074,789

$-997,834

Net income

$1,753,603

$1,628,045

                                                                                       

Tyler Toys, Inc.

Balance Sheet as of December 31, 2013 and 2014

ASSETS

2014

2013

LIABILITIES

2014

2013

Current assets

Current liabilities

Cash

$191,800

$186,995

Accounts payable

$1,545,434

$1,456,815

Investments

$180,888

$120,534

Short-term debt

$311,087

$333,794

Accounts receivable

$667,251

$631,113

Total current liabilities

$1,856,521

$1,790,609

Inventory

$588,772

$563,814

Long-term liabilities

Total current assets

$1,628,711

$1,502,456

Debt

$7,285,670

$6,603,931

Long-term assets

Other liabilities

$1,462,111

$1,346,207

Investments

$3,053,195

$2,828,266

Total liabilities

$10,604,302

$9,740,747

Plant, property, and equipment

$8,496,792

$8,481,309

OWNERS’ EQUITY

Goodwill

$347,021

$347,194

Common stock

$1,457,331

$1,453,971

Intangible assets

$1,158,088

$957,411

Retained earnings

$2,622,174

$2,921,918

Total owners’ equity

$4,079,505

$4,375,889

TOTAL LIABILITIES

TOTAL ASSETS

$14,683,807

$14,116,636

AND OWNERS’ EQUITY

$14,683,807

$14,116,636

What is the inventory turnover ratio for​ 2014? ________ ​(Round to four decimal​ places.)

What is the inventory turnover ratio for​ 2013? ________ ​(Round to four decimal​ places.)

What is the​ days' sales in inventory ratio for​ 2014? ________ days (Round to four decimal​ places.)

What is the​ days' sales in inventory ratio for​ 2013? ________ days ​(Round to four decimal​ places.)

What is the receivables turnover ratio for​ 2014? ________ ​(Round to four decimal​ places.)

What is the receivables turnover ratio for​ 2013? _________ ​(Round to four decimal​ places.)

What is the​ days' sales in receivables ratio for​ 2014? _______ days (Round to four decimal​ places.)

What is the​ days' sales in receivables ratio for​ 2013? _______ days ​(Round to four decimal​ places.)

What is the total asset turnover ratio for​ 2014? _______ ​(Round to four decimal​ places.)

What is the total asset turnover ratio for​ 2013? ________ ​(Round to four decimal​ places.)

Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the​ shareholders? (Select the best​ response.)

A. The company has a very poor turnover of assets and collects its receivables​ quickly; thus there are some concerns from these ratios.

B. The company has a very good turnover of assets but collects its receivables​ slowly; thus there are some real concerns from these ratios.

C. The company has a very good turnover of assets and collects its receivables​ quickly; thus there are major concerns from these ratios.

D. The company has a very good turnover of assets and collects its receivables​ quickly; thus there are no real concerns from these ratios.

Solutions

Expert Solution

PARTICULARS 2014 2013
A.COST OF GOODS SOLD            84,48,121.00            81,31,751.00
B. INVENTORY*              5,88,772.00              5,63,814.00
C.INVENTORY TURNOVER RATIO (A/B)                      14.3487                      14.4228
D.DAY'S SALES IN INVENTORY RATIO (B/A)*365                      25.4378                      25.3072
E.CREDIT SALES (ASSUMING WHOLE REVENUE FROM CREDIT SALES)          141,47,844.00          135,66,081.00
F.ACCOUNTS RECEIVABLE#              6,67,251.00              6,31,113.00
G.RECEIVABLE TURNOVER RATIO(E/F)                      21.2032                      21.4955
H.DAY'S SALES IN RECEIVABLE RATIO(F/E)*365                      17.2144                      16.9803
I.TOTAL ASSETS^          146,83,807.00          141,16,636.00
J.ASSET TURNOVER RATIO (E/I)                        0.9635                        0.9610
*USUALLY FOR CALCULATION OF INVENTORY TURNOVER RATIO, AVERAGE INVENTORY IS TAKEN
SINCE NO INFORMATION ABOUT OPENING STOCK OF 2013, WE ONLY CONSIDER CLOSING STOCK OF BOTH THE YEARS FOR CALCULATION.
#USUALLY FOR CALCULATION OF RECEIVABLE TURNOVER RATIO, AVERAGE RECEIVABLE IS TAKEN
SINCE NO INFORMATION ABOUT OPENING RECEIVABLE OF 2013, WE ONLY CONSIDER CLOSING RECEIVABLE BALANCE OF BOTH THE YEARS FOR CALCULATION.
^USUALLY FOR CALCULATION OF ASSET TURNOVER RATIO, AVERAGE ASSET IS TAKEN
SINCE NO INFORMATION ABOUT TOTAL ASSET OF 2012 GIVEN, WE ONLY CONSIDER TOTAL ASSETS OF BOTH THE YEARS FOR CALCULATION.

B. The company has a very good turnover of assets but collects its receivables​ slowly; thus there are some real concerns from these ratios.


Related Solutions

Financial? ratios: Asset management.??The financial statements for Tyler? Toys, Inc. are shown in the table below....
Financial? ratios: Asset management.??The financial statements for Tyler? Toys, Inc. are shown in the table below. Calculate the inventory? turnover, days' sales in? inventory, receivables? turnover, days' sales in?receivables, and total asset turnover for 2013 and 2014 for Tyler Toys. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the? shareholders? Tyler Toys, Inc. Income Statement for Years Ending December 31, 2013 and 2014 2014 2013 Revenue $14,147,668 $13,567,127...
Financial​ ratios: Asset management.  The financial statements for Tyler​ Toys, Inc. are shown in the popup​...
Financial​ ratios: Asset management.  The financial statements for Tyler​ Toys, Inc. are shown in the popup​ window: Calculate the inventory​ turnover, days' sales in​ inventory, receivables​ turnover, days' sales in​ receivables, and total asset turnover for 2013 and 2014 for Tyler Toys. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the​ shareholders? What is the inventory turnover ratio Tyler Toys, Inc. Income Statement for Years Ending December 31,...
Financial​ ratios: Financial leverage. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the...
Financial​ ratios: Financial leverage. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the debt​ ratio, times interest earned​ ratio, and cash coverage ratio for 2013 and 2014 for Tyler Toys. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the​ shareholders? Tyler Toys, Inc. Income Statement for Years Ending December 31, 2013 and 2014 2014 2013 Revenue $14,147,996 $13,566,458 Cost of goods sold $-8,448,120 $-8,131,722 Selling,...
Financial​ ratios: Financial leverage. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the...
Financial​ ratios: Financial leverage. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the debt​ ratio, times interest earned​ ratio, and cash coverage ratio for 2013 and 2014 for Tyler Toys. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the​ shareholders? Tyler Toys, Inc. Income Statement for Years Ending December 31, 2013 and 2014 2014 2013 Revenue $14,146,008 $13,566,936 Cost of goods sold $-8,448,426 $-8,131,134 Selling,...
Financial​ ratios: Profitability. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the profit​...
Financial​ ratios: Profitability. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the profit​ margin, return on​ assets, and return on equity for 2013 and 2014 for Tyler Toys. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the​ shareholders? Tyler Toys, Inc. Income Statement for Years Ending December 31, 2013 and 2014 2014 2013 Revenue $14,147,036 $13,566,155 Cost of goods sold $-8,447,557 $-8,131,158 Selling, general, and...
Financial​ ratios: Liquidity. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the current​...
Financial​ ratios: Liquidity. The financial statements for Tyler​ Toys, Inc. are shown below. Calculate the current​ ratio, quick​ ratio, and cash ratio for Tyler Toys for 2013 and 2014. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the​ shareholders? Tyler Toys, Inc. Income Statement for Years Ending December 31, 2013 and 2014 2014 2013 Revenue $14,147,831 $13,567,868 Cost of goods sold $-8,447,482 $-8,132,539 Selling, general, and administrative expenses...
Financial? ratios: Financial leverage.??The financial statements for Tyler? Toys, Inc. are shown in the table below....
Financial? ratios: Financial leverage.??The financial statements for Tyler? Toys, Inc. are shown in the table below. Calculate the debt? ratio, times interest earned? ratio, and cash coverage ratio for 2013 and 2014 for Tyler Toys. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the? shareholders? Tyler Toys, Inc. Income Statement for Years Ending December 31, 2013 and 2014 2014 2013 Revenue $14,146,827 $13,567,406 Cost of goods sold $-8,447,289...
The financial statements for Tyler​ Toys, Inc.  Calculate the current​ ratio, quick​ ratio, and cash ratio...
The financial statements for Tyler​ Toys, Inc.  Calculate the current​ ratio, quick​ ratio, and cash ratio for Tyler Toys for 2013 and 2014. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the​ shareholders? Tyler Toys, Inc. Income Statement for Years Ending December 31, 2013 and 2014 2014 2013 Revenue $14,147,946 $13,566,699 Cost of goods sold $-8,447,605 $-8,132,285 Selling, general, and administrative expenses $-997,233 $-980,532 Depreciation $-1,497,455 $-1,472,391 EBIT...
Compare and contrast the types (categories) of financial ratios: liquidity ratios, asset management ratios, debt management...
Compare and contrast the types (categories) of financial ratios: liquidity ratios, asset management ratios, debt management ratios, profitability ratios, market value ratios. Be sure to discuss how each type of ratio is used and by whom.
The financial statements and industry norms are shown below for Pamplin, Inc.: a. Compute the financial...
The financial statements and industry norms are shown below for Pamplin, Inc.: a. Compute the financial ratios for Pamplin for 2014 and for 2015 to compare both against the industry norms. b. How liquid is the firm? c. Areitsmanagersgeneratinganadequateoperatingprofitonthefirm’sassets? d. How is the firm financing its assets? e. Are its managers generating a good return on equity? INDUSTRY NORM Current ratio 5.00 Acid-test (quick) ratio 3.00 Inventory turnover 2.20 Average collection period 90.00 Debt ratio 0.33 Times interest earned 7.00...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT