Question

In: Finance

Ratio analysis: Refer to the information above for Nederland Consumer Products Company. Compute the firm’s ratios...

Ratio analysis: Refer to the information above for Nederland Consumer Products Company. Compute the firm’s ratios for the following categories and briefly evaluate the company’s performance from these numbers.
a.     Efficiency ratios
b.     Asset turnover ratios
c.     Leverage ratios
d.     Coverage ratios
Nederland Consumer Products Company
Income Statement for the Fiscal Year
Ended September 30, 2014
Net sales $51,407
Cost of products sold $25,076
Gross margin $26,331
Marketing, research, administrative exp. $15,746
Depreciation $758
Operating income (loss) $9,827
Interest expense $629
Other nonoperating income (expense), net $152
Earnings (loss) before income taxes $9,350
Income taxes $2,869
Net earnings (loss) $6,481
Nederland Consumer Product Company
Balance Sheet as of September 30, 2014
Assets: Liabilities and Equity:
Cash and cash equivalents $5,469 Accounts payable $3,617
Investment securities 423 Accrued and other liabilities 7,689
Accounts receivable 4,062 Taxes payable 2,554
Inventory 4,400 Debt due within one year 8,287
Deferred income taxes 958 Total current liabilities $22,147
Prepaid expenses and other receivables 1,803 Long-term debt 12,554
Total current assets $17,115 Deferred income taxes 2,261
Property, plant, and equipment, at cost 25,304 Other noncurrent liabilities 2,808
Less: Accumulated depreciation 11,196 Total liabilities $39,770
Net property, plant, and equipment $14,108 Convertible class A preferred stock 1,526
Net goodwill and other intangible assets 23,900 Common stock 2,141
Other noncurrent assets 1,925 Retained earnings 13,611
Total shareholders' equity (deficit) $17,278
Total assets $57,048 Total liabilites and shareholders' equity $57,048

Solutions

Expert Solution

a.     Efficiency ratios:

Inventory tunrnover ratio = cost of goods sold / inventory

= $25,076 / $4,400

= 5.70

days sales inventory = 365 /   Inventory tunrnover ratio

= 365 / 5.70

= 64.04 days

Accounts receivable turnover = net sales / Accounts receivable

=$51,407 / 4062

= 12.66

days sale outstanding = 365 / Accounts receivable turnover

= 365 / 12.66

=28.83 days

b.     Asset turnover ratios

Total assets turnover = net sales / total assets

=$51,407  / $57,048

= 0.9

Fixed Asset turnover ratios = net sales / Net property, plant, and equipment

= $51,407  / 14108

= 3.64

c.     Leverage ratios :

Debt-equity ratio =Total liabilities / Total shareholders' equity

=$39,770 / $17,278

=2.30

Total debt ratio =Total liabilities / Total assets

=$39,770 / $57,048

=0.70

Equity multiplier ratio =Total assets / Total equity

= $57048 / $17278

= 3.30

d.     Coverage ratios

  Interest coverage ratio = operating income / interest expense

= $9,827 / $629

=15.62

Cash coverage ratio = [operating income + depreciation] / interest expense

= 10585 / $629

= 16.83


Related Solutions

