PLEASE SHOW YOUR VBA CODE IN EXCEL!!!!!

THANK YOU!!

1. The following shows an example of tax code (this is from a number of years ago, so it probably is not still valid) a. Create a user-defined VBA function called tax(, ) that outputs the tax given the taxable income (in dollars) and status ( 1 for single and 2 for married filing jointly). As an example, if a married couple earned $125,000 (taxable income), then the tax would be: $10,367.50+0.25($125,000$75,300)=$22,792.50 Working function in Excel: If you make $75,000 in taxable income your first year working as an engineer, what will your taxes be? Assume that you are single. Also, what percentage of your overall taxable income will you be paying in taxes? Plot tax as a function of taxable income from $0 to $500,000 for a single taxpayer. Remove any markers and present the result as a smoothed line. You overhear a very wealthy couple (married filing jointly, who you know make $500,000 a year in taxable income) complain, " 40% of what we make we have to pay back in taxes!" Yes, the money that is earned between $466,950 and $500,000 is taxed at a nearly 40% tax rate (39.6\%), but really, how much (looking for a percentage) of their total taxable income do they have to pay in taxes