P12.4 (LO 1) Excel (Payroll Tax Entries) The following is a payroll sheet for Otis Imports for the month of September 2025. The company is allowed a 1% unemployment compensation rate by the state; the federal unemployment tax rate is 0.8% and the maximum for both is $7,000. Assume a 10% federal income tax rate for all employees and a 7.65% FICA tax on employee and employer on a maximum of $142,800. In addition, 1.45% is charged both employer and employee for an employee's wages in excess of $142,800 per employee. Name B.D. Williams D. Raye K. Baker Earnings to Aug. 31 $ 6,800 6,500 7,600 13,600 131,300 136,300 September Earnings $ 800 700 1,100 1,900 13,000 16,000 Income Tax Withholding FICA Unemployment Tax Federal State F. Lopez A. Daniels B. Kingston Instructions a. Complete the payroll sheet and make the necessary entry to record the payment of the payroll. b. Make the entry to record the payroll tax expenses of Otis Imports. c. Make the entry to record the payment of the payroll liabilities created. Assume that the company pays all payroll liabilities at the end of each month.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
P12.4 (LO 1)Excel (Payroll Tax Entries) The following is a payroll sheet for Otis Imports for the
month of September 2025. The company is allowed a 1% unemployment compensation rate by the state;
the federal unemployment tax rate is 0.8% and the maximum for both is $7,000. Assume a 10% federal
income tax rate for all employees and a 7.65% FICA tax on employee and employer on a maximum of
$142,800. In addition, 1.45% is charged both employer and employee for an employee's wages in excess
of $142,800 per employee.
Name
B.D. Williams
D. Raye
K. Baker
F. Lopez
A. Daniels
B. Kingston
Instructions
Earnings
to Aug. 31
$ 6,800
6,500
7,600
13,600
131,300
136,300
September
Earnings
$ 800
700
1,100
1,900
13,000
16,000
Income
Tax
Withholding FICA
Unemployment Tax
Federal
State
a. Complete the payroll sheet and make the necessary entry to record the payment of the payroll.
b. Make the entry to record the payroll tax expenses of Otis Imports.
c. Make the entry to record the payment of the payroll liabilities created. Assume that the company
pays all payroll liabilities at the end of each month.
Transcribed Image Text:P12.4 (LO 1)Excel (Payroll Tax Entries) The following is a payroll sheet for Otis Imports for the month of September 2025. The company is allowed a 1% unemployment compensation rate by the state; the federal unemployment tax rate is 0.8% and the maximum for both is $7,000. Assume a 10% federal income tax rate for all employees and a 7.65% FICA tax on employee and employer on a maximum of $142,800. In addition, 1.45% is charged both employer and employee for an employee's wages in excess of $142,800 per employee. Name B.D. Williams D. Raye K. Baker F. Lopez A. Daniels B. Kingston Instructions Earnings to Aug. 31 $ 6,800 6,500 7,600 13,600 131,300 136,300 September Earnings $ 800 700 1,100 1,900 13,000 16,000 Income Tax Withholding FICA Unemployment Tax Federal State a. Complete the payroll sheet and make the necessary entry to record the payment of the payroll. b. Make the entry to record the payroll tax expenses of Otis Imports. c. Make the entry to record the payment of the payroll liabilities created. Assume that the company pays all payroll liabilities at the end of each month.
Expert Solution
steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Administration and Procedures
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education