Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Secretarial Audits Under Corporate Laws And Annual Return Certification

Authors: CS Shilpa Dixit And CS Amogh Diwan CS Milind Kasodekar

1st Edition

9389449324, 978-9389449327

More Books

Students also viewed these Accounting questions

Question

For a 2-curve with df = 10, determine a. 2 0.05. b. 2 0.025.

Answered: 1 week ago