$2$ Case Report $1$ Excel Question $1$

$3$ Part a$)$

$4$

$5$ Income Before Taxes $($BT$$)$

$6$

$7$ Tax Rate $($T$)$

$8$

$91-$T

$10$

Formula:

$11$ Income After Taxes $($AT$$)$

AT$ $=$ BT$$*(1-T)$