Question

In: Accounting

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 $330,000 cash merchandise that had cost $194,000. 4. Sold merchandise for $275,000 to credit card customers. The merchandise had cost $130,000. The credit card company charges a 3 percent fee. 5. Collected $790,000 cash from accounts receivable. 6. Paid $695,000 cash on accounts payable. 7. Paid $162,000 cash for selling and administrative expenses. 8. Collected cash for the full amount due from the credit card company (see item 4). 9. Loaned $67,000 to J. Parks. The note had an 6 percent interest rate and a one-year term to maturity. 10. Wrote off $9,200 of accounts as uncollectible. 11. 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, 2017 (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 2017. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Statement of Cash Flows, and Balance Sheet only: Items to be deducted must be indicated with a minus sign.) b. Compute the net realizable value of accounts receivable at December 31, 2017. 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

a. In the books of Tile Etc. Inc.

Transaction/ Event Account Titles Debit Credit
$ $
1. Inventory 665,000
Accounts Payable 665,000
2. Accounts Receivable 1,060,000
Sales Revenue 1,060,000
2. Cost of Goods Sold 505,000
Inventory 505,000
3. Cash 330,000
Sales Revenue 330,000
3. Cost of Goods Sold 194,000
Inventory 194,000
4. Accounts Receivable 266,750
Credit Card Expense 8,250
Sales Revenue 275,000
4. Cost of Goods Sold 130,000
Inventory 130,000
5. Cash 790,000
Accounts Receivable 790,000

Contd.

6. Accounts Payable 695,000
Cash 695,000
7. Selling and Administrative Expense 162,000
Cash 162,000
8. Cash 266,750
Accounts Receivable 266,750
9. Note Receivable 67,000
Cash 67,000
10. Allowance for Doubtful Accounts 9,200
Accounts Receivable 9,200
11. a. Uncollectible Accounts Expense 13,350
Allowance for Doubtful Accounts 13,350
b. Interest Receivable 2,345
Interest Revenue 2,345

Tile Etc. Inc.

Income Statement

For the year ended December 31, 2017

Sales Revenue $ 1,665,000
Cost of Goods Sold 829,000
Gross Profit $ 836,000
Operating Expenses
Selling and Administrative Expense 162,000
Credit Card Expense 8,250
Uncollectible Accounts Expense 13,350
Total Operating Expenses 183,600
Operating Income 652,400
Interest Revenue 2,345
Net Income 654,745

Tile Etc Inc.

Statement of Changes in Stockholders' Equity

For the year ended December 31, 2017

Common Stock $ 535,000
Retained Earnings 122,500
Total Stockholders' Equity, December 31, 2016 $ 657,500
Add: Net Income for the period 654,745
Total Stockholders' Equity, December 31, 2017 $ 1,312,245

Tile Etc. Inc.

Balance Sheet

December 31, 2017

Assets $ Liabilities and Stockholders' Equity $
Cash 657,750 Accounts Payable 82,000
Accounts Receivable 402,800
Allowance for Doubtful Accounts (30,650) 372,150 Stockholders' Equity 1,312,245
Inventory 295,000
Note Receivable 67,000
Interest Receivable 2,345
Total Assets 1,394,245 Total Liabilities and Stockholders' Equity 1,394,245

b. Net realizable value of accounts receivable at December 31, 2017: $ 372,150


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, 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 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...
The following is a partial trial balance for General Lighting Corporation as of December 31, 2016:...
The following is a partial trial balance for General Lighting Corporation as of December 31, 2016:   Account Title Debits Credits   Sales revenue 3,200,000   Interest revenue 97,000   Loss on sale of investments 31,000   Cost of goods sold 1,360,000   Loss from write-down of inventory due to obsolescence 370,000   Selling expenses 470,000   General and administrative expenses 235,000   Interest expense 96,000 300,000 shares of common stock were outstanding throughout 2016. Income tax expense has not yet been recorded. The income tax rate is 40%....
The following is a partial trial balance for General Lighting Corporation as of December 31, 2016:...
The following is a partial trial balance for General Lighting Corporation as of December 31, 2016:   Account Title Debits Credits   Sales revenue 2,550,000   Interest revenue 84,000   Loss on sale of investments 24,500   Cost of goods sold 1,230,000   Loss from write-down of inventory due to obsolescence 240,000   Selling expenses 340,000   General and administrative expenses 170,000   Interest expense 83,000 300,000 shares of common stock were outstanding throughout 2016. Income tax expense has not yet been recorded. The income tax rate is 40%....
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT