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

Computing inventory, gross profit, and receivables ratios

Requirements

1. Compute the inventory turnover, days’ sales in inventory, and gross profit

percentage for Accel’s Companies for 2018.

2. Compute days’ sales in receivables during 2018. Round intermediate calculations to

three decimal places. Assume all sales were on account.

3. What do these ratios say about Accel’s Companies’ ability to sell inventory and

collect receivables?

Determining the effects of business transactions on selected ratios

Financial statement data of Modern Traveler’s Magazine include the following items:

Cash

\(19,000

Accounts Receivable, Net

82,000

Merchandise Inventory

183,000

Total Assets

638,000

Accounts Payable

102,000

Accrued Liabilities

35,000

Short-term Notes Payable

50,000

Long-term Liabilities

221,000

Net Income

69,000

Common Shares Outstanding

50,000 shares

Requirements

  1. Compute Modern 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.

a. Purchased merchandise inventory of \)42,000 on account.

b. Borrowed \(121,000 on a long-term note payable.

c. Issued 5,000 shares of common stock, receiving cash of \)103,000.

d. Received cash on account, $5,000.

Net sales revenue, net income, and common stockholders’ equity for Eyesight Mission Corporation, a manufacturer of contact lenses, follow for a four-year period.

2019

2018

2017

2016

Net Sales Revenue

\(766000

\)708000

\(644000

\)664000

Net Income

60000

38000

36000

44000

Ending Common Stockholder’s Equity

368000

352000

326000

296000

Requirements

1.Compute trend analyses for each item for 2017–2019. Use 2016 as the base year, and round to the nearest whole percent.

2.Compute the rate of return on common stockholders’ equity for 2017–2019, rounding to three decimal places.

Briefly describe the ratios that can be used to evaluate a company’s profitability.

What is benchmarking, and what are the two main types of benchmarks in financialstatement analysis?

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