Complete the Analysis section using formulas with statistical functions. Use named ranges instead of cell references in the form
1 answer:
You might be interested in
Answer:
- Federal Income tax ⇒ $80
- FICA ⇒ $125.46
- State income tax ⇒ $52.97
- Local deduction - Clark County Income tax ⇒ $29.52
Explanation:
Brent gets paid semi-monthly so his pay per period is:
= 39,360 / (12 months *2)
= $1,640
Based on the table therefore, his federal tax is:
= $80
This figure is based on the intersection between income of $1,640 and 3 withholding allowances.
FICA tax rate is 7.65% so his FICA tax is:
= 1,640 * 7.65%
= $125.46
State income tax = $52.97
Local deduction - Clark County Income tax = $29.52
Total deductions:
= Federal tax + FICA + State income tax + Clark County income tax
= 80 + 125.46 + 52.97 + 29.52
= $287.95
