Use the spreadsheet federalindividualratehistory.xlsx to answer the questions. It contains a complete history of income tax brackets and rates from the inception of the income tax in 1913 through 2013, in both dollars current in each year and adjusted for inflation (2012 dollars) c) use the 2013 tax tables to compute her tax in 2013. what is her effective tax rate? d) compare her 2003 tax and effective tax rate with her 2013 tax and effective tax rate, taking inflation into account. has her tax gone up, or down, or stayed the same?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

7.8.26 c),d)

Use the spreadsheet federalindividualratehistory.xlsx to answer the questions. It contains a complete history of income tax brackets and rates from the inception of the income tax in 1913 through 2013, in both dollars current in each year and adjusted for inflation (2012 dollars)

c) use the 2013 tax tables to compute her tax in 2013. what is her effective tax rate?

d) compare her 2003 tax and effective tax rate with her 2013 tax and effective tax rate, taking inflation into account. has her tax gone up, or down, or stayed the same?

Federalindividualratehistory.xlsx
1913-2013
CPI Data
$35,308
15.0%
$8,690
$35,308
15.0%
$12,397
$47,280
20
$71,254
25.0%
$35,308
$85,505
25.0%
$47,280
$122,150
108,568
28.0%
$85,505
$178,364
28.0%
$122,150
$197,750
193,921
33.0%
$178,364
$387,842
33.0%
$197,750
$387,842
35.0%
$387,842
35.0%
$388,329
2003
CPI: 184
Single
Head of Household
Marginal
Tax Brackets
Marginal
Tax Brackets
ot Over
Tax Rate
Over
But Not Over
Tax Rate
Over
But Not Over
$8,735 0 10.0%
$0
$8,735 0 10.0%
$0
$12,478
$29,604
15.0%
$8,735
$35,437
15.0%
$12,478
$47,479
20
$71,530
25.0%
$35,437
$85,848
25.0%
$47,479
$122,596
108,995
28.0%
$85,848
$179,058
28.0%
$122,596
$198,524
194,625
33.0%
$179,058
$389,249
33.0%
$198,524
$389,249
35.0%
$389,249
35.0%
$389,249
Transcribed Image Text:Federalindividualratehistory.xlsx 1913-2013 CPI Data $35,308 15.0% $8,690 $35,308 15.0% $12,397 $47,280 20 $71,254 25.0% $35,308 $85,505 25.0% $47,280 $122,150 108,568 28.0% $85,505 $178,364 28.0% $122,150 $197,750 193,921 33.0% $178,364 $387,842 33.0% $197,750 $387,842 35.0% $387,842 35.0% $388,329 2003 CPI: 184 Single Head of Household Marginal Tax Brackets Marginal Tax Brackets ot Over Tax Rate Over But Not Over Tax Rate Over But Not Over $8,735 0 10.0% $0 $8,735 0 10.0% $0 $12,478 $29,604 15.0% $8,735 $35,437 15.0% $12,478 $47,479 20 $71,530 25.0% $35,437 $85,848 25.0% $47,479 $122,596 108,995 28.0% $85,848 $179,058 28.0% $122,596 $198,524 194,625 33.0% $179,058 $389,249 33.0% $198,524 $389,249 35.0% $389,249 35.0% $389,249
2013
CPI: 234.345 (Projected)
Single
Head of Household
ts
Marginal
Tax Brackets
Marginal
Tax Brackets
Not Over
Tax Rate
Over
But Not Over
Tax Rate
Over
But Not Over
$0
$8,744
$8,744 0
10.0%
$8,744 0
10.0%
$0
$12,491
$35,515
15.0%
$35,515
15.0%
$12,491
$47,615
$71,716
25.0%
$35,515
$86,069
25.0%
$47,615
$122,907
$109,264
28.0%
$86,069
$179,535
28.0%
$122,907
$199,031
$195,137
33.0%
$179,535
$390,273
33.0%
$199,031
$390,273
35.0%
$390,273
- 0
35.0%
$390,273
- 0
39.6%
$391,890
39.6%
$416,383
Transcribed Image Text:2013 CPI: 234.345 (Projected) Single Head of Household ts Marginal Tax Brackets Marginal Tax Brackets Not Over Tax Rate Over But Not Over Tax Rate Over But Not Over $0 $8,744 $8,744 0 10.0% $8,744 0 10.0% $0 $12,491 $35,515 15.0% $35,515 15.0% $12,491 $47,615 $71,716 25.0% $35,515 $86,069 25.0% $47,615 $122,907 $109,264 28.0% $86,069 $179,535 28.0% $122,907 $199,031 $195,137 33.0% $179,535 $390,273 33.0% $199,031 $390,273 35.0% $390,273 - 0 35.0% $390,273 - 0 39.6% $391,890 39.6% $416,383
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education