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 | $ | 117,000 | |||||
Short-term investments | 99,000 | ||||||
Accounts receivable (net) | 314,000 | ||||||
Prepaid expenses (for the next 12 months) | 66,000 | ||||||
Land | 109,000 | ||||||
Buildings | 354,000 | ||||||
Accumulated depreciationbuildings | $ | 177,000 | |||||
Equipment | 282,000 | ||||||
Accumulated depreciationequipment | 137,000 | ||||||
Accounts payable | 190,000 | ||||||
Accrued liabilities | 62,000 | ||||||
Notes payable | 134,000 | ||||||
Mortgage payable | 320,000 | ||||||
Common stock | 270,000 | ||||||
Retained earnings | 51,000 | ||||||
Totals | $ | 1,341,000 | $ | 1,341,000 | |||
Additional information:
- The short-term investments account includes $35,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 | $ | 248,000 | |
b. | Allowance for uncollectible accountstrade customers | (19,000 | ) | |
c. | Nontrade notes receivable (due in three years) | 82,000 | ||
d. | Interest receivable on notes (due in four months) | 3,000 | ||
Total | $ | 314,000 | ||
- The notes payable account consists of two notes of $67,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 $6,400 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 540,000 shares have been issued and are outstanding.
- The land account includes $67,000 representing the cost of the land on which the company's office building resides. The remaining $42,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.)
rev: 01_30_2020_QC_CS-195439
Next Visit question map
Question9of10Total9 of 10
Prev
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