# top answer: 401K(403B) Spreadsheet Learning Objectives: 1. Familiarize students with the 401K(403B) retirem

Don't use plagiarized sources. Get Your Custom Essay on
top answer: 401K(403B) Spreadsheet Learning Objectives: 1. Familiarize students with the 401K(403B) retirem
Just from \$10/Page

Learning Objectives:

1. Familiarize students with the 401K(403B) retirement plan

2. Encourage students to enroll in 401K (403B)

3. Determine monthly cost of enrolling in 401K (403B) retirement plan

4. Apply future value concepts to determine amount of retirement savings

5. Discuss the intent of the 401K (403B)retirement account

____________________________________________________________________________

Assignment:
The purpose of this paper is to quantify the potential total retirement savings at post-graduation intervals for students.

1. Create a spreadsheet to determine retirement savings using the following criteria.

Annual Compensation: \$60,000 (monthly \$5,000)

401K (403B) Contribution Percent 6%

Company match 50% up to 6% (e.g. 3%- 50% x 6%)

Tax Rate 25%

Annual Investment Return Rate 8%

In your spreadsheet, each of these fields should be changeable. For example, if change the base pay to \$48,000, your spreadsheet will calculate new retirement amounts. The intent of this exercise is also for you to learn how to do what if analysis for any of the key inputs on retirement savings. Please include your expected 401K (403B) balance at 10 year intervals as follows: 10 years, 20 years, 30 years, 40 years. Most of you will be 32, 42, 52 and 62 (ready for retirement) for these intervals.

2. Since 401K (403B) contributions are taken out pretax, I would like for you to calculate the difference in monthly take home pay under two scenarios:

a. Without 401K (403B) contributions

b. With 401K (403B) contributions (hint: this number will be lower, but will be offset by your savings net of taxes)

The intent of this calculation is to determine how much your take home (paycheck) will be reduced if you enroll in a 401K (403B).

Submission:

Your group submission will only be an excel spreadsheet that you will present in the classroom. No powerpoint or word document is required.

Remember, there is no right or wrong answer. The intent of this assignment is to encourage you to think critically about retirement savings when you have the opportunity post commencement to determine if you want to enroll in your company or organization’s 401K (403B).

File naming convention:

Keyword: 401K

Your file name (excel) should be Group#401K (e.g. Group1401K)

You will submit an excel file only in D2L.

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.