Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the amount of tax for the salaries listed based on the following rules: - Everyone will have to pay a fixed percentage of federal

Calculate the amount of tax for the salaries listed based on the following rules:

- Everyone will have to pay a fixed percentage of federal tax

- The state tax is calculated based on the state each person lives in

- the amount taxed in the sum of federal and state taxes.

Federal Tax Rate: 2%

State: 5%

Salary: $89,00

$44,00

$60,000

$120,000

Please show formula in excel.

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

Audit And Business Performance

Authors: BELAMKADDAM HAMZA

1st Edition

6205444062, 978-6205444061

More Books

Students also viewed these Accounting questions

Question

What is meant by 'Wealth Maximization ' ?

Answered: 1 week ago

Question

What do you think of the MBO program developed by Drucker?

Answered: 1 week ago