Question 2: Logic and reference (5 marks)

Use reference functions to work out how much tax is payable for any positive taxable income, based on the tax table below.

Taxable income	$106,000
			Income thresholds	$0	$18,200	$37,000	$80,000	$180,000
			Tax amount at threshold	$0	$0	$3,572	$17,547	$54,547
			Tax rate above threshold	0%	19.0%	32.5%	37.0%	45.0%
Tax payable

Hint: You can assume that the taxable income is $106,000. It is probably easier to use several cells to compute relevant numbers with the final answer entered in the cell corresponding to Tax payable.