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

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

Completing a comprehensive financial statement analysis

In its annual report, XYZ Athletic Supply, Inc. includes the following five-year financial summary:

XYZ ATHLETIC SUPPLY, INC.

Five-Year Financial Summary (Partial; adapted)

(Dollar amounts in thousands except per share data)

2018

2017

2016

2015

2014

2016

Net sales revenue

\(275,000

\)222,000

\(199,000

\)171,000

131,000

Net Sales Revenue Increase

24%

12%

16%

31%

17%

Domestic Comparative Store Sales Increase

6%

6%

5%

8%

10%

Other Income—Net

2,090

1,780

1,770

1,700

1,310

Cost of Goods Sold

208,725

169,386

154,822

134,235

103,883

Selling and Administrative Expenses

41,280

36,340

31,670

27,450

22,540

Interest:

Interest Expense

(1,070)

(1,370)

(1,330)

(1,100)

(800)

Interest Income

140

155

150

230

140

Income Tax Expense

4,420

3,900

3,610

3,390

2,730

Net Income

21,735

12,939

9,488

6,755

2,497

Per Share of Common Stock:

Net Income

1.10

0.80

0.70

0.50

0.28

Dividends

0.45

0.43

0.39

0.35

0.31

Financial Position

Current Assets, Excluding Merchandise Inventory

\(30,900

\)27,200

\(26,800

\)24,400

$21,800

Merchandise Inventory

24,700

22,400

21,600

19,300

17,000

16,800

Property, Plant, and Equipment, Net

51,600

46,200

40,500

35,000

25,200

Total Assets

107,200

95,800

88,900

78,700

64,000

Current Liabilities

32,600

27,800

28,800

25,600

17,000

Long-term Debt

23,000

21,200

16,800

18,600

12,900

Stockholders’ Equity

51,600

46,800

43,300

35,500

34,100

Financial Ratios

Acid-Test Ratio

0.9

1.0

0.9

1.0

1.3

Rate of Return on Total Assets

22.5%

15.5%

12.8%

10.9%

9.9%

Rate of Return on Common Stockholders’ Equity

44.2%

28.7%

24.1%

19.4%

18.9%

Requirements

Analyze the company’s financial summary for the fiscal years 2014–2018 to decide whether to invest in the common stock of XYZ. Include the following sections in your analysis.

1. Trend analysis for net sales revenue and net income (use 2014 as the base year).

2. Profitability analysis.

3. Evaluation of the ability to sell merchandise inventory.

4. Evaluation of the ability to pay debts.

5. Evaluation of dividends.

6. Should you invest in the common stock of XYZ Athletic Supply, Inc.? Fully explain your final decision

The following data are adapted from the financial statements of Bridget’s Shops, Inc.:

Total Current Assets $ 1,216,000

Accumulated Depreciation 2,000,000

Total Liabilities 1,540,000

Preferred Stock 0

Debt Ratio 55%

Current Ratio 1.60

Prepare Bridget’s condensed balance sheet as of December 31, 2018.

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.

Question: What is horizontal analysis, and how is a percentage change computed?

Evaluating current ratio

Requirements

1. Compute Accel’s Companies’ current ratio at May 31, 2018 and 2017.

2. Did Accel’s Companies’ current ratio improve, deteriorate, or hold steady during 2018?

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