Question

In: Accounting

The following trial balance was prepared for Tile, Etc., Inc., on December 31, Year 1, after...

The following trial balance was prepared for Tile, Etc., Inc., on December 31, Year 1, after the closing entries were posted:

Account Title Debit Credit
Cash $ 125,000
Accounts Receivable 128,000
Allowance for Doubtful Accounts $ 19,500
Inventory 431,000
Accounts Payable 98,000
Common Stock 465,000
Retained Earnings 101,500
Totals $ 684,000 $ 684,000


Tile, Etc. had the following transactions in Year 2:

Purchased merchandise on account for $595,000.

Sold merchandise that cost $435,000 for $920,000 on account.

Sold for $260,000 cash merchandise that had cost $166,000.

Sold merchandise for $205,000 to credit card customers. The merchandise had cost $102,000. The credit card company charges a 3 percent fee.

Collected $650,000 cash from accounts receivable.

Paid $625,000 cash on accounts payable.

Paid $148,000 cash for selling and administrative expenses.

Collected cash for the full amount due from the credit card company (see item 4).

Loaned $75,000 to J. Parks. The note had an 6 percent interest rate and a one-year term to maturity.

Wrote off $7,800 of accounts as uncollectible.

Made the following adjusting entries:

(a) Recorded uncollectible accounts expense estimated at 1 percent of sales on account.

(b) Recorded seven months of accrued interest on the note at December 31, Year 2 (see item 9).


Required
a. Prepare general journal entries for these transactions; post the entries to T-accounts; and prepare an income statement, a statement of changes in stockholders’ equity, a balance sheet, and a statement of cash flows for Year 2.
b. Compute the net realizable value of accounts receivable at December 31, Year 2.
c. If Tile, Etc. used the direct write-off method, what amount of uncollectible accounts expense would it report on the income statement?
  

Solutions

Expert Solution

Journal Entries

Date

Account Titles

Amount Dr.

Amount Cr.

Inventory

595000

Accounts Payable

595000

Accounts Receivable

920000

Sales

920000

Cost of Goods Sold

435000

Inventory

435000

Cash

260000

Sales

260000

Cost of Goods Sold

166000

Inventory

166000

Accounts Receivable

198850

Credit Card charges

6150

Sales

205000

Cost of Goods Sold

102000

Inventory

102000

Cash

650000

Accounts Receivable

650000

Accounts Payable

625000

Cash

625000

Selling and Administrative expenses

148000

Cash

148000

Cash

198850

Accounts Receivable

198850

6% One year Notes Receivable

75000

Cash

75000

Allowances for Doubtful debts

7800

Accounts Receivable

7800

a.

Allowances for Doubtful debts

2500

Income Summary

2500

b.

Interest Receivable

3937.5

Interest Revenue

3937.5

Cash Account

Date

Account Title

Amount Dr.

Date

Account Title

Amount Cr.

Beginning Balance

125,000

Accounts Payable

625,000

Sales

260,000

Selling and Administrative expenses

148,000

Account Receivable

650,000

6% One year Notes Receivable

75,000

Account Receivable

198,850

Ending Cash balance

385,850

1,233,850

1,233,850

Account Receivable Account

Date

Account Title

Amount Dr.

Date

Account Title

Amount Cr.

Beginning Balance

128,000

Cash

650,000

Sales

920,000

Cash

198,850

Sales

198,850

Allowances for Doubtful accounts

7,800

Ending Blance

390,200

1,246,850

1,246,850

Allowances for Doubtful accounts

Date

Account Title

Amount Dr.

Date

Account Title

Amount Cr.

Accounts Receivable

7,800

Beginning Balance

19,500

Income Summary

2,500

Ending Balance

9,200

19,500

19,500

Inventory Account

Date

Account Title

Amount Dr.

Date

Account Title

Amount Cr.

Beginning Balance

431,000

Cost of Goods Sold

435,000

