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 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
Get step-by-step solutions from verified subject matter experts
