Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 | $ | 107,000 | |||||
Short-term investments | 89,000 | ||||||
Accounts receivable (net) | 304,000 | ||||||
Prepaid expenses (for the next 12 months) | 56,000 | ||||||
Land | 99,000 | ||||||
Buildings | 344,000 | ||||||
Accumulated depreciationbuildings | $ | 172,000 | |||||
Equipment | 277,000 | ||||||
Accumulated depreciationequipment | 132,000 | ||||||
Accounts payable | 185,000 | ||||||
Accrued liabilities | 57,000 | ||||||
Notes payable | 124,000 | ||||||
Mortgage payable | 250,000 | ||||||
Common stock | 220,000 | ||||||
Retained earnings | 136,000 | ||||||
Totals | $ | 1,276,000 | $ | 1,276,000 | |||
Additional information:
- The short-term investments account includes $30,000 in U.S. treasury bills purchased in May. The bills mature in July, 2021.
- The accounts receivable account consists of the following:
a. | Amounts owed by customers | $ | 247,000 | |
b. | Allowance for uncollectible accountstrade customers | (27,000 | ) | |
c. | Nontrade notes receivable (due in three years) | 77,000 | ||
d. | Interest receivable on notes (due in four months) | 7,000 | ||
Total | $ | 304,000 | ||
- The notes payable account consists of two notes of $62,000 each. One note is due on September 30, 2021, and the other is due on November 30, 2022.
- 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.
- Nine hundred thousand shares of no par common stock are authorized, of which 440,000 shares have been issued and are outstanding.
- The land account includes $62,000 representing the cost of the land on which the company's office building resides. The remaining $37,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.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started