Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use excel worksheet It is very important for all individuals and especially, accounting professionals/CPAs to understand how payroll works. Identify the IRC code sections

please use excel worksheet image text in transcribed
image text in transcribed
It is very important for all individuals and especially, accounting professionals/CPAs to understand how payroll works. Identify the IRC code sections that define the Social Security rate of 6.2 for employees (EE) and employers (ER) and the Medicare rate of 1.45% and .9% for employees and 1.45% employers. Make sure to use proper IRC citations by starting with IRC and then reference the correct #s, lower case letters, upper case letters, etc. and in the correct order. The correct solution requires four IRC citations. Additionally, use the attached Excel file to calculate the EE Net pay and Total ER payroll expense (including wages) for 2020. Proper Excel utilization is required. Assume the following: 1. Based on the employee's W-4 information, Federal income tax withholdings are 20%. 2. Based on the employee's M-4 information, State income tax withholdings are 5%. 3. The employee's annual health care premiums are $4,800 of which the employer pays half. Employer (ER) Employee (EE) 225,000 Single Taxpayer: 2020 Gross Wages Federal income tax (W-4) State income tax (M-4) Social Security tax Medicare tax Additional medicare tax Other EE deductions Net pay Health insurance for example (50% EE/50% ER) FUTA @.6% SUTA @ 5.4% Total ER payroll expense It is very important for all individuals and especially, accounting professionals/CPAs to understand how payroll works. Identify the IRC code sections that define the Social Security rate of 6.2 for employees (EE) and employers (ER) and the Medicare rate of 1.45% and .9% for employees and 1.45% employers. Make sure to use proper IRC citations by starting with IRC and then reference the correct #s, lower case letters, upper case letters, etc. and in the correct order. The correct solution requires four IRC citations. Additionally, use the attached Excel file to calculate the EE Net pay and Total ER payroll expense (including wages) for 2020. Proper Excel utilization is required. Assume the following: 1. Based on the employee's W-4 information, Federal income tax withholdings are 20%. 2. Based on the employee's M-4 information, State income tax withholdings are 5%. 3. The employee's annual health care premiums are $4,800 of which the employer pays half. Employer (ER) Employee (EE) 225,000 Single Taxpayer: 2020 Gross Wages Federal income tax (W-4) State income tax (M-4) Social Security tax Medicare tax Additional medicare tax Other EE deductions Net pay Health insurance for example (50% EE/50% ER) FUTA @.6% SUTA @ 5.4% Total ER payroll expense

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_2

Step: 3

blur-text-image_3

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

The Accounting And Financial Audit

Authors: Landry Kouamé

1st Edition

620430481X, 978-6204304816

More Books

Students also viewed these Accounting questions

Question

e. What do you know about your ethnic background?

Answered: 1 week ago

Question

b. Why were these values considered important?

Answered: 1 week ago