Question: What is the answer for the following excel question? Part of the Excel model you built during tutorials to calculate income tax payable is displayed
What is the answer for the following excel 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
