Sowed 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, Credits $ Debits 85,000 67,000 282,000 34,000 77,000 322.000 $ 161,000 266,000 Account Title Cash Short-term investments Accounts receivable (net) Prepaid expenses (for the next 12 months) Land Buildings Accumulated depreciation-buildings Equipment Accumulated depreciation equipment Accounts payable Accrued liabilities Notes payable Mortgage payable Common stock Retained earnings Totals 121,000 174,000 46,000 102,000 240,000 110,000 179,800 $1,133,000 $1,133,000 Additional information: 1. The short-term investments account includes $19.000 in U.S. treasury bills purchased in May. The bills 2. The accounts receivable account consists of the following: a. Amounts owed by customers b. Allowance for uncollectible accounts-trade customers C. Nontrade notes receivable (due in three years) d. Interest receivable on notes (due in four months) Total $226,000 (12,000) 66,000 2,000 $282,000 The notes payable account consists of two notes of $51,000 each. One note is due on September 3 November 30, 2022 The mortgage payable is a loan payable to the bank in semiannual installments of $4,800 each plu due on October 31, 2021. Interest has been properly accrued and is included in accrued expenses. 1 of 5 BE