/*! 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} Question 11 E E5-11 (L03) EXCEL (Balance Sheet... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

E5-11 (L03) EXCEL (Balance Sheet Preparation) Presented below is the adjusted trial balance of Kelly Corporation at December 31, 2017.

Particular

Debit

Credit

Cash

\(?

Supplies

1,200

Prepaid insurance

1,000

Equipment

48,000

Accumulated depreciation – Equipment

\)4,000

Trademarks

950

Accounts payable

10,000

Salaries and wages payable

500

Unearned service revenue

2,000

Bonds payable (due 2024)

9,000

Common stock

10,000

Retained earnings

25,000

Service revenue

10,000

Salaries and wages expenses

9,000

Insurance expenses

1,400

Rent expenses

1,200

Interest expenses

900

Total

\(?

\)?

Additional information:

1. Net loss for the year was $2,500.

2. No dividends were declared during 2017.

Instructions

Prepare a classified balance sheet as of December 31, 2017.

Short Answer

Expert verified

The balance sheet of the company totals$54,000.

Step by step solution

01

Definition of Common Stock

The cluster of the securities issued by the business entity that provide voting rights to its holder is known as common stock. It is given to fulfill the capital requirement of the business entity.

02

Classified Balance Sheet

Particular

Amount $

Amount $

Assets

Current Assets

Cash (54,000 – 47,150)

$6,850

Supplies

1,200

Prepaid Insurance

1,000

Property, Plant, and equipment

Equipment

48,000

Less: Accumulated depreciation – equipment

(4,000)

44,000

Intangible assets

Trademarks

950

Total assets

54,000

Liabilities

Current liabilities

Account payable

10,000

Salaries and Wages payable

500

Unearned service revenue

2,000

Non-current liabilities

Bond payable

9,000

Total liabilities

21,500

Stockholders’ equity

Common stock

10,000

Reserves and surplus

Retained earnings (25,000 – 2,500)

22,500

Total liabilities and equity

$54,000

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

The current assets and current liabilities sections of the balance sheet of Allessandro Scarlatti Company appear as follows.

ALLESSANDRO SCARLATTI COMPANY

BALANCE SHEET PARTIAL

December 31, 2017

Cash

\(40,000

Account payable

\)61,000

Accounts receivables

\(89,000

Note payable

67,000

Less: Allowance for doubtful accounts

(7,000)

82,000

\)128,000

Inventory

171,000

Prepaid expenses

9,000

\(302,000

The following errors in the corporation’s accounting have been discovered:

1. January 2018 cash disbursements entered as of December 2017 included payments of accounts payable in the amount of \)39,000, on which a cash discount of 2% was taken.

2. The inventory included \(27,000 of merchandise that had been received at December 31 but for which no purchase invoices had been received or entered. Of this amount, \)12,000 had been received on consignment; the remainder was purchased f.o.b. destination, terms 2/10, n/30.

3. Sales for the first four days in January 2018 in the amount of \(30,000 were entered in the sales journal as of December 31, 2017. Of these, \)21,500 were sales on account and the remainder were cash sales.

4. Cash, not including cash sales, collected in January 2018 and entered as of December 31, 2017, totaled \(35,324. Of this amount, \)23,324 was received on account after cash discounts of 2% had been deducted; the remainder represented the proceeds of a bank loan.

Instructions

(a) Restate the current assets and current liabilities sections of the balance sheet in accordance with good accounting practice. (Assume that both accounts receivable and accounts payable are recorded gross.)

(b) State the net effect of your adjustments on Allessandro Scarlatti Company’s retained earnings balance.

What are the major limitations of the balance sheet as a source of information?

Presented below is a condensed version of the comparative balance sheets for Zubin Mehta Corporation for the last two years at December 31.

2017

2016

Cash

\(177,000

\)78,000

Accounts receivables

180,000

185,000

Investment

52,000

74,000

Equipment

298,000

240,000

Accumulated depreciation

(106,000)

(89,000)

Current liabilities

134,000

151,000

Common stock

160,000

160,000

Retained earnings

307,000

177,000

Additional information:

Investments were sold at a loss of \(10,000; no equipment was sold; cash dividends paid were \)30,000; and net income was $160,000.

Instructions

(a) Prepare a statement of cash flows for 2017 for Zubin Mehta Corporation.

(b) Determine Zubin Mehta Corporation’s free cash flow.

Grant Wood Corporation’s balance sheet at the end of 2016 included the following items.

Current assets (\(Cash 82,000)

\)235,000

Current liabilities

\(150,000

Land

30,000

Bond payable

100,000

Building

120,000

Common stock

180,000

Equipment

90,000

Retained earnings

44,000

Accumulated depreciation – Building

(30,000)

Accumulated depreciation – Equipment

(11,000)

Patents

40,000

Total

\)474,000

Total

\(474,000

The following information is available for 2017.

1. Net income was \)55,000.

2. Equipment (cost \(20,000 and accumulated depreciation \)8,000) was sold for \(10,000.

3. Depreciation expense was \)4,000 on the building and \(9,000 on equipment.

4. Patent amortization was \)2,500.

5. Current assets other than cash increased by \(29,000. Current liabilities increased by \)13,000.

6. An addition to the building was completed at a cost of \(27,000.

7. A long-term investment in stock was purchased for \)16,000.

8. Bonds payable of \(50,000 were issued.

9. Cash dividends of \)30,000 were declared and paid.

10. Treasury stock was purchased at a cost of $11,000.

Instructions

(Show only totals for current assets and current liabilities.)

(a) Prepare a statement of cash flows for 2017.

(b) Prepare a balance sheet at December 31, 2017.

Keyser Beverage Company reported the following items in the most recent year.

Net income $40,000

Dividends paid 5,000

Increase in accounts receivable 10,000

Increase in accounts payable 7,000

Purchase of equipment (capital expenditure) 8,000

Depreciation expense 4,000

Issue of notes payable 20,000

Compute net cash provided by operating activities, the net change in cash during the year, and free cash flow.

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.