(I ALREADY HAVE THE TEMPLET I NEED TO USE AND THE LABELS! I NEED NUMBERS)
The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account Title Debits Credits Cash $ 83,000 65,000 280,000 32,000 75,000 320,000 $ 160,000 265,000 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 120,000 173.000 45,000 100,000 250,000 100,000 172,000 $1.120.000 $1,120.000 Additional Information: 1. The short-term investments account includes $18,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 $225,000 b. Allowance for uncollectible accounts-trade customers (15,000) c. Nontrade notes receivable (due in three years) 65.000 d. Interest receivable on notes (due in four months) 5.000 Total $280.000 3. The notes payable account consists of two notes of $50,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,000 each plus interest. The next payment is due on October 31, 2021. Interest has been properly accrued and is included in accrued expenses. 5. Five hundred thousand shares of no par common stock are authorized, of which 200,000 shares have been issued and are outstanding. 6. The land account includes $50,000 representing the cost of the land on which the company's office building resides. The remaining $25,000 is the cost of land that the company holding for investment purposes. Required: Prepare a classified balance sheet for the Excell Company at June 30, 2021. Include headings for each classification, as well as titles for each classification's subtotal. An example of a classified balance sheet can be found in the Concept Review Exercise at the end of Part A of this chapter. COMPANY Balance Sheet At June 30, 2021 Assets Current assets: Cash and cash equivalents Short-term investments Accounts receivable, net of allowance for uncollectible accounts of $15.000 Interest receivable Prepaid expenses Total current assets Investments: Notes receivable Land held for sale Property, plant, and equipment: Land Buildings Equipment Less: Accumulated depreciation-buildings Less: Accumulated depreciation-equipment Net property, plant, and equipment Total assets Liabilities and Shareholders' Equity Current liabilities: Accounts payable Accrued liabilities Notes payable Current maturities of long-term debt Total current liabilities Long-term liabilities: Notes payable Mortgage payable Total long-term liabilities Total liabilities Shareholders' equity: Common stock, no par value; 500,000 shares authorized; 200,000 shares issued and outstanding Retained earnings Total shareholders' equity Total liabilities and shareholders' equity