Accounts Payable

595,000

Cost of Goods Sold

166,000

Cost of Goods Sold

102,000

Ending Balance

323,000

1,026,000

1,026,000

Accounts Payable Account

Date

Account Title

Amount Dr.

Date

Account Title

Amount Cr.

Cash

625,000

Beginning Balance

98,000

Ending Balance

68,000

Inventory

595,000

693,000

693,000

Common stock Account

Date

Account Title

Amount Dr.

Date

Account Title

Amount Cr.

Ending Balance

465,000

Beginning Balance

465,000

Retained Earnings Account

Date

Account Title

Amount Dr.

Date

Account Title

Amount Cr.

Ending Balance

635,788

Beginning Balance

101,500

Income Summary

530,350

Interest Revenue

3,938

635,788

635,788

Cost of Goods Sold Account

Date

Account Title

Amount Dr.

Date

Account Title

Amount Cr.

Inventory

435,000

Income Summary

703,000

Inventory

166,000

Inventory

102,000

703,000

703,000

Sales Account

Date

Account Title

Amount Dr.

Date

Account Title

Amount Cr.

Income Summary

1,385,000

Account Receivable

920,000

Cash

260,000

Credit Card charges

6,150

Account Receivable

198,850

1,385,000

1,385,000

Statement of Changes of Stock holders equity

Beginning

Ending

Change

% of change

Common stock

465000

465000

0

0

Retained Earnings

101500

635787.5

534287.5

5.263916

BalanceSheet

Cash

385,850

Accounts Payable

68,000

Account Receivable

390,200

Allowances for Doubtful accounts

9,200

Interest Receivable

3,938

Common stock

465,000

Inventory

323,000

Retained Earnings

635,787.50

6% One year Notes Receivable

75,000

Total Assets

1,177,987.50

Total Liabilities

1,177,987.50


Related Solutions

