Check the FTB Website for 2016 California Income Tax Bracket and build a model which will provide (1) the marginal tax rate and (2) the TOTAL tax due for married couples (Schedule Y) when the taxable income value is provided. Please note that FTB shows MARGINAL tax brackets. Please note that the model should allow for a quick update in the years following 2016. Please make sure that the model works for a loss (negative income). Please provide IF formulas used for Marginal Rate and CA Tax Due.

	Taxable Income:
	Marginal Rate:		for couples
	CA Tax Due:
	Brackets for couples:
		Income Over	Marginal Rate
		0	0.01
		16,030	0.02
		38,002	0.04
		59,978	0.06
		83,258	0.08
		105,224	0.093
		537,500	0.103
		644,998	0.113
		1,074,996	0.123