The table shows the income tax rate for Australian residents for the 2024-2025 financial year.
\begin{array}{|l|l|}
\hline
\rule{0pt}{2.5ex}\textit{Taxable income} \rule[-1ex]{0pt}{0pt}& \textit{Tax on this income} \\
\hline
\rule{0pt}{2.5ex}0-\$18\,200 \rule[-1ex]{0pt}{0pt}& \text{Nil} \\
\hline
\rule{0pt}{2.5ex}\$18 \, 201-\$45\,000 \rule[-1ex]{0pt}{0pt}& \text{16 cents for each \$1 over \$18 200} \\
\hline
\rule{0pt}{2.5ex}\$45\,001-\$135\,000 \rule[-1ex]{0pt}{0pt}& \$4288 \text{ plus 30 cents for each \$1 over \$45 000} \\
\hline
\rule{0pt}{2.5ex}\$135\,001-\$190\,000 \rule[-1ex]{0pt}{0pt}& \$31 \, 288 \text{ plus 37 cents for each \$1 over \$135 000} \\
\hline
\rule{0pt}{2.5ex}\$190\,001 \text{ and over} \rule[-1ex]{0pt}{0pt}& \$51 \, 638 \text{ plus 45 cents for each \$1 over \$190 000} \\
\hline
\end{array}
A company's spreadsheet was created that calculates its employees' after tax fortnightly pay, based on the table and excluding the Medicare levy.
- Write down the formula that was used in cell D6, using appropriate grid references. (1 mark)
--- 1 WORK AREA LINES (style=lined) ---
- Write down the formula that was used in cell C5, using appropriate grid references. (1 mark)
--- 2 WORK AREA LINES (style=lined) ---
- Hence, calculate Greg's fortnightly pay. (2 marks)
--- 4 WORK AREA LINES (style=lined) ---