Question

In: Accounting

Solve this problem using a worksheet with 6 pairs of columns. 1. Accounts of Unnamed Company...

Solve this problem using a worksheet with 6 pairs of columns.

1. Accounts of Unnamed Company at December 31, 2019:

Accounts Payable 55,200
Accounts Receivable 75,000
Accumulated Depreciation - PPE 282,000
Allowance for Uncollectible Accounts Receivable 2,600

Allowance for Uncollectible Notes Receivable 3,200

Bonds Payable 340,000
Capital Stock 400,000
Cash 48,000
Depreciation Expense 76,000
Discount on Bonds Payable 3,000
Dividends 10,000
Dividends Payable 1,000
Insurance Expense 37,000
Interest Revenue 8,500
Merchandise Inventory (1/1) 14,700
Miscellaneous Expense 6,700
Mortgage Payable 240,000
Notes Payable 143,000
Notes Receivable 82,000
Paid-in Capital in Excess of Par 200,000
Purchases 118,000
Property, Plant and Equipment 1,543,000
Retained Earnings 70,000
Sales Returns and Allowances 5,000
Sales Revenue 398,500
Supplies Inventory 7,600
Wages Expense 127,000

Prepare an Unadjusted Trial Balance with these accounts using their “natural balances” in the first pair of columns on your worksheet, one labeled “debit” and

the other labeled “credit.” Accounts should appear in the following order:

Assets with contra-assets, from current to long-term,
then Liabilities with contra-liabilities, from current to long-term,
then permanent (or real) Equity accounts,
then temporary (or nominal) accounts (mostly expenses and revenues).

Refer to the Advanced Company example for a review of a company using the periodic inventory method. Note that the Advanced Company example has fewer accounts than this problem and has a net loss.

2. After the company's trial balance was prepared, some adjustments were identified. Post these adjusting entries in the next set of two columns. The adjustments may require adding new accounts out of order at the bottom of the worksheet.

a. A patent had been purchased for $6,500 by issuing a Note Payable on December 23. Neither the patent nor the note had been posted yet.
b. A review of the insurance policy indicates that $6,000 of the insurance already paid for covers the following fiscal year.

c. Wages of $9,000 had been earned by employees but not paid by December 31.
d. Sales Revenue includes $11,500 that had been received from a customer to pay for goods that will not be delivered until January 15.
e. A count of the supplies inventory shows that only $2,000 of supplies remains at the end of the year.

3.
“Adjusted Trial Balance.”

Show the adjusted account balances in the next pair of columns labeled

4. Extend the income statement information to the next pair of columns along with the value of the beginning inventory. Label these columns "Income Statement." These columns will hold the information that will be used to prepare the Income Summary journal entries and the Income Statement. The Merchandise Inventory at December 31 was $38,500. Refer to the Advanced Company problem to see how to handle the beginning and ending inventory values on your worksheet. The two columns will not balance. The difference will equal the income or loss.

5. This company uses a periodic rather than a perpetual inventory. Therefore, the worksheet impact of updating the inventory will be seen in the Income Statement set of columns. The beginning inventory will be treated as an expense considered in figuring income. The ending inventory will be treated as a reduction of expense. The ending inventory will also appear among the assets listed in the Balance Sheet set of columns. This will assure that the income statement columns include all the parts of the Cost of Goods Sold Section that later appears on the Income Statement.

6. Extend the Retained Earnings Statement information (beginning retained earnings, net income, dividends) to the next two columns labeled "Retained Earnings. The difference between the two columns will equal the ending Retained earnings balance.

7. Extend all remaining permanent account totals to the final set of columns which will be the post-closing trial balance, or the Balance Sheet information. These columns should balance. Then write out the closing entries in good journal entry form. You don't need to write out the adjusting entries.

Solutions

Expert Solution


Related Solutions

