Answered step by step
Verified Expert Solution
Link Copied!

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 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 R550000.
As the salary is between R512801 and R673000 the base tax amount will be
R115762 plus 36% of the amount above R512801.
Therefore, the tax will be: (R550000-R512801)36%+R115762=R129154.
The Income Tax Act allows each natural person to claim a tax rebate. Everyone can
claim a primary rebate of R17235. After the age of 65 years, you can claim an
additional secondary rebate of R9444. Then after 75 years old, an additional tertiary
rebate can be claimed of R3145. 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 R550000) is: R129154- R17235= R111919.
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 AIN2601 and AIN3701. 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database Design With Microcomputer Applications

Authors: Glenn A. Jackson

1st Edition

0137718411, 978-0137718412

More Books

Students also viewed these Databases questions

Question

6. Conclude with the same strength as in the introduction

Answered: 1 week ago

Question

7. Prepare an effective outline

Answered: 1 week ago