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

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.

Briefly describe the ratios that can be used to evaluate a company’s ability to pay long-term debt.

Grand Oaks Realty’s net revenue & net income for the following five-year period using 2015 as the base year, follow:

Requirement:

  1. Compute a trend analysis for the net revenue & net income. Round to the nearest full percent.

  2. Which grew faster during the period, net revenue or the net income?

Using ratios to decide between two stock investments

Assume that you are purchasing an investment and have decided to invest in a company in the digital phone business. You have narrowed the choice to Digitalized Corp. and Every Zone, Inc. and have assembled the following data.

Selected income statement data for the current year:

Digitalized

Every Zone

Net sales revenue (all on credit)

\(423,035

\)493,845

Cost of goods sold

210,000

260,000

Interest expenses

0

19,000

Net income

51,000

72,000

Selected balance sheet and market price data at the end of the current year:

Digitalized

Every Zone

Current assets:

Cash

\(24,000

\)17,000

Short-term investment

40,000

14,000

Accounts receivables, Net

40,000

48,000

Merchandise inventory

66,000

97,000

Prepaid expenses

23,000

12,000

Total current assets

\(193,000

\)188,000

Total assets

266,000

323,000

Total current liabilities

105,000

96,000

Total liabilities

105,000

128,000

Common stock

\(1 par (12,000 shares)

12,000

\)1 par (17,000 shares)

17,000

Total stockholders equity

161,000

195,000

Market price per share of common stock

76.50

114.48

Dividend paid per common stock

1.10

1.00

Selected balance sheet data at the beginning of the current year:

Digitalized

Every Zone

Balance sheet:

Accounts Receivable, net

\(41,000

\)54,000

Merchandise Inventory

81,000

87,000

Total Assets

261,000

272,000

Common Stock:

\(1 par (12,000 shares)

12,000

\)1 par (17,000 shares)

17,000

Your strategy is to invest in companies that have low price/earnings ratios but appear to be in good shape financially. Assume that you have analyzed all other factors and that your decision depends on the results of ratio analysis.

Requirements

  1. Compute the following ratios for both companies for the current year:

a. Acid-test ratio

b. Inventory turnover

c. Days’ sales in receivables

d. Debt ratio

e. Earnings per share of common stock

f. Price/earnings ratio

g. Dividend payout

2. Decide which company’s stock better fits your investment strategy.

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