Question: Tableau Dashboard Activity 1 5 - 0 1 : New - Hire Decisions: Roth or Traditional Retirement Savings ( Static ) [ The following information

Tableau Dashboard Activity 15-01: New-Hire Decisions: Roth or Traditional Retirement Savings (Static)[The following information applies to the questions displayed below.] New Hire Decisions: Roth or Traditional Retirement Savings Eva is excited to start her position in the Accounting Department of Longevity, Incorporated, a local company known for its employees staying with the company for their whole career. While filling out her new hire packet to select health care coverage and other benefits, Eva must decide which retirement plan option offered by Longevity, Incorporated makes the most sense for her personal goals. Longevity, Incorporated offers a Roth plan or a Traditional plan for retirement savings. Eva considers the following variables, constraints, and assumptions: - Her starting salary is \$120,000; Longevity, Incorporated has historically increased 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 pay the same regardless of the chosen option. - Longevity, Incorporated's retirement investment options are expected to earn a \(12\%\) rate of return. - Eva expects to work for Longevity, Incorporated for 30 years and will spend 20 years in retirement. - During retirement, Eva intends to exit her retirement account investments and will take an even distribution of the retirement savings each year. Eva's goal is to maximize her after tax cash flow in retirement but also wants to minimize the amount of tax she pays over her lifetime. Using 2024 income tax brackets and assuming the trended inflation adjustments to tax brackets and standard deduction continue as experienced from 2022 through 2024, you have created the following Tableau visualization to help Eva make a decision. Mouse-over the graphs to reveal specific amounts for use in answering the following questions. Note, the Data Pane provides a summation of values based on the selected Year(s) slider and Roth or Traditional option in the dropdown Required:
a. What is the expected Market Value Traditional Year 30?
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? Note, this value is not given in the dashboard.
e. Which option maximizes Eva's After Tax Cash Flow in retirement? Note, Year 31 would be her first year of retirement.
Complete this question by entering your answers in the tabs below.
Which option maximizes Eva's After Tax Cash Flow in retirement? Note, Year 31 would be her first year of retirement.
Traditional
Dollar amount:
Tableau Dashboard Activity 1 5 - 0 1 : New - Hire

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!