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?
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?
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5a1b2b9d-136a-4887-96f9-8b3f93dfa3b9%2Fb4a83c93-77e0-43fc-ada4-adcfb4c83616%2Fctxf32b_processed.jpeg&w=3840&q=75)
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5a1b2b9d-136a-4887-96f9-8b3f93dfa3b9%2Fb4a83c93-77e0-43fc-ada4-adcfb4c83616%2Ftjp8ak9_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education