The following trial balance was prepared for Tile, Etc., Inc. on December 31, 2017, after the...
The following trial balance was prepared for Tile, Etc., Inc. on December 31, 2017, after the closing entries were posted: Account Title Cash $ 140,000 Accounts receivable 131,000 Allowance for doubtful accounts $ 21,000 Inventory 437,000 Accounts payable 101,000 Common stock 480,000 Retained earnings 106,000 Tile, Etc. had the following transactions in 2018: Purchased merchandise on account for $610,000. Sold merchandise that cost $450,000 for $950,000 on account. Sold for $275,000 cash merchandise that had cost $172,000. Sold merchandise for...
The following trial balance was prepared for Tile, Etc., Inc., on December 31, 2016, after the...
The following trial balance was prepared for Tile, Etc., Inc., on December 31, 2016, after the closing entries were posted: Account Title Debit Credit Cash $ 195,000 Accounts Receivable 142,000 Allowance for Doubtful Accounts $ 26,500 Inventory 459,000 Accounts Payable 112,000 Common Stock 535,000 Retained Earnings 122,500 Totals $ 796,000 $ 796,000 Tile, Etc. had the following transactions in 2017: 1. Purchased merchandise on account for $665,000. 2. Sold merchandise that cost $505,000 for $1,060,000 on account. 3. Sold for...
The following trial balance was prepared for Tile, Etc., Inc. on December 31, 2017, after the...
The following trial balance was prepared for Tile, Etc., Inc. on December 31, 2017, after the closing entries were posted: Account Title Cash $ 110,000 Accounts receivable 125,000 Allowance for doubtful accounts $ 18,000 Inventory 425,000 Accounts payable 95,000 Common stock 450,000 Retained earnings 97,000 Tile, Etc. had the following transactions in 2018: Purchased merchandise on account for $580,000. Sold merchandise that cost $420,000 for $890,000 on account. Sold for $245,000 cash merchandise that had cost $160,000. Sold merchandise for...
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31,...
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Debits Credits Accounts payable $ 96,000 Accounts receivable $ 32,000 Accrued interest payable 28,000 Accumulated depreciation 45,000 Administrative and selling expenses 47,000 Allowance for uncollectible accounts 12,000 Capital assets 712,000 Cash 89,000 Charges for sales and services 550,000 Cost of sales and...
The Village of Seaside Pines prepared the following General Fund Trial Balance as of December 31,...
The Village of Seaside Pines prepared the following General Fund Trial Balance as of December 31, 2017, the last day of its fiscal year. Control accounts are used for budgetary entries. Debits Credits Accounts Payable $  19,000 Allowance for Uncollectible Taxes 12,000 Appropriations (Control) 494,000 Budgetary Fund Balance 5,000 Cash $175,000 Deferred Inflows—Property Taxes 38,000 Due from Capital Projects Fund 5,000 Due to Debt Service Fund 17,000 Encumbrances 63,000 Estimated Revenue (Control) 534,000 Estimated Other Financing Uses (Control) 35,000 General Government...
An inexperienced bookkeeper prepared the following trial balance for Philip Browning, M.D., as of December 31,...
An inexperienced bookkeeper prepared the following trial balance for Philip Browning, M.D., as of December 31, 20XX. You have discovered the following errors in your review of the accounting records and need to prepare a corrected trial balance. Philip Browning, M.D. Trial Balance December 31, 20XX Debit Credit Cash 17,500 Medical Supplies 600 Medical Equipment 6,000 Accounts Payable 4,000 Philip Browning, Capital 30,000 Philip Browning, Drawing 1,000 Medical Fees 7,000 Rent Expense 2,500 Salaries Expense 2,000 Utilities Expense 1,000 Miscellaneous...
The village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31,...
The village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020. the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund Debits Credits Accounts payable $ 103,000 Accounts receivable $ 25,800 Accrued interest payable 28,900 Accumulated depreciation 46,500 Administrative and selling expenses 48,500 Allowance for uncollectible accounts 12400 Capital assets 707,000 Cash 90,200 charges for sales and services 553,000 Cost of sales and...
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31,...
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Debits Credits Accounts payable $ 117,000 Accounts receivable $ 31,900 Accrued interest payable 35,100 Accumulated depreciation 53,500 Administrative and selling expenses 55,500 Allowance for uncollectible accounts 13,900 Capital assets 732,000 Cash 99,500 Charges for sales and services 579,000 Cost of sales and...
Kay Wing, Inc., prepared the following balance sheet at December 31, 20X0. Balance Sheet as of December 31, 20X0:
Kay Wing, Inc., prepared the following balance sheet at December 31, 20X0. Balance Sheet as of December 31, 20X0:Cash $ 65,000Accounts receivable 37,000Inventory 70,000Long-term investments 20,000Land 39,000Plant and equipment (net) 109,000Total assets $ 340,000Accounts payable $ 33,000Taxes payable 4,000Bonds payable 80,000Capital stock 90,000Retained earnings 133,000Total liabilities and stockholders’ equity $ 340,000The following occurred during 20X1.1. $35,000 Note payable was issued. 2. Land was purchased for $50,000 3. Bonds payable (maturing in 20X5) in the amount of $30,000 were retired by...
December 31, 2018 Trial Balance of Target Inc.                                  &nbsp
December 31, 2018 Trial Balance of Target Inc.                                                                                                                                             DEBITS CREDITS Equipment $192,000 Accumulated Depreciation $60,000 Notes Payable        $90,000 Admission Revenue $380,000                  Advertising Expense $13,680 Salaries Expense   $57,600 Interest Expense   $1,400                                                                                                                                                                                                                                           FACTS:                                                                                                                                  1. Equipment has an estimated useful life of 16 years and a salvage value of $40,000. (Target Inc. uses straight line)                                                                                                                                   2. The note payable is a 90-day note given to the bank on October 20th and bears interest at 10% (assume a 360 day...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT