Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

401K(403B) Spreadsheet Learning Objectives: Familiarize students with the 401K(403B) retirement plan Encourage students to enroll in 401K (403B) Determine monthly cost of enrolling in 401K

401K(403B) Spreadsheet

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
  6. Exposure to spreadsheet configuration for what if analysis

____________________________________________________________________________

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.

Create your file to allow for what if analysis for the following variables:

  1. annual salary
  2. investment rate
  3. contribution percent
  4. company match percent

In your spreadsheet, highlight these fields in yellow indicating they can be modified to arrive at new retirement account balances.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting and auditing research tools and strategies

Authors: Thomas Weirich, Thomas Pearson, Natalie Tatiana

8th edition

9781118806487, 1118027078, 1118806484, 978-1118027073

More Books

Students also viewed these Accounting questions

Question

11.1 Explore the role of labor unions.

Answered: 1 week ago

Question

11.3 Discuss laws affecting collective bargaining.

Answered: 1 week ago