| Part 2 | |||
| Marks will be given only using self-defined function | |||
| tax_type = 1 | tax_type = 2 | ||
| Taxable income | Income tax rates for every | PAYE rates for every | |
| $1 of taxable income | $1 of taxable income | ||
| (excluding ACC earners' levy) | (including ACC earners' levy) | ||
| up to $14,000 | 10.50% | 12.20% | |
| from $14,001 to $48,000 | 17.50% | 19.20% | |
| from $48,001 to $70,000 | 30% | 31.70% | |
| $70,001 and over | 33% | 34.70% | |
| * Source is from IRD website | |||
| Test your function below | |||
| Test your function below: | |||
| Income ($) | Tax_Type 1 | Tax_Type 2 | Initial Setting |
| 1 | 2 | ||
| 0 | =TAX_CAL($A$21,B20) | =TAX_CAL($A$21,C20) | =TAX_CAL($A$21) |
| -1000 | |||
| 14000 | |||
| 45000 | |||
| 48000 | |||
| 700002 | |||
| Unknown | |||
11 years ago
complete A+ solution for you
NOT RATED
Purchase the answer to view it
- copy_of_fina515_special_part_b_1-1_work2_1_1.xlsm_.crdownload