The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account Title Debits Credits Cash $ 97,000 Short-term investments 79,000 Accounts receivable (net) 294,000 Prepaid expenses (for the next 46,000 12 months) Land 89,000 Buildings 334,000 Accumulated depreciation- buildings $ 167,000 Equipment 272,000 Accumulated depreciation- 127,000 equipment Accounts payable Accrued liabilities Notes payable Mortgage payable Common stock Retained earnings Totals 180,000 52,000 114,000 280,000 170,000 121,000 $1,211,000 $1,211,000 Additional information: 1. The short-term investments account includes $25,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 Allowance for uncollectible accounts-trade b. customers $231,000 (18,000) Nontrade notes receivable (due in three c. years) 72,000 Interest receivable on notes (due in four d. 9,000 months) Total $294,000 3. The notes payable account consists of two notes of $57,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 $5,600 each plus interest. The next payment is due on October 31, 2021. Interest has been properly accrued and is included in accrued expenses. 5. Nine hundred thousand shares of no par common stock are authorized, of which 340,000 shares have been issued and are outstanding. 6. The land account includes $57,000 representing the cost of the land on which the company's office building resides. The remaining $32,000 is the cost of land that the company is holding for investment purposes. Current assets: Balance Sheet At June 30, 2021 Assets Total current assets Investments: Property, plant, and equipment: Net property, plant, and equipment Total assets Liabilities and Shareholders' Equity Current liabilities: Total current liabilities Long-term liabilities: Total long-term liabilities Total liabilities Shareholders' equity: Total shareholders' equity equity Total liabilities and shareholders