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

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%.

Short Answer

Expert verified

Answer

Complete income statement given below.

Step by step solution

01

Preparation of Income Statement

Income Statement- Old Mills Company
For year ended 31 Dec, 2018
Particulars
Amount
Net sales Revenue
$6,900.00
Cost of Goods Sold
2,923.00
Gross Profit
3,977.00
Selling and Administrative Expenses
1,710.00
Interest Expense ($3,977-1,710-120-1,150)
997.00
Other Expenses
120.00
Income Before Income Taxes
1,150.00
Income Tax Expense ($1,150-$966)
184.00


Net Income
$966.00


02

Working Notes

Inventory Turnover= 3.70

Cost of goods sold/ Average Inventory= 3.70

Average Inventory =($810+770)/2 = $790

Cost of Goods Sold = 3.70x 790 = $2,923

Net Sales = $6,900

Profit Margin ratio= 14%

Net Income = $6,900x14% = $966.00

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

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.

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?

Data for Connor, Inc. and Alto Corp. follow:

Connor Alto

Net Sales Revenue \( 13,000 \) 22,000

Cost of Goods Sold 7,917 15,730

Other Expenses 4,342 5,170

Net Income \( 741 \) 1,100

Requirements

1. Prepare common-size income statements.

2. Which company earns more net income?

3. Which company’s net income is a higher percentage of its net sales revenue?

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