/*! 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} P5-2 EXCEL (Balance Sheet Preparation... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

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

1. Which of the following statements about IFRS and GAAP accounting and reporting requirements for the balance sheet is not correct?

(a) Both IFRS and GAAP distinguish between current and non-current assets and liabilities.

(b) The presentation formats required by IFRS and GAAP for the balance sheet are similar.

(c) Both IFRS and GAAP require that comparative information be reported.

(d) One difference between the reporting requirements under IFRS and those of the GAAP balance sheet is that an IFRS balance sheet may list long-term assets first.

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.

Use the information presented in BE5-14 for Martinez Corporation to compute the net cash used (provided) by financing activities.

BE5-14 (L05) Martinez Corporation engaged in the following cash transactions during 2017.

Sale of land and building $191,000

Purchase of treasury stock 40,000

Purchase of land 37,000

Payment of cash dividend 95,000

Purchase of equipment 53,000

Issuance of common stock 147,000

Retirement of bonds 100,000

Compute the net cash provided (used) by investing activities.

How does separating current assets from property, plant, and equipment in the balance sheet help analysts?

11. Should available-for-sale securities always be reported as a current asset? Explain.

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.