Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer this exercise in Excel attachment. Please calculate numbers in Excel formulas or please leave excel formulas so I can plug them in. Exercise

Please answer this exercise in Excel attachment. Please calculate numbers in Excel formulas or please leave excel formulas so I can plug them in.

image text in transcribed

Exercise 5. The monthly wages for December, 2016 and the year-to-date earnings as of November 30 for the three employees of the Elegant Inc. are listed in the table below. Requirements: 2. Calculate the amount of FICA: Social Security Tax and Medicare Tax to be withheld from each of the employee's gross (December only). Apply a 6.2 percent as a social security tax rate using the annual limit of the contribution and benefit base. For earnings in 2016, this base is 118,500. Also, apply a 1.45 percent as a Medicare tax rate. Employee December The year-to- Social MedicareTax Salary date earnings up (December, 2016) to November 2016 Security Tax (December, Rod Cast $2,900 Veronica Ergo Ann Lola 10,800 9,650

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

Active Auditing A Practical Guide To Lean And Agile Auditing

Authors: Prescott Coleman, Sandy Kasahara

1st Edition

1092839305, 978-1092839303

More Books

Students also viewed these Accounting questions

Question

Prepare an electronic rsum.

Answered: 1 week ago

Question

Strengthen your personal presence.

Answered: 1 week ago

Question

Identify the steps to follow in preparing an oral presentation.

Answered: 1 week ago