Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 3-5 (Algo) Balance sheet preparation [LO3-2, 3-3] The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account Title

Problem 3-5 (Algo) Balance sheet preparation [LO3-2, 3-3]

The following is the ending balances of accounts at June 30, 2021, for Excell Company.

Account Title Debits Credits
Cash $ 107,000
Short-term investments 89,000
Accounts receivable (net) 304,000
Prepaid expenses (for the next 12 months) 56,000
Land 99,000
Buildings 344,000
Accumulated depreciationbuildings $ 172,000
Equipment 277,000
Accumulated depreciationequipment 132,000
Accounts payable 185,000
Accrued liabilities 57,000
Notes payable 124,000
Mortgage payable 250,000
Common stock 220,000
Retained earnings 136,000
Totals $ 1,276,000 $ 1,276,000

Additional information:

  1. The short-term investments account includes $30,000 in U.S. treasury bills purchased in May. The bills mature in July, 2021.
  2. The accounts receivable account consists of the following:

a. Amounts owed by customers $ 247,000
b. Allowance for uncollectible accountstrade customers (27,000 )
c. Nontrade notes receivable (due in three years) 77,000
d. Interest receivable on notes (due in four months) 7,000
Total $ 304,000
  1. The notes payable account consists of two notes of $62,000 each. One note is due on September 30, 2021, and the other is due on November 30, 2022.
  2. The mortgage payable is a loan payable to the bank in semiannual installments of $5,000 each plus interest. The next payment is due on October 31, 2021. Interest has been properly accrued and is included in accrued expenses.
  3. Nine hundred thousand shares of no par common stock are authorized, of which 440,000 shares have been issued and are outstanding.
  4. The land account includes $62,000 representing the cost of the land on which the company's office building resides. The remaining $37,000 is the cost of land that the company is holding for investment purposes.

Required: Prepare a classified balance sheet for the Excell Company at June 30, 2021. (Amounts to be deducted should be indicated by a minus sign.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ethics And Auditing

Authors: Tom Campbell, Keith Houghton

1st Edition

1920942254, 978-1920942250

More Books

Students also viewed these Accounting questions

Question

Report to the class on the achievements of Evangelista Torricelli?

Answered: 1 week ago

Question

Prepare a constructive performance appraisal.

Answered: 1 week ago

Question

List the advantages of correct report formatting.

Answered: 1 week ago