Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

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

Short Answer

Expert verified

Answer

  1. CR= 1.40:1

  2. Cash Ratio = 0.26:1

  3. Acid Test Ratio= 0.70:1

  4. Inventory Turnover Ratio= 4.10 times

  5. Days sales in Inventory= 89 days

  6. Days sales in receivables= 58 days

  7. Gross Profit % =34.45%

Step by step solution

01

Current Ratio

Current Ratio = Current Assets/Current Liabilities

= $190,000/136,000

= 1.40:1

02

Cash Ratio

Cash Ratio= Cash & Cash Equivalent /Current Liabilities

Cash & Cash Equivalent = Cash + Short term investment

=$16,000+ $19,000

= $35,000/$136,000

Cash Ratio =0.26:1

03

Acid Test Ratio

Acid Test Ratio = Quick Assets/Current liabilities

Quick Assets: Total Current Assets- Prepaid Exp- Inventory

Quick Assets =$190,000 -$ 78,000 - $17,000

= $95,000

Acid Test Ratio = $95,000 / $136,000

Acid Test Ratio =0.70:1

04

Inventory Turnover Ratio

Inventory Turnover Ratio= Cost of Goods Sold/ Average Inventory.

Average Inventory = Beginning Inventory + Ending Inventory / 2

=$78,000+ $74,000 /2

Average Inventory= $76,000

Inventory turnover ratio = $312,000/$76,000

= 4.10 times

05

Days Sales in Inventory

Days Sales in Inventory = No of Days in Year/ Inventory Turnover Ratio

=365 / 4.10

= 89 days

06

Days Sales in Receivable

Days Sales in Receivable = (Average Accounts Receivable / Total Credit Sales) x 365

Average Accounts Received = $60,000 + $92,000 / 2

= $76,000

Days Sales In Received = $76,000/ $476,000 x365

Days Sales In Received = 58 days

Gross Profit Percentage = (Gross Profit / Net Sales) x 100

Gross Profit = Sales- Cost of Goods Sold

= ($476.000 - $312,000)/$476,000

= 34.45 %

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

Micatin, Inc.’s comparative income statement follows. The 2017 data are given as needed.


MICATIN INC.

Comparative Income Statement

Years Ended December 31, 2019, and 2018

Dollars in thousands

2019

2018

2017

Net Sales Revenue

\( 181,000

\) 160,000

Cost of Goods Sold

93,500

86,500

Selling and Administrative Expenses

45,000

40,500

Interest Expense

8,000

12,000

Income Tax Expense

11,000

10,500

Net Income

\( 23,500

\) 10,500

Additional data:

Total Assets

\( 209,000

\) 187,000

\( 167,000

Common Stockholders’ Equity

96,000

91,500

80,500

Preferred Dividends

2,000

2,000

0

Common Shares Outstanding During the Year

15,000

15,000

10,000

Requirements

  1. Calculate the profit margin ratio for 2019 and 2018.
  2. Calculate the rate of return on total assets for 2019 and 2018.
  3. Calculate the asset turnover ratio for 2019 and 2018.
  4. Calculate the rate of return on common stockholders’ equity for 2019 and 2018.
  5. Calculate the earnings per share for 2019 and 2018.
  6. Calculate the 2019 dividend payout on common stock. Assume dividends per share for common stock are equal to \)1.13 per share.
  7. Did the company’s operating performance improve or deteriorate during 2019?

Computing EPS and P/E ratio

Requirements

1. Compute earnings per share (EPS) for 2018 for Accel’s. Round to the nearest cent.

2. Compute Accel’s Companies’ price/earnings ratio for 2018. The market price per

share of Accel’s stock is $12.50.

3. What do these results mean when evaluating Accel’s Companies’ profitability?

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.

Briefly describe the ratios that can be used to evaluate a company’s stock as an investment.

Using ratios to evaluate a stock investment

Comparative financial statement data of Garfield, Inc. follow:

GARFIELD, INC
Comparative Income Statement
Years Ended December 31, 2018 and 2017

2018

2017

Net sales revenue

\(461,000

\)424,000

Cost of goods sold

241,000

211,000

Gross profit

220,000

213,000

Operating expenses

137,000

135,000

Income from operations

83,000

78,000

Interest expenses

9,000

13,000

Income before taxes

74,000

65,000

Income tax expenses

18,000

24,000

Net income

\(56,000

\)41,000

GARFIELD, INC
Comparative Income Statement
Years Ended December 31, 2018 and 2017

2018

2017

2016

Assets

Current assets

Cash

\(99,000

\)98,000

Accounts receivables, Net

108,000

114,000

107,000

Merchandise inventory

146,000

164,000

202,000

Prepaid expenses

20,000

9,000

Total current assets

373,000

385,000

Property, plant, and equipment

211,000

181,000

Total assets

\(584,000

\)566,000

\(602,000

Liabilities

Total current liabilities

\)227,000

\(246,000

Long-term liabilities

117,000

100,000

Total liabilities

344,000

346,000

Stockholder’s equity

Preferred stock, 3%

98,000

98,000

Common stockholder equity, no par

142,000

122,000

89,000

Total liabilities and stockholder’s equity

\)584,000

\(566,000

1. Market price of Garfield’s common stock: \)69.36 at December 31, 2018, and $38.04 at December 31, 2017.

2. Common shares outstanding: 14,000 on December 31, 2018 and 12,000 on December 31, 2017 and 2016.

3. All sales are on credit.

Requirements

1. Compute the following ratios for 2018 and 2017:

a. Current ratio

b. Cash ratio

c. Times-interest-earned ratio

d. Inventory turnover

e. Gross profit percentage

f. Debt to equity ratio

g. Rate of return on common stockholders’ equity

h. Earnings per share of common stock

i. Price/earnings ratio

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

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