Part of the Excel model you built during tutorials to calculate income tax payab

Question

Part of the Excel model you built during tutorials to calculate income tax payable is displayed below. If the tax free threshold, in A37, was updated from $18,200 to $27,000 and there were no other changes, what other cells in the spreadsheet would change as a result? 3 Income Tax Tables 2017/2018 Base Tax Amt $0 $0 $3,572 $19,822 $54,232 Tax Rate 0.0% 19.0% 32.5% 310% 45.0% 3s Start $0 36 7 $18,200 08 $37,000 3 $87,000 40 $180,000 42 43 REPORT 4INCOME TAX CALCULATIONS 45 Tuesday, 10 April 2018 46 Taxable Income 985 47 48 Tax Rate Base Tax Amount Tax Amount TAX PAYABLE 32.5% $3,572 2,595 $6,167 43 52

Explanation / Answer

Answer: NONE


Explanation :
If the value is changed from 18200 to 27000 , Then base Tax is still 0

Our Taxable AMOUNT (44,985) Does not fall in this Range, So No values will be affected

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.