Question

In: Accounting

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:

  1. Purchased merchandise on account for $610,000.
  2. Sold merchandise that cost $450,000 for $950,000 on account.
  3. Sold for $275,000 cash merchandise that had cost $172,000.
  4. Sold merchandise for $220,000 to credit card customers. The merchandise had cost $108,000. The credit card company charges a 4 percent fee.
  5. Collected $680,000 cash from accounts receivable.
  6. Paid $640,000 cash on accounts payable.
  7. Paid $151,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 $90,000 to J. Parks. The note had an 9 percent interest rate and a one-year term to maturity.
  10. Wrote off $8,100 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, 2018 (see item 9).

Required

  1. Organize the transaction data in accounts under an accounting equation.
  2. Prepare an income statement, a statement of changes in stockholders’ equity, a balance sheet, and a statement of cash flows for 2018
TILE, ETC., INC.
Statement of Cash Flows
For the Year Ended December 31, 2018
Cash flows from operating activities
Inflow from customers
Outflow for expenses
Outflow for inventory
not attempted
Net cash flow from operating activities
Cash flows from investing activities
Outflow for notes receivableselected answer correct (90,000)selected answer correct
not attempted 0selected answer correct
Net cash flows from investing activities (90,000)
Cash flows from financing activities 0selected answer correct
Net change in cash 1,232,700
Plus: Beginning cash balanceselected answer correct 140,000selected answer correct
Ending cash balance $1,372,700

What's cash inflow from customers, outflow inventory, and outflow expenses

Solutions

Expert Solution



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 $ 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, 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, 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 unadjusted trial balance of Marin Inc. at December 31, 2017, is as follows: Debit Credit...
The unadjusted trial balance of Marin Inc. at December 31, 2017, is as follows: Debit Credit Cash $17,340 Accounts Receivable 106,100 Allowance for Doubtful Accounts $3,670 Inventory 61,700 Prepaid Insurance 4,599 Bond Investment at Amortized Cost 50,400 Land 28,100 Buildings 152,700 Accumulated Depreciation—Buildings 6,045 Equipment 34,800 Accumulated Depreciation—Equipment 5,800 Goodwill 16,750 Accounts Payable 101,100 Bonds Payable (20-year, 7%) 168,000 Common Shares 120,500 Retained Earnings 61,184 Sales Revenue 190,500 Rent Revenue 11,100 Advertising Expense 23,100 Supplies Expense 10,600 Purchases 97,900 Purchase...
The Sage Corporation prepared, for 2017 and 2016, the following balance sheet data: December 31 2017...
The Sage Corporation prepared, for 2017 and 2016, the following balance sheet data: December 31 2017 2016 Cash .................................... $   87,375 $   63,750 Available-for-sale securities (not cash equivalents) ......................... 17,250 105,000 Accounts receivable ..................... 90,000 86,250 Merchandise inventory ................... 187,500 163,500 Prepaid insurance ....................... 1,125 1,500 Land, buildings, and equipment ......... 1,378,875 1,087,500 Accumulated depreciation ................ (558,750) (498,750) Total ................................. $1,203,375 $1,008,750 Accounts payable ........................ $ 153,375 $ 236,250 Salaries payable ........................ 18,750 26,250 Notes payable--bank (current) ........... 37,500 150,000...
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