Please make sure to include the formulas as well.

please include the formulas

Sheet 8: CalcNetPay Calculate employee payroll. Scroll down to row 60 to see all the data in this worksheet. Follow the instructions below to calculate the employees' pay sheet in cells E4 through J19. Remember: before copying a formula, apply absolute addressing to cell address(es) in the formula where appropriate. Payroll Taxes Employee Name Department YTD Earnings Gross Pay for this Week Adjusted Gross Income (AGI) Federal Tax Rate Federal Tax Soc Sec Tax Medicare Tax Net Pay Andrews, William Training $93,600 Brown, Betty Admin $1,800 $3,500 $2,000 Carson, Catherine $182,000 $104,000 $234,000 Training Carlton, James Sales $4,500 Chase, Troy Training $46,800 $1,050 Dawson, Jonathan Admin $2,000 Holland, Don Training $1,100 $104,000 $57,200 $62,400 $109,200 Sales Page, Lisa Pratt, Erik Spencer, Boyd Tanner, Timothy Sales Marketing Sales $1,200 $2,100 $3,600 $2,300 $187,200 $119,600 $78,000 Taylor, Hector Sales $1,500 $2,500 Weber, Larry ADC $130,000 $208,000 White, Daniel Admin $145,600 Wiggins, Lisa Wilkins, Sandy Training Marketing $4,000 $2,800 $3,200 $166,400 Standard Deduction from Gross Weekly Pay Per filer ($12,000 / 52); $230.77 1. In E4, calculate William Andrew's Adjusted Gross Income (AGI) for this week by subtracting the standard deduction from his gross weekly pay. 2. Copy this formula down the column to calculate the other employees' AGI. Note: As of 2018, there is no longer a standard deduction for each dependent. 3. In F4, use VLOOKUP and the Federal Tax Rate table in cells A28 through C33 to calculate William Andrew's Federal tax rate. 4. Copy this formula down the column to calculate the other employee's federal tax rate. Federal Tax Tables (for those paid weekly) 4. Copy this formula down the column to calculate the other employees' federal tax rate. Bracket min AGI was at least: Tax Rate on AGI Bracket $0.00 0% 1 5. In G4, calculate William Andrew's federal tax Samount by multiplying his tax rate by his AGI. 6. Copy this formula down the column to calculate the other employees' federal tax Samount. 10% 2 $73.00 $260.00 12% 3 4 $832.00 $1,692.00 $3,164.00 229 24% 32% 5 7. In H4, calculate William Andrew's social security tax Samount by multiplying his AGI by the social security tax rate IF his YTD pay is = to $132,900, his social security tax is $0. 8. Copy this formula down the column to calculate the other employees' social security tax Samount. FICA tax rates (SSN and medicare) 9. In 14, calculate William Andrew's medicare tax Samount by multiplying his AGI by the medicare tax rate. 10. Copy this formula down the column to calculate the other employees' medicare tax Samount. Up to Max Pay Limit Tax Rate 6.20% $132,900 Social Security Tax Medicare Tax 1.45% no limit 11. In J4, calculate William Andrew's net pay by subtracting his federal, social security, and medicare taxes from his gross pay- 12. Copy this formula down the column to calculate the other employees' net pay. $1,000.00 Example 1: Gena made $1000 this week 1. Gena's adjusted gross income (AGI) is $1,000 - $230.77: 2. Gena falls into bracket 3 because her AGI is more than $260 but less than 5832 so Gena will pay (5769.23 12%) in federal tax $769.23 $92.31 $47.69 3. Assume Gena's YTD pay= to $132,900, his social security tax is $0. 8. Copy this formula down the column to calculate the other employees' social security tax Samount. FICA tax rates (SSN and medicare) 9. In 14, calculate William Andrew's medicare tax Samount by multiplying his AGI by the medicare tax rate. 10. Copy this formula down the column to calculate the other employees' medicare tax Samount. Up to Max Pay Limit Tax Rate 6.20% $132,900 Social Security Tax Medicare Tax 1.45% no limit 11. In J4, calculate William Andrew's net pay by subtracting his federal, social security, and medicare taxes from his gross pay- 12. Copy this formula down the column to calculate the other employees' net pay. $1,000.00 Example 1: Gena made $1000 this week 1. Gena's adjusted gross income (AGI) is $1,000 - $230.77: 2. Gena falls into bracket 3 because her AGI is more than $260 but less than 5832 so Gena will pay (5769.23 12%) in federal tax $769.23 $92.31 $47.69 3. Assume Gena's YTD pay