Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started