Question: Do the excel and answer the following questions a EXCEL MASTER ITI PROBLEM Usi Excel to find the single che colded the VLOOKU Tver calculate

Do the excel and answer the following questions
Do the excel and answer the following questions a EXCEL MASTER ITI

a EXCEL MASTER ITI PROBLEM Usi Excel to find the single che colded the VLOOKU Tver calculate the amounts Be wave shown presented in the format a copy of the IRS Tak tahle fundal 2010 m. bales tasatis Income is utot 555 40.125 5525 16.00 207 350 518.400 The taxis 0 9.875 101 tento 40.72 597 0 12 thout over 3.075 05525 54.5150 22% of the amount over $40.125 163.300 514.605 plus 24. one amount over as 52 2070 $43.271 50 plus 37 of the amount over $163-100 518.400 $47.26750 s 35% amount over $207,30 $156 225 plus 37 of the amount over 5518.400 In reading this table, the marginal tax rate for taxable income less than 59.875 in 10 percent. If the taxable income is between $9.875 and 540,125. the tax bill is 5987.50 plus times the marginal tax rite of 12 percent. the marginal taxes. The marginal taxes are calculated as the taxable incomnc minus $9.875 Below. we have the tax table that was applicable for married individuals filing jointly in 2020. Taxable income is greater than or equal to Bur less than.. Tax rate 10% 12 22 S 19.750 80.250 171.050 326,600 414,700 622,050 $19.750 80.250 171,050 326,600 414.700 622.050 24 32 35 37 a. Create a tax table in Excel for a couple filing jointly similar to the individual tax table shown above. Your spreadsheet should then calculate the marginal tax rate, the average tax rate, and the tax bill for any level of taxable income input by a user. b. For a stable income of $225.000, what is the marginal tax rate? c. For a table income of $225,000, what is the total tax bill? d. For a taxable income of $225.000, what is the average tax rate

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!