Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required Information Tableau Dashboard Activity 15-01: New-Hire Declslons: Roth or Traditlonal Retirement Savings (Static) New Hire Decisions: Roth or Traditional Retirement Savings Eva is excited
Required Information Tableau Dashboard Activity 15-01: New-Hire Declslons: Roth or Traditlonal Retirement Savings (Static) New Hire Decisions: Roth or Traditional Retirement Savings Eva is excited to start her position in the Accounting Department of Longevity, Inc., a local company known for its employees staying with the compsny for their whole career. While filling out her new hire pocket to select heslth care coverage and other benefits, Evs must decide which retirement plan option offered by Longevity, Inc. makes the most sense for her personal gosls. Longevity, Inc. offers a Roth plan or a Tracitional plan for retirement savings. Eva considers the following varisbles, constraints, and assumptions: - Her starting salary is \$120,000; Longevity, Inc. has historically incressed employee compensation by 3% annually. - She wants to contribute 5% of her annual salary to the retirement account, but must keep her after tax take home poy the same regardless of the chosen option. - Longevity, Inc.'s retirement investment options are expected to earn a 12% rate of return. - Evs expects to work for Longevity, Inc. for 30 years and will spend 20 years in retirement. - During retirement, Evs intends to exit her retirement sccount investments and will take sn even distribution of the retirement sovings each year. Evo's gosl is to maximize her after tox cash flow in retirement but also wents to minimize the amount of tax she pays over her lifetime. Using 2019 income tax brackets and assuming a Standard Deduction incresse of 1.67% each year, you have created the following Tablesu visualization to help Evs make a decision. Mouse over the graphs to reveal specific amounts for use in answering the following questions. Note, the Dsta pane provides a summation of values bosed on the selected Year(s) slider and Roth or Traditional option in the dropdown menu. New-Hire Declslons: Roth or Tradltional Retlrement Savings - Part 1 (Static) Required: a. What is the expected Market Value in year 30 under each option? b. What Is the lifetime (year 1 through 50) Taxable Income and Tax expected to be If Eva chooses the traditional retirement account? c. Under which option will Eva pay less Tax over her lifetime? d. Which option has a lower average tax rate over her lifetime? e. Which option maximizes Eva's After Tax Cash Flow in retirement? Complete this question by entering your answers in the tabs below. What is the expected Market Value in year 30 under each option? Required: a. What is the expected Market Value in year 30 under each option? b. What is the IIfetime (year 1 through 50) Taxable Income and Tax expected to be if Eva chooses the traditional retirement account? c. Under which option will Eva pay less Tax over her lifetime? d. Which option has a lower average tax rate over her lifetime? e. Which option maximizes Eva's After Tax Cash Flow in retirement? Complete this question by entering your answers in the tabs below. What is the lifetime (year 1 through 50) Taxable Income and Tax expected to be if Eva chooses the traditional retirement account? Required: a. What is the expected Market Value in year 30 under each option? b. What Is the IIfetime (year 1 through 50) Taxable Income and Tax expected to be If Eva chooses the traditional retirement account? c. Under which option will Eva pay less Tax over her IIfetime? d. Which option has a lower average tax rate over her lifetime? e. Which option maximizes Eva's After Tax Cash Flow in retirement? Complete this question by entering your answers in the tabs below. Under which option will Eva pay less Tax over her lifetime? Required: a. What Is the expected Market Value in year 30 under each option? b. What is the Iffetime (year 1 through 50) Taxable Income and Tax expected to be if Eva chooses the traditional retirement account? c. Under which option will Eva pay less Tax over her lifetime? d. Which option has a lower average tax rate over her IIfetime? e. Which option maximizes Eva's After Tax Cash Flow in retirement? Complete this question by entering your answers in the tabs below. Which option has a lower average tax rate over her lifetime? New-Hire Decisions: Roth or Traditional Retirement Savings - Part 1 (Static) Required: a. What is the expected Market Value in year 30 under each option? b. What is the IIfetime (year 1 through 50 ) Taxable Income and Tax expected to be If Eva chooses the traditional retirement account? c. Under which option will Eva pay less Tax over her Iffetime? d. Which option has a lower average tax rate over her lifetime? e. Which option maximizes Eva's After Tax Cash Flow in retirement? Complete this question by entering your answers in the tabs below. Which option maximizes Eva's After Tax Cash Flow in retirement? Required Information Tableau Dashboard Activity 15-01: New-Hire Declslons: Roth or Traditlonal Retirement Savings (Static) New Hire Decisions: Roth or Traditional Retirement Savings Eva is excited to start her position in the Accounting Department of Longevity, Inc., a local company known for its employees staying with the compsny for their whole career. While filling out her new hire pocket to select heslth care coverage and other benefits, Evs must decide which retirement plan option offered by Longevity, Inc. makes the most sense for her personal gosls. Longevity, Inc. offers a Roth plan or a Tracitional plan for retirement savings. Eva considers the following varisbles, constraints, and assumptions: - Her starting salary is \$120,000; Longevity, Inc. has historically incressed employee compensation by 3% annually. - She wants to contribute 5% of her annual salary to the retirement account, but must keep her after tax take home poy the same regardless of the chosen option. - Longevity, Inc.'s retirement investment options are expected to earn a 12% rate of return. - Evs expects to work for Longevity, Inc. for 30 years and will spend 20 years in retirement. - During retirement, Evs intends to exit her retirement sccount investments and will take sn even distribution of the retirement sovings each year. Evo's gosl is to maximize her after tox cash flow in retirement but also wents to minimize the amount of tax she pays over her lifetime. Using 2019 income tax brackets and assuming a Standard Deduction incresse of 1.67% each year, you have created the following Tablesu visualization to help Evs make a decision. Mouse over the graphs to reveal specific amounts for use in answering the following questions. Note, the Dsta pane provides a summation of values bosed on the selected Year(s) slider and Roth or Traditional option in the dropdown menu. New-Hire Declslons: Roth or Tradltional Retlrement Savings - Part 1 (Static) Required: a. What is the expected Market Value in year 30 under each option? b. What Is the lifetime (year 1 through 50) Taxable Income and Tax expected to be If Eva chooses the traditional retirement account? c. Under which option will Eva pay less Tax over her lifetime? d. Which option has a lower average tax rate over her lifetime? e. Which option maximizes Eva's After Tax Cash Flow in retirement? Complete this question by entering your answers in the tabs below. What is the expected Market Value in year 30 under each option? Required: a. What is the expected Market Value in year 30 under each option? b. What is the IIfetime (year 1 through 50) Taxable Income and Tax expected to be if Eva chooses the traditional retirement account? c. Under which option will Eva pay less Tax over her lifetime? d. Which option has a lower average tax rate over her lifetime? e. Which option maximizes Eva's After Tax Cash Flow in retirement? Complete this question by entering your answers in the tabs below. What is the lifetime (year 1 through 50) Taxable Income and Tax expected to be if Eva chooses the traditional retirement account? Required: a. What is the expected Market Value in year 30 under each option? b. What Is the IIfetime (year 1 through 50) Taxable Income and Tax expected to be If Eva chooses the traditional retirement account? c. Under which option will Eva pay less Tax over her IIfetime? d. Which option has a lower average tax rate over her lifetime? e. Which option maximizes Eva's After Tax Cash Flow in retirement? Complete this question by entering your answers in the tabs below. Under which option will Eva pay less Tax over her lifetime? Required: a. What Is the expected Market Value in year 30 under each option? b. What is the Iffetime (year 1 through 50) Taxable Income and Tax expected to be if Eva chooses the traditional retirement account? c. Under which option will Eva pay less Tax over her lifetime? d. Which option has a lower average tax rate over her IIfetime? e. Which option maximizes Eva's After Tax Cash Flow in retirement? Complete this question by entering your answers in the tabs below. Which option has a lower average tax rate over her lifetime? New-Hire Decisions: Roth or Traditional Retirement Savings - Part 1 (Static) Required: a. What is the expected Market Value in year 30 under each option? b. What is the IIfetime (year 1 through 50 ) Taxable Income and Tax expected to be If Eva chooses the traditional retirement account? c. Under which option will Eva pay less Tax over her Iffetime? d. Which option has a lower average tax rate over her lifetime? e. Which option maximizes Eva's After Tax Cash Flow in retirement? Complete this question by entering your answers in the tabs below. Which option maximizes Eva's After Tax Cash Flow in retirement
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started