Refer to the information below to compute and explain the ratios below. Balance Sheet 2017                     ...
Refer to the information below to compute and explain the ratios below. Balance Sheet 2017                      2018 Cash                                                                      10,000 600 A/R                                                                         12,900                  18,000 Inventories                                                         31,000                  50,700 Total Current Assets                                       53,900                 69,300 Land                                                                      22,000                  29,000 Plant & Equipment                                          80,000                  130,000 Less Accumulated Depreciation (28,000)               (48,000) Total Fixed Assets                                       74,000 11,000 Total Assets                                               127,900                180,300 Accounts Payable                                       7,900                    17,400 Accrued Expenses...
TBSFCO0166 Compute Ratios Use the information in the exhibit(s) above as needed. Using the information below,...
TBSFCO0166 Compute Ratios Use the information in the exhibit(s) above as needed. Using the information below, compute the following amounts and ratios for the Quant Corporation for the current year. Assume that (1) the only effects on retained earnings are net income and cash dividends for the year, and (2) only common stock dividends were declared (none for preferred stock). Assume a 365 day year. Enter your amounts rounded to two decimal places, and include the preceding "0" before the...
Comprehensive analysis of Wal-Mart and Target, compute the four ratios; current ratio, quick ratio, liabilities to...
Comprehensive analysis of Wal-Mart and Target, compute the four ratios; current ratio, quick ratio, liabilities to equity, times earned. Current Ratio                                 2018        2017 Walmart                                        0.75:1     0.86:1 Target                                           0.95:1     0.94:1 Quick Ratio                                  2018        2017 Walmart                                       0.20:1     0.21:1 Target                                          0.29:1     0.28:1 Total liabilities to equity            2018          2017 Walmart    1.62times 1.55times Target 2.33times 2.41times    Times interest earned                      2018              2017 Walmart                                     7.490.5times   9.659.5times Target                                         6.475.5times 4.949.5times -          Which company is more liquid? More solvent? -          Compare the liabilities to equity ratio, do...
Backus, Inc., makes and sells many consumer products. The firm’s average contribution margin ratio is 25%....
Backus, Inc., makes and sells many consumer products. The firm’s average contribution margin ratio is 25%. Management is considering adding a new product that will require an additional $11,000 per month of fixed expenses and will have variable expenses of $5.5 per unit. Required: a. Calculate the selling price that will be required for the new product if it is to have a contribution margin ratio equal to 25%. (Round your answer to 2 decimal places.) b. Calculate the number...
For each company, compute the following ratios.
Suppose selected financial data of Target and Wal-Mart for 2020 are presented here (in millions).TargetCorporationWal-MartStores, Inc.Income Statement Data for YearNet sales$65,357$408,214Cost of goods sold45,583304,657Selling and administrative expenses15,10179,607Interest expense7072,065Other income (expense)(94)(411)Income tax expense1,3847,139Net income$ 2,488$ 14,335Balance Sheet Data (End of Year)Current assets$18,424$48,331Noncurrent assets26,109122,375Total assets$44,533$170,706Current liabilities$11,327$55,561Long-term debt17,85944,089Total stockholders’ equity15,34771,056Total liabilities and stockholders’ equity$44,533$170,706Beginning-of-Year BalancesTotal assets$44,106$163,429Total stockholders’ equity13,71265,682Current liabilities10,51255,390Total liabilities30,39497,747Other DataAverage net accounts receivable$7,525$4,025Average inventory6,94233,836Net cash provided by operating activities5,88126,249Capital expenditures1,72912,184Dividends4964,217(a)For each company, compute the following ratios. (Enter free cash flow in millions. Round...
Describe the three categories of ratios used in ratio analysis. When working on assessing the company...
Describe the three categories of ratios used in ratio analysis. When working on assessing the company you chose, which of these ratios do you think is the most important indicator of successful performance, why
Define ratio analysis,What are different types of ratios ,also explain with formulas following ratios: a)Liquidity Ratios...
Define ratio analysis,What are different types of ratios ,also explain with formulas following ratios: a)Liquidity Ratios b)Solvency Ratios c)Profitability Ratios
Ratio Analysis - Explain how the following ratios are calculated and what the ratio indicates. Include...
Ratio Analysis - Explain how the following ratios are calculated and what the ratio indicates. Include how these ratios provide useful information related to accounting decision making topics such as efficiency (collecting amounts owed to the firm, using the assets well, getting items to market, etc.), liquidity (ability to pay current debts), solvency (ability to pay long term or all debts), etc. Please look at all the ratios not just these. Days’ sales in Inventory Gross Profit Percentage Return on...
REQUIREMENTS: 1. Compute Eastland's current? ratio, debt? ratio, and earnings per share. Round all ratios to...
REQUIREMENTS: 1. Compute Eastland's current? ratio, debt? ratio, and earnings per share. Round all ratios to two decimal places. Start by determining the formula for each ratio,beginning withthe current ratio,followed by the debt ratio, and then endings pershare. 2. Compute the three ratios after evaluating the effect of each transaction that follows. Consider each transaction separately. a. Borrowed $115,000 on a? long-term note payable. b. On January? 1, Issued 15,000 shares of common? stock, receiving cash of $367,000. c. Paid?...
REQUIREMENTS: 1. Compute Eastland's current? ratio, debt? ratio, and earnings per share. Round all ratios to...
REQUIREMENTS: 1. Compute Eastland's current? ratio, debt? ratio, and earnings per share. Round all ratios to two decimal places. 2. Compute the three ratios after evaluating the effect of each transaction that follows. Consider each transaction separately. a. Borrowed $115,000 on a? long-term note payable. b. On January? 1, Issued 15,000 shares of common? stock, receiving cash of $367,000. c. Paid? short-term notes? payable, $30,000. d. Purchased merchandise of $44,000 on? account, debiting Inventory. e. Received cash on? account, $15,000....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT