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

Chapter 24: Question 4P-b (page 1452)

(Horizontal and Vertical Analysis) Presented below is the comparative balance sheet for Gilmour Company.

GILMOUR COMPANY

COMPARATIVE BALANCE SHEET

AS OF DECEMBER 31, 2018 AND 2017

December 31

2018

2017

Assets

Cash

\( 180,000

\) 275,000

Accounts receivable (net)

220,000

155,000

Short-term investments

270,000

150,000

Inventories

1,060,000

980,000

Prepaid expenses

25,000

25,000

Plant & equipment

2,585,000

1,950,000

Accumulated depreciation

(1,000,000)

(750,000)

\(3,340,000

(2,785,000)

Liabilities and Stockholders’ Equity

Accounts payable

\) 50,000

\( 75,000

Accrued expenses

170,000

200,000

Bonds payable

450,000

190,000

Common stock

2,100,000

1,770,000

Retained earnings

570,000

550,000

\)3,340,000

(2,785,000)

Instructions

(Round to two decimal places.)

  1. Prepare a comparative balance sheet of Gilmour Company showing the dollar change and the percent change for each item.

Short Answer

Expert verified

The total change in the value of assets and liabilities is $555,000.

Step by step solution

01

Meaning of Vertical Analysis

Vertical analysis is the proportional study of a financial statement, in which each line item is reported as the rate of another itemon the financial statement. This means that on the income statement, each line item is reported as the gross transaction rate, while on the balance sheet, each line item is expressed as the total asset rate.

02

Preparing a comparative balance sheet of Gilmour Company showing the dollar change and the percent change for each item.

GILMOUR COMPANY

Comparative Balance Sheet

December 31, 2018, and 2017
December 31 Increase or (Decrease)

2018

2017

$ change

% change

Assets

Cash

$ 180,000

$ 275,000

$ (95,000)

(34.55)

Accounts receivable (net)

220,000

155,000

65,000

41.94

Short-term investments

270,000

150,000

120,000

80.00

Inventories

1,060,000

980,000

80,000

8.16

Prepaid expenses

25,000

25,000

0

0

Plant and equipment

2,585,000

1,950,000

635,000

32.56

Accumulated

depreciation

(1,000,000)

(750,000)

(250,000)

33.33

Total

$ 3,340,000

$2,785,000

$ 555,000

19.93%

Liabilities and Stockholders’ Equity

Accounts payable

$ 50,000

$ 75,000

$ (25,000)

(33.33)

Accrued expenses

170,000

200,000

(30,000)

(15.00)

Bonds payable

450,000

190,000

260,000

136.84

Common stock

2,100,000

1,770,000

330,000

18.64

Retained earnings

570,000

550,000

20,000

3.64

Total

$3,340,000

$2,785,000

$555,000

19.93%

Working Notes:-

All the percentage change values should be determined by using the formula as follows:-

Percentagechangevalue=DifferenceinamountoveryearBaseyear

To find the change value in cash is as follows

Percentagechangevalue=Cashin2017-Cashin2018Baseyear=180,000-275,000275,000=34.55%

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

(Ratio Computations and Additional Analysis) Bradburn Corporation was formed 5 years ago through a public subscription of common stock. Daniel Brown, who owns 15% of the common stock, was one of the organizers of Bradburn and is its current president. The company has been successful, but it currently is experiencing a shortage of funds. On June 10, 2018, Daniel Brown approached the Topeka National Bank, asking for a 24-month extension on two \(35,000 notes, which are due on June 30, 2018, and September 30, 2018. Another note of \)6,000 is due on March 31, 2019, but he expects no difficulty in paying this note on its due date. Brown explained that Bradburn’s cash flow problems are due primarily to the company’s desire to finance a \(300,000 plant expansion over the next 2 fiscal years through internally generated funds. The commercial loan officer of Topeka National Bank requested the following financial reports for the last 2 fiscal years

BRADBURN CORPORATION

BALANCE SHEET

MARCH 31

Assets

2018

2017

Cash

\) 18,200

\( 12,500

Notes receivable

148,000

132,000

Accounts receivable (net)

131,800

125,500

Inventories (at cost)

105,000

50,000

Plant & Equipment (net of depreciation)

1,449,000

1,420,500

Total assets

\)1,852,000

\(1,740,500

Liabilities and Stockholders’ Equity

Accounts payable

\) 79,000

\( 91,000

Notes payable

76,000

61,500

Accrued liabilities

9,000

6,000

Common stock (130,000 shares, \)10 par)

1,300,000

1,300,000

Retained earnings*

388,000

282,000

Total liabilities and stockholders’ equity

\(1,852,000

\)1,740,500

*Cash dividends were paid at the rate of \(1 per share in the fiscal year 2017 and \)2 per share in the fiscal year 2018.

BRADBURN CORPORATION

INCOME STATEMENT

FOR THE FISCAL YEARS ENDED MARCH 31

2018

2017

Sales revenue

\(3,000,000

\)2,700,000

Cost of goods sold*

1,530,000

1,425,000

Gross margin

1,470,000

1,275,000

Operating expenses

860,000

780,000

Income before income taxes

610,000

495,000

Income taxes (40%)

244,000

198,000

Net income

\( 366,000

\) 297,000

*Depreciation charges on the plant and equipment of \(100,000 and \)102,500 for fiscal years ended March 31, 2017, and 2018, respectively, are included in the cost of goods sold.

Instructions

(a). Compute the following items for Bradburn Corporation.

  1. Current ratio for fiscal years 2017 and 2018.

Edna Millay Inc. is a manufacturer of electronic components and accessories with total assets of $20,000,000. Selected financial ratios for Millay and the industry averages for firms of similar size are presented below.

Edna Millay

2017 Industry

2015

2016

2017

Averages

Current ratio

2.09

2.27

2.51

2.24

Quick ratio

1.15

1.12

1.19

1.22

Inventory turnover

2.40

2.18

2.02

3.50

Net sales to stockholders’ equity

2.71

2.80

2.99

2.85

Return on common stockholders’ equity

0.14

0.15

0.17

0.11

Total liabilities to stockholders’ equity

1.41

1.37

1.44

0.95

Millay is being reviewed by several entities whose interests vary, and the company’s financial ratios are a part of the data being considered. Each of the parties listed below must recommend an action based on its evaluation of Millay’s financial position.

Archibald MacLeish Bank. The bank is processing Millay’s application for a new 5-year term note. Archibald MacLeish has been Millay’s banker for several years but must reevaluate the company’s financial position for each major transaction.

Robert Penn Warren. A brokerage firm specializing in the stock of electronics firms that are sold over-the-counter, Robert Penn Warren must decide if it will include Millay in a new fund being established for sale to Robert Penn Warren’s clients.

Working Capital Management Committee. This is a committee of Millay’s management personnel chaired by the chief operating officer. The committee is charged with the responsibility of periodically reviewing the company’s working capital position, comparing actual data against budgets, and recommending changes in strategy as needed.

Instructions

c) Discuss what the financial ratios presented in the question reveal about Millay. Support your answer by citing specific ratio levels and trends as well as the interrelationships between these ratios.

Answer each of the questions in the following unrelated situations.

b) A company had an average inventory last year of $200,000 and its inventory turnover was 5. If sales volume and unit cost remain the same this year as last and inventory turnover is 8 this year, what will average inventory have to be during the current year?

What are diversified companies? What accounting problems are related to diversified companies?

“The financial statements of a company are management’s, not the accountant’s.” Discuss the implications of this statement.

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