Question: For this 19 point asaignment, you will create an Excel spreadsheet using pege 1 of Form 941 (found in the tab above) as your guide.

 For this 19 point asaignment, you will create an Excel spreadsheet

For this 19 point asaignment, you will create an Excel spreadsheet using pege 1 of Form 941 (found in the tab above) as your guide. Be creative as to the format but it must inctude the following lines from Form 941: - Line 2: Wages, tips and other compensation - Line 3. Federal income tax withheld from wages, tips, and other compensation - Lines Sa, 5c,5d : Formula REQUIRED for each coll unless cell is "0. . - Line 5E, 7, 8, 9. 11: Assume 0, no formulas needed - Lines 50,6,10 and 12. Formula REQIRED for each cell unless cell is 0 - Line 13a and 13 g Total deposits, no formula needed - Line 14 or 15: Formula REQUIRED for each cell unless cell is "0". All other lines can be ignored for our purposes. Given Information: Tiger and Company, ElN $991234567, located at 678 North High St, Columbus, OH 43215 , is preparing the Form 941 for the third quarter of 2022 . Total wages paid for the quarter are $172,000 and taxable social security wages are $117,000. The company had twelve employees who are paid twice monthly on the 15 th and last day of the month. During this period's payroll, Mr. Harry Chewbacca, the president of Tiger and Company who is single has total taxable Medicare wages over $200,000. Included in the wages for the period is a payment of $12,000 paid to Mr. Chewbacca. Each MONTH during the quarter resulted in employee federal income tax withholding of $6.700. A total of $39,698 was deposited for the quarter. The company had no former employees for which COBRA Health Care premiums were collected or paid, nor did the company make any advanced earned income (EIC) to employees

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f