personal Income Tax Calculator

any ideas ?

\

3) Calculate Provincial Tax on taxable income 5.05% on the first $45,142 of taxable income, plus 9.15% on the next $45,145 of taxable income (on the portion of taxable income over 45,142 up to $90,287), plus 11.16% on the next $59,713 of taxable income (on the portion of taxable income over $90,287 up to $150,000), plus 12.16% on the next $70,000 of taxable income (on the portion of taxable income over $150,000 up to $220,000), plus 13.16% of taxable income over $220,000 4) Net Income after tax and other calculations Total Tax=Federal Tax + Provincial Tax Annual Net Income = Annual Income - CPP - EI Total Tax . Monthly Net Income=Net Take-home / 12 Biweekly Net Income = Net Take-home / 26 Weekly Net Income =Net Take-home/52 Durham Financial Services 1 2 Run Tax Calculator Clear Worksheet 3 4 5 6 7 8 9 10 11 12 13 14 15 16 First Name Last Name SIN Annual Income CPP EI Provincial Tax Federal Tax Total Tax Net Take-home Monthly Bi-weekly Weekly Fig. 1. Initial Setup Personal Income Tax Calculator Durham Financial Services First Name: Last Name: Annual Net Income SIN: Generate Report Annual Income: Reset Form Task 3: Write codes for each button Refer to Fig. 3 as you complete Task 3. (a) The Annual Net Income button should compute and display the annual net income amount for the user (don't forget to format this value). () The Reset button should clear the user form (four textboxes and one label). () The Generate Report button compute should display the required information onto the Personal Income Tax Calculator worksheet as shown in Fig. 3. (d) The Close button should close the user form. Task 4: ActiveX Buttons and Error Handling (a) Link the Income Tax Calculator user form to your Run Tax Calculator ActiveX control button. 6) Program the Reset Worksheet ActiveX control button to clear the contents of your worksheet (C4:016) (c) The Personal Income Tax Calculator user form should have an error handling mechanism to avoid application malfunction due to empty textboxes. For example, if one of the textboxes is empty, then the programn should display an error message similar to Fig. 4. (d) Test your application. Save and close your workbook. 3) Calculate Provincial Tax on taxable income 5.05% on the first $45,142 of taxable income, plus 9.15% on the next $45,145 of taxable income (on the portion of taxable income over 45,142 up to $90,287), plus 11.16% on the next $59,713 of taxable income (on the portion of taxable income over $90,287 up to $150,000), plus 12.16% on the next $70,000 of taxable income (on the portion of taxable income over $150,000 up to $220,000), plus 13.16% of taxable income over $220,000 4) Net Income after tax and other calculations Total Tax=Federal Tax + Provincial Tax Annual Net Income = Annual Income - CPP - EI Total Tax . Monthly Net Income=Net Take-home / 12 Biweekly Net Income = Net Take-home / 26 Weekly Net Income =Net Take-home/52 Durham Financial Services 1 2 Run Tax Calculator Clear Worksheet 3 4 5 6 7 8 9 10 11 12 13 14 15 16 First Name Last Name SIN Annual Income CPP EI Provincial Tax Federal Tax Total Tax Net Take-home Monthly Bi-weekly Weekly Fig. 1. Initial Setup Personal Income Tax Calculator Durham Financial Services First Name: Last Name: Annual Net Income SIN: Generate Report Annual Income: Reset Form Task 3: Write codes for each button Refer to Fig. 3 as you complete Task 3. (a) The Annual Net Income button should compute and display the annual net income amount for the user (don't forget to format this value). () The Reset button should clear the user form (four textboxes and one label). () The Generate Report button compute should display the required information onto the Personal Income Tax Calculator worksheet as shown in Fig. 3. (d) The Close button should close the user form. Task 4: ActiveX Buttons and Error Handling (a) Link the Income Tax Calculator user form to your Run Tax Calculator ActiveX control button. 6) Program the Reset Worksheet ActiveX control button to clear the contents of your worksheet (C4:016) (c) The Personal Income Tax Calculator user form should have an error handling mechanism to avoid application malfunction due to empty textboxes. For example, if one of the textboxes is empty, then the programn should display an error message similar to Fig. 4. (d) Test your application. Save and close your workbook