Assume Harlequin Souvenir Shop has been in business for several years. The balances in the accounts on January 1, 2019 are in the Transaction Analysis Worksheet and in the T- Accounts. The following transactions took place during 2019. 1. Company purchased inventory on credit (with accounts payable), cost of $335,000. 2. Company made credit sales (with accounts receivable), amount of $220,000. 3. Company collected accounts receivable, amount of $170,000. 4. Company hired a new assistant store manager. She will start in January 2020. 5. Company made cash sales, amount of $160,000. 6. Company paid off accounts payable in the amount of $255,000. 7. Company counted inventory at year-end, and found that the inventory sold cost $275,000 8. Company paid $34,000 in salaries in cash. 9. Company paid $3,000 for interest on the note payable (Noncurrent). 10. Company recognized $5,000 in depreciation on the Property, Plant and Equipment 11. Company pays income taxes at a rate of 20%. It uses an income tax payable account now, and will pay cash in the future. Requirements A. Complete the transaction analysis worksheet and indicate the account, amount and direction of the effect: increase or decrease. Put the ending balances in each column. Use the Excel worksheet. Cash Invest Accounts Inventory PPE (Current) Rec Acc Dep Total Assets Accts Pay Inc Note Tx Pay Pay (Non Current) Common Stock Retained Earnings Details Beg Bal Total Liabs+SE Beg Bal $20,000 $12,000 $5,000 $29,000 $270,000 ($5,000) $331,000 $17,000 $0 $146,000 $132,000 $36,000 $331,000 Sales Rev CGS Exp Sal Exp Int Exp Dep Exp Inc Tx Exp Trans 1 2. 3 4 5 6 7 8 9 10 11 Totals