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?What is the answer for the following excel question? Part of theExcel model you built during tutorials to calculate income tax payable is

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!