finance homework excel! due in 3 hours!!
zaina
FIN313PPTTable.xlsx
Tax Table
| | | Taxable Income | | Tax Rate |
| | | $0 | $50,000 | 15.0% |
| | | $50,001 | $75,000 | 25.0% |
| | | $75,001 | $100,000 | 34.0% |
| | | $100,001 | $335,000 | 39.0% |
| | | $335,001 | $10,000,000 | 34.0% |
| | | $10,000,001 | $15,000,000 | 32.0% |
| | | $15,000,001 | $18,333,333 | 30.0% |
| | | $18,333,334 | | 28.0% |
| | Income | $200,000 | | Tax Rate | | Income | Taxes |
| | | $0 | $50,000 | 15.0% | | $50,000 | $7,500 |
| | | $50,001 | $75,000 | 25.0% | | $24,999 | $6,250 |
| | | $75,001 | $100,000 | 34.0% | | $24,999 | $8,500 |
| | | $100,001 | $335,000 | 39.0% | | $99,999 | $39,000 |
| | | $335,001 | $10,000,000 | 34.0% | | | $61,249 |
| | | $10,000,001 | $15,000,000 | 35.0% |
| | | $15,000,001 | $18,333,333 | 38.0% |
| | | $18,333,334 | | 35.0% |
