It is very important for all individuals and especially, accounting professionals/CPAS to understand how payroll works....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. Single Taxpayer: Emplovee (EE) Emplover (ER) 2020 Gross Wages 225,000 Federal income tax (W-4) State income tax (M-4) Social Security tax Medicare tax Additional medicare tax Other EE deductions Health insurance for example (50% EE/50% ER) Net pay 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. Single Taxpayer: Emplovee (EE) Emplover (ER) 2020 Gross Wages 225,000 Federal income tax (W-4) State income tax (M-4) Social Security tax Medicare tax Additional medicare tax Other EE deductions Health insurance for example (50% EE/50% ER) Net pay FUTA @ .6% SUTA @ 5.4% Total ER payroll expense
Expert Answer:
Answer rating: 100% (QA)
Single Taxpayer Employee Employer Gross Wages 250000 Federal income ta... View the full answer
Related Book For
Horngrens Accounting
ISBN: 978-0133855371
10th Canadian edition Volume 1
Authors: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura, Carol A. Meissner, Jo-Ann L. Johnston, Peter R. Norwood
Posted Date:
Students also viewed these accounting questions
-
It is very important to set up a properly numbered chart of accounts, especially in a computerized accounting system. Use account numbers 101 through 106, 201, 221, 301, 321, 401, 501, and 521 to...
-
Explain how federal and state income tax withholdings are determined.
-
Explain how federal and provincial income tax withholdings are calculated.
-
Steam enters a steady-flow turbine with a mass flow rate of 13 kg/s at 600°C, 8 MPa, and a negligible velocity. The steam expands in the turbine to a saturated vapor at 300 kPa where 10 percent...
-
Solve the preceding problem if the mass of the tailgate is M T = 27 kg and that of the crate is M C = 68 kg. Use dimensions H = 305 m m, L = 406 mm, d C = 460 mm, and d T = 350 mm. The cable...
-
The mean wages for a sample of employees in a company was \($18.00\) per day with a standard deviation of \($2.50\) per day. Between what two values do 95% of the data lie? (Assume the data set has a...
-
Moonbay is a home-building corporation that primarily develops retirement communities. Farmtex owns a number of feedlots in Sunny Valley. Moonbay purchased 20,000 acres of farmland in the same area...
-
When I consider optimizing the portfolio allocation for both my 403(b) and CALSTRS retirement accounts, I find it crucial to employ a well-structured model to ensure that my investments align with my...
-
For the preceding problem you should find that there are significant differences among the three treatments. One reason for the significance is that the sample variances are relatively small. To...
-
Documenting risk management issues and recommendations helps future projects, and business processes. Select all topics that apply to this documentation. Select all that apply: Date of occurrence of...
-
Bassinger Company purchases an oil tanker depot on January 1, 2015, at a cost of \($600\),000. Bassinger expects to operate the depot for 10 years, at which time it is legally required to dismantle...
-
Uddin Publishing Co. publishes college textbooks that are sold to bookstores on the following terms. Each title has a fixed wholesale price, terms f.o.b. shipping point, and payment is due 60 days...
-
Assume that on January 1, 2015, Peking Duck Co. sells a computer system to Liquidity Finance Co. for 510,000 and immediately leases the computer system back. The relevant information is as follows....
-
Bedard Corporation reported net income of 300,000 in 2015 and had 200,000 ordinary shares outstanding throughout the year. Also outstanding all year were 45,000 options to purchase ordinary shares at...
-
The following situations relate to Bolivia Company. 1. Bolivia provides a warranty with all products sold. It estimates that it will sell 1,000,000 units of its product for the year ended December...
-
a. Assess the changes in the short-term liquidity risk of Coca-Cola between Year 1 and Year 3. b. Assess the changes in the long-term solvency risk of Coca-Cola between Year 1 and Year 3. Exhibit...
-
Estimate a range for the optimal objective value for the following LPs: (a) Minimize z = 5x1 + 2x2 Subject to X1 - x2 3 2x1 + 3x2 5 X1, x2 0 (b) Maximize z = x1 + 5x2 + 3x3 Subject to X1 + 2x2 +...
-
Refer to the Creative Kaos Store inventory data in Exercise 6-2, except assume that the store uses the moving-weighted-average-cost method. Prepare Creative Kaos Store's perpetual inventory record...
-
Suppose Dawson Communications uses the perpetual inventory system and reported these figures in its December 31, 2017, financial statements: Accounts payable...
-
The adjusted trial balance of Harrison Trading Company at September 30, 2017 is given below. Harrison Trading Company uses the perpetual inventory system. Required 1. Journalize Harrison Trading...
-
Describe what sexual harassment is and what forms it can take.
-
Explain public policies that protect employees from unlawful discharge.
-
Discuss under what conditions unemployment compensation can be denied to a claimant.
Study smarter with the SolutionInn App