<
>
• Math Help

On page 212, the table showing the graduated income tax for the taxable income of a single person in 2010 has been simplified from the actual table used. For instance, the first row in the IRS 2010 tax tables essentially says, "If your taxable income is over \$0 but not over \$8375, then the tax is 10% of the amount over \$0." What is the marginal tax rate for a taxable income of \$8375.25? For the amount of \$8375, it would be taxed at the 10% rate, and the remaining \$0.25 would be taxed at the 15% rate.

To make a spreadsheet similar to the one in Example 1(a), use the steps below.

1. Enter the titles "Taxable Income," "Marginal Tax Rate," and "Tax," into row 1
2. Enter 8375 into cell A2, = 34000 − 8375 into cell A3, and = 67850 − 34000 into cell A4.
3. Enter the formula = SUM(A2:A4) into cell A5.
4. Enter 0.1 into cell B2, 0.15 into cell B3, and 0.25 into cell B4.
5. Enter the formula = A2*B2 into cell C2.
6. Select cell C2. From the Edit menu, choose Copy.
7. Select cells C3 and C4. From the Edit menu, choose Paste.
8. Enter the formula = SUM(C2:C4) into cell C5.

To format the cells, use the steps below.

1. Select cells A2 through A5.
2. From the Format menu, choose Cells....
3. In the Format Cells dialog, select the Number tab.
4. From the Category: list, select Currency.
5. For Decimal places:, enter 2. For Symbol, choose \$ from the drop down list. Then click OK.
6. Select cells B2 through B4.
7. From the Format menu, choose Cells....
8. In the Format Cells dialog, select the Number tab.
9. From the Category: list, select Percentage.
10. For Decimal places:, enter 0. Then click OK.
11. Select cells B2 through B5. Repeat Steps 2 through 5.
• Consumer Suggestion

Do you want to know exactly how much you pay in taxes? Use the 2011 tax table from the Internal Revenue Service to find out.

• Checkpoint Solution

Use a spreadsheet to calculate the income tax owed.

The federal income tax is \$19,609.25.

The effective tax rate is

These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.

``` __   _      ___      ______    ______   _____
| || | ||   / _ \\   /_____//  /_   _// |  __ \\
| '--' ||  / //\ \\  `____ `    -| ||-  | |  \ ||
| .--. || |  ___  || /___//     _| ||_  | |__/ ||
|_|| |_|| |_||  |_|| `__ `     /_____// |_____//
`-`  `-`  `-`   `-`  /_//      `-----`   -----`
`-`
```