Ms Jansen $($financial director$)$ once again called you to her office for some assistance.

One of the employees of Ikhishi Likagogo called the manager of the Pay Office

$($reporting to Ms Jansen$)$ to enquire how much tax he$/$she needs to pay for the current

year. The Pay Office manager used the tax tables provided by the South African

Revenue Services $($SARS$)$ to assist the employee. On average, the Pay Office manager

gets up to five calls every day from employees asking this question.

Ms Jansen provides you with the following spreadsheet $($as attached$)$:

You will notice in column A that there are different tax brackets. Columns B and $C$ put

these values in different columns. Then you will see a base amount in column $D$ with a

percentage $(\%)$ in column $E.$

Let me quickly explain to you how this work. Let's say your yearly salary is R$550000.$

As the salary is between R$512801$ and R$673000$ the base tax amount will be

R$115762$ plus $36\%$ of the amount above R$512801.$

Therefore, the tax will be: $($R$550000-R512801)36\%+R115762=R129154.$

The Income Tax Act allows each natural person to claim a tax rebate. Everyone can

claim a primary rebate of R$17235.$ After the age of $65$ years, you can claim an

additional secondary rebate of R$9444.$ Then after $75$ years old, an additional tertiary

rebate can be claimed of R$3145.$ Please note that this is applicable to the $2024$ tax

year. The solution should also take the age of the taxpayer into consideration. For example, let's say you are $45$ years old. You would then be able to claim a primary

rebate against the above calculated tax. Therefore, the tax payable by you for the $2024$

tax year is $($if your salary is R$550000)$ is: R$129154-$ R$17235=$ R$111919.$

Ms Jansen asked you to create a button to request the employee's salary as well as the

employee's age $($in the "Taxtables" worksheet$).$ The calculated result should display via

a message box.

REQUIRED: Code the solution to the problem as required in the e$-$mail from Ms Jansen by

making use of Visual Basic for Applications $($VBA$).$ Make sure your coding

complies to coding best practices. No marks will be awarded for coding

functions and commands not covered in AIN$2601$ and AIN$3701.$ Therefore,

refrain from using arrays and collections.

Lastly, please make use of a FUNCTION to calculate the tax payable. Your

SUB PROCEDURE should only facilitate the input from and the output to the

user. For the selection structure$($s$),$ please use IF$-$statements.