/*! 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

Case 4: Amazon.com The incredible growth of Amazon.com has put fear into the hearts of traditional retailers. Amazon’s stock price has soared to amazing levels. However, it is often pointed out in the financial press that it took the company several years to report its first profit. The following financial information is taken from a recent annual report.

(\( in millions)

Current year

Prior year

Current assets

\)31,327

$24,625

Total assets

54,505

40,159

Current liabilities

28,089

22,980

Total liabilities

43,764

30,413

Cash provided by operations

6,842

5,475

Capital expenditures

4,893

3,444

Dividend paid

0

0

Net income (loss)

(241)

274

Sales

88,988

74,452

Instructions

(a) Calculate free cash flow for Amazon for the current and prior years, and discuss its ability to finance expansion from internally generated cash. Thus far Amazon has avoided purchasing large warehouses. Instead, it has used those of others. It is possible, however, that in order to increase customer satisfaction, the company may have to build its own warehouses. If this happens, how might your impression of its ability to finance expansion change?

(b) Discuss any potential implications of the change in Amazon’s cash provided by operations from the prior year to the current year.

IFRS5-4 Rainmaker Company prepares its financial statements in accordance with IFRS. In 2017, Rainmaker recorded the following revaluation adjustments related to its buildings and land: The company’s building increased in value by \(200,000; its land declined by \)35,000. How will these revaluation adjustments affect Rainmaker’s statement of financial position? Will the reporting differ under GAAP? Explain.

Case 3: Deere & Company Presented below is the SEC-mandated disclosure of contractual obligations provided by Deere & Company in a recent annual report. Deere & Company reported current assets of \(50,060 and total current liabilities of \)21,394 at year-end. (All dollars are in millions.)

Aggregate Contractual Obligations

The payment schedule for the company’s contractual obligations at year-end in millions of dollars is as follows:

Total

Less than 1 year

1-3 Years

4 and 5 Years

More than 5 Years

Debt

Equipment Operations

\( 5,091

\) 434

\( 270

\)775

\( 3,612

Financial services

31,692

9,962

11,477

6,578

3,675

Total

36,783

10,396

11,747

7,353

7,287

Interest on debt

4,777

609

1,069

745

2,354

Account payable

2,743

2,611

90

39

3

Capital lease

87

39

42

4

2

Purchase obligations

3,007

2,970

37

0

0

Operating leases

371

121

134

70

46

Total

\) 47,768

\( 16,746

\)13,119

8,211

9,692

Instructions

(a) Compute Deere & Company’s working capital and current ratio (current assets ÷ current liabilities) with and without the off-balance-sheet contractual obligations reported in the schedule.

(b) Briefly discuss how the information provided in the contractual obligation disclosure would be useful in evaluating Deere & Company for loans (1) due in one year and (2) due in five years.

Refer to the definition of assets on page 204. Discuss how a leased building might qualify as an asset of the lessee (tenant) under this definition.

What is working capital? How does working capital relate to the operating cycle?

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.