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 | $ | 91,000 | |||||
Short-term investments | 73,000 | ||||||
Accounts receivable (net) | 288,000 | ||||||
Prepaid expenses (for the next 12 months) | 40,000 | ||||||
Land | 83,000 | ||||||
Buildings | 328,000 | ||||||
Accumulated depreciationbuildings | $ | 164,000 | |||||
Equipment | 269,000 | ||||||
Accumulated depreciationequipment | 124,000 | ||||||
Accounts payable | 177,000 | ||||||
Accrued liabilities | 49,000 | ||||||
Notes payable | 108,000 | ||||||
Mortgage payable | 210,000 | ||||||
Common stock | 140,000 | ||||||
Retained earnings | 200,000 | ||||||
Totals | $ | 1,172,000 | $ | 1,172,000 | |||
Additional information:
- The short-term investments account includes $22,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 | $ | 229,000 | |
b. | Allowance for uncollectible accountstrade customers | (12,000 | ) | |
c. | Nontrade notes receivable (due in three years) | 69,000 | ||
d. | Interest receivable on notes (due in four months) | 2,000 | ||
Total | $ | 288,000 | ||
- The notes payable account consists of two notes of $54,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 $4,200 each plus interest. The next payment is due on October 31, 2021. Interest has been properly accrued and is included in accrued expenses.
- Six hundred thousand shares of no par common stock are authorized, of which 280,000 shares have been issued and are outstanding.
- The land account includes $54,000 representing the cost of the land on which the company's office building resides. The remaining $29,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