Week 6 Assignment Part l (2) Q Search Sheet InsertPage Layout Formulas Data Review View tShare A Wrap Text Copy Fill u,, 's, _, !!] Merge & Center, $, % ,.oo*co conditional Format Cell Formatting as Table Styles ..E insert Delete Format Sort & Format B I Clear 17 Below, we have the tax table as shown in the textbook, as well as a taxable income. $ 1,350,000 19 20 21 Taxable income The corporate income tax table currently in effect is: Taxable income is greater than or equal less than... $50,000 Tax rate 15% 25% 34% 39% 34% 35% 38% 35% 25 50,001 75,001 100,001 100,000 335,000 335,001 10,000,000 15,000,000 15,000,001 18,333,333 28 10,000,001 31 32 33 a. Create a tax table for corporate taxes similar to the individual tax table shown above. 34 35 b. For a given taxable income, what is the marginal tax rate? 36 37 C. For a given taxable income, what is the total tax bill? 38 39 d For a given taxable income, what is the average tax rate? 18,333,334 Master it! Solution + Select destination and press ENTER or choose Paste 144%