The following is the ending balances of accounts at June 30. 2018 for Excell Com
ID: 2335122 • Letter: T
Question
The following is the ending balances of accounts at June 30. 2018 for Excell Company. Account Title Debits Credits $ 83,000 65,000 280,000 32,000 75,000 320,000 Cash Short-term investments Accounts receivable Prepaid expenses (for the next 12 months) Land Buildings Accumulated depreciation-buildings Equipment Accumulated depreciation-equipment Accounts payable Accrued expenses Notes payable Mortgage payable Common stock Retained earnings s 160,000 265,000 120,000 173,000 45,000 100,000 250,000 100,000 172,000 $1,120,000 Totals $1,120,000o Additional Information: 1. The short- -term investments account includes $18,000 in U.S. treasury bills purchased in May. The bills mature in July 2. The accounts receivable account consists of the following a. Amounts owed by customers b. Allowance for c. Nontrade note receivable (due in three years) d. Interest receivable on note (due in four months) $225,000 (15,000) 65,000 5,000 $280,000 uncollectible accounts-trade customers Total 3. The notes payable account consists of two notes of $50,000 each. One note is due on September 30, 2018, and the other is due on November 30, 2019. 4. The mortgage payable is payable in semiannual installments of $5,000 each plus interest. The next payment is due on October 31, 2018. 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 is holding for investment purposes. Required Prepare a classified balance sheet for the Excell Company at June 30, 2018.Explanation / Answer
Answer:
EXCELL COMPANY
Balance Sheet
At June 30, 2018
Assets
Current assets
Cash and cash equivalents
$101,000
Short-term investments
47,000
Accounts receivable, net of allowance
210,000
Interest receivable
5,000
Prepaid expenses
32,000
Total current assets
395,000
Investments
Note receivable
$65,000
Land held for sale
25,000
90,000
Property, plant, and equipment
Land
50,000
Buildings
320,000
Equipment
265,000
635,000
Accumulated depreciation
-280,000
Net property, plant, and equipment
355,000
Total assets
$840,000
Liabilities and Shareholders' Equity
Current liabilities
Accounts payable
$173,000
Accrued expenses
45,000
Note payable
50,000
Current maturities of long-term debt
10,000
Total current liabilities
278,000
Long-term liabilities
Note payable
50,000
Mortgage payable
240,000
Total long-term liabilities
290,000
Shareholders' equity
Common stock
100,000
Retained earnings
172,000
Total shareholders' equity
272,000
Total liabilities and shareholders' equity
$840,000
EXCELL COMPANY
Balance Sheet
At June 30, 2018
Assets
Current assets
Cash and cash equivalents
$101,000
Short-term investments
47,000
Accounts receivable, net of allowance
210,000
Interest receivable
5,000
Prepaid expenses
32,000
Total current assets
395,000
Investments
Note receivable
$65,000
Land held for sale
25,000
90,000
Property, plant, and equipment
Land
50,000
Buildings
320,000
Equipment
265,000
635,000
Accumulated depreciation
-280,000
Net property, plant, and equipment
355,000
Total assets
$840,000
Liabilities and Shareholders' Equity
Current liabilities
Accounts payable
$173,000
Accrued expenses
45,000
Note payable
50,000
Current maturities of long-term debt
10,000
Total current liabilities
278,000
Long-term liabilities
Note payable
50,000
Mortgage payable
240,000
Total long-term liabilities
290,000
Shareholders' equity
Common stock
100,000
Retained earnings
172,000
Total shareholders' equity
272,000
Total liabilities and shareholders' equity
$840,000
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.