Shows the marginal federal tax rate for choice of tax years 2014, 2015, or 2016. User chooses one of the following three as the independent variable and enters dollar amounts for the other two.
For example, the following graph shows the marginal tax rate as Non-SS ordinary income increases for a single filer age 65+ taking the standard deduction who has $10,000 of QDI/LTCG and a $30,000 Social Security benefit.
10/08/15: Initial version
10/11/15: Add 28% tax bracket
10/12/15: Add graph of marginal taxable SS underneath marginal tax chart
02/04/16: Add Tables sheet to handle multiple tax years
02/05/16: Add Compare sheet to show marginal rates for specific inputs
02/16/16: Let tax exempt interest also be chosen as the variable to graph
07/14/16: Elim Indirect() function since makes Excel prompt to Save even if no mod
03/31/17: Add 2017 tax brackets etc.
Click following link to download: MarginalTaxRates.xlsx