Question

In: Accounting

The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account...

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 depreciation—buildings $ 164,000
Equipment 269,000
Accumulated depreciation—equipment 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:

  1. The short-term investments account includes $22,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 $ 229,000
b. Allowance for uncollectible accounts—trade 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
  1. 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.
  2. 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.
  3. Six hundred thousand shares of no par common stock are authorized, of which 280,000 shares have been issued and are outstanding.
  4. 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.)

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 depreciation—buildings $ 164,000
Equipment 269,000
Accumulated depreciation—equipment 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:

  1. The short-term investments account includes $22,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 $ 229,000
b. Allowance for uncollectible accounts—trade 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
  1. 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.
  2. 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.
  3. Six hundred thousand shares of no par common stock are authorized, of which 280,000 shares have been issued and are outstanding.
  4. 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.)

Solutions

Expert Solution


Related Solutions

The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account...
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 depreciation—buildings $ 164,000 Equipment 269,000 Accumulated depreciation—equipment 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...
The following is the ending balances of accounts at June 30, 2018 for Excell Company. Account...
The following is the ending balances of accounts at June 30, 2018 for Excell Company. Account Title Debits Credits Cash $ 121,000 Short-term investments 103,000 Accounts receivable 318,000 Prepaid expenses 70,000 Land 113,000 Buildings 358,000 Accumulated depreciation—buildings $ 179,000 Equipment 284,000 Accumulated depreciation—equipment 139,000 Accounts payable 192,000 Accrued expenses 64,000 Notes payable 138,000 Mortgage payable 320,000 Common stock 290,000 Retained earnings 45,000 Totals $ 1,367,000 $ 1,367,000 Additional information: The short-term investments account includes $37,000 in U.S. treasury bills purchased...
Balance Sheet:   The following is the ending balances of accounts at June 30, 2017 for WorkBee...
Balance Sheet:   The following is the ending balances of accounts at June 30, 2017 for WorkBee Company. Account Title Debits Credits Cash 148,000 Accounts receivable 280,000 Prepaid expenses 35,000 Land 72,000 Buildings 320,000 Accumulated depreciation—buildings 160,000 Investments 265,000 Salaries Payable 120,000 Accounts payable 173,000 Deferred Revenue 45,000 Notes payable 100,000 Mortgage payable 250,000 Common stock 100,000 Retained earnings 172,000 Totals 1,120,000 1,120,000 Additional Information: 1. The accounts receivable account consists of the following: a. Amounts owed by customers $225,000 b....
Lopez Manufacturing Company had the following account balances for the quarter ending June 30, unless otherwise...
Lopez Manufacturing Company had the following account balances for the quarter ending June 30, unless otherwise noted:       Work-in-process inventory (April 1)                $ 149,300       Work-in-process inventory (March 31)               181,700       Finished goods inventory (January 1)                 550,000       Finished goods inventory (March 31)                 513,000       Direct materials used                                           391,000       Indirect materials used                                          96,000       Direct manufacturing labor                                 494,000       Indirect manufacturing labor                               212,000       Property taxes on manufacturing plant building   35,700       Salespersons' company car costs                           19,000       Depreciation of manufacturing equipment          287,200       Depreciation of office equipment                        137,400       Miscellaneous plant overhead                             133,100       Plant utilities                                                        129,000       General office expenses                                       301,000       Marketing distribution costs                                  51,800 Required: a.   Prepare a...
The following is the ending balances of accounts at December 31, 2021, for the Weismuller Publishing Company.
The following is the ending balances of accounts at December 31, 2021, for the Weismuller Publishing Company.Account TitleDebitsCreditsCash$69,000Accounts receivable164,000Inventory287,000Prepaid expenses152.000Equipment324,000Accumulated depreciation$112,000Investments144,000Accounts payable62,000Interest payable22,000Deferred revenue82,000Income taxes payable32,000Notes payable210,000Allowance for uncollectible accounts18,000Common stock402,000Retained earnings200,000Totals$1,140,000$1,140,000Additional information: 1. Prepaid expenses include $124,000 paid on December 31, 2021, for a two-year lease on the building that houses both the administrative offices and the manufacturing facility. 2. Investments include $32,000 in Treasury bills purchased on November 30, 2021. The bills mature on January 30, 2022. The remaining $112,000...
The following is the ending balances of accounts at December 31, 2021, for the Weismuller Publishing...
The following is the ending balances of accounts at December 31, 2021, for the Weismuller Publishing Company. Account Title Debits Credits Cash $ 105,000 Accounts receivable 200,000 Inventory 305,000 Prepaid expenses 188,000 Equipment 360,000 Accumulated depreciation $ 130,000 Investments 180,000 Accounts payable 80,000 Interest payable 40,000 Deferred revenue 100,000 Income taxes payable 50,000 Notes payable 300,000 Allowance for uncollectible accounts 36,000 Common stock 420,000 Retained earnings 182,000 Totals $ 1,338,000 $ 1,338,000 Additional information: Prepaid expenses include $160,000 paid on...
The following is the ending balances of accounts at December 31, 2021, for the Weismuller Publishing...
The following is the ending balances of accounts at December 31, 2021, for the Weismuller Publishing Company.Account TitleDebitsCreditsCash$83,000Accounts receivable178,000Inventory294,000Prepaid expenses166,000Equipment338,000Accumulated depreciation$119,000Investments158,000Accounts payable69,000Interest payable29,000Deferred revenue89,000Income taxes payable39,000Notes payable245,000Allowance for uncollectible accounts25,000Common stock409,000Retained earnings193,000Totals$1,217,000$1,217,000Additional information: 1. Prepaid expenses include $138,000 paid on December 31, 2021, for a two-year lease on the building that houses both the administrative offices and the manufacturing facility. 2. Investments include $39,000 in Treasury bills purchased on November 30, 2021. The bills mature on January 30, 2022. The remaining $119,000...
The following is the ending balances of accounts at December 31, 2021, for the Vosburgh Electronics...
The following is the ending balances of accounts at December 31, 2021, for the Vosburgh Electronics Corporation. Account Title Debits Credits Cash 69,000 Short-term investments 184,000 Accounts receivable 125,000 Long-term investments 36,000 Inventory 216,000 Receivables from employees 41,000 Prepaid expenses (for 2022) 17,000 Land 281,000 Building 1,560,000 Equipment 638,000 Patent (net) 153,000 Franchise (net) 41,000 Notes receivable 255,000 Interest receivable 13,000 Accumulated depreciation—building 621,000 Accumulated depreciation—equipment 211,000 Accounts payable 190,000 Dividends payable (payable on 1/16/2022) 11,000 Interest payable 17,000 Income...
The following is the ending balances of accounts at December 31, 2021, for the Weismuller Publishing...
The following is the ending balances of accounts at December 31, 2021, for the Weismuller Publishing Company. Account Title Debits Credits Cash $ 67,000 Accounts receivable 162,000 Inventory 286,000 Prepaid expenses 150,000 Equipment 322,000 Accumulated depreciation $ 111,000 Investments 142,000 Accounts payable 61,000 Interest payable 21,000 Deferred revenue 81,000 Income taxes payable 31,000 Notes payable 205,000 Allowance for uncollectible accounts 17,000 Common stock 401,000 Retained earnings 201,000 Totals $ 1,129,000 $ 1,129,000 Additional information: Prepaid expenses include $122,000 paid on...
The following is the ending balances of accounts at December 31, 2021, for the Weismuller Publishing...
The following is the ending balances of accounts at December 31, 2021, for the Weismuller Publishing Company. Account Title Debits Credits Cash $ 103,000 Accounts receivable 198,000 Inventory 304,000 Prepaid expenses 186,000 Equipment 358,000 Accumulated depreciation $ 129,000 Investments 178,000 Accounts payable 79,000 Interest payable 39,000 Deferred revenue 99,000 Income taxes payable 49,000 Notes payable 295,000 Allowance for uncollectible accounts 35,000 Common stock 419,000 Retained earnings 183,000 Totals $ 1,327,000 $ 1,327,000 Additional information: Prepaid expenses include $158,000 paid on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT