The financial statements of Ion Corporation include the following items:

Current Year Preceding Year

Balance Sheet:

Cash \( 6,000 \) 8,000

Short-term Investments 4,400 10,700

Net Accounts Receivable 21,600 29,200

Merchandise Inventory 30,800 27,600

Prepaid Expenses 6,000 3,600

Total Current Assets 68,800 79,100

Total Current Liabilities 53,200 37,200

Income Statement:

Net Sales Revenue $ 184,800

Cost of Goods Sold 126,000

Compute the following ratios for the current year:

7. Current ratio

8. Acid-test ratio

9. Inventory turnover

10. Gross profit percentage

Short Answer

Expert verified

Answer

Current Ratio- 1.29 times Acid Test ratio= 0.7143 or 71.43%, Inventory Turnover- 4.32 times, Gross Profit Percentage= 31.8%

Step by step solution

01

Definitions

Current ratio- The current ratio is a liquidity ratio that measures a company's ability to pay short-term obligations or those due within one year

Acid Test Ratio- The acid test, orquick ratio, shows if a company has, or can get, enough cash to pay its immediate liabilities, such as short-term debt.

Inventory Turnover- Inventory turnover is the rate that which inventory stock is sold, or used, and replaced. The inventory turnover ratio iscalculated by dividing the cost of goods by the average inventory for the same period. A higher ratio tends to point to strong sales and a lower one too weak sale

Gross Profit Percentage- The gross profit margin is a metric used to assess a firm's financial health and is equal to the revenue less the cost of goods sold as a percent of total revenue.

02

Calculations

Current Ratio- Current Assets / Current Liabilities

= 68,800/ 53,200

=1.29 times

Acid Test Ratio- (Current Assets – Inventory)/Current Liabilities

=(68,800- 30,800)/53,200

= 0.7143 or 71.43%

Inventory Turnover- Cost of Goods Sold/ Average Inventory

= 126,000/[(30,800+27,600)]/2

=126,000/29,200

=4.32 times

Gross Profit Percentage= (Revenue-COGS) /Revenue

= (184,800- 126,000)/184,800

=0.318 or 31.8%

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Determining the effects of business transactions on selected ratios Financial statement data of Style Traveler Magazine include the following items:

Cash

\( 23,000

Accounts Receivable, Net

81,000

Merchandise Inventory

185,000

Total Assets

635,000

Accounts Payable

99,000

Accrued Liabilities

37,000

Short-term Notes Payable

51,000

Long-term Liabilities

224,000

Net Income

68,000

Common Shares Outstanding

20,000 shares

Requirements

  1. Compute Style Traveler’s current ratio, debt ratio, and earnings per share. Round all ratios to two decimal places, and use the following format for your answer:

Current Ratio Debt Ratio Earnings per Share

2.Compute the three ratios after evaluating the effect of each transaction that follows. Consider each transaction separately

  1. Purchased merchandise inventory of \)49,000 on the account.
  2. Borrowed \(127,000 on a long-term note payable.
  3. Issued 2,000 shares of common stock, receiving cash of \)107,000.
  4. Received cash on account, $5,000.

Moss Exports is having a bad year. Net income is only \(60,000. Also, two important overseas customers are falling behind in their payments to Moss, and Moss’s accounts receivable are ballooning. The company desperately needs a loan. The Moss Exports Board of Directors is considering ways to put the best face on the company’s financial statements. Moss’s bank closely examines cash flow from operating activities. Daniel Peavey, Moss’s controller, suggests reclassifying the receivables from the slow-paying clients as long-term. He explains to the board that removing the \)80,000 increase in accounts receivable from current assets will increase net cash provided by operations. This approach may help Moss get the loan.

Requirements

1. Using only the amounts given, compute net cash provided by operations, both without and with the reclassification of the receivables. Which reporting makes Moss look better?

2. Under what condition would the reclassification of the receivables be ethical? Unethical?

Using ratios to evaluate a stock investment

Comparative financial statement data of Sanfield, Inc. follow:

SANFIELD, INC.

Comparative Income Statement

Years Ended December 31, 2018, and 2017

2018

2017

Net Sales Revenue

\( 462,000

\) 430,000

Cost of Goods Sold

236,000

213,000

Gross Profit

226,000

217,000

Operating Expense

135,000

133,000

Income from Operations

91,000

84,000

Interest Expense

8,000

12,000

Income Before Income Tax

83,000

72,000

Income Tax Expense

18,000

22,000

Net Income

\( 65,000

\) 50,000

SANFIELD, INC.

Comparative Balance Sheet

December 31, 2018, and 2017

2018

2017

2016

Asset

Current Assets:

Cash

\( 99,000

\) 97,000

Accounts Receivable, Net

109,000

117,000

\( 100,000

Merchandise Inventory

142,000

164,000

207,000

Prepaid Expenses

15,000

5,000

Total Current Assets

365,000

383,000

Property, Plant, and Equipment, Net

215,000

177,000

Total Assets

\) 580,000

\( 560,000

\) 599,000

Liabilities

Total Current Liabilities

\( 222,000

\) 244,000

Long-term Liabilities

113,000

92,000

Total Liabilities

335,000

336,000

Stockholders’ Equity

Preferred Stock, 4%

92,000

92,000

Common Stockholders’ Equity, no par

153,000

132,000

85,000

Total Liabilities and Stockholders’ Equity

\( 580,000

\) 560,000

1. Market price of Sanfield’s common stock: \(51.48 at December 31, 2018, and \)37.08 at December 31, 2017.

2. Common shares outstanding: 16,000 on December 31, 2018 and 15,000 on December 31, 2017 and 2016.

3. All sales are on credit.

Requirements

1. Compute the following ratios for 2018 and 2017:

  1. Current ratio
  2. Cash ratio
  3. Times-interest-earned ratio
  4. Inventory turnover
  5. Gross profit percentage
  6. Debt to equity ratio
  7. Rate of return on common stockholders’ equity
  8. Earnings per share of common stock
  9. Price/earnings ratio

2. Decide (a) whether Sanfield’s ability to pay debts and sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.

Old Mills’s income statement appears as follows (amounts in thousands):

Use the following ratio data to complete Old Mills’s income statement:


1. Inventory turnover is 3.70 (beginning Merchandise Inventory was \(810; ending

Merchandise Inventory was \)770).

2. Profit margin ratio is 14%.

Big Beautiful Photo Shop has asked you to determine whether the company’s ability to pay current liabilities and total liabilities improved or deteriorated during 2018. To answer this question, you gather the following data:

2018

2017

Cash

\(58,000

\)47,000

Short-term Investments

34,000

0

Net Accounts Receivable

140,000

124,000

Merchandise Inventory

217,000

272,000

Total Assets

530,000

565,000

Total Current Liabilities

288,000

205,000

Long-term Notes Payable

40,000

50,000

Income from Operations

165,000

158,000

Interest Expense

55,000

41,000

Compute the following ratios for 2018 and 2017, and evaluate the company’s ability to pay its current liabilities and total liabilities:

a. Current ratio

b. Cash ratio

c. Acid-test ratio

d. Debt ratio

e. Debt to equity ratio

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free