Required: Below is a payroll sheet for Riverbed 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 Earnings to Aug.31 $6,900 6,700 7,600 14,800 130,000 135,000 September Income Tax Earnings Withholding $900 800 1,100 1,800 13,900 16,500 FICA Unemployment Tax State Federal 1. Complete the payroll sheet in Excel and make the necessary entry to record the payment of the payroll. 2. Make the entry to record the payroll tax expenses of Riverbed Imports. 3. Make the entry to record the payment of the payroll liabilities created in parts a and b. Assume that the company pays all payroll liabilities at the end of each month. Please round your answers to two decimal places.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
Required:
Below is a payroll sheet for Riverbed 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
Earnings
to
Aug.31
$6,900
6,700
7,600
14,800
130,000
135,000
September Income Tax
Earnings Withholding
$900
800
1,100
1,800
13,900
16,500
FICA
Unemployment Tax
State
Federal
1. Complete the payroll sheet in Excel and make the necessary entry to record the payment of the payroll.
2. Make the entry to record the payroll tax expenses of Riverbed Imports.
3. Make the entry to record the payment of the payroll liabilities created in parts a and b. Assume that the company pays all payroll liabilities at
the end of each month. Please round your answers to two decimal places.
Transcribed Image Text:Required: Below is a payroll sheet for Riverbed 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 Earnings to Aug.31 $6,900 6,700 7,600 14,800 130,000 135,000 September Income Tax Earnings Withholding $900 800 1,100 1,800 13,900 16,500 FICA Unemployment Tax State Federal 1. Complete the payroll sheet in Excel and make the necessary entry to record the payment of the payroll. 2. Make the entry to record the payroll tax expenses of Riverbed Imports. 3. Make the entry to record the payment of the payroll liabilities created in parts a and b. Assume that the company pays all payroll liabilities at the end of each month. Please round your answers to two decimal places.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps

Blurred answer
Knowledge Booster
Journal entries
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