Remove Arra Formula nsert AutoSum Builder mBulder Reference Show sfwitch nser Tr
ID: 3065363 • Letter: R
Question
Remove Arra Formula nsert AutoSum Builder mBulder Reference Show sfwitch nser Trace Dependents Check for En Reference Name E6 Tax rate(%) Name Salary Tax-Amount s J. Smith1 54,000 65,000 3 37,000 6 J. Smith2 J. Smith J. Smith4 44,000 9 J. Smith5 62,000 o J. Smith6 42,000 31,000 88,000 91,000 11 J. Smith7 12 J. Smith8 13 J. Smith9 4 J. Smith1 15 16 Total Tax Amount 18 20 Complete the following steps: 1. Calculate the individual Tax-Amount 22 2. Get the TOTAL TAX AMOUNT of all Tax-Amounts 23 3. use Goal Seek to increase the TOTAL TAX AMOUNT 55,000-what will the new Tax rate be?Explanation / Answer
The new tax rate would be 10.74
Name Salary J.Smith1 54,000 (54,000*8)/100 =4320 J.Smith2 65,000 5200 J.Smith3 37,000 2960 J.Smith4 44,000 3520 J.Smith5 62,000 4960 J.Smith6 42,000 3360 J.Smith7 31,000 2480 J.Smith8 88,000 7040 J.Smith9 91,000 7280 J.Smith10 52,000 4160 Total Tax Amount=45280