Question: Please create an excel program as well 10. Jeb Bush proposed a new income taxation system for the US. Along with other com- ponents, Bush

Please create an excel program as well 10. Jeb Bush proposed aPlease create an excel program as well

10. Jeb Bush proposed a new income taxation system for the US. Along with other com- ponents, Bush proposed to reduce the number of tax brackets from seven to three, as outlined below. Note that both systems are progressive; that is, for the Bush system, a taxpayer would pay 10% tax on their first portion of their income up to $43,750, then 25% tax on their income above $43,750, up to $97,751, and 28% on any income over that amount. CURRENT SYSTEM BUSH PROPOSAL Rate Income Range Rate Income Range 10% $0 to $9,225 10% $0 to $43,750 15% $9,226 to $37,450 25% $43,751 to $97,750 25% $37,451 to $90,750 28% $97,751 or more 28% $90,751 to $189,300 33% $189,301 to $411,500 35% $411,501 to $413,200 39.6% $413,201 or more (a) Draw one graph with two curves, showing the amount of tax paid for various income levels for each of the systems, for comparison. (b) Create a table and corresponding graph to help Bush opponents demonstrate that his proposed system favors the wealthy. 10. Jeb Bush proposed a new income taxation system for the US. Along with other com- ponents, Bush proposed to reduce the number of tax brackets from seven to three, as outlined below. Note that both systems are progressive; that is, for the Bush system, a taxpayer would pay 10% tax on their first portion of their income up to $43,750, then 25% tax on their income above $43,750, up to $97,751, and 28% on any income over that amount. CURRENT SYSTEM BUSH PROPOSAL Rate Income Range Rate Income Range 10% $0 to $9,225 10% $0 to $43,750 15% $9,226 to $37,450 25% $43,751 to $97,750 25% $37,451 to $90,750 28% $97,751 or more 28% $90,751 to $189,300 33% $189,301 to $411,500 35% $411,501 to $413,200 39.6% $413,201 or more (a) Draw one graph with two curves, showing the amount of tax paid for various income levels for each of the systems, for comparison. (b) Create a table and corresponding graph to help Bush opponents demonstrate that his proposed system favors the wealthy

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!