/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q12SE Traditional Mills’s balance sh... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

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.

Short Answer

Expert verified

Answer

Accounts Receivables = $855, Prepaid Expense= $100, Total Current Assets= $1800, Plant Assets, Net= $2710, Long-term Note Payable =$1290, Total Liabilities=$4550, Total Liabilities and Stockholders=$7000

Step by step solution

01

Preparation of Balance Sheet

TRADITIONAL MILLS

Balance Sheet

December 31, 2018

Assets
$
Liabilities
$
Cash
45
Total Current Liabilities
2,500
Accounts Receivables
855Long-term Note Payable
1,290
Merchandise Inventory
800Other Long-term Liabilities
760
Prepaid Expenses
100Total Liabilities
4,550
Total Current Assets
1,800

Plant Assets, Net
2,710Stockholders’ Equity

Other Assets
2,490
Stockholders’ Equity
2,450
Total Assets
7,000
Total Liabilities and Stockholders’ Equity
7,000
02

Step 2:Calculations

Total asset = Total liabilities and stockholder’s equity

Therefore, total liabilities and stockholder’s equity = $7,000

Total liabilities and stockholder’s equity = Total liabilities + Stockholder's equity

Total liabilities = $7,000 - $2450

= $4,550

Total liabilities = Total current liability + Long term note payable + Other long term liabilities

Long term notes payable =$4,550 - $2,500 - $760

= $1290

Current ratio = Current asset/ Current liabilities

Current assets = 0.72x2500

= $1,800

Total asset = Plant asset + Other asset + Total current asset

Plant asset = $7,000 - $1,800 - $2,490

=$2,710

Acid ratio = (Cash + Investment + Account receivable)/ Current liabilities

Account receivable = $2,500x0.36 - $45

Account receivable = $855

Prepaid expense = Total Current Assets – Inventory – Account Receivable - Cash

= $1800 - $800 - $855 - $45

= $100

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 91Ó°ÊÓ!

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

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.

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 commonA stockholders’ equity for Azbel Mission Corporation, a manufacturer of contact lenses, follow for a four-year period.

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.

The Randall Department Stores, Inc. chief executive officer (CEO) has asked you to compare 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.

RANDALL DEPARTMENT STORES, INC.

Income Statement Compared with Industry Average

Year Ended December 31, 2018

Randall

Industry Average

Net Sales Revenue

\( 783,000

100.0%

Cost of Goods Sold

527,742

65.8

Gross Profit

255,258

34.2

Operating Expenses

163,647

19.7

Operating Income

91,611

14.5

Other Expenses

6,264

0.4

Net Income

\) 85,347

14.1%

RANDALL DEPARTMENT STORES, INC.

Balance Sheet Compared with Industry Average

December 31, 2018

Randall

Industry Average

Current Assets

\( 310,040

70.9%

Property, Plant, and Equipment, Net

119,600

23.6

Intangible Assets, Net

7,360

0.8

Other Assets

23,000

4.7

Total Assets

\) 460,000

100.0%

Current Liabilities

\( 210,680

48.1%

Long-term Liabilities

103,960

16.6

Total Liabilities

314,640

64.7

Stockholders’ Equity

145,360

35.3

Total Liabilities and Stockholders’ Equity

\) 460,000

100.0%

Requirements

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

Compare the company’s profit performance and financial position with the average for the industry

Great Value Optical Company reported the following amounts on its balance sheet at

December 31, 2018 and 2017:

2018 2017

Cash and Receivables \( 80,640 \) 80,575

Merchandise Inventory 56,840 54,450

Property, Plant, and Equipment, Net 142,520 139,975

Total Assets \( 280,000 \) 275,000

Prepare a vertical analysis of Great Value’s assets for 2018 and 2017.

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.