cash total must be $37,865 trial balance after all transactions are recorded should be $76,225

1-4 + 1 Avalo ZUID Jan. 1 2. 3 4 5 10 11 13 15 15 15 16 17 William Evans started Evans Distributors with an investment of 549,000. He also invested personal business supplies worth $1,000 Purchased merchandise for cash, S10,500, Check 100. Sold merchandise on account to Chu Corporation, $750, terms 2/10, 30, Invoice 1001. Purchased merchandise on account from Whitson Company, S1,800, terms 1/10,6/30, Invoice 1125 Received and paid freight charges related to January 4 purchase of merchandise from Whitson Company, S100, Check 101. Chu Corporation returned merchandise purchased on January 2, issued credit memo #101 for $100. Received payment in full from Chu Corporation Paid amount due to Whitson Company for purchase of January 4, Check 102. Recorded cash sales for the two-week period ended Jan. 15 of 5,750. Recorded sales on credit cards for the two-week period ended Jan. 15, 51,200, the bank charges a 3% fee on all credit card sales. Paid wages, 1,400, Check 103. Purchased equipment (not for resale), S1,750, Check 104. Paid freight for delivery of equipment purchased on January 16 5250, Check 105. (Note: freight charges for purchase of equipment should be debited to the Equipment account.) Purchased merchandise on account from Terri Manufacturing for $4,500, subject to trade dis- count of 40%, term 1/10, 1/30, Invoice 2078. Sold merchandise on account to Moloney Corp. 52, 500, terms 1/10,w/30, Invoice 1002 Purchased merchandise on account from Schmidt Company, $3,000, terms 1/10, 1/30 Invoice 3204, freight prepaid by Schmicht Company and added to invoke, S70. (Total invoice amount $3,070). Paid amount owed to Terri Manufacturing for purchase of January 18 Check 106. Received amount due from Moloney Corp. for the sale of January 20. Paid amount due to Schmidt Company for purchase of January 21, Check 107. Recorded cash sales for the period from January 16-31, 56,200. Recorded sales on the credit cards for the period from January 1631, 52,200, the bank charges a 3% fee on all credit card soles. 18 20 21 27 29 30 31 31 - + 2 E A VOI UPUT ULM LUNCULICIT. 2. Record all transactions in the appropriate merchandising t-accounts. Make sure you show the dates for ALL TRANSACTIONS. The first one has been done for you as an example. 3. For any accounts that affect Accounts Receivable or Accounts Payable, update the subsidiary ledgers as appropriate. Record terms of payment and any relevant document numbers in the subsidiary ledger. 4. When you have completed recording all transactions, insure that you balance with the check figures as follows: a. Cash total is $37,865. b. The trial balance totals after all transactions have been recorded is $76,225. 5. Save your work as MERCH TRANSS. I will be reviewing the following "printouts on the one downloaded file that you submit: a. T Accounts with Trial Balance. (Landscape: Fit to one page.) 1. Formulas using Control. (Create a new tab called "Formulas." Copy your work over to the new tab. Use Control Tilde to show your formulas. Widen the columns if necessary so I can see complete formulas.) C. The subsidiary ledgers and schedules of accounts receivable and accounts payable. (Landscape: Fit to one page.) d. Formulas of the Subsidiary ledgers and Schedules. (Create a new tab called "Formulas Ledgers." Copy your work over to the new tab. Use Control Tilde to show your formulas. Widen the columns if necessary so I can see complete formulas.) 6. Analysis of Info: Create a new "tab" or worksheet within the same workbook or file. Call the new worksheet "Analysis" Assuming that ending inventory for the month ended 1/31/2016 was $5,000, compute the following IN PROPER FORM on the "Analysis