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

Account Title

Cash

$

200,000

Accounts receivable

143,000

Allowance for doubtful accounts

$

27,000

Inventory

461,000

Accounts payable

113,000

Common stock

540,000

Retained earnings

124,000

Tile, Etc. had the following transactions in 2018:

1.Purchased merchandise on account for $670,000.

2.Sold merchandise that cost $510,000 for $1,070,000 on account.

3.Sold for $335,000 cash merchandise that had cost $196,000.

4.Sold merchandise for $280,000 to credit card customers. The merchandise had cost $132,000. The credit card company charges a 4 percent fee.

5.Collected $800,000 cash from accounts receivable.

6.Paid $700,000 cash on accounts payable.

7.Paid $163,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 $68,000 to J. Parks. The note had an 9 percent interest rate and a one-year term to maturity.

10.Wrote off $9,300 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

a.Organize the transaction data in accounts under an accounting equation.

b.Create an income statement, a statement of changes in stockholders' equity, a balance sheet, and a statement of cash flows for 2018.

TILE, ETC., INC. Assets Horizontal Statements Model Event Cash + Accounts Liabilities + Equity Receivable Allowance + Merchandise Inventory + Notes Receivable + Interest Bal. Received Accounts Accou Payable + Common Stock = Retained + + Earnings 1 + = 2a. + + T 2b. + + 3a. + + 3b. + + + + + 4a + + + + + 4b. + + + 5. + + + 6. + + + + + 7. + + + + + 8. + + + 9 + + 10. + + 11a + + + 11b. + Bal. + + 0 0 + 0 = + + O = 0 + = 0