EXCEL (Balance Sheet Preparation) Presented below are a number of balance sheet items for Montoya, Inc., for the current year, 2017.

Goodwill

\(125,000

Accumulated depreciation - equipment

\)292,000

Payroll tax payable

177,591

Inventory

239,800

Bond payable

300,000

Rent payable (short-term)

45,000

Discount on bond payable

15,000

Income tax payable

98,362

Cash

360,000

Rent payable (long-term)

480,000

Land

480,000

Common stock, \(1 par value

200,000

Notes receivable

445,700

Preferred stock, \)10 par value

150,000

Note payable

265,000

Prepaid expenses

87,920

Account payable

490,000

Equipment

1,470,000

Retained earnings

Debt investment (trading)

121,000

Income tax receivable

97,630

Accumulated depreciation – building

270,200

Note payable (Long-term)

1,600,000

Buildings

1,640,000

Instructions

Prepare a classified balance sheet in good form. Common stock authorized was 400,000 shares, and preferred stock authorized was 20,000 shares. Assume that notes receivable and notes payable are short-term unless stated otherwise. The cost and fair value of equity investments (trading) are the same.

Short Answer

Expert verified

The balance sheet of the company totals$4,407,220.

Step by step solution

01

Definition of Note Payable

The liability of the business entity arising out of a written promise made by the business entity to repay the borrowed amount on a specified date along with interest is known as a note payable.

02

Classified Balance sheet

Particular

Amount $

Amount $

Assets

Current assets:

Cash

$360,000

Prepaid expenses

87,920

Inventory

239,800

Note receivable

445,700

Debt investment (trading)

121,000

Total current assets

1,254,420

Property, Plant and Equipment

Land

480,000

Building

$1,640,000

Less: Accumulated depreciation

(270,200)

1,369,800

Equipment

1,470,000

Less: Accumulated depreciation

(292,000)

1,178,000

Intangible assets

Goodwill

125,000

Total assets

4,407,220

Liabilities

Current liabilities

Account payable

490,000

Income tax payable

98,362

Less: Income tax receivable

(97,630)

732

Rent payable

45,000

Payroll tax payable

177,591

Note payable

265,000

Total current liabilities

978,323

Non-Current liabilities

Note payable (long-term)

1,600,000

Bond payable

300,000

Less: Discount on bond payable

(15,000)

285,000

Rent Payable

480,000

Total liabilities

3,343,323

Stockholder equity

Common shares authorized 400,000 shares

200,000

Preferred shares authorized 20,000 shares

150,000

Retained earnings

713,897

Total liabilities and shareholder’s equity

$4,407,220

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

Case 1: Uniroyal Technology Corporation

Uniroyal Technology Corporation (UTC), with corporate offices in Sarasota, Florida, is organized into three operating segments. The high-performance plastics segment is responsible for research, development, and manufacture of a wide variety of products, including orthopedic braces, graffiti-resistant seats for buses and airplanes, and a static-resistant plastic used in the central processing units of microcomputers. The coated fabrics segment manufactures products such as automobile seating, door and instrument panels, and specialty items such as waterproof seats for personal watercraft and stain-resistant, easy-cleaning upholstery fabrics. The foams and adhesives segment develops and manufactures products used in commercial roofing applications.

The following items relate to operations in a recent year.

1. Serious pressure was placed on profitability by sharply increasing raw material prices. Some raw materials increased in price 50% during the past year. Cost containment programs were instituted and product prices were increased whenever possible, which resulted in profit margins actually improving over the course of the year.

2. The company entered into a revolving credit agreement, under which UTC may borrow the lesser of \(15,000,000 or 80% of eligible accounts receivable. At the end of the year, approximately \)4,000,000 was outstanding under this agreement. The company plans to use this line of credit in the upcoming year to finance operations and expansion.

Instructions

(a) Should investors be informed of raw materials price increase, such as described in item 1? Does the fact that the company successfully met the challenge of higher prices affect the answer? Explain.

(b) How should the information in item 2 be presented in the financial statements of UTC?

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.

The net income for the year for Genesis, Inc. is \(750,000, but the statement of cash flows reports that the net cash provided by operating activities is \)640,000. What might account for the difference?

Sergey Co. has net cash provided by operating activities of \(1,200,000. Its average current liabilities for the period are \)1,000,000, and its average total liabilities are $1,500,000. Comment on the company’s liquidity and financial flexibility, given this information.

Discuss at least two situations in which estimates could affect the usefulness of the information in the balance sheet.

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