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

The Klein Department Stores, Inc. chief executive officer (CEO) has asked you tocompare the company’s profit performance and financial position with the averages for the industry. The CEO has given you the company’s income statement and balance sheet as well as the industry average data for retailers.

Requirements

1.Prepare a vertical analysis for Klein for both its income statement and balance sheet.

2.Compare the company’s profit performance and financial position with the averagefor the industry.

Completing a comprehensive financial statement analysis

In its annual report, XYZ Athletic Supply, Inc. includes the following five-year financial summary:

XYZ ATHLETIC SUPPLY, INC.

Five-Year Financial Summary (Partial; adapted)

(Dollar amounts in thousands except per share data)

2018

2017

2016

2015

2014

2016

Net sales revenue

\(275,000

\)222,000

\(199,000

\)171,000

131,000

Net Sales Revenue Increase

24%

12%

16%

31%

17%

Domestic Comparative Store Sales Increase

6%

6%

5%

8%

10%

Other Income—Net

2,090

1,780

1,770

1,700

1,310

Cost of Goods Sold

208,725

169,386

154,822

134,235

103,883

Selling and Administrative Expenses

41,280

36,340

31,670

27,450

22,540

Interest:

Interest Expense

(1,070)

(1,370)

(1,330)

(1,100)

(800)

Interest Income

140

155

150

230

140

Income Tax Expense

4,420

3,900

3,610

3,390

2,730

Net Income

21,735

12,939

9,488

6,755

2,497

Per Share of Common Stock:

Net Income

1.10

0.80

0.70

0.50

0.28

Dividends

0.45

0.43

0.39

0.35

0.31

Financial Position

Current Assets, Excluding Merchandise Inventory

\(30,900

\)27,200

\(26,800

\)24,400

$21,800

Merchandise Inventory

24,700

22,400

21,600

19,300

17,000

16,800

Property, Plant, and Equipment, Net

51,600

46,200

40,500

35,000

25,200

Total Assets

107,200

95,800

88,900

78,700

64,000

Current Liabilities

32,600

27,800

28,800

25,600

17,000

Long-term Debt

23,000

21,200

16,800

18,600

12,900

Stockholders’ Equity

51,600

46,800

43,300

35,500

34,100

Financial Ratios

Acid-Test Ratio

0.9

1.0

0.9

1.0

1.3

Rate of Return on Total Assets

22.5%

15.5%

12.8%

10.9%

9.9%

Rate of Return on Common Stockholders’ Equity

44.2%

28.7%

24.1%

19.4%

18.9%

Requirements

Analyze the company’s financial summary for the fiscal years 2014–2018 to decide whether to invest in the common stock of XYZ. Include the following sections in your analysis.

1. Trend analysis for net sales revenue and net income (use 2014 as the base year).

2. Profitability analysis.

3. Evaluation of the ability to sell merchandise inventory.

4. Evaluation of the ability to pay debts.

5. Evaluation of dividends.

6. Should you invest in the common stock of XYZ Athletic Supply, Inc.? Fully explain your final decision

The financial statements of Valerie’s Natural Foods include the following items:

Compute the following ratios for the current year:

  1. Current ratio

  2. Cash ratio

  3. Acid-test ratio

  4. Inventory turnover

  5. Day’s sales in inventory

  6. Day’s sales in receivables

  7. Gross profit percentage

Data for Oxford State Bank follow:


2018

2017

Net Income

\(71,900

\)64,300

Dividends—Common

22,000

22,000

Dividends—Preferred

16,800

16,800

Total Stockholders’ Equity at Year-End (includes 95,000 shares of common stock)

770,000

610,000


Net Income

\( 71,900

\) 64,300

Market Price per Share of Common Stock

\( 16.50

\) 10.00


Evaluate the common stock of Oxford State Bank as an investment. Specifically,

use the three stock ratios to determine whether the common stock has increased or decreased in attractiveness during the past year. Round to two decimal places.

Traditional Mills’s balance sheet appears as follows (amounts in thousands):

Use the following ratio data to complete Traditional Mills’s balance sheet.

  1. Current ratio is 0.72.

2. Acid-test ratio is 0.36.

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