Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use excel and show me how to do this using goal seek and how to solve for the 28% tax rate. Question 2 (a)

image text in transcribedPlease use excel and show me how to do this using goal seek and how to solve for the 28% tax rate.

Question 2 (a) Modify the Millers' Tax Computation program in Figure 1.2 to include the next higher tax bracket: 28% for earnings between $153,101 and Z233,350. (b) Suppose that Sue's estimated income is now $120,000, and Rob's is $80,200. What will Font heir new estimated tax per quarter? Figure 1.2 Millers' Tax Computation Known Parameters Retirement Savings % Maximum savings Personal exemption Standard deduction Tax rates per person 7.0% $8,000 $4,050 $12.700 10.0% 15.0% 25.0% $1 to $18,650 $18,651 to $75,900 $75,901 to $153,100 Variables Sue's estimated income Rob's estimated income $65,000.00 $60,000.00 $125,000.00 $8,000.00 $8,100.00 $12,700.00 Tax Computation Total income Retirement savings Personal exemptions Standard deduction Taxable income Tax @ 10% rate Tax @ 15% rate Tax @ 25% rate Total tax Estimated tax per quarter $96,200.00 $1,865.00 $8,587.50 $5,075.00 $15,527.50 $3,881.88 Question 2 (a) Modify the Millers' Tax Computation program in Figure 1.2 to include the next higher tax bracket: 28% for earnings between $153,101 and Z233,350. (b) Suppose that Sue's estimated income is now $120,000, and Rob's is $80,200. What will Font heir new estimated tax per quarter? Figure 1.2 Millers' Tax Computation Known Parameters Retirement Savings % Maximum savings Personal exemption Standard deduction Tax rates per person 7.0% $8,000 $4,050 $12.700 10.0% 15.0% 25.0% $1 to $18,650 $18,651 to $75,900 $75,901 to $153,100 Variables Sue's estimated income Rob's estimated income $65,000.00 $60,000.00 $125,000.00 $8,000.00 $8,100.00 $12,700.00 Tax Computation Total income Retirement savings Personal exemptions Standard deduction Taxable income Tax @ 10% rate Tax @ 15% rate Tax @ 25% rate Total tax Estimated tax per quarter $96,200.00 $1,865.00 $8,587.50 $5,075.00 $15,527.50 $3,881.88

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Enterprise Applications And Services In The Finance Industry

Authors: Artur Lugmayr

1st Edition

331928150X,3319281518

More Books

Students also viewed these Finance questions