Problem 4-3A The completed financial statement columns of the worksheet for Bray Company are shown as...
Problem 4-3A The completed financial statement columns of the worksheet for Bray Company are shown as follows: BRAY COMPANY Worksheet For the Year Ended December 31, 2017 Income Statement Balance Sheet Account No. Account Titles Dr. Cr. Dr. Cr. 101 Cash 9,100 112 Accounts Receivable 10,700 130 Prepaid Insurance 2,600 157 Equipment 23,500 158 Accumulated Depreciation—Equip. 4,700 201 Accounts Payable 8,900 212 Salaries and Wages Payable 2,300 301 Owner’s Capital 19,900 306 Owner’s Drawings 11,800 400 Service Revenue 59,600 622...
Question 1 The adjusted trial balance columns of the worksheet for Martinez Company are as follows....
Question 1 The adjusted trial balance columns of the worksheet for Martinez Company are as follows. MARTINEZ COMPANY Worksheet (partial) For the Month Ended April 30, 2017 Adjusted Trial Balance Account Titles Dr. Cr. Cash 8,850 Accounts Receivable 7,769 Prepaid Rent 2,478 Equipment 23,235 Accumulated Depreciation—Equip. 5,386 Notes Payable 5,842 Accounts Payable 4,831 Share Capital—Ordinary 24,145 Retained Earnings 4,224 Dividends 3,287 Service Revenue 12,464 Salaries and Wages Expense 9,695 Rent Expense 842 Depreciation Expense 736 Interest Expense 22 Interest Payable...
1. The completed financial statement columns of the worksheet for Blossom Company are shown as follows:...
1. The completed financial statement columns of the worksheet for Blossom Company are shown as follows: Blossom Company Worksheet For the Year Ended December 31, 2020 Income Statement Balance Sheet Account No. Account Titles Dr. Cr. Dr. Cr. 101 Cash 9,000 112 Accounts Receivable 10,600 130 Prepaid Insurance 2,800 157 Equipment 24,100 158 Accumulated Depreciation—Equip. 4,300 201 Accounts Payable 8,900 212 Salaries and Wages Payable 2,300 301 Owner’s Capital 20,000 306 Owner’s Drawings 10,300 400 Service Revenue 60,100 622 Maintenance...
Problem 4-2A (Part Level Submission) The adjusted trial balance columns of the worksheet for Monty Company...
Problem 4-2A (Part Level Submission) The adjusted trial balance columns of the worksheet for Monty Company are as follows. Monty Company Worksheet For the Year Ended December 31, 2019 Adjusted Trial Balance Account No. Account Titles Dr. Cr. 101 Cash 5,000 112 Accounts Receivable 10,800 126 Supplies 1,800 130 Prepaid Insurance 1,800 157 Equipment 27,400 158 Accumulated Depreciation—Equipment 5,200 200 Notes Payable 14,600 201 Accounts Payable 6,300 212 Salaries and Wages Payable 2,600 230 Interest Payable 500 311 Common Stock...
E4.1 (LO 1, 3) The trial balance columns of the worksheet for Dixon Company at June...
E4.1 (LO 1, 3) The trial balance columns of the worksheet for Dixon Company at June 30, 2020, are as follows. Dixon Company Worksheet For the Month Ended June 30, 2020 Trial Balance Account Titles Dr. Cr. Cash 2,320 Accounts Receivable 2,440 Supplies 1,880 Accounts Payable 1,120 Unearned Service Revenue 240 Owner’s Capital 3,600 Service Revenue 2,400 Salaries and Wages Expense 560 Miscellaneous Expense 160 7,360 7,360 Other data: 1. A physical count reveals $500 of supplies on hand. 2....
The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. Ayayai Company...
The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. Ayayai Company Worksheet (Partial) For the Month Ended April 30, 2019 Adjusted Trial Balance Account Titles Dr. Cr. Cash 11,500 Accounts Receivable 7,620 Prepaid Rent 2,180 Equipment 22,950 Accumulated Depreciation—Equip. 5,000 Notes Payable 5,800 Accounts Payable 4,500 Common Stock 20,500 Retained Earnings 8,550 Dividends 3,500 Service Revenue 15,500 Salaries and Wages Expense 10,800 Rent Expense 700 Depreciation Expense 600 Interest Expense 60 Interest Payable 60     Totals...
The adjusted trial balance columns of the worksheet for Martinez Company are as follows. Martinez Company...
The adjusted trial balance columns of the worksheet for Martinez Company are as follows. Martinez Company Worksheet For the Year Ended December 31, 2019 Adjusted Trial Balance Account No. Account Titles Dr. Cr. 101 Cash 5,300 112 Accounts Receivable 10,700 126 Supplies 1,600 130 Prepaid Insurance 1,900 157 Equipment 27,500 158 Accumulated Depreciation—Equipment 5,100 200 Notes Payable 14,000 201 Accounts Payable 6,100 212 Salaries and Wages Payable 2,100 230 Interest Payable 700 311 Common Stock 9,900 320 Retained Earnings 3,400...
The adjusted trial balance columns of the worksheet for Martinez Company are as follows. Martinez Company...
The adjusted trial balance columns of the worksheet for Martinez Company are as follows. Martinez Company Worksheet (Partial) For the Month Ended April 30, 2022 Adjusted Trial Balance Account Titles Dr. Cr. Cash 11,500 Accounts Receivable 7,720 Prepaid Rent 2,340 Equipment 22,700 Accumulated Depreciation—Equip. 4,500 Notes Payable 5,900 Accounts Payable 5,500 Common Stock 21,010 Retained Earnings 8,200 Dividends 3,850 Service Revenue 15,000 Salaries and Wages Expense 10,600 Rent Expense 750 Depreciation Expense 650 Interest Expense 80 Interest Payable    80...
The adjusted trial balance columns of the worksheet for Alshwer Company are as follows. ALSHWER COMPANY...
The adjusted trial balance columns of the worksheet for Alshwer Company are as follows. ALSHWER COMPANY Worksheet For the Year Ended December 31, 2017 Adjusted Trial Balance Account No. Account Titles Dr. Cr. 101 Cash 5,400 112 Accounts Receivable 11,000 126 Supplies 1,400 130 Prepaid Insurance 1,800 157 Equipment 26,500 158 Accumulated Depreciation—Equipment 5,500 200 Notes Payable 13,200 201 Accounts Payable 6,200 212 Salaries and Wages Payable 2,100 230 Interest Payable 700 311 Common Stock 10,400 320 Retained Earnings 4,900...
The adjusted trial balance columns of the worksheet for Alshwer Company are as follows. ALSHWER COMPANY...
The adjusted trial balance columns of the worksheet for Alshwer Company are as follows. ALSHWER COMPANY Worksheet For the Year Ended December 31, 2017 Adjusted Trial Balance Account No. Account Titles Dr. Cr. 101 Cash 5,400 112 Accounts Receivable 11,000 126 Supplies 1,400 130 Prepaid Insurance 1,800 157 Equipment 26,500 158 Accumulated Depreciation—Equipment 5,500 200 Notes Payable 13,200 201 Accounts Payable 6,200 212 Salaries and Wages Payable 2,100 230 Interest Payable 700 311 Common Stock 10,400 320 Retained Earnings 4,900...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT