Question: d . Create a formula in cell H 5 to calculate the taxable pay. Multiply the number of dependents by the deduction per dependent and

d. Create a formula in cell H5 to calculate the taxable pay. Multiply the number of dependents by the deduction per dependent and subtract that from the gross pay. With two dependents, Abram's taxable pay is $417.40. E. Use a VLOOKUP function in cell I5 to identify and calculate the federal withholding tax. With a taxable pay of $417.40, Abram's tax rate is 25% and the withholding tax is $104.35. The VLOOKUP function returns the applicable tax rate, which you must then multiply by the taxable pay. F. Calculate FICA in cell J5 based on gross pay and the FICA rate, and calculate the net pay in cell K5.
d . Create a formula in cell H 5 to calculate the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!