Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ms Jansen ( financial director ) once again called you to her office for some assistance. One of the employees of Ikhishi Likagogo called the
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 heshe 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 put
these values in different columns. Then you will see a base amount in column with a
percentage in column
Let me quickly explain to you how this work. Let's say your yearly salary is R
As the salary is between R and R the base tax amount will be
R plus of the amount above R
Therefore, the tax will be: R
The Income Tax Act allows each natural person to claim a tax rebate. Everyone can
claim a primary rebate of R After the age of years, you can claim an
additional secondary rebate of R Then after years old, an additional tertiary
rebate can be claimed of R Please note that this is applicable to the tax
year. The solution should also take the age of the taxpayer into consideration. For example, let's say you are 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
tax year is if your salary is R is: R R R
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 email 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 and AIN 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 structures please use IFstatements.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started