1. Calculate the average tax rate and marginal tax rate. 7 5 1 Corporate Taxes - Excel FORMULAS DATA REVIEW VIEW Sign In FILE HOME INSERT PAGE LAYOUT M X thun 11 Cells Editing Paste BIU- AA 96 & A Alignment Number Conditional Format as Cell Formatting Table Styles Clipboard Font 1 > AB C 10 11 12 13 Plus this Percentage Taxable income (Bottom of Taxable income Pay this Amount on Anything Over the Bracket) (Top of Bracket) on Base Income Base $ 50,000 $ 15% $ 50,001 $ 75,000 $ 7,500 25% 75,001 $ 100,000 $ 13,750 34% 100,001 $ 335,000 $ 22,250 39% 335,001 $ 10,000,000 $ 113,900 34% 10,000,001 $ 15,000,000 $ 3,400,000 35% $ 15,000,001 $ 18,333,333 $ 5,150,000 38% $ 18,333,334 $ 6,416,667 35% 14 15 16 17 18 19 20 21 22 23 Complete the following analysis. Do not hard code values in your calculations. 24 25 26 Tax on base income of bracket Tax on income within final bracket Total tax Average tax rate Marginal tax rate 27 28 29 30 4 Sheet1 Prey 1 of 1