Question

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	$	91,000
Short-term investments		73,000
Accounts receivable (net)		288,000
Prepaid expenses (for the next 12 months)		40,000
Land		83,000
Buildings		328,000
Accumulated depreciation—buildings				$	164,000
Equipment		269,000
Accumulated depreciation—equipment					124,000
Accounts payable					177,000
Accrued liabilities					49,000
Notes payable					108,000
Mortgage payable					210,000
Common stock					140,000
Retained earnings					200,000
Totals	$	1,172,000		$	1,172,000

Additional information:

1. The short-term investments account includes $22,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	$	229,000
b.	Allowance for uncollectible accounts—trade customers		(12,000	)
c.	Nontrade notes receivable (due in three years)		69,000
d.	Interest receivable on notes (due in four months)		2,000
	Total	$	288,000

3. The notes payable account consists of two notes of $54,000 each. One note is due on September 30, 2021, and the other is due on November 30, 2022.
4. The mortgage payable is a loan payable to the bank in semiannual installments of $4,200 each plus interest. The next payment is due on October 31, 2021. Interest has been properly accrued and is included in accrued expenses.
5. Six hundred thousand shares of no par common stock are authorized, of which 280,000 shares have been issued and are outstanding.
6. The land account includes $54,000 representing the cost of the land on which the company's office building resides. The remaining $29,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.)

Answer 1