The Boston Tax Group assist residents in tax planning. Your task is to analyze the total taxes owed based on two new fat-rate tax alternatives. In addition, you will compare the amount owed and penalties for each alternative. Open Boston Tax Group and save it as a Boston Tax Group (with your name at the end). In cell G12, write a formula to calculate the total tax amount for Alternate 1 on the income in cell B12. Use the HLOOKUP function to determine the Alternate 1 flat tax rate for the income in cell B 12 and then multiply by the income to get the dollar amount owed. If done properly the result in G12 should be 14, 462. Make sure you have used absolute references appropriately and then autofill down. In cell H 12, write a formula to calculate the total tax amount for alternate 2 on the income in cell B12. Use the HLOOKUP function to determine the Alternate 2 flat tax rate for the income in cell B12 and then multiply by the income to get the dollar amount owed. If done properly the result in H12 should be 16, 528. Make sure you have used absolute references appropriately and the autofill down. In cell 112, write a formula to calculate the amount of unpaid taxes based on the Actual Tax Owed (column F) and the Actual Withholding Paid (column D). This is simply the difference between column F and column D. If done properly the result in 112 should be 4, 719. In cell I12, write a formula to calculate the amount of unpaid taxes based on the Alternate 1 Tax Owed(column G) and the Actual Withholding Paid (column D). This is simply the difference between column G and column D. If done properly the result in J12 should be 4, 227. In cell k12, write a formula to calculate the amount of unpaid taxes based on the Alternate 2 Tax Owed (column H) and the Actual Withholding Paid (column D). This is simply the difference between column H and column D. If done properly the result in K12 should be 6, 293. In cell L12, write a formula to calculate the Actual penalty owed IF the Actual unpaid tax in 112 is >0.You can LOOKUP the penalty rate in cells H2;18. You will need to use If, VLOOKUP and then multiplication. If done properly the result in L12 should be 236. If necessary, modify your original formula in cell L12 with the appropriate absolute references so that you could have copied it across to column M and N and down to row 21. Now, autofill L12 with the appropriate absolute references so that you should have copied it across to column M and N and down to row 21. Now, autofill L12 across to N12 and down to N21. Save the workbook and upload to Blackboard. The Boston Tax Group assist residents in tax planning. Your task is to analyze the total taxes owed based on two new fat-rate tax alternatives. In addition, you will compare the amount owed and penalties for each alternative. Open Boston Tax Group and save it as a Boston Tax Group (with your name at the end). In cell G12, write a formula to calculate the total tax amount for Alternate 1 on the income in cell B12. Use the HLOOKUP function to determine the Alternate 1 flat tax rate for the income in cell B 12 and then multiply by the income to get the dollar amount owed. If done properly the result in G12 should be 14, 462. Make sure you have used absolute references appropriately and then autofill down. In cell H 12, write a formula to calculate the total tax amount for alternate 2 on the income in cell B12. Use the HLOOKUP function to determine the Alternate 2 flat tax rate for the income in cell B12 and then multiply by the income to get the dollar amount owed. If done properly the result in H12 should be 16, 528. Make sure you have used absolute references appropriately and the autofill down. In cell 112, write a formula to calculate the amount of unpaid taxes based on the Actual Tax Owed (column F) and the Actual Withholding Paid (column D). This is simply the difference between column F and column D. If done properly the result in 112 should be 4, 719. In cell I12, write a formula to calculate the amount of unpaid taxes based on the Alternate 1 Tax Owed(column G) and the Actual Withholding Paid (column D). This is simply the difference between column G and column D. If done properly the result in J12 should be 4, 227. In cell k12, write a formula to calculate the amount of unpaid taxes based on the Alternate 2 Tax Owed (column H) and the Actual Withholding Paid (column D). This is simply the difference between column H and column D. If done properly the result in K12 should be 6, 293. In cell L12, write a formula to calculate the Actual penalty owed IF the Actual unpaid tax in 112 is >0.You can LOOKUP the penalty rate in cells H2;18. You will need to use If, VLOOKUP and then multiplication. If done properly the result in L12 should be 236. If necessary, modify your original formula in cell L12 with the appropriate absolute references so that you could have copied it across to column M and N and down to row 21. Now, autofill L12 with the appropriate absolute references so that you should have copied it across to column M and N and down to row 21. Now, autofill L12 across to N12 and down to N21. Save the workbook and upload to Blackboard