Work in Microsoft Excel

Swreadsheet Assiguments 4. PARTIAL BALANCE SHEET 79 Assume that Wilson Sporting Goods completed these selected transactions during December Champs, a chain of sporting goods stores, ordered $15,000 of tennis and golf equipment. With its order, Champs sent a check for $15,000 in advance. a Wilson will ship the goods on January 3, 20x7 The December payroll of $195,000 is subject to employee withbeld income tax of 9%, FICA tax of 8% (employee and employer), state unemployment tax of 54%, and federal unemployment tax of0.8 percent. On December 31, b. Wilson pays employees but accrues all tax amounts. c. Sales of $1,000,000 are subject to estimated warranty cost of 1.4 percent. d. On December 2, Wilson signed a $100,000 note payable that requires annual payments of$20,000 plus 9% interest on the unpaid balance each December 2nd. Classify each liability as current or long-term, and prepare a partial balance sheet showing iabilities above, as of December 31, 20x6. 43, SUMMARY OF LIQUIDATION TRANSACTIONS Prior to liquidation, the accounting records of Pratt, Qualls, and Ramirez included the following balances and profit-and-loss sharing percentages: Noncash Pratt Qualls Ramirez Cash + Assets -Liabilities + (40%) + a056) +(30%) sreal Balances before sale of assets$8,000 $$7,000 $19,000 s20,000 $15,000 $11,000 The partnership sold the noncash assets for $73,000, paid the liabilities, and disbursed the remaining cash to the partners. Complete the summary of transactions in the liquidation the partnership. Use the same approach as in the illustration that follows